oracle 1Z0-909 Exam Questions
Questions for the 1Z0-909 were updated on : Dec 01 ,2025
Page 1 out of 5. Viewing questions 1-15 out of 65
Question 1
Which change will prevent negative ages to be inserted into the people table?
- A. DELIMITER // CREATE TRIGGER agecheck BEFORE INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER ;
- B. ALTER TABLE people ADD COLUMN valid_age=ABS(check_age) GENERATED ALWAYS;
- C. DELIMITER // CREATE TRIGGER age check AFTER INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER;
- D. ALTER TABLE people ADD CONSTRAINT check_age CHECK (ABS(age)>=0);
Answer:
D
Question 2
Which two are true about MySQL connectors?
- A. Connectors must be installed on both the client and server hosts.
- B. Connector/J is based on Connector/C.
- C. Connector/ODBC is available on Unix, Windows, and MacOS X.
- D. Connector/NET runs on the Windows platform only.
- E. Connector/Python is released in precompiled binary and source code.
Answer:
AB
Question 3
Examine these statements issued from Session 1 which execute successfully:
Now, examine these statements issued from Session 2 which execute successfully:
Session 2>
BEGIN;
UPDATE band SET song=CONCAT ("Here Comes the ", song) WHERE song LIKE ' %Sun ;
Which two are true?
- A. Session 1 takes a shared lock on all the rows in the band table.
- B. Session 1 must commit before the update in Session 2 can complete.
- C. Session 1 does not block Session 2.
- D. Statements in Session 2 are committed.
- E. Session 2 takes an exclusive lock on all the rows in the band table.
- F. Session 2 does not start a transaction.
Answer:
BD
Question 4
What is an advantage of using mysqli in PHP programs rather than using PHP Data Objects (PDO)?
- A. mysqli supports object oriented programming.
- B. mysqli can access databases from other vendors.
- C. mysqli supports non blocking, asynchronous queries.
- D. mysqli includes X DevAPI functions.
Answer:
A
Question 5
Examine these statements which execute successfully:
Now, examine this query:
What is the result?
- A. It inserts a row with a warning.
- B. It inserts a row with no error or warning.
- C. It inserts a row with an error.
- D. It fails with an error.
- E. It fails with a warning.
Answer:
B
Question 6
Examine the content of the employee table:
Now examine this PHP script:
Finally examine this desired output:
- A. $options = [PDO:: ATTR_DEFAULT_FETCH__MODE => PDO: : FETCH_ASSOC] ;
- B. $options = [PDO:: ATTR_DEFAUXT_FETCH__MODE => PDO: : PDO: :FETCH_OBJ] ;
- C. $options = [PDO:: ATTR_DEFAOLT_FETCH__MODE => PDO : : FETCH_BOTH] ;
- D. $options = [PDO:: ATTR__DEFAULT_FETCH MODE => PDO: :FETCH_CLASS] ;
Answer:
C
Question 7
Examine these lines of Python code:
You must add a line of code to complete the code to return data to the variable d. Which line will do
this?
- A. d = cursor.execute(query)
- B. d = cursor.execute(query, (hire_start, hire_end) )
- C. d = cursor.fetch(query % (hire_start, hire_end))
- D. d = cursor.fetch(query, (hire_start, hire_end))
- E. d = cursor . f etchall (query)
- F. d = cursor.fetchall(query, (hire_start, hire_end))
Answer:
D
Question 8
Which statement is true about the show errors command?
- A. It displays the total number of errors, warnings, and notes since the beginning of the current session.
- B. It displays the total number of errors, warnings, and notes since the server last restarted.
- C. It cannot display information for more than max_errot_count server system variable setting.
- D. It displays errors messages only, since the start time of the current session.
- E. It displays errors messages only, since the server last restarted.
- F. It displays similar diagnostics results as get diagnostics.
Answer:
A
Question 9
Examine this statement and output:
Which is true?
- A. The underlying table's index on the Name column is not chosen because of low selectivity.
- B. myview cannot be automatically indexed.
- C. myview was defined with the temptable processing algorithm.
- D. Column Name in myview can be indexed if the is_updatable attribute is true.
Answer:
C
Question 10
Examine this statement which executes successfully:
CREATE TABLE 'fshop’ ('product' JSON DEFAULT NULL ) ENGINE=InnoDB;
Now, examine a json value contained in the table:
{"name" : "orange", "varieties" :
[{"VarietyName":"Clementine", "Origin" : ["PA", "BU"] },
{"VarietyName": "tangerine", "Origin" : ["CH","JP"]>]>
Which will cause documents to be indexed over the 'name' key?
- A. ALTER TABLE fshop ADD COLUMN name VARCHAR(20) AS (product- >* S .varieties. VarietyName ' ) VIRTUAL, ADD KEY idx_name (name.) ;
- B. ALTER TABLE fshop ADD COLUMN name VARCHAR(100) AS (product->' S - varieties' ) VIRTUAL, ADD KEY idx_name (name) ;
- C. ALTER TABLE fshop ADD COLUMN name VARCHAR(20) AS (product->' S - name' ) VIRTUAL, ADD KEY idx_name (name) ;
- D. ALTER TABLE fshop ADD COLUMN name VARCHAR(20), ADD KEY idx_name (name) ;
- E. ALTER TABLE fshop ADD name VARCHAR(20) AS (JSON_ONQUOTE (product- >"S.varieties.VarietyName")), ADD INDEX (name);
Answer:
B
Question 11
Examine these statement which execute successfully:
Now, examine the statements executed in the mysqi command-line client:
What is true?
A)
B)
C)
D)
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer:
C
Question 12
Examine the appointments table definition which contains one million rows:
Now, examine this statement which executes successfully:
Which statement will improve query performance?
- A. ALTER TABLE appointments add index IX_4<attendant_id, payment, credit)
- B. ALTER TABLE appointments add index IX_1(credit,payment)
- C. ALTER TABLE appointments add index IX_2(attendant_session_id, created_by)
- D. ALTER TABLE appointments add index IX_3(attendant_id, created_by)
Answer:
A
Question 13
Examine these commands and output:
Which is true about the execution of the insert statement?
- A. It returns an error.
- B. It inserts a row in the view and base table.
- C. It inserts a new row in the base table only.
- D. It inserts a new row in the view only.
Answer:
D
Question 14
Examine these commands which execute successfully:
mYsql> CREATE TABLE income (acct_num INT, amount DECIMAL(10,2));
mysql> CREATE TRIGGER subtotal BEFORE INSERT ON income
FOR EACH ROW SET @subtotal = ©subtotal + NEW.amount;
Which is true for the income table?
- A. The trigger activates after any row has been inserted into the table.
- B. The trigger body set causes trigger activation.
- C. The trigger activates after any row in the table has been updated.
- D. Execution of an insert statement causes the trigger to activate.
Answer:
D
Question 15
Examine these statement which execute successfully:
Now, examine this desired output:
Which two queries will produce the out?
A)
B)
C)
D)
E)
- A. Option A
- B. Option B
- C. Option C
- D. Option D
- E. Option E
Answer:
BC