Free Oracle 1z1-909 Exam Dumps Questions & Answers

Which change will prevent negative ages to be inserted into the people table?

• A.  ALTER TABLE people ADD COLUMN valid_age=ABS(check_age) GENERATED ALWAYS;
• B.  DELIMITER //
  CREATE TRIGGER age check AFTER INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER;
• C.  ALTER TABLE people ADD CONSTRAINT check_age CHECK (ABS(age)>=0);
• D.  DELIMITER //
  CREATE TRIGGER agecheck BEFORE INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER ;

You must reclaim memory used by a prepared statement named prep. Which two achieve this?

• A.  DROP PROCEDURE prep;
• B.  DROP PREPARE prep;
• C.  SET @prep = NULL;
• D.  DEALLOCATE PREPARE prep?
• E.  PREPARE prep FROM '';
• F.  SET @a = ''; EXECUTE prep USING @a;

Examine these statements which execute successfully:

The statements executed without exception. Which two are true?

• A.  Two transactions commit.
• B.  No row is inserted into band.
• C.  No transaction commits.
• D.  The transaction is rolled back to the savepoint.
• E.  One row is inserted into band.

The variables c and d are declared as integer types.
Examine these initialization statements with placeholder value <p1>, which execute successfully:
Now, examine this loop which executes successfully:

Which loop results in the same value of d for all valid values of <p1>?
A)

B)

C)

• A.  Option C
• B.  Option D
• C.  Option A
• D.  Option B

Examine this statement:
DECLARE not_found CONDITION FOR SQLSTATE '02000';
In which two statements can not found be used?

• A.  in a leave statement to exit a loop
• B.  in a handler declaration
• C.  in a while loop
• D.  in a signal statement
• E.  in an if statement