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

4.2/5 - (6 选票)

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

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

Oracle 1z1-909 考试大纲主题：

主题	详细信息
主题 1	Schedule database operations Store and process temporal data
主题 2	创建和访问文档存储 JSON 和文档存储存储和处理数字数据
主题 3	重写查询以进行优化存储和处理字符串数据
主题 4	Explain the programming constructs used in stored routines Choose between connectors for a given application
议题 5	演示连接器的使用、管理和配置安全凭证和连接
主题 6	解决隔离级别的一致性问题设置 SQL 模式以更改 MySQL 行为
主题 7	讲解使用 NoSQL 和 XDevAPI 开发应用程序处理并解释错误和警告

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. 检查这些命令和输出：

哪个是真的？

删除现有的 emp_vuL，用新定义创建新的 emp_vu1。

由于在执行 drop table 语句时删除了前一个视图，因此创建了一个新视图。

返回错误，因为 CREATE TABLE 语句自动重新创建了视图。

返回错误，因为 DROP TABLE 语句没有删除视图。

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)

方案 A

方案 B

选项 C

选项 D

Q15. 检查这条成功执行的语句：
SET @ir := 2；
哪个查询会将 @r 的值更新为 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. 检查这条已成功执行的语句：

使用 like 代替 RLIKE 可以提高执行性能。

该语句利用了索引 description_idx。

使用列描述作为最左前缀列描述的复合索引可以提高执行性能。

任何指数都无法改善报表性能。

通过在列描述上添加索引，可以提高执行性能。

Q17. 请看这句话：

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. 检查这些成功执行的语句：

Now, examine this query:

结果如何？

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. 检查该语句和输出：

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. 检查这些成功执行的语句：

现在，检查在 mysqi 命令行客户端中执行的语句：

什么是真的？
A)

B)

C)

D)

方案 A

方案 B

选项 C

选项 D

Q24. 检查该语句和输出：

You execute this statement:
SELECT JSON_SEARCH(product,’one’,’IT’) FROM fshop ;
产出是什么？

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)

方案 A

方案 B

选项 C

选项 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?