0

databases Online Quiz - 189

Description: databases Online Quiz - 189
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  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

SQL0901 error means?

  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

SQL363 error means?

  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
  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