databases Online Quiz - 148
|Description: databases Online Quiz - 148|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
What are the situations when an index might not be picked up?
Microsoft recommends a clustered index in every SQL Server table
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?
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.
SPLIT function is available in SQL server 2005?
Which command is used to Check integrity of a table or indexed view?