Question 1

We can nest Group Functions

technology databases

True
False

Answer

Correct Option: B

Question 2

SYSDATE is a date function that returns the current database server date and time.

technology databases

True
False

Answer

Correct Option: B

Question 3

The value returned by the subquery is used by the main query.

technology databases

True
False

Answer

Correct Option: B

Question 4

To perform wild card search “Like” is used .

technology databases

True
False

Answer

Correct Option: B

Question 5

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 6

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 7

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 8

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

technology databases

True
False

Answer

Correct Option: B

Question 9

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

technology databases

True
False

Answer

Correct Option: B

Question 10

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 11

Single-Row Functions can return multiple results per row.

technology databases

True
False

Answer

Correct Option: B

Question 12

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 13

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 14

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 15

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 16

____________ is the outer join operator.

technology databases

(+)
(-)
(*)
+

Answer

Correct Option: A

Question 17

____________ is used to join a table to itself.

technology databases

Selfjoin
Outerjoin
innerjoin
equijoin

Answer

Correct Option: A

Question 18

A null is the same as zero or a blank space.

technology databases

True
False

Answer

Correct Option: B

Question 19

What is the output of the following? SELECT ROUND(1111.93412,3) FROM DUAL;

technology databases

1112
1111.93
1111.93412
1111.934

Answer

Correct Option: D

Question 20

What does the MOD Function do?

technology databases

It divides both the values and gives the quotient.
It multiplies both the values and gives the product.
It divides both the values and gives the remainder.
There is no such function.

Answer

Correct Option: C

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

databases Online Quiz - 156

Find more quizzes from top tags