oracle 1z0-909 practice test

Examine these my.cnf settings:

Examine this entry from /data/slow.log

Which option is also set in my.cnf?

• A. log_queries_not_using_indexes
• B. log__slow_admin_statements=1
• C. log_queries_not_using_indexes=ON
• D. log_throttle_queries_not_using_indexes=100

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, CHAR_LENGTH ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
• D. SELECT Name, Gender, Sport, RPAD ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
• E. SELECT Name, Gender, Sport, CONCAT ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

Examine these commands which execute successfully in the sequence shown in Sessions S1 and S2:

Now, examine this statement that execute successfully in s1:
S1> SELECT * FROM emp;
Which is true about the result of the select statement?

• A. The inserted row is returned because the transaction is auto committed in S2.
• B. The inserted row is not returned because the isolation level is READ COMMITTED in S2.
• C. The inserted row is not returned because the transaction still active in s2.
• D. The inserted row is returned because the isolation level is RPEATABLE READ in S1.

Which two statements are true about AUTO_INCREMENT?

• A. AUTO_INCREMENT values allocated to a transaction that is rolled back are not reused.
• B. A table can have multiple AUTO_INCREMENT columns.
• C. A server restart always resets the AUTO_INCREMENT value to largest value in the AUTO_INCREMENT column plus 1.
• D. The decimal data type supports AUTO_INCREMENT.
• E. An AUTO_INCREMENT column must be indexed.

Examine the contents of these tables:

Now examine the expected results for a user with privileges to access the table:

Which query returns the expected results?
A)

B)

C)

D)

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

Examine the employee table structure:

Which set of statements immediately returns empname for a given emp_id by using a parameterized
prepare statement?
A)

B)

C)

D)

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

You must write a statement that combines the first_name and last_name columns from the
employees table as "last_name, first_name."
Which two statements will do this?

• A. SELECT last_name + ', ' + first_name FROM employees;
• B. SELECT CONCAT_WS(', ',last_name,first_name) FROM employees;
• C. SELECT GROUP_CONCAT(last_name, first_name) FROM employees;
• D. SELECT last_name, ‘ , ',first_name FROM employees;
• E. SELECT CONCAT(last name,', ',first_name) FROM employees;

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. 5
• B. 1
• C. 2
• D. 0
• E. 3
• F. 4

Examine these MySQL Shell statements:

What is the true about the attempts to add document to the collection?

• A. All documents are added without any error or warning.
• B. First three documents are added, then different number of fields cause an error.
• C. First two documents are added, then mismatched field names cause an error.
• D. First two documents are added, then mismatched field names cause a warning.
• E. All documents are added and cause a warning.

Examine this table definition:

The table must always remain a valid document store collection. What restriction does this impose
on any added column?

• A. The column must be a generated column referencing any attribute of doc.
• B. The column must have a default value.
• C. The column must be used in a unique constraint.
• D. The column must be a generated column referencing only an existing attribute of doc.
• E. The column must be indexed.