### databases Online Quiz - 160

 Description: databases Online Quiz - 160 Number of Questions: 20 Created by: Aliensbrain Bot Tags: databases
Attempted 0/20 Correct 0 Score 0
1. Selfjoin

2. Outerjoin

3. innerjoin

4. equijoin

Correct Option: A
1. True

2. False

Correct Option: B

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

1. 1112

2. 1111.93

3. 1111.93412

4. 1111.934

Correct Option: D

What does the MOD Function do?

1. It divides both the values and gives the quotient.

2. It multiplies both the values and gives the product.

3. It divides both the values and gives the remainder.

4. There is no such function.

Correct Option: C
1. Duplicate

2. Distinct

3. Remove

4. Delete

Correct Option: B
1. Single-row subquery, Double-row subquery

2. Double-row subquery, Multiple-row subquery

3. Multiple-row subquery

4. Single-row subquery and Multiple subquery

Correct Option: D

Single-row subquery returns:

1. Only one row

2. Two rows

3. Zero rows

4. There is no such subquery

Correct Option: A

What is the result of the query below? SELECT Stud_name, Rollnum FROM STUDENT WHERE stud_marks=(SELECT MIN (stud_marks) FROM STUDENT GROUPBY Rollnum);

1. It gives the name and marks of all the students.

2. It does not return anything.

3. It shows an error saying” INVALID SYNTAX ERROR”

4. It shows an error saying” Single-row subquery returns more than one row

Correct Option: D

Which of the following is not a multiple-row operator?

1. IN

2. OF

3. ALL

4. ANY

Correct Option: B
1. IN

2. OF

3. ALL

4. ANY

Correct Option: C
1. Add new rows to a table

2. Modify existing rows of a table

3. Remove existing rows from a table

4. All of the above

Correct Option: D
1. Insert to table tablename (….);

2. Insert into table tablename (….);

3. Insert into table tablename values (…..);

4. Any one of the above

Correct Option: C

Which is the function that records the current date?

1. Date

2. Sysdate

3. Current Date

4. System Date

Correct Option: B

Limiting the rows in a select statement for a specific condition is done by the clause

1. Distinct

2. Projection

3. Where

4. All of the above

Correct Option: C
1. True

2. False

Correct Option: B
1. True

2. False

Correct Option: B

Concatenation operator is

1. +

2. -

3. ||

4. *

Correct Option: C

What are SQL “SELECT” statement capabilities.

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

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

1. True

2. False

Correct Option: B
- Hide questions