Tag: databases

Questions Related to databases

  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
  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
  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
  1. FUNCTIONALITY IS NOT IMPLEMENTED

  2. NO MORE JOIN SEEDS POSSIBLE

  3. Both 1 and 2

  4. None of these


Correct Option: A
  1. Access denied

  2. EXECUTION INTERRUPTED BY USER

  3. REMOTE SQL SERVER IS NOT AVAILABLE

  4. SQL SERVER IS NOT RUNNING


Correct Option: A