Free 98-364 Exam Dumps Preview

You have a table of products with fields for ProductID, Name, and Price.

You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.

Which clause should you use in your update statement?

Which statement should you use to remove a foreign key?

You need to remove a view named EmployeeView from your database.

Which statement should you use?

You are developing a SQL query.

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

You ate creating a database object named Student to store the following data:

Which syntax should you use to create the object?

Which command should you use to remove a table from a database?

You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column.

You execute the following statement:

DELETE FROM Student

What is the result?

HOTSPOT

You have a user that has server roles as defined below:

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

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

You have a table named Employee that includes the following columns:

EmployeeID
Smp1oyeeName

Which statement should you use to return the number of rows in the table?

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

Create a query that returns a set of table data by using the UPDATE statement.

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.

The component that holds information for a single entry in a table is called a:

You have a table that contains information about all students in your school.

Which SQL keyword should you use to change a student's first name in the table?

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?

HOTSPOT

The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

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

A key defines the amount of storage space that is allocated to a value in a column.

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

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

SELECT *
FROM Employee

Which columns are returned?

You have a table named Product that contains one million rows.

You need to search for product information in the Product table by using the product's unique ID.

What will make this type of search more efficient?

Which keyword can be used in a create table statement?

You need to add rows to a database table.

Which Structured Query Language (SQL) keyword should you use?

On which database structure does an insert statement operate?