98-364 Exam Questions

The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?

One reason to add an index is to:

You have a table that contains the following data. You break the table into the following two tables. This process is referred to as:

You have a table that contains the following data. Which database term is used to describe the relationship between ProductID and ProductCategory?

Which key uniquely identifies a row in a table?

Which statement creates a composite key?

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

In which situation do you need to perform a restore on a database?

Which command should you use to give a user permission to read the data in a table?

You need to enable a new employee to authenticate to your database. Which command should you use?

One reason to create a stored procedure is to:

Which permission does a user need in order to run a stored procedure?

You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category. You execute a statement on the Product t...

In SQL, an insert statement is used to add a:

You have two tables. Each table has three rows. How many rows will be included in the Cartesian product of these two tables?

You are writing an SQL statement to retrieve rows from a table. Which data manipulation language (DML) command should you use?

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

Which category of SQL statements is used to add, remove, and modify database structures?

You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column. The results include: - All customers and their orders...

Data in a database is stored in:

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

You need to establish a set of permissions that you can routinely assign to new users. What should you create?

Which database term is used to describe the process of applying a backup to a damaged or corrupt database?

You need to disable User1's access to view the data in the Customer table. Which statement should you use?

Denormalization is performed in order to:

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

You have a table named Product that contains the following data. The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category....

You need to list the name and price of each product, sorted by price from highest to lowest. Which statement should you use?

You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:

Which statement deletes the rows where the employee's phone number is not entered?

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

You have a table named Employee that includes four columns. You execute the following statement: - SELECT * - FROM Employee Which columns are returned?

Which two elements are required to define a column? (Choose two.)

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

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

What is one difference between an update statement and a delete statement?

You have a Department table and an Employee table in your database. You need to ensure that an employee can be assigned to only an existing department. What should you apply to the...

You need to store the first name, last name, and student ID for 100 students. This information will be stored in a table as:

What are three valid data manipulation language (DML) commands? (Choose three.)

You assign User1 a set of permissions that include the WITH GRANT OPTION. The WITH GRANT OPTION enables User1 to:

Which type of index changes the order in which the data is stored in a table?

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?

You have a database table named SongInformation as defined below: You need to create a Structured Query Language (SQL) query to retrieve only the names of songs that sold more than...

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. The table has the following colum...

This question requires that you evaluate the underlined text to determine if it is correct. Use the FROM keyword in a SELECT statement to return rows that meet a specific condition...

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?

This question requires that you evaluate the underlined text to determine if it is correct. The CREATE TABLE command removes one or more table definitions and all data, indexes, tr...

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

While attending college, you accept an IT internship at a local charity. The charity needs to report on data that is related and exists in two tables. You need to establish a relat...

This question requires that you evaluate the underlined text to determine if it is correct. A view can be used to ensure referential integrity. Instructions: Review the underlined...