Oracle Technology Certification

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

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?

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?

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

You create a table and a stored procedure:
CREATE TABLE t1 (f1 int);
INSERT INTO t1 VALUES (1), (2) , (3), (4), (5);
CREATE PROCEDURE sum_t1()

BEGIN -
DECLARE done INT DEFAULT 0;
DECLARE va1 INT;
DECLARE result CURSOR FOR SELECT f1 FROM t1;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;
OPEN cur;

REPEAT -
FETCH cur INTO va1;

IF NOT done THEN -
SET result = result +va1;
END IF:
UNTIL done END REPEAT;
SELECT result;

END -
CALL sum_t1();
What is the result of the CALL statement?