You create an application by using the Microsoft .NET Framework 3.5 and Microsoft
ADO.NET.You write the following code segment. (Line numbers are included for reference
only.)
01 DataTable dt = new DataTable();
02 dt.Columns.Add(“number”);
03 dt.Columns.Add(“string”);
04 dt.Rows.Add(1, “3”);
05 dt.Rows.Add(2, “2”);
06 dt.Rows.Add(3, “1”);
07 var result = from p in dt.AsEnumerable()
08
09 foreach (var number in result) {
10 Console.Write(number.ToString());
11 }
You need to display the string “321”.Which line of code should you insert at line 08?

You create an application by using the Microsoft .NET Framework 3.5 and Microsoft
ADO.NET.You write the following code segment.
DataTable dt = new DataTable(“Strings”);
dt = new DataTable();
dt.Columns.Add(“Strings”);
dt.Rows.Add(“A-B”);
dt.Rows.Add(“C-D”);
var c = from Strings in dt.AsEnumerable()
select Strings[0];
int count = 0;
You need to ensure that the value of the count variable is 4. Which line of code should you add?

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. You are designing the database schema of the application. The database schema is as shown in the exhibit. (Refer to the Exhibit.)

You need to ensure that the design meets the following requirements:
The database contains no duplicate data.
A category can contain zero or more products.
Each product can be associated with zero or more categories.
What should you do?

You create an application by using the Microsoft .NET Framework 3.5 and Microsoft
ADO.NET.You write the following code segment. (Line numbers are included for reference
only.)
01 private void GetRecords(SqlDataAdapter da, DataTable table) {
02
03 try {
04 da.Fill(table);
05 }
06 catch (SqlException exp) {
07
08 }
09 finally {
10
11 }
12 }
13
The da.SelectCommand.CommandText property is set to a stored procedure. The stored
procedure declares a variable named @msg.For each record that contains a bad shipping
address, the stored procedure performs the following tasks:
It sets @msg with the id of the record.
It raises an error for the record.
The error raised is as shown in the following text:
RaiseError(@msg, 10, 1)
You need to ensure that all valid records are retrieved even if invalid records are present.
You also need to ensure that a list item is added to the lstResults list box for each invalid
record. What should you do?

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application includes two namespaces named Contoso.Security and Contoso.Log. Classes in the Contoso.Security namespace will be distributed for use in a data access layer component. Classes in the two namespaces will be distributed for use by other client components in the application. Not all client components will use both the Contoso.Security and Contoso.Log classes. You plan to design a strategy for component reuse. You need to ensure that unnecessary code is not distributed to any client application. You also need to ensure that all necessary code is available to dependent components. What should you do?