98-364 Online Practice Questions and Answers

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.

Hot Area:

Hot Area:

You have a table named Product. The Product table has columns for ProductDescription and ProductCategory.

You need to change the ProductCategory value for all the spoons in the Product table to 43.

Which statement should you use?

A. Option A

B. Option B

C. Option C

D. Option D

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 list the name and price of each product, sorted by price from highest to lowest. Which statement should you use?

A. Option A

B. Option B

C. Option C

D. Option D

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

CREATE TABLE Product (ProductID INTEGER, Name VARCHAR(20))

You need to insert a new product. The product's name is Plate and the product's ID is 12345.

Which statement should you use?

A. Option A

B. Option B

C. Option C

D. Option D

You need to combine the results of two queries into a single result that contains all of the rows from both queries. Which Structured Query Language (SQL) statement should you use?

A. TRUNCATE

B. JOIN

C. EXCEPT

D. UNION

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

You have two tables. Each table has three rows. You create a SQL query that uses a cross join. The query does not include a WHERE clause.

Nine rows will be included in the Cartesian product of these two tables.

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

A. No change is needed

B. Zero

C. Three

D. Six

You have the following SQL query

SELECT * FROM dbo.ProAthlete WHERE Salary > 500000

The query takes too much time to return data.

You need to improve the performance of the query.

Which item should you add to the Salary column?

A. Non-null constraint

B. Default constraint

C. Index

D. Foreign key