Andrew works as a Software Developer for BlueWell Inc. He develops a Windows-based application, named App1, using Visual Studio .NET. The application uses Microsoft SQL Server as a backend database. Andrew wants to perform security checks on App1. Which of the following statements regarding security checks are true?
Each correct answer represents a complete solution. Choose two.

• A. Declarative security check works by instantiating security classes.
• B. Imperative security check works by assigning attributes to assemblies.
• C. Imperative security check works by instantiating security classes.
• D. Declarative security check works by assigning attributes to assemblies.

Peter works as a Software Developer for NessCom Inc. He creates a Web application named WebApp using Visual Studio .NET. WebApp contains an .aspx page named DataValidatePage.aspx, which has several Web server controls. Two TextBox controls, txtProdID and txtProdName, are used. The txtProdID control is used to enter the identification number of the products used by the company. The txtProdName control is used to enter valid product names. Peter wants to ensure that only valid data is entered in these two TextBox controls. Therefore, he implements a RequiredFieldValidator class in the DataValidatePage.aspx page. Choose the appropriate actions Peter will perform to accomplish the task.

Allen works as a Software Developer for Mansoft Inc. He develops an application using Visual Studio .NET 2005. The application connects to a SQL Server database using a SqlConnection object named NewConnection. Allen creates a few stored procedures in the database. Sometimes an error occurs, when a user executes stored procedures. Allen wants to add an error-handling code to the application to handle errors that occur on executing stored procedures. Which of the following code segments will he use to accomplish this task?

• A. try { NewConnection.Open(); } catch(InvalidCastException exep) { //Error-handling code }
• B. try { NewConnection.Open(); } catch(SqlException exep) { //Error-handling code }
• C. try { NewConnection.Open(); } catch(DataException exep) { //Error-handling code }
• D. try { NewConnection.Open(); } catch(DBConcurrencyException exep) { //Error-handling code }

You work as a Database Administrator for ABC Inc. The company has a SQL Server 2000 computer. One of the databases on the server contains a table named Employees, for storing information about employees in the company. There are two employees, Joe and Rick, to whom you want to give additional responsibilities. You want Joe to be allowed to modify only the E-mail column of the table, and Rick should be allowed to modify only the Salary column of the table. Neither Joe nor Rick should be allowed to have permission on the Employees table.
You want to ensure that the above rule is followed strictly. What will you do to accomplish this?

• A. Create a stored procedure to modify data
• B. Create a RULE on both the columns.
• C. Create a user-defined function to modify data.
• D. Create a CHECK constraint on both the columns.

You work as a Software Developer for ManSoft Inc. The company uses Visual Studio.NET as its application development platform. You create an application using the .NET Framework. You use ManSoft's intranet to deploy the application to client computers. You use the security configuration of the .NET Framework to configure security for the application at the enterprise policy level. Virus attacks caused the IT manager at ManSoft Inc. to tighten the security at the machine level. Users reported that they could no longer execute the application. Which of the following options will you use to resolve this issue?

• A. Include the Exclusive attribute in the intranet code group policy at the enterprise level by using the Permission View tool (Permview.exe).
• B. Include the LevelFinal attribute in the intranet code group policy at the enterprise level by using the Code Access Security Policy tool (Caspol.exe).
• C. Include the LevelFinal attribute in the intranet code group policy at the enterprise level by using the Permission View tool (Permview.exe).
• D. Include the Exclusive attributes in the intranet code group policy at the enterprise level by using the Code Access Security Policy tool (Caspol.exe).