Q1. 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

Q2. You are creating a new class named Sphere derived from the Shape class. The Shape class has the following code: 

class Shape 

{ 

public virtual void Area() 

{ 

// additional code... 

} 

} 

The Area method in the Shape class should provide new functionality but also hide the Shape class implementation of the Area method. Which code segment should you use to accomplish this? 

A. class Sphere : Shape 

{ 

public override void Area() 

{ 

// additional code ... 

} 

} 

B. class Sphere : Shape 

{ 

public new void Area() 

{ 

// additional code ... 

} 

} 

C. class Sphere : Shape 

{ 

public virtual void Area() 

{ 

// additional code ... 

} 

} 

D. class Sphere : Shape 

{ 

public static void Area() 

{ 

// additional code ... 

} 

} 

View Answer

Q3. You are writing a C# program that needs to iterate a fixed number of times. You need to make sure that your code is easy to understand and maintain even when the loop body contains complex code. Which of the following C# statements provide the best solution for this requirement? 

A. while 

B. for 

C. for each 

D. do-while 

View Answer

Q4. You are reviewing a C# program that contains the following class: 

public class Rectangle 

{ 

public double Length {get; set;} 

public double Width { get; set; } 

} 

The program executes the following code as part of the Main method: 

Rectangle r1, r2; 

r1 = new Rectangle { Length = 10.0, Width = 20.0 }; 

r2 = r1; 

r2.Length = 30; 

Console.WriteLine(r1.Length); 

What will be the output when this code is executed? 

A. 10 

B. 20 

C. 30 

D. 40 

View Answer

Q5. You are developing a C# application. You create a class of the name Widget. You use some third-party libraries, one of which also contains a class of the name Widget. You need to make sure that using the Widget class in your code causes no ambiguity. Which C# keyword should you use to address this requirement? 

A. namespace 

B. override 

C. delegate 

D. class 

View Answer

Q6. You are developing code for a method that calculates the discount for the items sold. You name the method CalculateDiscount. The method defines a variable, percentValue of the type double. You need to make sure that percentValue is accessible only within the CalculateDiscount method. What access modifier should you use when defining the percentValue variable? 

A. private 

B. protected 

C. internal 

D. public 

View Answer

Q7. You are in the process of developing a new software application. As defects are reported, you take the necessary steps to fix them. You need to make sure that each new fix doesn’t break anything that was previously working. Which type of testing should you use? 

A. integration testing 

B. system testing 

C. acceptance testing 

D. regression testing 

View Answer

Q8. You are writing a C# program that iterates through a collection such as arrays and lists. You need to make sure that you process each item in the collection once. You also need to ensure that your code is easy to read and debug. Which of the following C# statements provide the best solution for this requirement? 

A. while 

B. for 

C. foreach 

D. do-while 

View Answer

Q9. You are designing a database for your company and are reviewing the normalization for the database tables. 

You review the following Customer table: 

Which of the following statements is true? 

A. The highest normal form of the Customer table is the first normal form. 

B. The highest normal form of the Customer table is the second normal form. 

C. The highest normal form of the Customer table is the third normal form. 

D. The Customer table is not normalized. 

View Answer

Q10. You are developing a data-entry application that receives user input in multiple data fields. The application allows users to enter the data either by using a keyboard or by using a bar-code scanner. When a code is entered, a picture of the product appears onscreen. The application also needs to log its operation to a console window. Occasionally, the operator will look at the console window to monitor communication with the scanner. 

What project should you choose to create such an application? 

A. a console application project 

B. a console application project with the Output type set to Windows Application 

C. a Windows Forms application project 

D. a Windows Forms application project with the Output type set to Console Application 

View Answer