0

databases Online Quiz - 148

Description: databases Online Quiz - 148
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Leading column in the index is not part of the search arguments

  2. Data types are not matching while doing a join

  3. Optimizer decides that table scan is better

  4. Index name is improper


Correct Option: A,B,C
  1. There needs to be a Foreign Key relationship between the two tables.

  2. Table_B.Column_1 shouldn't have NULL values.

  3. There should be a clustered index on Table_A.Column_1 and a non-clustered index on Table_B.Column_1.

  4. Table_B.Column_1 should be unqiue.


Correct Option: D
  1. Use UNION between the 10 SELECT statements

  2. Execute separate SQL statements and let the front-end merge the results

  3. Use UNION ALL between the 10 SELECT statements

  4. Define a temporary table and populate it with data from the 10 SELECT statements and then do a single SELECT from this table


Correct Option: C

Always use hints while writing queries (e.g. WITH NOLOCK, WITH UPDLCK) since it will help the query optimizer

  1. True

  2. False


Correct Option: B
  1. It will describe the table.

  2. It will return ar error:'Table or view does not exist'

  3. The query is not correct.

  4. None of the above


Correct Option: A
  1. Non aggregate functions only

  2. Aggregate functions only

  3. Both 1 & 2

  4. None of the above


Correct Option: B

Which of the below is the correct query to update the columns of a table:

  1. update table TABLE_NAME set COMLUMN_NAME= where

  2. update TABLE_NAME set COMLUMN_NAME= where

  3. Both 1 & 2 are correct

  4. None of the above


Correct Option: B

UNION query returns only distinct rows and UNION ALL may return duplicates.

  1. True

  2. False


Correct Option: A

Bitmap index is suitable for the tables having huge and repeatative(duplicates) data.

  1. True

  2. False


Correct Option: A
  1. Data Dynamic Link

  2. Data Description Language

  3. Data Definition Language

  4. Data Definition Link


Correct Option: C
  1. sp_xml_postdocument

  2. sp_xml_readdocument

  3. sp_xml_loaddocument

  4. sp_xml_preparedocument


Correct Option: D

Which command is used to Check integrity of a table or indexed view?

  1. DBCC CHECKIDENT

  2. DBCC CHECKTABLE

  3. DBCC CHECKALLOC

  4. DBCC CHECKINTEG


Correct Option: B
- Hide questions