98-364 Online Practice Questions and Answers

HOTSPOT

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 have the following table definition:

CREATE TABLE Road (RoadID INTEGER NOT NULL, Distance INTEGER NOT NULL)

The Road table contains the following data: You execute the following statement: INSERT INTO Road VALUES (1234, 36)

What is the result?

A. an error stating that NULL values are not allowed

B. a new row in the table

C. an error stating that duplicate IDs are not allowed

D. a syntax error

One reason to create a stored procedure is to:

A. Improve performance.

B. Minimize storage space.

C. Bypass case sensitivity requirements.

D. Give the user control of the query logic.

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

Data in a database is stored in:

A. Tables

B. Queries

C. Data types

D. Stored procedures

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

You need to insert two new products into the Product table. The first product is named Book and has an ID of 125. The second product is named Movie and has an ID of 126.

Which statement should you use?

A. Option A

B. Option B

C. Option C

D. Option D

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

Use the ALTER statement to add a new table in a database.

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

C. INSERT

D. CREATE

You need to rename a column in a database table.

Which data definition language (DDL) statement should you use?

A. ALTER

B. INSERT

C. CREATE

D. UPDATE

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.

A. No change is needed.

B. Data manipulation language (DML) statements

C. Data definition language (DDL) statements

D. A unique constraint

You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer.

When volunteers ask to be removed from mailing lists, the table must be updated.

You need to use a transaction to ensure that the database has data integrity and referential integrity.

Which statement should you use?

A. Option A

B. Option B

C. Option C

D. Option D

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

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

Ports 20 and 21 are the default ports to secure a SQL Server.

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. 1433 and 1434

C. 411 and 412

D. 67 and 68

You create the following table, which lists how many books you have on loan to your friends.

Harry in San Francisco returns your books.

Which statement will update your table correctly?

A. UPDATE LoanedBooks SET Books = 0 WHERE (Name = 'Harry' AND City = 'San Francisco')

B. UPDATE LoanedBooks SET Books = 0 WHERE (Name = 'Harry' OR City = 'San Francisco')

C. UPDATE LoanedBooks SET Books = 0 WHERE (Name in 'Harry', 'San Francisco')

D. INSERT INTO LoanedBooks SET Books = 0 WHERE ID =

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

A relational database management system employs the concept of an attribute to ensure that data entered into a field in a column is valid.

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. a primary key

C. a constraint

D. an index