databases Online Quiz - 189

Description: databases Online Quiz - 189
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Sub-query cannot have following clause

  1. Order by

  2. Having

  3. Group by

  4. Where

Correct Option: A
  1. Decode

  2. Case

  3. Minus

  4. None of above

Correct Option: A

to_date('2008','yyyy'); What is the output of this if sysdate is 22-Sep-09

  1. 01-Jan-08

  2. 22-Sep-08

  3. 01-Sep-08

  4. None of above

Correct Option: C
  1. Not Null

  2. Check

  3. Unique key

  4. All of above

Correct Option: C

SQL is set oriented language because

  1. It process tuples one by one

  2. It can be used in PLSQL

  3. It can use SET operators

  4. None of above

Correct Option: D
  1. SQL System Error

  2. SQL Data base error

  3. SQL numeric error

  4. None of the these

Correct Option: A

SQL0204 error means?

  1. Database error

  2. MYSYSCONF not found

  3. ORDER BY column not in result table

  4. not valid for naming convention

Correct Option: B

SQL0208 error means?

  1. interger not found

  2. Numeric not allowed

  3. Name &1 not allowed.

  4. ORDER BY column not in result table

Correct Option: D

SQL310 error means

  1. Constraint or Key not found

  2. Foreign key references non-existent table

  3. Before Delete trigger failed

  4. Row to DELETE not found

Correct Option: B
  1. Trigger not found

  2. Trigger name not unique

  3. Trigger with same EVENT, TIME, and ORDER already defined

  4. Fatal Connection error

Correct Option: A

SQL89 error means?

  1. Numeric expected

  2. Integer expected

  3. Column Constraint expected

  4. Invalid table name

Correct Option: B
  1. Fatal error occurred

  2. %THRESHOLD Violation

  3. Privilege Violation

  4. Access violation

Correct Option: D
  1. No stream object defined for field

  2. Communication link failure

  3. Memory allocation failure

  4. None of these

Correct Option: C
  1. Unknown or non-unique User or Role

  2. Cannot INSERT/UPDATE/DELETE on a read only table

  3. Row to DELETE not found

  4. Operation Disallowed by Operation Table

Correct Option: A
  1. After Delete trigger failed

  2. Before Delete trigger failed

  3. Before Update trigger failed

  4. Before Insert trigger failed

Correct Option: D
  1. Multi-Line Field not valid in ORDER BY clause

  2. Multi-Line Field must be the Left operand of the Comparison

  3. Multi-Line Field only valid for LIKE, Contains ([), or NULL Comparison

  4. None of these

Correct Option: A
  1. Duplicate cursor name

  2. Unable to receive server message

  3. Invalid Stored Procedure Name

  4. None of these

Correct Option: A
- Hide questions