Q1. You are designing database for a new Web application. You need to identify appropriate relational database structure to satisfy business requirements. Which of the following activities should you not perform as part of the design process? 

A. Identify tables and columns. 

B. Choose primary keys for the tables. 

C. Identify table relationships. 

D. Apply the normalization process. 

E. Write stored procedures. 

View Answer

Q2. You are planning to develop a new software system for your organization. You need to verify that the implementation of the system matches with the requirements of the system. Which of the following activities would accomplish this requirement? 

A. testing 

B. design 

C. release 

D. requirements analysis 

View Answer

Q3. You need to update the Products table and remove all discontinued products. When the products are discontinued, the value of the field Discontinued is set to true. Which of the following SQL statements should you use to make changes to the Products table? 

A. INSERT 

B. SELECT 

C. UPDATE 

D. DELETE 

View Answer

Q4. In your application, you are using a stack data structure to manipulate information. You need to find which data item will be processed next, but you don’t want to actually process that data item yet. Which of the following queue operations will you use? A. pop 

B. push 

C. peek 

D. contains 

View Answer

Q5. You are developing an ASP.NET application that uses a Web service created by one of your large customers. This Web service provides you with the Order object, which has several properties. The developer of the Web service has informed you that a new property named Priority has added to the Order object. What should you do to be able to use the Priority property in your code with minimum effort? 

A. Create a new ASP.NET application and add a Web reference to the Web service in the new application. 

B. Delete and re-create the Web reference in the existing ASP.NET application. 

C. Update the Web reference in the existing ASP.NET application. 

D. Ask the developer of the Web service forthe updatedDLL file of the Web service. Add a reference to theDLL in your ASP.NET project. 

View Answer

Q6. You write the following code in your Web page: 

protected void Page_Load 

(object sender, EventArgs e) 

{ 

/* additional code here */ 

} 

You expect this code to be executed in response to the Load event of the ASP.NET page. However, when you request the page, you notice that the method is not executed. What should you do to make sure that the Page_Load method is executed when the Load event of the Wep page is fired? 

A. Set the AutoEventWireup attribute of the @page directive to true. 

B. Set the AutoEventWireup attribute of the @page directive to false. 

C. Set the IsCallBack property of the page class to true. 

D. Set the IsPostBack property of the page class to true. 

View Answer

Q7. You are planning to develop a new software system for your organization. You need to review the plan for packaging, deployment, delivery, and support for the software. Which of the following should you contact? 

A. quality assurance manager 

B. release manager 

C. technical architect 

D. database administrator 

View Answer

Q8. You are developing an application that needs to copy data from a SQL Server table to a DataSet. Which of the following methods should you use to copy the data? 

A. Fill 

B. FillSchema 

C. GetFillParameters 

D. Update 

View Answer

Q9. Arrange the various activities of an application lifecycle in the order in which they are likely to occur. 

A. Requirements analysis, design, coding, testing, and release 

B. Design, requirements analysis, coding, testing, and release 

C. Release, requirements analysis, coding, testing, and design 

D. Requirements analysis, design, release, coding, and testing 

View Answer

Q10. The application you are developing needs to write data to a flat file that include items such as a five-digit integer key, followed by a 20-character customer name, followed by two date and time fields. Your solution should be as fast as possible and should create smallest size data file. Which of the following classes should you use? 

A. FileStream 

B. StreamWriter 

C. BinaryWriter 

D. DataWriter 

View Answer