Latest 1z1-909 Pass Guaranteed Exam Dumps with Accurate & Updated Questions [Q10-Q27]

4.2/5 - (6 votes)

Latest 1z1-909 Pass Guaranteed Exam Dumps with Accurate & Updated Questions

1z1-909 Exam Brain Dumps – Study Notes and Theory

Oracle 1z1-909 Exam Syllabus Topics:

Topic	Details
Topic 1	Schedule database operations Store and process temporal data
Topic 2	Create and access a document store JSON and Document Store Store and process numeric data
Topic 3	Rewrite queries for optimization Store and process string data
Topic 4	Explain the programming constructs used in stored routines Choose between connectors for a given application
Topic 5	Demonstrate connector use, management and configuration Secure credentials and connections
Topic 6	Resolve consistency problems with isolation levels Set SQL Modes to change MySQL behavior
Topic 7	Explain application development with NoSQL and XDevAPI Handle and interpret errors and warnings

Q10. Your program which uses a MySQL connector receives this error:
Client does not support authentication protocol request by server
The account running the program uses caching_sha2_password.
Which two resolve this conflict?

Disable TLS/SSL authentication.

Place this in the root directory of your shell account:
[mysqld] require__secure_transport=OFF

Use blank RSA or SSL certificates.

Upgrade the connector to a version that supports caching_sha2_password.

Change the user account to use mysql_native_password.

Q11. Examine these statements:
SET collation_connection=utf8mb4_0900_as_cs;
SELECT STRCMPCAlice’, UCASE (‘Alice* )) ;
What is displayed?

ERROR: 1267 (HYOOO): Illegal mix of collations

-1

NULL

Q12. Examine these my.cnf settings:

Examine this entry from /data/slow.log

Which option is also set in my.cnf?

log_queries_not_using_indexes

log__slow_admin_statements=1

log_queries_not_using_indexes=ON

log_throttle_queries_not_using_indexes=100

Q13. Examine these commands and output:

Which is true?

Existing emp_vuL is dropped and a new emp_vu1 created with the new definition.

A new view is created because the previous was dropped on execution of the drop table statement.

It returns an error because the CREATE TABLE statement automatically recreated the view.

It returns an error because the DROP TABLE statement did not drop the view.

Q14. The employee table includes these columns:
e_id INT, e_name VARCHAR (45), dept_id INT salart INT
You must create a stored function, getMaxSalary(), which returns the maximum salary paid for a given department id.
Which statement will create the function?
A)

B)

C)

D)

Option A

Option B

Option C

Option D

Q15. Examine this statement which executes successfully:
SET @ir := 2;
Which query updates the value of @r to 0?

SELECT ‘Car’ REGEXP(‘Ca?’) >= 0 INTO @r;

SELECT STRCMP(‘Car’/Ca?’) >= 0 INTO @r;

SELECT ‘Car’ LIKE ‘Ca?’ INTO @r;

SELECT ‘Car’ RLIKE ‘Ca?’ INTO @r;

Q16. Examine this statement which has executed successfully:

Execution performance can be improved by using like instead of RLIKE.

The statement takes advantage of index description_idx.

Execution performance can be improved by, using a composite index with column description as the leftmost prefix column description.

No index will improve statement performance.

Execution performance can be improved by adding an index on column description.

Q17. Examine this statement:

Inserting COMMIT; SET @m :=: before line 4

user who creates the procedure needing the create and execute privileges

user who creates the procedure needing the create routine privilege

inserting USE <database >; before line 3

Inserting DEFINER ‘username ‘@’ localhost’ clause into the CREATE PROCEDURE statement

Q18. 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?

The inserted row is returned because the transaction is auto committed in S2.

The inserted row is not returned because the isolation level is READ COMMITTED in S2.

The inserted row is not returned because the transaction still active in s2.

The inserted row is returned because the isolation level is RPEATABLE READ in S1.

Q19. Your program which uses a MySQL connector receives this error:
Client does not support authentication protocol request by server
The account running the program uses caching_sha2_password.
Which two resolve this conflict?

Disable TLS/SSL authentication.

Place this in the root directory of your shell account:
[mysqld] require__secure_transport=OFF

Use blank RSA or SSL certificates.

Upgrade the connector to a version that supports caching_sha2_password.

Change the user account to use mysql_native_password.

Q20. Examine these statements:
SET collation_connection=utf8mb4_0900_as_cs;
SELECT STRCMPCAlice’, UCASE (‘Alice* )) ;
What is displayed?

ERROR: 1267 (HYOOO): Illegal mix of collations

-1

NULL

Q21. Examine these statements which execute successfully:

Now, examine this query:

What is the result?

It inserts a row with a warning.

It inserts a row with no error or warning.

It inserts a row with an error.

It fails with an error.

It fails with a warning.

Q22. Examine this statement and output:

What causes the error?

The engine is disabled.

The set local_infile option has not been enabled.

The database user does not have sufficient privilege.

The database server process does not have sufficient privilege.

The database client process does not have sufficient privilege.

The database server is running in read-only mode.

Q23. Examine these statement which execute successfully:

Now, examine the statements executed in the mysqi command-line client:

What is true?
A)

B)

C)

D)

Option A

Option B

Option C

Option D

Q24. Examine this statement and output:

You execute this statement:
SELECT JSON_SEARCH(product,’one’,’IT’) FROM fshop ;
What is the output?

product->”$.varieties [4]. origin[1];;

”$.varieties[4]. origin[1]”

product->varieties[3]. origin[0]”

”$.varieties [3]. origin[0]”

Q25. The continent column in the country table contains no null values.
Examine this output:

A)

B)

C)

D)

Option A

Option B

Option C

Option D

Q26. Examine the appointments table definition which contains one million rows:

Now, examine this statement which executes successfully:

Which statement will improve query performance?