As a developer, you inherit this table as part of a project:
CREATE TABLE exam (
Exam_id INTEGER UNSIGNED NOT NULL PRIMARY KEY,
Examinee_id INTEGER UNSIGNED UNIQUE,
Score INTEGER UNSIGNED
)
What change should you make to ensure that examinee_id is an integer value throughout the table?

• A. The PRIMARY KEY should be dropped and re-created as PRIMARY KEY (examinee-id, exam_id).
• B. A NOT NULL qualifier should be added to examinee_id.
• C. The examinee_id column should be designated as PRIMARY KEY.
• D. A NOT NULL qualifier should be moved from exam-id to examinee-id.

What are two ways in which normalizing your tables helps improve performance In MySQL?

• A. Normalizing Improves the performance of innodb_file_per _table.
• B. Separate tables allow indexing more columns.
• C. Smaller table sizes and row lengths improve sorting operations.
• D. Fewer nullable column improve index usage.

The tab-delimited file"/tmp/people,txt contains:
1636 Carsten Pederson Denmark
4672 Kai Voigt Germany
4628 Max Mether France
This is the structure of the people table:
Mysq1> DESCRIBE people;

Which statement will load the first and last names into the Names column and the country into the country column?

• A. LOAD DATA INFILE '/tmp/people.txt 'INTO TABLE People
  (@ Skip, @First , @Last, @Country
  SET Name=CONCAT (@First, ' ',@Last)
• B. LOAD DATA INFILE '/tmp/people.txt ' INTO TABLE People
  @ Skip=$1 , @ First=$2, @Last=$3, @ Country=4,
  (CONCAT (@First, ' ' .@ Last) , @ Country)
• C. LOAD DATA INFILE '/tmp/people,txt, INTO TABLE People.
  (@Skip. @First, @Last, @Country)
  Country=@country
• D. LOAD DATA INFILE '/tmp/people.txt'INTO TABLE PEOPLE@First=$2. @Last=$3 @Country=$4
  (CONCAT (@First, ' ',@Last) , @ Country)
• E. It is not possible to load the data from the file/tmp/people.txt into the people table,as shown.

You wish to create a trigger on the 'city' table that will check the value of the 'District' field before any INSERT. The
trigger needs to change it to" Unknown" for an empty string or NULL.
CREATE TRIGGER City_bi
BEFORE INSERT ON CITY
FOR EACH ROW
BEGIN
IF OLD. District IS NULL OR OLD.District= . .
THEN
SET NEW.District='Unknown';
END IF :
END;
Does the CREATE TRIGGER statement accomplish this goal?

• A. No; the syntax should be CREATE TRIGGER city-bi ON city BEFORE INSERT....
• B. No; FOR EACH ROW is invalid syntax.
• C. Yes; the trigger works correctly.
• D. No; the OLD keyword cannot be used in an INSERT trigger.

Consider the structure of the table countryLanguage and the distribution of the column Is official.
DESCRIBE CountryLanguage;

SELECT Isofficial, COUNT (Isofficial) FROM CountryLanguage GROUP BY Isofficial;

You add an index on the Isofficial column.
Which two statement are true?

• A. The optimizer will not choose the index on the Isofficial column.
• B. The optimizer will choose the index when Isofficial='F' is in the WHERE clause.
• C. The speed of INSERT statements to this table will be improved.
• D. The optimizer will choose the index when Isofficial='T' is in the WHERE clause.
• E. The speed of INSERT statements to this table will be unchanged.
• F. The speed of INSERT statements to this table will be reduced.