Free Oracle 1Z0-909 Exam Dumps Questions & Answers

Examine this bar graph based on columns from the players table:

Which two statements would generate this bar graph?

• A.SELECT Name, Gender, Sport, REPEAT('# 'Y GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
• B.SELECT Name, Gender, Sport, LENGTH (GPA*10, '# ') AS GPA_Graph FROM players ORDER BY GPA DESC;
• C.SELECT Name, Gender, Sport, RPAD ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
• D.SELECT Name, Gender, Sport, CONCAT ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
• E.SELECT Name, Gender, Sport, CHAR_LENGTH ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

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

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

Examine the statement which executes successfully:
SET sql_mode=' NO_ENGINE_SUBSTITTJTION' ;
You try to create a table with a storage engine that is not available. What will happen?

• A.The server will create the table but it will be unusable until the specified storage engine is available.
• B.The server will create the table but report an error when the first attempt to insert a row is performed.
• C.The server will create the table using the default storage engine.
• D.An error occurs and the create table statement fails.

You are using buffered queries with PHP mysqli in a browser-based web application. Which three are true?

• A.Buffered queries are enabled by default.
• B.Additional queries on the same session are blocked until the result set is released.
• C.Results are sent to the calling PHP process for buffering.
• D.Buffered queries must be explicitly enabled using mysqliuseresult.
• E.Results are sent from the server to the browser for buffering.
• F.Buffered queries should be used on large tables when the result size is unknown.
• G.Large results can have a negative impact on performance.

Examine these statements issued from Session 1 which execute successfully:

Now, examine this statement issued from Session 2:

What is the outcome of the update statement in Session 2?

• A.The statement will wait for the transaction in Session 1 to finish.
• B.A deadlock will occur.
• C.The transaction in Session 1 will be rolled back automatically.
• D.The row will be updated immediately.