Microsoft has specified more than twenty objectives for the 70-310 test, which are grouped under four topics. Following are some important areas in which an individual should possess good knowledge before taking the 70-310 test:
The 70-316 test measures an individual’s ability to develop and implement Windows-based applications using Microsoft Visual C# .NET and Microsoft Visual Studio .NET. Before taking the 70-316 test, you should practice the following:
Application roles restrict users to access data through a specific application only. Database permissions can be gained only by using specific applications and a user cannot logon directly to a database.
Trace.axd is an Http Handler that can be used to view the trace details for an application. This file resides in the application’s root directory. A request to this file through a browser displays the trace log of the last n requests in time-order, where n is an integer determined by the value set by requestLimit=”[n]” in the application’s configuration file.
The SystemProcessor Queue Length counter displays the number of threads ready in the processor queue but not currently able to use the processor. The Processor: %Processor Time counter should be measured with a counter. If its value is two, it indicates a CPU bottleneck. This results in slow performance of the server. To eliminate the performance problem, several steps can be used such as reducing the number of processors, using = multiple processors, updating the processors, or installing new and updated CPUs.
The FROM clause of the SQL SELECT statement is used to specify the table names that will be joined together to extract the data values. For example:
FROM <tables>
WHERE <condition>
The ExecuteNonQuery method of the SqlCommand class is used to execute commands that change a database. These commands include the Transact-SQL INSERT, UPDATE, DELETE, and SET statements. The method acts directly on a database connection and does not require a data set. It returns an integer that indicates the number of rows affected by the execution of a command. This method can also be used to perform catalog operations, such as querying the structure of a database or creating database objects.
The GetChildRows method of the DataRow class is used to get the child rows of a DataRow object. The DataRow class defines four overloaded versions of the method. Their signatures are as follows:
| |
|
The MessageName property of the WebMethod attribute is used to give an alias name to an XML Web service method. It is generally used to uniquely identify overloaded Web methods. By default, the MessageName property for a Web method is set to the name of the method. However, if an XML Web service contains two or more Web methods with the same name, individual Web methods are uniquely identified by setting MessageName to a name that is unique within that XML Web service. The SOAP message uses the name, which is used in the MessageName property for a method as the method name instead of the actual method name.
Following is the syntax for the
where, datasetobjectname specifies the name of the DataSet object, filename specifies the name of the file, including the path, to which to write data, and mode specifies an XmlWriteMode value. Following are the values that can be used for XmlWriteMode:
