You are creating an ASP.NET application that is hosted on your company's Web server. You want to access a database with minimal effort. What you will do?

1. Begin a transaction

2. Create a connection to the database

3. Create a data set using an adapter object

4. Use the data set to display data or to change items in the database

5. Update the database from the data set

6. Close the database connection

7. Check for transaction errors

You are developing a website that has four layers. The layers are user interface (web pages), business objects, data objects, and database. You want to pass data from the database to controls on a web form. What should you do?

1. Populate the data objects with data from the database. Populate the controls with values retrieved from the data objects.

2. Populate the business objects with data from the database. Populate the controls with values retrieved from the business objects.

3. Populate the data objects with data from the database. Populate the business objects with data from the data objects. Populate the controls with values retrieved from the business objects

4. Bind the controls directly to the database.

Which of the following are not date parts?

1. Quarter

2. dayofweek

3. dayofyear

4. weekday

Which one of the following must be specified in every DELETE statement?

1. Table Name

2. Database name

3. LIMIT clause

4. WHERE clause

5. Column Names

Which of the following commands is used to change the structure of table?

1. CHANGE TABLE

2. MODIFY TABLE

3. ALTER TABLE

4. UPDATE TABLE

What is the correct SQL syntax for returning all the columns from a table named “Persons” sorted REVERSE alphabetically by “FirstName”?

1. SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC

2. SELECT * FROM Persons SORT REVERSE ‘FirstName’

3. SELECT * FROM Persons ORDER BY ‘FirstName’

4. SELECT * FROM Persons ORDER BY FirstName DESC

5. SELECT * FROM Persons ORDER BY DESC FirstName

What is the maximum value that can be stored for a datetime field?

1. Dec 31, 9999

2. Jun 6, 2079

3. Jan 1, 2753

4. Jan 1, 2100

How can you view the structure of a table named “myTable” in SQL Server?

1. desc myTable

2. desc table myTable

3. sp_columns myTable

4. None of the above

5. Using either option a or c

What does referential integrity (also called relational integrity) prevent?

1. Loss of data from employee sabotage

2. Loss of data from any one corrupted table

3. Recursive joins

4. One-to-many or many-to-many relationships between columns in a table

5. Data redundancy

Which of the following is not a global variable?

1. @@colcount

2. @@error

3. @@rowcount

4. @@version

5. All are valid global variables