QUESTION: 1
The application logs contain many entries of the following:
ERROR 1153 (OSSO1): Got a packet bigger than `max_al owed_packet' bytes
With two scenarios can (Hibernate this error message?
A. The application tried to INSERTa row that exceeded max_al owed_packet.
B. The network caused an error Inducing the max_al owed_packet error.
C. The application did not use the COMPRESS ()function for a large result set.
D. The application tried to SELECT many rows together that exceeded max__allowed_packet.
E. The application tried to SELECT a row that exceeded max_al owed_packet.
F. The operating system caused an error inducing the max_al owed_packet error.
Answer(s): D, F
QUESTION: 2
Which two Functions can be used in a C program to retrieve information about warning?
A. mysql_info
B. mysql_error
C. mysql_warning_count
D. mysql_errno
Answer(s): A, B
QUESTION: 3
You wish to create a trigger on the `city' table that wil 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. Yes; the trigger works correctly.
B. No; FOR EACHROWis invalid syntax.
C. No; the syntax should be CREATETRIGGERcity-bi ON city BEFOREINSERT....
D. No; the OLD keyword cannot be used in an INSERT trigger.
Answer(s): A
QUESTION: 4
The tab-delimited file"/tmp/people, txt contains:
1636 Carsten Pederson Denmark