Free Oracle 1z1-909 Exam Dumps Questions & Answers

Examine this statement that execute successfully in an interactive session:

The user running this session now goes to lunch for an hour.
Now, examine these statements executed independently in separate sessions while Session 0 is still active:

How many of them will complete while Session 0 is still active?

• A.  2
• B.  3
• C.  0
• D.  4
• E.  5
• F.  1

What is an advantage of using mysqli in PHP programs rather than using PHP Data Objects (PDO)?

• A.  mysqli includes X DevAPI functions.
• B.  mysqli supports object oriented programming.
• C.  mysqli can access databases from other vendors.
• D.  mysqli supports non blocking, asynchronous queries.

Examine this statement:

• A.  user who creates the procedure needing the create routine privilege
• B.  Inserting COMMIT; SET @m :=: before line 4
• C.  Inserting DEFINER 'username '@' localhost' clause into the CREATE PROCEDURE statement
• D.  user who creates the procedure needing the create and execute privileges
• E.  inserting USE <database >; before line 3

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 ;

The meeting table stores meeting schedules with participants from five continents. The participants' details are stored in another table.

You need to adjust the start_time and duration columns for optimal storage. What datatype changes would achieve this?

• A.  start__time DATETIME duration TIME
• B.  start_time TIMESTAMP duration TIME
• C.  start_time TIMESTAMP duration TIMESTAMP
• D.  start_time TIME duration TIME
• E.  start_time DATETIME duration DATETIME