Download Oracle.1z0-882.TestKing.2020-01-24.60q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-882 |
| Exam Name: | MySQL 5.6 Developer |
| Date: | Jan 24, 2020 |
| File Size: | 2 MB |
Demo Questions
Question 1
Which two functions can be used in a C program to retrieve information about warning? (Choose two.)
- mysql_info
- mysql_error
- mysql_warning_count
- mysql_errno
Correct answer: AB
Question 2
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?
- Yes; the trigger works correctly.
- No; FOR EACH ROW is invalid syntax.
- No; the syntax should be CREATE TRIGGER city-bi ON city BEFORE INSERT….
- No; the OLD keyword cannot be used in an INSERT trigger.
Correct answer: A
Question 3
What are two ways in which normalizing your tables helps improve performance In MySQL?
- Smaller table sizes and row lengths improve sorting operations.
- Separate tables allow indexing more columns.
- Fewer nullable column improve index usage.
- Normalizing Improves the performance of innodb_file_per _table.
Correct answer: BC
