0

databases Online Quiz - 155

Description: databases Online Quiz - 155
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Numeric data

  2. Data type

  3. Char data

  4. None of the Above


Correct Option: A
  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


Correct Option: B
  1. CHECK keyword

  2. WITH CHECK keyword

  3. WITH CHECK OPTION keyword

  4. None of the Above


Correct Option: C
  1. INSERT statement

  2. UPDATE statement

  3. Both of the Above

  4. None of the Above


Correct Option: C

MERGE statement

  1. Avoids separate updates

  2. ncreases performance and ease of use

  3. Is useful in data warehousing applications

  4. All of the above


Correct Option: D
  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


Correct Option: D

In an Oracle Database, Locks are critical

  1. True

  2. False


Correct Option: B

You can use Avg or Sum group functions for any numeric data

  1. True

  2. False


Correct Option: B

COUNT(DISTINCT expr) returns

  1. No. of rows in a table

  2. No. of rows with non-null values of the expr

  3. No. of distinct non-null values of the expr

  4. None of the above


Correct Option: C

All columns in the SELECT list, that are not there in the GROUP function, should be in the Group By clause

  1. True

  2. False


Correct Option: B

Which is the clause used to restrict groups?

  1. HAVING

  2. WHERE

  3. Order By

  4. Group by


Correct Option: A

Arithmetic expressions containing a null value evaluate to null.

  1. True

  2. False


Correct Option: B
- Hide questions