C170 Alternate Test

A customer can purchase many products and a product can be purchased by many customers. Which kind of binary relationship does this scenario describe?

Which kind of relationship is displayed in this entity-relationship diagram?

Which kind of relationship is displayed in this entity-relationship diagram?

How is this portion of the entity-relationship diagram read, from left to right?

Which two examples are attributes?

Which delete rule sets column values in a child table to NULL when the matching data is deleted from the parent table?

A patient is related to two exam records. The table follows the restrict delete rule. What happens if someone tried to delete the patient?

Which two columns are created as something other than variable-length strings in the statement above? Choose 2 answers

The database table above has 7 different physician IDs in the first column and physician_id is the primary key of the table. There are 7 different physician names in the second column. The third column indicates which site a physician is located at. There are 3 different sites. Two of the site names are repeated 3 times. Which action should be used to translate this data into third normal form?

A database designer is working through the normalization process. A simple primary key has been established. All of the repeating groups and multi-valued fields have been removed In which form is this table:

Two attributes in two related tables have the exact same domain of values. The attribute is a primary key (PK) in one table. Which kind of key is the attribute in the other table?

In this entity-relationship diagram, many instructors are shown as working at a minimum of one campus. How is the relationship between instructors and campuses represented in the diagram?

In which two ways can data redundancy affect managing disk storage space and calculation speed? Choose 2 answers:

With which command can a database administrator allow a user named Mary to query the Patient table by executing SELECT commands on it?

Why does MySQL’s architecture use concurrency control?

Which command creates a database only if it does not already exist?

Refer to the given SQL statement: SELECT item_number, item_name FROM item Which line should be added to the end of the statement to return the item numbers and item names for items that have an item_price of 10 dollars?

What does WHERE identify in a basic SQL SELECT statement?

Refer to the given SQL statement. SELECT patient_id FROM patient Which line added to the end of the statement returns patient ids of at least 1000?

Refer to the given SQL statement: SELECT item_id, SUM(quantity) FROM invoice Which line, when added to the end of the statement, returns the total number of each kind of item by item_id?

Which data definition language statement affects databases or objects in them?

What does the DELETE statement do?

Which condition must be in effect to use the INSERT INTO … VALUES syntax for an INSERT statement?

Which kind of data type is FLOAT in the statement?

Which two MySQL data types can represent images or sounds? Choose two

Refer to the given SQL statement. CREATE TABLE Invoice ( invoice_id INT NOT NULL , date DATE NOT NULL, customer_id INT NOT NULL, PRIMARY KEY (invoice_id), FOREIGN KEY (customer_id) REFERENCES Customer (customer_id) ); In which line of the statement is the table given its name?

Which method creates an empty copy of a table and then populates it from the original table?

Refer to the given MySQL syntax. ALTER TABLE tbl_name action [, action ] … ; What does this syntax allow? Choose two answers:

Which command eliminates a table?

Why is a view used to give controlled access to data?

Which data definition language statement affects databases or objects in them?

Refer to the given SQL statement. SELECT customer_id, customer_last_name, customer_first_name FROM customer; Which statement, when added before this statement, generates a view?

What is the proper command to change a view?

DROP VIEW patient_view; What happens as a result of the execution of this statement to the patient table on which patient_view is based?

Which optional clause added to a GRANT statement enables the account to give its own privileges to other uses?

When a patient is deleted from the patient table, all corresponding rows from the patient in the exam table are automatically deleted as well. What is this referential integrity technique called?

Which clause should be added to the end to make the invoice_id attribute the primary key within a CREATE TABLE statement?

Which statement should be used to establish a foreign key on customer_id?

Which ALTER TABLE statement adds a foreign key constraint to a child table?

The database administrator has been tasked with implementing an index to speed up the retrieval of data based on the V_STATE values. The database is using the InnoDB engine. What is the correct syntax to create an index to be built on the V_STATE field based on the database information?

Which clause when added to the end of the statement creates and index on the customer_id field?

Which syntax is the correct way to use the DROP INDEX command to drop a primary key from a table?

A database administrator tried to delete a row in a parent table, but the delete fails because a row in another table depends on that row. Which referential-integrity rule is in effect?

Refer to the given MySQL statement. INSERT INTO Invoice VALUES (10217, ‘2018-08-01’, 55527), (10218, ‘2018-08-01’, 44436); Describe what the parentheses denote.

Which statement deletes all rows from the invoice table?

Refer to the given SQL statement. SELECT table1.*, table2.* FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;

Refer to the given SQL Statement. 1. SELECT invoice_id 2. FROM Invoice 3. WHERE customer_id = 4. FROM customer 5. WHERE customer_id = 55547); What is missing from the subquery at the beginning of Line 4?