Leading column in the index is not part of the search arguments

Data types are not matching while doing a join

Optimizer decides that table scan is better

Index name is improper

True

False

Change it to CHAR(10)

Change it to VARCHAR(50)

Change it to NVARCHAR(50)

Change it to CHAR(100)

Istore

GL

Cash Management

Purchasing

Inventory

Order Management

True

False

Index scan

Table scan

Bookmark lookup

Index seek

Dynamic Management Views (DMV)

DBCC commands

Query plans

BCP

There needs to be a Foreign Key relationship between the two tables.

Table_B.Column_1 shouldn't have NULL values.

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

Table_B.Column_1 should be unqiue.

Defining a clustered index on Account_ID

Defining a clustered index on Account_ID, Trans_Date

Defining a non-clustered index on Account_ID, Trans_Date

Don't define any indexes

Use UNION between the 10 SELECT statements

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

Use UNION ALL between the 10 SELECT statements

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

True

False

It will describe the table.

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

The query is not correct.

None of the above

Non aggregate functions only

Aggregate functions only

Both 1 & 2

None of the above

update table TABLE_NAME set COMLUMN_NAME= where

update TABLE_NAME set COMLUMN_NAME= where

Both 1 & 2 are correct

None of the above

True

False

True

False

True

False

Data Dynamic Link

Data Description Language

Data Definition Language

Data Definition Link

sp_xml_postdocument

sp_xml_readdocument

sp_xml_loaddocument

sp_xml_preparedocument

DBCC CHECKIDENT

DBCC CHECKTABLE

DBCC CHECKALLOC

DBCC CHECKINTEG