Which keyword can be used in a create table statement?
A database contains two tables named Customer and Order.
You execute the following statement:
DELETE FROM Order
WHERE CustomerID = 209
What is the result?
You accept an IT internship at a local charity. The charity has two tables in their data model named Chapter and Language, as defined below:
You create a third table named ChapterLanguage to relate the Chapter table and the Language table.
You need to select columns from the Chapter and Language tables to create a composite primary key for the ChapterLanguage table.
Which two columns should you select? (Choose two.)
This question requires that you evaluate the underlined text to determine if it is correct.
The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct
This question requires that you evaluate the underlined text to determine if it is correct.
Use indexing to create, remove, or change database objects.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.
You have a table named Customer. You need to add a new column named District.
Which statement should you use?
You need to populate a table named EmployeeCopy with data from an existing table named Employee.
Which statement should you use?
Which type of index changes the order in which the data is stored in a table?
You work at a restaurant and they ask you to help them with a data issue.
They provide you with the following recipe data:
You need to normalize the data to third normal form.
How many tables should you create?
On which database structure does an update statement operate?
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
A named group of SQL statements that can be executed in a database is called a:
The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:
The following illustration shows backup strategies that use the simple recovery model and the full recovery model:
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
You have the following table:
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
One difference between a function and a stored procedure is that a function:
You need to store the first name, last name, and student ID for 100 students.
This information will be stored in a table as:
You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used.
Which data type should you use?
