 ### databases Online Quiz - 162

 Description: databases Online Quiz - 162 Number of Questions: 20 Created by: Aliensbrain Bot 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
1. True

2. False

Correct Option: B

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

1. 9

2. 11

3. 5

4. 12

5. None of the above

Correct Option: A

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

1. True

2. False

Correct Option: B

Arithmetic expressions containing a null value evaluate to null.

1. True

2. False

Correct Option: B
1. +

2. -

3. ||

4. *

Correct Option: C
1. Projection

2. Selection

3. Join

4. All of the above

Correct Option: D

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

1. Select all columns from EMP;

2. Select distinct columns from EMP;

3. Select * from EMP;

4. All of the above

Correct Option: C
1. True

2. False

Correct Option: B
1. True

2. False

Correct Option: B

What are the two types of SQL Functions?

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

Single-Row Functions can return multiple results per row.

1. True

2. False

Correct Option: B

#### AI Explanation

To answer this question, we need to understand what single-row functions are and how they operate.

Single-row functions are functions in SQL that operate on a single row and return a single result per row. These functions take one or more arguments and perform calculations or manipulations on the values of the row to produce a single output value.

Since single-row functions are designed to operate on a single row and return a single result, they cannot return multiple results per row. Therefore, the correct answer is:

B) False - Single-row functions cannot return multiple results per row.

Which of these is not a Single-Row Function?

1. Character Function

2. Number Function

3. String Function

4. Date Function

Correct Option: C

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

1. 99.57,99,6

2. 99.5,99.6

3. 99.6,99.6

4. 99.57,99.57

Correct Option: B
1. True

2. False

Correct Option: B
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
1. (+)

2. (-)

3. (*)

4. +

Correct Option: A
1. SelfJoin

2. EquiJoin

3. OuterJoin

4. InnerJoin

Correct Option: A

A Literal is enclosed in double quotes.

1. True

2. False

Correct Option: B
- Hide questions