Tag: technology

Questions Related to technology

Can transformer do sorting? State true or false
technology

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

A transaction must have ACID properties to be qualified as such.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which of the Isolation levels causes "Dirty Read"?

technology databases

  1. Read Uncommitted

  2. Read Committed

  3. Repeatable Read

  4. Snapshot

  5. Serializable

Show answer
Correct Option: A

Which one of the below functions is Non-Deterministic?
technology databases

  1. CASE

  2. ISNULL

  3. ISNUMERIC

  4. ISDATE

  5. None

Show answer
Correct Option: D

The given T-SQL statement is executed. What happens?
technology databases

  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

Show answer
Correct Option: B

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

technology databases

  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

Show answer
Correct Option: A

sys.sql_modules system catalog contains a row for each object of type P, RF, V, TR, FN, IF, TF, R, and D.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

We can write triggers for Truncate.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Extended Stored Procedure master.dbo.xp_fileexist can be used to decide if a file exists.
technology databases

  1. True

  2. False

Show answer
Correct Option: A