98-364 Online Practice Questions and Answers

At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails. You run a script to apply only the

3:00 P.M. backup to your database.

What is the result of the script?

A. The Customer table no longer exists.

B. The Customer table is unaffected.

C. The Customer table exists but has no data.

D. The script fails.

You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?

A. INTEGER

B. DOUBLE

C. COUNT

D. FLOAT

The Product table contains the following data.

You execute the following statement:

SELECT COUNT(*)

FROM Product WHERE Quantity > 18

What is the value returned by this statement?

A. 1

B. 2

C. 3

D. 4

You need to disable User1's access to view the data in the Customer table.

Which statement should you use?

A. Option A

B. Option B

C. Option C

D. Option D

First normal form requires that a database excludes:

A. Foreign keys

B. Composite keys

C. Duplicate rows

D. Repeating groups

Your database contains a table named Customer.

You need to delete the record from the Customer table that has a CusromerID of 12345.

Which statement should you use?

A. Option A

B. Option B

C. Option C

D. Option D

You have the database table named Cars as defined below:

You have the following Structured Query Language (SQL) statement:

How many rows are returned by the SQL statement?

A. 4

B. 5

C. 6

D. 7

This question requires that you evaluate the underlined text to determine if it is correct.

In a database table, each column represents a unique record.

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. Table

C. Index

D. Row

You are developing a SQL query.

Which two SQL constructs represent data manipulation language (DML) statements? Choose two.

A. SELECT EmployeeName FROM Employee WHERE EmployeeName = 'Jack Smith';

B. INSERT INTO Employee VALUES ('Jack Smith')

C. ALTER TABLE Employee ADD EmployeeName Varchar;

D. CREATE ROW IN Employee WHERE EmployeeName = 'Jack Smith';

You need to create a view to filter rows of data from an underling table.

Which type of clause must be included in the CREATE VIEW statement?

A. CONSTRAINT

B. WHERE

C. JOIN

D. FILTER