Free Oracle 1Z0-909 Exam Dumps Questions & Answers

Examine these commands and output:


Which is true about the execution of the insert statement?

• A.  It inserts a new row in the view only.
• B.  It returns an error.
• C.  It inserts a row in the view and base table.
• D.  It inserts a new row in the base table only.

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

Which statement is true about the show errors command?

• A.  It displays errors messages only, since the server last restarted.
• B.  It displays errors messages only, since the start time of the current session.
• C.  It displays similar diagnostics results as get diagnostics.
• D.  It displays the total number of errors, warnings, and notes since the server last restarted.
• E.  It displays the total number of errors, warnings, and notes since the beginning of the current session.
• F.  It cannot display information for more than max_errot_count server system variable setting.

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

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

Which two statements are true about aggregate functions?

• A.  MAX () returns null if there are no rows to aggregate.
• B.  AVG () does not allow use of the distinct option.
• C.  MIN () cannot use distinct when it executes as a Windows function.
• D.  COUNT (distinct) returns a count of the number of rows with different values including Null.
• E.  SUM () returns o if there are no rows to aggregate.