1.
You have a table named ITEMS with the following fields:
ID (integer, primary key, auto generated)
Description (text)
Completed (Boolean)
You need to insert the following data in the table:
"Cheese", False
Which statement should you use?
2.
This question requires that you evaluate the underlined text to determine if it is correct. The bubble sort algorithm steps through the list to be sorted, comparing adjacent items and swapping them if they are in the wrong order Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed" if the underlined text makes the statement correct.
3.
You are developing a webpage that enables students to manage races. The webpage will display two lists: past races and upcoming races. The page also contains a sidebar with contact information and a panel with social media settings that can be edited. Race results can be shared on social media. How many components will be on the webpage?
4.
This question requires that you evaluate the underlined text to determine if it is correct. Converting a value type to a reference type in an object is called boxing. Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed" if the underlined text makes the statement correct.
 
5.
The Dog class and the Cat class inherit from the Animal class. The Animal class includes a breathe() method and a speak() method. If the speak() method is called from an object of type Dog, the result is a bark. If the speak() method is called from an object of type Cat, the result is a meow. Which term is used to describe this object-oriented concept?
6.
This question requires that you evaluate the underlined text to determine if it is correct. A data dictionary that describes the structure of a database is called metadata. Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed" if the underlined text makes the statement correct.
7.
This question requires that you evaluate the underlined text to determine if it is correct. To improve performance, a SQL SELECT statement should use indexes. Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed'' if the underlined text makes the statement correct.
8.
You are building a web application that enables international exchange students to schedule phone calls with their prospective schools. The application allows students to indicate a preferred date and time for phone calls. Students may indicate no preferred time by leaving the date and time field empty. The application must support multiple time zones. Which data type should you use to record the student's preferred date and time?
9.
This question requires that you evaluate the underlined text to determine if it is correct. When a base class declares a method as virtual, the method is hidden from implementation bv a derived class. Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed'' if the underlined text makes the statement correct.
10.
This question requires that you evaluate the underlined text to determine if it is correct. The process of transforming compiled C# code into an XML string for a web service is known as deserialization. Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed'' if the underlined text makes the statement correct.