1.
You have to read large amounts of XML data. The data resides on an external data source. You need to read the XML data and validate it as it is read. Which of the following classes should you use which will be most memory-efficient way?
2.
You are busy using the XmlWriter class to write large amount of XML data to a physical device via a buffer stream. Which method should you use to write all buffered data in the stream to the device without losing any buffered data?
3.
You are creating a Windows Forms application that implements a master/detail form by using two DataGridView controls. You populate a dataset with a master table and a details table. You set the DataSource property of the master DataGridView control to the dataset. You set the DataMember property to the name of the master table. You also set the DataSource property of the details DataGridView control to the dataset. You need to ensure that the details DataGridView control displays only the child rows of the selected master row.
What should you do?
4.
You are busy developing a Microsoft Windows Forms application. The applications that you are developing are using shared assemblies that must be installed into the Global Assembly Cache (GAC).
What should you do to develop a deployment strategy?
5.
You are busy to develop a Microsoft Windows Forms application that has localized resources for the Arabic language.
Which code segment is used to display all currencies in the format used by Egypt?
6.
You are configuring a ClickOnce deployment that allows users to install your application from the Internet zone under partial trust permission. You want the application to access data that resides on the same remote server from the application is installed. You need to add one of more types of data access that are allowed under partial trust permissions to your application. Which type or types of data access are allowed? (Choose all that apply.)
7.
A Windows Forms application contains the following code segment.
string SQL =
@"SELECT OrderID, ProductID, UnitPrice, Quantity FROM [Order Details]";
SqlDataAdapter da = new SqlDataAdapter(SQL, connStr); Data Table dt = new Data Table();
da.Fill(dt);
You need to add a new column to the data table named ItemSubtotal. The ItemSubtotal column must contains the named of the UnitPrice column multipled by the value of the Quantity column. Which code segment should you use?
8.
You have received instructions to call a stored procedure that return images from a Microsoft SQL Server 2005 database.
You want to use the SqlDataReader class to read the returned images. To ensure that each image is returned as a Stream instance that can be read on demand, what should you do?
9.
You are busy using the XmlWriter class to write large amount of XML data to a physical device via a buffer stream. Which method should you use to write all buffered data in the stream to the device without losing any buffered data?
10.
You are creating a Windows Forms application. The application loads a data table named dt from a database and modifies each value in the data table. You add the following code.
(Line numbers are included for reference only.)
01 foreach (DataRow row in dt.Rows) {
02 foreach (DataColumn col in dt.Columns) {
04 Trace.WriterLine(str);
05 }
06 }
You need to format the string named str to show the value of the column at the time the data is loaded and the current value in the column. Which code segment should you add at line 03?