MS SQL Server 2005, Databases

Question: Which of the following is the new sample database in the SQL SERVER 2005?
A
Northwind

B
pubs

C
AdventureWorks

D
master

E
tempdb

Note: Not available
1. Report
Question: Which of the following SQL queries correctly selects the rows from the table "employees" that have NULL value in the "salary" column?
A
SELECT * FROM employees WHERE salary=null

B
SELECT * FROM employees WHERE salary equals null

C
SELECT * FROM employees WHERE salary is null

D
SELECT * FROM employees WHERE salary contains null

Note: Not available
1. Report
Question: Which level of data abstraction describes the data that is stored in the database and their corresponding relationships?
A
View Level

B
Procedural Level

C
Physical Level

D
Logical Level

E
Conceptual Level

Note: Not available
1. Report
Question: Which of the following "insert queries" will be inserted in the XML field? The creation query of the table is: CREATE TABLE Branches(recordID int, description XML)
A
INSERT Into Branches(recordID, description) VALUES(1, '<log><application>Sales</application><description>The connection timed out.</description></log>')

B
INSERT UniversalLog(recordID, description) VALUES(1, 'database unavailable')

C
INSERT Into Branches(recordID, description) VALUES(1, '<log><application>Sales<description>The connection timed out')

D
XML cannot be inserted into database

E
XML can be inserted but syntax in all queries is wrong

Note: Not available
1. Report
Question: Which of the following is not an Aggregate function?
A
AVG()

B
LEN()

C
COUNT()

D
SUM()

E
MAX(column)

Note: Not available
1. Report
Question: Consider the following query: Select name from employees where name like "%_n_" Which names will be displayed?
A
Names starting with n

B
Names containing n

C
Names containing n as the second letter

D
Names containing n as the second last letter

E
Names having 3 ns

Note: Not available
1. Report
Question: You want to select a row using cursors in the table 'qlist'. Which of the following statements DECLARES a cursor 'qselect' to perform the desired operation?
A
DECLARE qselect CURSOR ON SELECT * FROM qlist

B
DECLARE qselect CURSOR FOR SELECT * FROM qlist

C
DECLARE qlist CURSOR ON SELECT * FROM qselect

D
DECLARE qselect CURSOR AS SELECT * FROM qlist

Note: Not available
1. Report
Question: Which query will be used for a particular column of a table, if 'Reading' is to be replaced by 'Writing'?
A
Update [Table Name] set [Field Name]= (replace('Reading','Writing'))

B
Update [Table Name] set [Field Name]= (replace('Writing',' Reading'))

C
Update [Table Name] set [Field Name]= (replace([Field Name],' Writing'))

D
Update [Table Name] set [Field Name]= (replace([Field Name],' Reading '))

E
Update [Table Name] set [Field Name]= (replace([Field Name],'Reading','Writing'))

F
Update [Table Name] set [Field Name]= (replace([Field Name],'Writing ','Reading'))

Note: Not available
1. Report
Question: What is wrong with the following query in accordance with performance? SELECT * FROM [Table_Name] WHERE LOWER(Field_Name) = 'name'
A
The required keyword ('name') is already in the LOWER case

B
The query requires more time to convert to the LOWER case

C
T-Sql is not case sensitive. Hence, the LOWER keyword is not required

D
Instead of '=' the operator, 'LIKE' should be used

Note: Not available
1. Report
Question: How is the following query incorrect? select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)
A
In the sub-query, '*' should be used instead of 'OrderID'

B
The sub-query can return more than one row, so, '=' should be replaced with 'in'

C
The sub-query should not be in parenthesis

D
None of these

Note: Not available
1. Report

First Prev 5 6 7 8 Next Last

Question: Which of the following is the new sample database in the SQL SERVER 2005?

Question: Which of the following SQL queries correctly selects the rows from the table "employees" that have NULL value in the "salary" column?

Question: Which level of data abstraction describes the data that is stored in the database and their corresponding relationships?

Question: Which of the following "insert queries" will be inserted in the XML field? The creation query of the table is: CREATE TABLE Branches(recordID int, description XML)

Question: Which of the following is not an Aggregate function?

Question: Consider the following query: Select name from employees where name like "%_n_" Which names will be displayed?

Question: You want to select a row using cursors in the table 'qlist'. Which of the following statements DECLARES a cursor 'qselect' to perform the desired operation?

Question: Which query will be used for a particular column of a table, if 'Reading' is to be replaced by 'Writing'?

Question: What is wrong with the following query in accordance with performance? SELECT * FROM [Table_Name] WHERE LOWER(Field_Name) = 'name'

Question: How is the following query incorrect? select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)