3i Infotech Placement: Sample Questions 499 - 500 of 1245

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 499

Question

MCQ▾

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

Choices

Choice (4)

a.

CREATE INDEX emp_empno_idx FOR employee, empno

b.

CREATE INDEX emp_empno_idx ON employee, empno

c.

CREATE INDEX emp_empno_idx ON employee (empno)

d.

CREATE emp_empno_idx INDEX ON employee (empno)

Answer

c.

Explanation

CREATE INDEX emp_empno_idx ON employee (empno) statement creates a Index on EMPNO column in the EMPLOYEE table.

Question 500

Question

MCQ▾

A company contracts to paint 3 houses. Mr. Brown can paint a house in 6 days while Mr. Black would take 8 days and Mr. Blue 12 days. After 8 days Mr. Brown goes on vacation and Mr. Black begins to work for a period of 6 days. How many days will it take Mr. Blue to complete the contract?

Choices

Choice (4)

a.

8

b.

7

c.

12

d.

11

Answer

d.

Explanation

A company contracts to paint 3 houses.

Mr. Brown can paint a house in 6 days. So, he will take 18 days to paint all 3 houses.

Mr. Black can paint a house in 8 days. So, he will take 24 days to paint all 3 houses.

Mr. Blue can paint a house in 12 days. So, he will take 36 days to paint all 3 houses.

Mr. Brown alone works for 8 days.

So, in 8 days he has completed amount of work.

Then Mr. Black started working for 6 days.

So, in 6 days he has completed amount of work.

So, total amount of work is completed.

Yet, work is remaining.

1/36 amount of work can be completed by Mr. Blue in one day.

Then, 11/36 amount of work can be completed by him in how many days.

So, Mr. Blue will take 11 days to complete the contract.

Developed by: