3i Infotech Placement: Sample Questions 17 - 18 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 17

Edit

Write in Short

Short Answer▾

A man ate 100 bananas in five days, each day eating 6 more than the previous day. How many bananas did he eat on the first day?

Explanation

Man ate 100 bananas in five days.

Each day man is eating 6 more than the previous day.

let՚s say, man is eating x bananas on the first day.

So, on second day, he will eat bananas.

On third day, he will eat bananas.

On fourth day, he will eat bananas.

On fifth day, he will eat bananas.

So,

So, man ate 8 bananas on the first day.

Question 18

Question

MCQ▾

Without the use of Cartesian product, how many joining conditions are required to join tables?

Choices

Choice (4)

a.

1

b.

3

c.

4

d.

2

Answer

b.

Explanation

  • To join ‘n’ tables ‘n-1’ conditions should be satisfied so to join tables conditions should be satisfied.
  • Join is used to collate data from two more tables- joined to appear as single table of data.
  • Combines columns from two or more tables by using values common to both table.
  • “Join” keyword is used in SQL queries for joining two or more tables.
  • Minimum required condition for joining table is (n-1) where n, is number of tables.
  • A table can also join to itself, which is known as self join.

Developed by: