Oracle 1z0-882 Exam Actual Questions

The application logs contain many entries of the following:
ERROR 1153 (OSSO1): Got a packet bigger than max_allowed_packet bytes
With two scenarios can (Hibernate this error message?

Correct Answer: AF 🗳️

Which two Functions can be used in a C program to retrieve information about warning?

Correct Answer: AC 🗳️
http://dev.mysql.com/doc/refman/5.6/en/c-api-function-overview.html

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?

Correct Answer: D 🗳️

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?

Correct Answer: C 🗳️