98-364 Online Practice Questions and Answers

You need to set up a database to provide a view of North American mammals. Match the Structured Query Language (SQL) statements to the SQL query.

Instructions: To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL query on the right Each SQL statement may be used once, more than once, or not at all. Each correct match is worth one point.

Select and Place:

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

Hot Area:

You are structuring a table in a relational database.

Instructions: For each of the following statement, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

Hot Area:

Which keyword can be used in a create table statement?

A. ORDER BY

B. DISTINCT

C. GROUP BY

D. UNIQUE

Which category of SQL statements is used to add, remove, and modify database structures?

A. Data access language (DAL)

B. Data manipulation language (DML)

C. Data control language (DCL)

D. Data definition language (DDL)

You have a table named Employee that includes four columns. You execute the following statement:

SELECT * FROM Employee

Which columns are returned?

A. all columns

B. only the last column

C. only the first column

D. only the first and last columns

You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted. What is the result in the database?

A. The table will be corrupted.

B. Forty (40) rows will be deleted from the table.

C. The transaction will restart.

D. No rows will be deleted from the 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?

A. 1

B. 2

C. 3

D. 4

You work at a coffee shop. They ask you to set up a website that stores charges on purchases.

You need to recommend a data type in a database table to run financial functions against the charged amounts.

Which data type should you recommend?

A. Money

B. Bit

C. Varchar

D. Binary

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

A. No change is needed

B. INTERSECT

C. ALL

D. JOIN