MS SQL Server 2005, Databases

Question: Which command is used to create User defined Data Type in the SQL SERVER 2005?
A
sp_addtype

B
Create Type

C
Create Data Type

D
None of these

Note: Not available
1. Report
Question: Which of the following mechanisms is used by "ENCRYPTION by passphrase" to encrypt the data in the SQL SERVER 2005?
A
DES (Data Encryption Standard)

B
AES (Advanced Encryption Standard)

C
user defined password

Note: Not available
1. Report
Question: Which one of the following statements about Indexes is wrong?
A
Indexes are created in an existing table to locate rows more quickly and efficiently

B
It is possible to create an index on one or more columns of a table

C
A table is scanned when index is not available

D
Indexes can only be implemented on integer datatypes

Note: Not available
1. Report
Question: What will be the output of the following SQL query? SET SHOWPLAN_TEXT ON GO SELECT * FROM abcsite.abctable GO
A
It will show the query plan and the estimated cost of running

B
It will show all the rows of the "abctable" table

C
It will show all the rows of the "abctable" table and the table structure

D
It will show the identities and Constraints applied on this table

Note: Not available
1. Report
Question: __________ is a container that holds tables, views, procedures, functions and so on.
A
Instance

B
Cluster

C
Metadata

D
Schema

E
None of these

Note: Not available
1. Report
Question: What exactly is a Super key?
A
A Super key is a column or a set of columns that uniquely identifies rows in a table

B
A Super key checks the number of columns in a table which have non-null values

C
A Super key is used to match columns in other tables

D
A Super key checks the number of rows in a table which have non-null values

Note: Not available
1. Report
Question: Which one of the following statements is correct?
A
You can create DDL triggers

B
You can create DML triggers

C
Both are correct

D
Neither is correct

Note: Not available
1. Report
Question: Starting from the slowest, arrange the following operators in the order in which they produce results in "SQL WHERE" query. 1. >, >=, <, <= 2. <> 3. = 4. LIKE
A
1,4,3,2

B
4,1,2,3

C
3,2,1,4

D
2,4,1,3

Note: Not available
1. Report
Question: Why are Joins generally better than the Correlated sub-query?
A
The Correlated sub-query scans the whole table

B
Joins pick up the rows according to the condition of the queries

C
The Correlated sub-query creates a nested loop

D
The Correlated sub-query makes the statement complex

Note: Not available
1. Report
Question: Consider the following table "Students": Students - - - - - - Name Hobbies John Driving Miller Fishing David Writing Robert Singing What will be the output of the following query? Select Substring(Hobbies,3) From students Where name= "john"
A
Dri

B
ivi

C
iving

D
ving

E
It will give an error

Note: Not available
1. Report

First Prev 3 4 5 6 7 Next Last

Question: Which command is used to create User defined Data Type in the SQL SERVER 2005?

Question: Which of the following mechanisms is used by "ENCRYPTION by passphrase" to encrypt the data in the SQL SERVER 2005?

Question: Which one of the following statements about Indexes is wrong?

Question: What will be the output of the following SQL query? SET SHOWPLAN_TEXT ON GO SELECT * FROM abcsite.abctable GO

Question: __________ is a container that holds tables, views, procedures, functions and so on.

Question: What exactly is a Super key?

Question: Which one of the following statements is correct?

Question: Starting from the slowest, arrange the following operators in the order in which they produce results in "SQL WHERE" query. 1. >, >=, <, <= 2. <> 3. = 4. LIKE

Question: Why are Joins generally better than the Correlated sub-query?

Question: Consider the following table "Students": Students - - - - - - Name Hobbies John Driving Miller Fishing David Writing Robert Singing What will be the output of the following query? Select Substring(Hobbies,3) From students Where name= "john"