Tag: databases

Questions Related to databases

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

technology databases

  1. 1112

  2. 1111.93

  3. 1111.93412

  4. 1111.934

Show answer
Correct Option: D

What does the MOD Function do?

technology databases

  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.

Show answer
Correct Option: C

We can use Group functions in the WHERE clause
technology databases

  1. True

  2. False

Show answer
Correct Option: B

We can use MIN and MAX for any
technology databases

  1. Numeric data

  2. Data type

  3. Char data

  4. None of the Above

Show answer
Correct Option: A

You can update more than 1 row in a table with one update syntax
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Delete from Employee where grade = ‘Y’” deletes
technology databases

  1. All rows of the Employee table

  2. Rows of the Employee table where the set grade is ‘Y’

  3. Delete 1 row

  4. Nothing will be deleted

Show answer
Correct Option: B

Which keyword used in DML statements prohibits you from changing rows that are not in the sub-query?
technology databases

  1. CHECK keyword

  2. WITH CHECK keyword

  3. WITH CHECK OPTION keyword

  4. None of the Above

Show answer
Correct Option: C

Explicit Defaults can be used in
technology databases

  1. INSERT statement

  2. UPDATE statement

  3. Both of the Above

  4. None of the Above

Show answer
Correct Option: C

MERGE statement
technology databases

  1. Avoids separate updates

  2. ncreases performance and ease of use

  3. Is useful in data warehousing applications

  4. All of the above

Show answer
Correct Option: D

Database transactions end with
technology databases

  1. COMMIT or ROLLBACK

  2. A DDL or DCL statement executing

  3. USER exiting iSQL*Plus or System crash

  4. Any one of the above

Show answer
Correct Option: D