Which language uses Data Definition Language (DDL) and Data Manipulation Language
(DML)?

A table named Student has columns named ID, Name, and Age. An index has been created
on the ID column. What advantage does this index provide?

Which language was designed for the primary purpose of querying data, modifying data, and
managing databases in a Relational Database Management System?

You need to ensure the data integrity of a database by resolving insertion, update, and
deletion anomalies.
Which term is used to describe this process in relational database design?

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?

A data warehouse database is designed to:

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?

Which type of application has the following characteristics when it is installed?
Runs continuously in the background by default when the startup type is set to automatic
Presents no user interface

You are creating an application that accepts input and displays a response to the user. You
cannot create a graphical interface for this application.
Which type of application should you create?

You need to create an application that processes data on a last-in, first-out (LIFO) basis.
Which data structure should you use?