Tag: databases

Currency

Calender

Accounting Field Structure and Calender

Currency, Calender and Accounting Field Structure

Application

Set of Books

Organization

Set Of Books

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.