1) A database administrator is attempting to improve the performance of the database speed when returning each customer by name through the use of an index.

Which command line will make an index on the CUSTOMER table by NAME?

• ADD INDEX IDX_NAME ON CUSTOMER (NAME);
• ADD INDEX IDX_NAME BY CUSTOMER ( NAME);
• CREATE INDEX IDX_NAME ON CUSTOMER (NAME);
• CREATE INDEX IDX_NAME BY CUSTOMER ( NAME);

2) An index was created with the following command:

CREATE INDEX index_name ON inventory (partnum, supplier)l

What happens if the supplier column is dropped from the table

• The index generates a new index
• The index continues referring to the remaining column
• The index continues referring to both columns
• The index is dropped

3)

A referential integrity restrict delete rule is in effect on the TEAM table, which includes the L02 team. When can the L02 team be deleted from this TEAM table

• When the L02 team is no longer responsible for a project described by a dependent row in another table
• When the TEAM table is deleted
• When the L02 team is set to a NULL value
• When the manager of the team leaves the team and hands off project responsibility to the manager’s manager

4) A manager deletes the BUILDING_MANAGEMENT row in a DEPARTMENT table. Deleting the row also sets the values of the GARDENING_TEAM and CLEANING_TEAM columns from the referenced PERSONNEL_TEAMS table to nothing

Which referential-integrity rule is in effect

• The default delete rule
• The cascade delete rule
• The restrict delete rule
• The setto-null delete rule

5) One method to insert raw data into a table is to use an INSERT statement

What is another way that can be used to insert raw data into a table

• LOAD DATA statement
• InnoDB engine
• SELECT statement
• ALTER TABLE statement

6) Which statement changes the name of every employee in a table to “Assignee”

• UPDATE employee SET name =’Assignee’;
• RENAME employee SET name =’Assignee’;
• employee SET name =’Assignee’;
• SET employee name =’Assignee’;

7) Which command deletes the row for employee number 202 in the EMPLOYEE table

• DELETE EMPNUM = 202 FROM EMPLOYEE;
• DELETE FRM EMPLOYEE
  AND ROW = 202;
• DELETE FROM EMPLOYEE
  WHERE EMPNUM = 202;
• DELETE ROW 202 FROM EMPLOYEE;

8) When does a SELECT operation retrieve a single row from a table

• When the table is restricted
• When the search argument is a unique attribute
• When multiple values to be selected are expressed in a subquery or a join
• When the rows contain numbers

Answer rating: 100% (QA)

The detailed answer for the above question is provided below Lets go through each question 1 Index C... View the full answer