D427 Second attempt Quiz

How did you feel going in the first attempt?

Rate your experience with the OA.

What transpired during the attempt?

A column in Table B has been indexed? Which action would cause the index to be updated?

• A different table is joined with Table B

• A different column is updated in Table B

• A row is deleted from Table B

• A new column is added to Table B

What is the purpose of an index in a database?

• To store data

• To enhance the speed of data retrieval

• To backup the database

• To normalize the data

You have a table named 'sales' with millions of rows. Queries on this table are running slowly. Which of the following strategies would likely improve query performance the most? (1 Point)

• Adding more columns to the 'sales' table.

• Creating indexes on the columns most frequently used in WHERE clauses.

• Splitting the table into multiple smaller tables.

• Adding redundant data to the table to avoid joins.

Values in a foreign key must be unique.

• True

• False

In a CREATE TABLE statement, the FOREIGN KEY constraint must follow all column declarations.

• True

• False

In a FOREIGN KEY constraint, parentheses are required around the foreign key column name.

• True

• False

Drop the UNIQUE constraint called UniqueNameMgr from the existing Department table. ALTER TABLE Department.

• DROP INDEX UniqueNameMgr

• DROP CONSTRAINT UniqueNameMgr

• DROP CHECK UniqueNameMgr

• DROP CHANGE UniqueNameMgr

Determine the maxima for this relationship. Student-Takes-Course.

• one-many

• many-one

• one-one

• many-many