98-364 Online Practice Questions and Answers

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:

Which constraint ensures a unique value in the ID column for each customer?

A. DISTINCT

B. FOREIGN KEY

C. SEQUENTIAL

D. PRIMARY KEY

Which keyword must be included in a create view statement?

A. WHERE

B. ORDER BY

C. UPDATE

D. SELECT

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

What defines the amount of storage space that is allocated to a value in a column?

A. format

B. key

C. data type

D. validator

You are creating a table to store customer data. The AccountNumber column uses values that always consist of one letter and four digits. Which data type should you use for the AccountNumber column?

A. CHAR

B. BYTE

C. DOUBLE

D. SMALLINT

You have a table that contains product IDs and product names.

You need to write an UPDATE statement to change the name of a specific product to glass.

What should you include in the update statement?

A. SET ProduetName = 'glass'

B. LET ProduetName = 'glass'

C. EXEC ProduetName = 'glass'

D. ASSIGN ProduetName = 'glass'

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 accept an IT internship at a local charity. The charity wants you to help them with compliance and auditing requirements.

You need to ensure that a column or combination of columns uniquely identifies each row of a table.

Which constraint should you define?

A. Primary key

B. Secondary key

C. Foreign key

D. Default key

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

ALTER TABLE removes all rows from a table without logging the individual row deletions.

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. DROP TABLE

C. TRUNCATE TABLE

D. CREATE TABLE