Which three are valid SQL keywords? (Choose three.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
You open the Internet Information Services 7.5 Manager console as shown in the following exhibit:
You need to examine the current configuration of the server W2008R2.
Use the drop-down menus to select the answer choice that answers each question. Each correct selection is worth one point.
You are reviewing the architecture for a system that allows race officials to enter the results of 5K race results. The results are then made available to students using a web application. The architecture is shown below:
Use the drop-down menus to select the answer choice that answers each question. Each correct selection is worth one point.
You are creating an application that presents the user with a Windows Form. You need to configure the application to display a message box to confirm that the user wants to close the form.
Which event should you handle?
You have a Microsoft ASP.NET web application.
You need to store a value that can be shared across users on the server.
Which type of state management should you use?
The following functions are defined:
What does the console display after the following line?
Printer(2)
You execute the following code.
What will the variable result be?
This question requires that you evaluate the underlined text to determine if it is correct.
Arguments are passed to console applications as a Hashtable object.
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.
You are creating a routine that will perform calculations by using a repetition structure. You need to ensure that the entire loop executes at least once.
Which looping structure should you use?
You are creating an application that presents users with a graphical interface in which they computers that do not have network connectivity.
Which type of application should you choose?
You have a class named Glass that inherits from a base class named Window. The Window class includes a protected method named break().
How should you call the Glass class implementation of the break() method?
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?
In which order do the typical phases of the Software Development Life Cycle occur?
Which type of function can a derived class override?
The purpose of the Finally section in an exception handler is to:
What are two methods that can be used to evaluate the condition of a loop at the start of each iteration? (Each correct answer presents a complete solution. Choose two. )
You are developing an application that displays a list of race results. The race results are stored in the following class:
The code that manages the list is as follows:
You need to implement the AddRace method.
Match the code segment to its location. (To answer, drag the appropriate code segment from the column on the left to its location on the right. Each code segment may be used once, more than once, or not at all. Each correct match is worth one point.)
You have a class with a property.
You need to ensure that consumers of the class can write to the value of the property.
Which keyword should you use?
You have a website that includes a form for usemame and password.
You need to ensure that users enter their username and password. The validation must work in all browsers.
Where should you put the validation control?
How should you configure an application to consume a Web service?
You are reviewing a design for a database. A portion of this design is shown in the exhibit. Note that you may choose to view either the Crow's Foot Notation or Chen Notation version of the design. (To view the Crow's Foot Notation, click the Exhibit A button. To view the Chen Notation, click the Exhibit B button.)
Which term is used to describe the relationship between Customer and Order?
Which language allows you to dynamically create content on the client side?
What does the Console.Error property do within a console-based application?
This question requires that you evaluate the underlined text to determine if it is correct.
When creating a site to utilize message queuing, the "IP address" must be configured to MSMQ.
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.
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?
You are creating a Web application. The application will be consumed by client computers that run a variety of Web browsers.
Which term is used to describe the process of making the application available for client computers to access?
Which language was designed for the primary purpose of querying data, modifying data, and managing databases in a Relational Database Management System?
This question requires that you evaluate the underlined text to determine if it is correct.
Converting an object to a more general type is called upcasting.
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.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
You are designing a class for an application. You need to restrict the availability of the member variable accessCount to the base class and to any classes that are derived from the base class.
Which access modifier should you use?
You have a stack that contains integer values. The values are pushed onto the stack in the following order: 2,4,6,8.
The following sequence of operations is executed:
Pop
Push 3
Pop
Push 4
Push 6
Push 7
Pop
Pop
Pop
What is the value of the top element after these operations are executed?
A data warehouse database is designed to:
In your student directory database, the Students table contains the following fields:
firstName
lastName
emailAddress
telephoneNumtoer
You need to retrieve the data from the firstName, lastName, and emailAddress fields for all students listed in the directory. The results must be in alphabetical order according to lastName and then firstName.
Which statement should you use?
For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
You have a server that limits the number of data connections.
What should you use to optimize connectivity when the number of users exceeds the number of available connections?
For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
This question requires that you evaluate the underlined text to determine if it is correct.
The default entry point for a console application is the Class method.
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.
What are two advantages of normalization in a database? (Choose two)
In the application life cycle, the revision of an application after it has been deployed is referred to as:
You have a table named ITEMS with the following fields:
You need to insert the following data in the table:
"Cheese", False
Which statement should you use?