Question 1

When is a Cartesian product formed?

technology databases

When a join condition is omitted.
When a join condition is invalid.
All rows in the first table are joined to all rows in the second table.
All of the above.

Answer

Correct Option: D

Question 2

In a join condition it is mandatory to specify the table name along with the Column name.

technology databases

True
False

Answer

Correct Option: B

Question 3

The minimum number of join statements required to join 10 tables together are:

technology databases

9
11
5
12
None of the above

Answer

Correct Option: A

Question 4

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

technology databases

True
False

Answer

Correct Option: B

Question 5

Arithmetic expressions containing a null value evaluate to null.

technology databases

True
False

Answer

Correct Option: B

Question 6

Concatenation operator is

technology databases

+
-
||
*

Answer

Correct Option: C

Question 7

What are SQL “SELECT” statement capabilities.

technology databases

Projection
Selection
Join
All of the above

Answer

Correct Option: D

Question 8

To select all the columns from a table EMP, which one of the following is TRUE?

technology databases

Select all columns from EMP;
Select distinct columns from EMP;
Select * from EMP;
All of the above

Answer

Correct Option: C

Question 9

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

technology databases

True
False

Answer

Correct Option: B

Question 10

Sorting SQL statement result data by column alias is not possible.

technology databases

True
False

Answer

Correct Option: B

Question 11

What are the two types of SQL Functions?

technology databases

Single-row Functions and Double-row Functions
One-row Functions and Two-row Functions
Single-row Functions and Multiple-row Functions
None of the above

Answer

Correct Option: C

Question 12

Single-Row Functions can return multiple results per row.

technology databases

True
False

Answer

Correct Option: B

Question 13

Which of these is not a Single-Row Function?

technology databases

Character Function
Number Function
String Function
Date Function

Answer

Correct Option: C

Question 14

Compare the output of the following: SELECT TRUNC(99.57,1) FROM DUAL; and SELECT ROUND(99.57,1) FROM DUAL;

technology databases

99.57,99,6
99.5,99.6
99.6,99.6
99.57,99.57

Answer

Correct Option: B

Question 15

LAST_DAY(date) finds the date of the last day of the month that contains date.

technology databases

True
False

Answer

Correct Option: B

Question 16

Which of the following WHERE clauses represent equi-join?

technology databases

Table1.column1=Table2.column2
Table1.column1=Table2.column1
Table1.column2=Table2.column1
None of the above

Answer

Correct Option: B

Question 17

An outer join is used to:

technology databases

Return records which have no direct match
Return records which have direct match
Return all the records
None of the above

Answer

Correct Option: A

Question 18

____________ is the outer join operator.

technology databases

(+)
(-)
(*)
+

Answer

Correct Option: A

Question 19

____________ is used to join a table to itself.

technology databases

SelfJoin
EquiJoin
OuterJoin
InnerJoin

Answer

Correct Option: A

Question 20

A Literal is enclosed in double quotes.

technology databases

True
False

Answer

Correct Option: B

Description: databases Online Quiz - 162
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 162

Find more quizzes from top tags