visual studio .net | uCertify.com

MCTS 70-431 Short Notes: Exam Passing Tips

Installing and Configuring SQL Server 2005

In order to change collation settings, reinstall SQL Server 2005 on a server with the same collation settings as another server.
In order to install SQL Server 2005 on a computer on which SQL Server 2000 is already installed, install SQL Server 2005 as a named instance.
Members of db_access role can assign permissions to other users to enable them to access and query the database.
RAID-0, also known as disk striping, is made up of a disk set in which data is divided into blocks and spread equally in each disk. It provides best performance because data read and data write operations are not limited to a single disk, but to a set of disks. It does not provide data redundancy. Data once lost cannot be recovered.
The Service Broker can be attached to a database by using the FOR ATTACH clause of the CREATE DATABASE statement.

If a snapshot of a database is present on the same computer on which the database is present, the database cannot be deleted.
In order to connect to the DAC, specify ADMIN: server_name in the Connect to the Server dialog box.
The login information stored in the master database.
In order to secure data that is data transmitted over a network, set the value of the ForceEncryption option on a server to Yes.
In order to enable a user to connect to the database, a DBA should add the user to that database.
The db_ddladmin fixed database role allows its members to add, modify, or drop objects in the database. Members of the db_ddladmin role can issue DDL statements (e.g. CREATE, ALTER, and DROP) in the database.
Member of db_ddladmin role have the permission to execute the T-SQL statements.
The sysadmin role allows a user to view the security log.

Developing applications that use system types and collections

Use the CausesValidation property of the ImageButton class to set a value to indicate whether validation is performed on a Web server control when an ImageButton control is clicked.
Installation packages are created for deploying a Web application by using a Web Setup project. A merge module project is used for components to be added to the application.
Use the Web Setup project and Deployment project to create installation packages for the deployment of Web-based applications such as XML Web services, Web applications etc., to a Web server.
Use a RequiredFieldValidator control to check whether or not an input control contains a value.
Use a RegularExpressionValidator control to check whether or not the value entered into a form field matches the pattern specified by a regular expression.
Use the validation error messages to be displayed on a Web page in a message box by setting the ShowMessageBox property of the ValidationSummary control to true. By setting the ValidationSummary property of the ValidationSummary control to false, the validation summary will not be displayed on the Web page.
Create and sort an array of data using the System namespace.

Creating User Services

The identity object that implements the IIdentity interface, is used during the authentication process, when a user’s identity is verified. It contains information about a user who is being validated, such as username and password.
The principal object that implements the IPrincipal interface, is used during the authentication process when the application determines the data that can be accessed by a user and the code to be executed. It contains information about a user’s identity, such as username and password, as well as information about a user’s role, such as manager or associate.
Setting the MinimizeBox property of a Windows form to false prevents the minimize button from being displayed in the caption bar of the form.