最新的Oracle Data Management認證 1z1-320考試題庫

問題1

What command should be used to execute a stored procedure named run_daily_report with the parameter
2016/12/31?

A. CALL run_daily_report ('2016/12/31');

B. SELECT SP run_daily_report ('2016/12/31') from mysql.procedures;

C. EXECUTE PROC run_daily_report INCLUDE PARAMETER ('2016/12/31');

D. UPDATE PROCEDURE run_daily_report WHERE VARIABLE = ("2016/12/31');

正確答案: A

說明：（僅 VCESoft 成員可見）

問題2

You need to change the password level for a test system. Which two options enable to change this level before you create new test user/passwords?

A. SET GLOBAL validate_password_policy='new level';

B. Add validate_password='new level' in the [security] section of the MySQL configuration file.

C. SET GLOBAL force_password_complex_policy=0;

D. Add validate_password_policy='new level' in the [mysql] section of the MySQL configuration file.

正確答案: A,B

問題3

When there are long-running queries, mysqbackup hangs there to wait for the completion of the queries. You know that the system has only user data on InnoDB and there is no DDL execution during the backup period.
There is no update/alternation to tables with non-InnoDB storage engines.
Which two ways allow the MySQL Enterprise Backup to be executed without being blocked or without locking?

A. There is no extra option. MySQL Enterprise Backup does this automatically by kicking out the long-running queries.

B. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds) and does not disturb the normal processing of mysqld much. However, use - -single-user-mode to back up the long-running queries to allow mysqlbackup to run successfully without locking.

C. Running mysqlbqckup from a remote machine enabled you to back up the database without locking.

D. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - -no-locking option to backup up the non-InnoDB files. Note that MyISAM, .frm, and other files copied under the --no-locking setting cannot be guaranteed to be consistent, if they are updated during this final phase of the backup.

E. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - - only-innodb option to back up only InnoDB tables, to avoid blocking.

正確答案: B,D

問題4

You want to access your MySQL Cloud Service cloud environment from an external application based on ODBC. What are the required steps?

A. Enable ora_p2admin_mysql, which opens port 3306 on the Access Rules tab.

B. Access to the OS (SSH) and MySQL (3306) are open by default.

C. Create a new SSH key for your ODBC connector.

D. Switch to the Compute Cloud Service Dashboard and disable reject:*.public-internet

E. Enable SSH tunnel and access MySQL based on TCP/IP over SSH.

正確答案: E

問題5

For accessing a new default MySQL Cloud Service (CS) cloud environment, you used the "Create SSH Keys function" during the guided MySQL CS setup. You want to use Putty from your Windows Client. Identify the correct steps.

A. You open Port 22 on your MySQL CS Instance and configure Putty with the provided private key.

B. Use the provided private key for authentication.

C. Convert the private key to ppk format first, and use the new private key for authentication.

D. Open Port 22 on your MySQL CS Instance and convert the private key to ppk format. This new private key can be used for authentication.

正確答案: D

問題6

Which command in MySQL Utility can perform and start replication among a slave and multiple masters?

A. mysqlreplicatems

B. mysqlrplcheck

C. mysqlreplicate

D. mysqlrplms

E. mysqlrpladmin

正確答案: D

問題7

Identify two features of MySQL Enterprise Firewall.

A. You can automatically delete a user if the user breaks your firewall.

B. You can block out potential threats by setting up a preapproved whitelist.

C. You can modify a request with a SQL statement substitution.

D. You can set a recording mode to record incoming SQL statement to create a whitelist of permitted commands.

E. You set the firewall per database.

正確答案: B,D

問題8

The MySQL Cloud Service (CS) is a database offering from Oracle. Which three statements are correct?

A. MySQL CS is based on an IaaS Oracle Linux image including full root privileges to the OS.

B. MySQL CS configuration can be changed in /etc/my.cnf.

C. Oracle MySQL Enterprise Tools & Plugins are available as optional services (installation Feature Pack I/II).

D. MySQL CS is based on the MySQL GPLv2 version from the Oracle Linux 6 with optimizations for the Cloud (Oracle Flexible Architecture Standard).

E. MySQL CS is based on the MySQL Enterprise Product Suite.

F. MySQL CS is installed based on the Oracle Flexible Architecture Standard.

正確答案: B,C,E

問題9

Which command would you use to create a user named jenny for the localhost server with the hashed password SecretPass123!?

A. CREATE USER 'jenny'@localhost' WITH HASHED (password, 'SecretPass123!');

B. CREATE USER 'jenny'@localhost' IDENTIFIED WITH HASH PASSWORD ('SecretPass123!');

C. CREATE USER 'jenny'@localhost' IDENTIFIED BY SHA ('SecretPass123!', '256');

D. CREATE USER 'jenny'@localhost' IDENTIFIED WITH sha_256PASSWORD by 'SecretPass123!';

正確答案: C

問題10

You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup.
You are required to restore the database and apply the log.
Which two options should you add to the mysqlbackup to achieve the restoration of the database?

A. --copy-back-and-apply-log

B. --uncompress-and-apply-log

C. --apply-log-and-copy-back

D. --uncompress

E. --decompress

正確答案: A,D

最新的Oracle MySQL Cloud Service 2018 Implementation Essentials - 1z1-320免費考試真題

最新更新

站內鏈接

聯系我們