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

Which one is the scalar operator

  1. IN

  2. >=

  3. ANY

  4. ALL


Correct Option: B

Sub-query cannot have following clause

  1. Order by

  2. Having

  3. Group by

  4. Where


Correct Option: A

Which of following will cause end of user transaction.

  1. Commit

  2. Drop

  3. Truncate

  4. All of above


Correct Option: D

Which of following is not ISO std SQL construct

  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

Which of following can be run within database

  1. java

  2. sql

  3. plsql

  4. All of above


Correct Option: D

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

SQL89 error means?

  1. Numeric expected

  2. Integer expected

  3. Column Constraint expected

  4. Invalid table name


Correct Option: B

SQL112 error means?

  1. Fatal error occurred

  2. %THRESHOLD Violation

  3. Privilege Violation

  4. Access violation


Correct Option: D

SQL462 error means?

  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

SQL130 error means?

  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