NEW
Font size
WorksheetsC# Chapter 6
Total questions: 10
Worksheet time: 10mins
Your application needs to store the product image out to a disk file. You’d like to minimize the size of this disk file. Which of the following objects should you use to write the file?
FileStream
StreamWriter
BinaryWriter
XmlWriter
Your C# program needs to return the total number of customers in a database. The program will be used several times a day. What is the fastest way to return this information from your program?
Write a SQL query and use the SqlCommand.ExecuteScalar method to execute the query.
Create a stored procedure to return the total number of customers, then use the SqlCommand.ExecuteScalar method to execute the stored procedure
Write a SQL query and use the SqlDataAdapter.Fill method to execute the query.
Create a stored procedure to return the total number of customers, then use the SqlDataAdapter.Fill method to execute the stored procedure.
You need to modify the records in a Products table by marking certain products as Discontinued. However, you need to do this only when the UnitsInStock and UnitsOnOrder are both zero. Which of the following SQL statements should you use?
INSERT
SELECT
UPDATE
DELETE
You need to update the Region fields for customers in Japan. You write the following SQL UPDATE statement: UPDATE Customers
SET Region = 'EastAsia'
You test the query on a test database and find that more records were affected than you expected. You need to correct the SQL statement. What should you do?
Add a WHERE clause to the UPDATE statement.
Add an additional SET clause to the UPDATE statement.
Add a GROUP BY clause to the UPDATE statement.
Add a HAVING clause to the UPDATE statement.
You are developing an application that needs to retrieve a list of customers from a SQL Server database. The application should move through the list sequentially once, processing each customer’s record. Which of the following classes should you use to hold the customer list in order to achieve maximum performance?
DataSet
DataTable
DataView
SqlDataReader
The application you are developing needs to read data from a flat file that include items such as a five-digit integer key, followed by a 20-character customer name, followed by two date and time fields. Which of the following classes should you use?
FileStream
StreamReader
BinaryReader
DataReader
You are developing an application that will need to copy data from a SQL Server view to a DataSet. You name the DataSet object dsData. Which of the following methods should you use to copy the data?
Fill
InsertCommand
SelectCommand
Update
You are developing an application that manages customers and their orders. Which of the following situations is not a good candidate for implementation with stored procedures in your application?
Retrieving the list of all customers in the database
Retrieving the list of all orders for particular customers
Inserting a new order into the Orders table
Ad hoc querying by the database administrator
Your application connects to a SQL Server database that contains a table called Employees with the following columns:
EmployeeID (int, identity)
EmployeeType (char(1))
EmployeeDate (datetime)
You need to write a query that deletes all rows from the table where the EmployeeType value is either C or T. You do not want to delete any other rows. Which statement should you use?
DELETE FROM Employees WHERE EmployeeType LIKE '[CT]'
DELETE FROM Employees WHERE EmployeeType LIKE '[C-T]
DELETE FROM Employees WHERE EmployeeType LIKE 'C' OR 'T'
DELETE * FROM Employees WHERE EmployeeType IN ('C', 'T')
Your application includes a SqlDataAdapter object named sqlDataAdapter that connects to the Employees table. Based on this SQLDataAdapter, your application also includes a DataSet object dsEmployees. What line of code should you use to load the data from the database into the DataSet object?
dsEmployees = sqlDataAdapter.Fill("Employees");
sqlDataAdapter.Fill("dsEmployees", "Employees")
sqlDataAdapter.Fill(dsEmployees);
sqlDataAdapter.Fill(dsEmployees, "Employees");
