最新的高品質 1Z0-921 考試練習題庫

Oracle 1Z0-921 考試概覽:

Oracle 1Z0-921 考試大綱主題:

最新的 Oracle MySQL 1Z0-921 免費考試真題：

1. Which four authentication protocols are allowed when using MySQL Enterprise Authentication?

A) Native Windows services
B) authentication via Pluggable Authentication Modules (PAMs)
C) Simple Authentication and Security Layer
D) connections through the local host via the UNIX socket file
E) authentication using SHA-256 password hashing
F) SECURID authentication and authorization identity

2. Assume that MySQL Enterprise Monitor is configured to monitor MySQL 8.0.10 or a later instance. Which three features are available?

A) monitoring the availability of the MySQL Instance
B) deploying MySQL agent on supported target operating system
C) tracing import and export with mysqldump
D) creating e-mail alerts and SNMP traps for MySQL warnings
E) starting and stopping the MySQL instance
F) analyzing executed MySQL queries

3. You are using the innoDB engine and the innodb_f ile_per_table option is set.
You delete a significant number of rows of a large table named inventory and issue the command optimize table inventory.
What will happen to the inventory table?

A) The table statistics will be stored.
B) The table will be checked for errors and repaired.
C) The table storage space will be reduced.
D) The table will be optimized and replicated.

4. The MySQL Enterprise Monitor Agent requires a user configured in each MySQL instance that is being monitored with suitable privileges to collect information about the server.
Which statement is correct?

A) The super privilege is required when creating and populating the inventory table, as well as running statements such as show master logs or SHOW ENGINE INNODB STATUS.
B) The super privilege is required when starting, stopping, or restarting monitored MySQL databases.
C) MySQL Enterprise Monitor creates the required users automatically.
D) Monitoring metrics need super and root privileges because they are not available for a less-privileged user.

5. Which statement would you use to remove the population column from the city table?

A) DELETE population FROM city;
B) ALTER TABLE city DELETE population;
C) DROP population FROM city;
D) ALTER TABLE city LESS population;
E) ALTER TABLE city DROP population;

問題與答案：