MS SQL Server 2005, Databases

Question: Which of the following are not Database Models?
A
Hierarchical model

B
Network model

C
Composite model

D
Relational model

E
Recursive model

Note: Not available
1. Report
Question: Which functions does the following SQL QUERY perform? DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)
A
It checks the current identity field value of the specified table

B
It sets the identity field value to the new reseed value

C
It sets the identity field value to 1

D
None of these

Note: Not available
1. Report
Question: You have a table named "employees" with the following table structure: empid int(4) deptname varchar(50) salary int(4) The following select query is executed on this table: SELECT * FROM employees ORDER BY deptname DESC, salary DESC What will be the output of the above query?
A
The above SQL query will give an error

B
Records will be shown with the salary field displayed in the descending order

C
Records will be shown with the deptname field in the ascending order and salary in the descending order

D
Records will be shown with the deptname field and the salary field in the descending order

E
Records will be shown in a jumbled manner

Note: Not available
1. Report
Question: Consider the following tables: Customers - - - - - - - - Customerid Customername Address Orders - - - - - Orderid Customerid Orderdate Comments What will be the query to fetch Customername and 1st Orderdate for order placed by each customer?
A
Select Customers.Customername,(Select Min(Orderdate) From Orders Where Customers.Customerid=Orders.Customerid) From Customers

B
Select Customers.Customername,(Select Max(Orderdate) From Orders Where Customers.Customerid=Orders.Customerid) From Customers

C
Select Customers.Customername,(Select Orderdate From Orders Where Customers.Customerid=Orders.Customerid) From Customers

D
Select Customers.Customername,Min(Orders.Orderdate) From Orders,Customers Where Customers.Customerid=Orders.Customerid

E
None of these

Note: Not available
1. Report
Question: Which edition of the SQL SERVER 2005 will best meet the following scenario? A company has an online shopping website named www.shoppingxyz.com. It also has to handle its line of business portion. Its main server supports 4 CPUs and a multi-core processor.
A
SQL SERVER 2005 Enterprise Edition

B
SQL SERVER 2005 Standard Edition

C
SQL SERVER 2005 Workgroup Edition

D
SQL SERVER 2005 Developer Edition

E
SQL SERVER 2005 Express Edition

Note: Not available
1. Report
Question: State whether True or False. While using the Select query, the IN clause is a better choice than the EXIST clause.
A
True

B
False

Note: Not available
1. Report
Question: State whether True or False. Many-to-One is a type of relationship in RDBMS.
A
False

B
True

Note: Not available
1. Report
Question: State whether True or False. You can send emails through the Database engine.
A
False

B
True

Note: Not available
1. Report
Question: State whether True or False. The 'Having' clause can not be used when there is a 'Where' clause in the statement already.
A
True

B
False

Note: Not available
1. Report
Question: State whether True or False. Triggers can be created in Assemblies.
A
True

B
False

Note: Not available
1. Report

First Prev 1 2 3 4 Next Last

Question: Which of the following are not Database Models?

Question: Which functions does the following SQL QUERY perform? DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)

Question: You have a table named "employees" with the following table structure: empid int(4) deptname varchar(50) salary int(4) The following select query is executed on this table: SELECT * FROM employees ORDER BY deptname DESC, salary DESC What will be the output of the above query?

Question: Consider the following tables: Customers - - - - - - - - Customerid Customername Address Orders - - - - - Orderid Customerid Orderdate Comments What will be the query to fetch Customername and 1st Orderdate for order placed by each customer?

Question: Which edition of the SQL SERVER 2005 will best meet the following scenario? A company has an online shopping website named www.shoppingxyz.com. It also has to handle its line of business portion. Its main server supports 4 CPUs and a multi-core processor.

Question: State whether True or False. While using the Select query, the IN clause is a better choice than the EXIST clause.

Question: State whether True or False. Many-to-One is a type of relationship in RDBMS.

Question: State whether True or False. You can send emails through the Database engine.

Question: State whether True or False. The 'Having' clause can not be used when there is a 'Where' clause in the statement already.

Question: State whether True or False. Triggers can be created in Assemblies.