Tag: databases

Questions Related to databases

  1. Outer joins

  2. Multi-table updates and deletes

  3. Equi-joins

  4. Equi-join with a text column in select list


Correct Option: C

A UNION of two or more queries is valid provided the queries meet which of the following conditions? (Choose 3)

  1. All select lists in the UNION must have the same number of expressions

  2. Corresponding columns must have the same column names

  3. Corresponding columns must be of the same datatype or the server must be able to implicitly convert them

  4. Corresponding columns must be in the same order


Correct Option: A,C,D
  1. Duplicate rows are removed from the result set by default

  2. ASE evaluates a statement containing union operators from left to right

  3. Order by and group by clauses are not allowed in a union query

  4. The into clause can be used only in the first query


Correct Option: A,B,D
  1. the inserted and deleted tables are created manually

  2. triggers can be disabled using alter table

  3. a single trigger can be created for both insert and delete

  4. @@sqlstatus contains the number of rows affected


Correct Option: B,C

Which T-SQL elements can be used in a stored procedure? (Choose 2)

  1. 'return', without a return value

  2. 'rollback transaction'

  3. 'rollback trigger'

  4. the built-in function 'update()'


Correct Option: A,B
  1. Index

  2. Cluster

  3. Package

  4. DB links

  5. Function


Correct Option: A,C,E