Tag: technology

Questions Related to technology

@@Error returns the sys.messages.message_id column value if an error occurs in the last T-SQL statement executed.True/False?

  1. True

  2. False


Correct Option: A

Which of the Isolation levels causes "Dirty Read"?

  1. Read Uncommitted

  2. Read Committed

  3. Repeatable Read

  4. Snapshot

  5. Serializable


Correct Option: A
  1. A run time error occurs

  2. Returns all the column names in the table but no records

  3. Returns all the records in the table

  4. Returns nothing

  5. Returns NULL


Correct Option: B

COUNT(*) returns the number of items in a group - which of the below is correct?

  1. This includes NULL values and duplicate

  2. This includes NULL values but not the duplicates

  3. This does not include NULL values and duplicates

  4. None of the above


Correct Option: A