Tag: databases

Questions Related to databases

SQL72 error means?

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