# 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.