0

databases Online Quiz - 188

Description: databases Online Quiz - 188
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Stored Procedure Not Found

  2. General error

  3. Duplicate cursor name

  4. Option value changed


Correct Option: D
  1. DDL not allowed on this table definition

  2. Column with this name already exists

  3. View's WITH CHECK OPTION validation failed in UPDATE

  4. One or more matching rows is locked by another user


Correct Option: A
  1. Invalid field name

  2. Invalid table name

  3. Invalid index name

  4. Invalid view name


Correct Option: B
  1. Cursor not updateable

  2. DISTINCT not valid in subquery of FROM clause

  3. Positive integer constant or variable expected

  4. Incompatible SELECT list is used in INSERT


Correct Option: D
  1. COMMAND NOT SPECIFIED

  2. ALREADY LOGGED IN

  3. SESSION DOES NOT EXIST

  4. None of these


Correct Option: A
  1. FAILED TO RETAIN COOPERATIVE TASK

  2. FAILED TO LOAD INFILE

  3. FAILED TO PUT SQL LOCK ON A TABLE

  4. FAILED TO LOCK RECORD FOR WRITING


Correct Option: B
  1. DISTINCT NOT ALLOWED

  2. GROUP BY index is not allowed

  3. HAVING is not an aggregate expression

  4. Column function is not allowed


Correct Option: D
  1. FOREIGN KEY DOES NOT EXIST

  2. FAILED TO CREATE FOREIGN KEY

  3. FOUND VIEW COLUMN

  4. INDEX ALREADY EXISTS


Correct Option: A
  1. UNEXPECTED HEADER VALUE

  2. INVALID AGENT SIGNATURE

  3. Both 1 and 2

  4. None of these


Correct Option: A
  1. UNKNOWN COMMAND

  2. ALREADY LOGGED IN

  3. NOT LOGGED IN

  4. HEADER NOT FOUND


Correct Option: D

SQL3001 error means?

  1. ALREADY LOGGED IN

  2. UNKNOWN COMMAND

  3. SOCKET READ ERROR

  4. INVALID AGENT SIGNATURE


Correct Option: B
  1. INVALID AGENT SIGNATURE

  2. STILL LOGGED IN

  3. INVALID STATEMENT ID

  4. HEADER NOT FOUND


Correct Option: A

SQL1816 error means?

  1. Failed to aggregate

  2. Failed to execute DISTINCT

  3. Failed to execute HAVING clause

  4. Failed to execute WHERE clause


Correct Option: A

SQL1724 error means?

  1. Failed to validate CASE expression

  2. Failed to execute UPDATE command

  3. Failed to calculate LIKE predicate pattern

  4. Failed to validate column list


Correct Option: D
  1. FAILED TO PARSE YEAR

  2. UNEXPECTED CHARACTER

  3. Failed to parse duration

  4. Failed to parse timestamp


Correct Option: C
  1. VARIABLE WAS NOT FOUND

  2. POINTER OF UNKNOWN TYPE

  3. RESULT IS NOT A SELECTION

  4. ARRAY NOT ALLOWED IN EXECUTE IMMEDIATE


Correct Option: B

SQL1203 error means?

  1. FUNCTIONALITY IS NOT IMPLEMENTED

  2. NO MORE JOIN SEEDS POSSIBLE

  3. Both 1 and 2

  4. None of these


Correct Option: A

SQL1004 error means?

  1. Access denied

  2. EXECUTION INTERRUPTED BY USER

  3. REMOTE SQL SERVER IS NOT AVAILABLE

  4. SQL SERVER IS NOT RUNNING


Correct Option: A
  1. Superkey

  2. Candidate key

  3. Primary key

  4. Composite key


Correct Option: A,B,C,D
- Hide questions