What are the situations when an index might not be picked up?

Microsoft recommends a clustered index in every SQL Server table

A column in a table, having millions of rows, contains the name of States in India. It is defined as CHAR(50). What performance improvements can be made with respect to the data type?

ABC Corp is an organization, where company raises purchase orders, process payments, captures transaction and reconciles the information. The products involved in this are (choose all applicable)

Numeric columns are best suited to define an index (for faster access)

In a SQL Server 2005 query plan, the presence of which of the below items are indicators of potential performance issues?

During performance tuning, it is imperative that we have data regarding the pain points (slow performing queries, high CPU utilizing queries, etc.). What tools are useful in getting these info?

In a query, Table_A is joined with Table_B based on the join criteria (Table_A.Column_1 = Table_B.Column_1). The SME in the team mentions that Table_B is the child of Table_A based on Column_1 (one-to-many relationship) and should always have value. Given these considerations, which of the following doesn't apply to this situation?

In Accounts_History table, among many columns, I have the Account_ID (Primary Key) and Trans_Date. There is a query that runs frequently to know the latest transaction that was done on the account. Which one of the below approaches will be most beneficial in this case?

There are 10 tables with similar structure but mutually exclusive records. A query needs to fetch some records from each of these tables. Which of the following is the best approach to do this?

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

Please see the below query: create table employee (emp_id number(6) primary key, emp_name varchar2(20)); rollback; What will the result of the below query: desc employee;

We can use group by clause with:

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

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

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

SPLIT function is available in SQL server 2005?

DDL means?

Which inbuilt SP is used to parse the values from XML document

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