0

databases Online Quiz - 162

Description: databases Online Quiz - 162
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

When is a Cartesian product formed?

  1. When a join condition is omitted.

  2. When a join condition is invalid.

  3. All rows in the first table are joined to all rows in the second table.

  4. All of the above.


Correct Option: D

A Non equi-join is a join condition that does not contain an equality operator.

  1. True

  2. False


Correct Option: B
  1. Projection

  2. Selection

  3. Join

  4. All of the above


Correct Option: D
  1. Select all columns from EMP;

  2. Select distinct columns from EMP;

  3. Select * from EMP;

  4. All of the above


Correct Option: C

Select ename from emp where ename =”Scott”; This select statement executes successfully.

  1. True

  2. False


Correct Option: B
  1. Single-row Functions and Double-row Functions

  2. One-row Functions and Two-row Functions

  3. Single-row Functions and Multiple-row Functions

  4. None of the above


Correct Option: C
  1. Character Function

  2. Number Function

  3. String Function

  4. Date Function


Correct Option: C
  1. Table1.column1=Table2.column2

  2. Table1.column1=Table2.column1

  3. Table1.column2=Table2.column1

  4. None of the above


Correct Option: B
  1. Return records which have no direct match

  2. Return records which have direct match

  3. Return all the records

  4. None of the above


Correct Option: A

____________ is used to join a table to itself.

  1. SelfJoin

  2. EquiJoin

  3. OuterJoin

  4. InnerJoin


Correct Option: A
- Hide questions