CET_TARDE - MTA Database - INDEX

1

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.

1

This question requires that you evaluate the underlined text to determine if it is correct. In a database table, each column represents a unique record.
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.

1

You have two tables named Salesperson and Sales. You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table. Which database object should you add to the Sales table?

1

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 relationship between the data that is in the two tables. Which constraint should you define?

1

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, triggers, constraints, and permission specifications for those 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 correct

1

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

1

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 Employee table?

1

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

1

Which statement will result in the creation of an index?

1

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

1

One reason to add an index is to:

1

The following illustration shows the structure of a clustered index in a single partition:

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

1

Instructions: For each of the following statements, select Yes if the statement is true.
Otherwise, select No. Each correct selection is worth one point.

Database Fundamentals Quizzes preparing to certification

CET_TARDE - MTA Database - INDEX

You have two tables named Salesperson and Sales. You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table. Which database object should you add to the Sales table?

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 relationship between the data that is in the two tables. Which constraint should you define?

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

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 Employee table?

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

Which statement will result in the creation of an index?

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

One reason to add an index is to:

The following illustration shows the structure of a clustered index in a single partition: Instructions: Use the drop-down menus to select the answer choice that completes each statement Each correct selection is worth one point.

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

The following illustration shows the structure of a clustered index in a single partition:

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

Instructions: For each of the following statements, select Yes if the statement is true.
Otherwise, select No. Each correct selection is worth one point.