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

問題1

What are security rules in Compute Cloud Service?

A. Security are essentially firewall rules that can help to control traffic between Cloud Service instances, as well as between instances and external hosts.

B. They are user-role designation that assign rights to certain users.

C. Security rules are data encryption levels that control who can see the data.

D. They allow administrators access to applications in the cloud.

E. These are rules established by HIPAA for securing end-user data.

正確答案: A

問題2

Which two methods can change password expiration for a database user account? (Choose two.)

A. Use the SET GLOBAL command to update the default password expiration time

B. Update the my.cnf configuration to include default_password_lifetime=100 and restart the server

C. Create a new database user account with an explicit password expiration time

D. Use an ALTER USER command to change the password expiration

正確答案: D

問題3

MySQL Enterprise provides query analyzing metrics for SQL statements. Which four MySQL environments will provide QUAN metrics?

A. All MySQL (when MySQL connectors with Aggregator is used for the application)

B. MySQL 5.7.9 Community (and later)

C. MySQL 5.6.14 Commercial (and later)

D. MySQL 5.5.9 (and later)

E. All MySQL (with MySQL Enterprise Monitor Proxy)

正確答案: B,C,D,E

問題4

Your customer runs several Oracle products and would like to reuse them. Identify four options that are certified to work with the MySQL Enterprise Edition features.

A. MySQL Server can be monitored by Oracle Enterprise Manager both for performance and alerting.

B. MySQL Enterprise Backup can send its backups directly to Oracle Secure Backup.

C. MySQL Enterprise Firewall uses Oracle Database Firewall to block intrusive users and queries.

D. MySQL Server's configuration can be saved by Oracle Enterprise Manager so that configuration changes can be tracked.

E. MySQL Enterprise Encryption uses Cloud Key Vault's access to OpenSSL to create encrypted keys.

F. MySQL Server can be hosted using Oracle VM for hard-partitioned virtualization installations.

正確答案: B,C,D,E

問題5

Select three privileges that are necessary to successfully back up a server instance with the mysqlbackup command after the initial installation.

A. CREATE TEMPORARY TABLES

B. GRAND OPTION

C. RELOAD

D. REPLICATION CLIENT

E. INDEX

正確答案: A,C,D

問題6

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

問題7

MySQL is installed on a Linux server and has the following configuration:
[mysqld]
User=mysql
Datadir=/data/mysql
Which two methods should you use to change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?

A. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.

B. Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';

C. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.

D. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';

正確答案: A,D

問題8

You have a user on your MySQL instance who is flooding the server with complex queries and large INSERTS, which prevents another user with a higher priority from running queries. Which two choices will limit the number of SELECTS to 10 per hour and the number of INSERTS to 4 per hour for user 'employee1' from MySQL Workbench by first selecting Server> Users and Privileges> employee1?

A. Set Max Updates to 4 for 'employee1'.

B. Set Max. Queries to 14 for 'employee1'.

C. Set Max. Connections to 14 for 'employee1'.

D. Set Max. Queries to 10 for 'employee1'.

E. Set Concurrent Connections to 14 for 'employee1'.

正確答案: C,D

問題9

Which three statements describe MySQL Cloud Service Backup?

A. MySQL Cloud Service offers backup based on Oracle RMAN with optimized row locking.

B. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.

C. MySQL Cloud Service Backup is an optimized backup based on mysqldump with optimized row locking.

D. MySQL Cloud Service Backup provides the point-in-time recovery functionality.

E. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Storage Service.

正確答案: A,C,D

問題10

You have a text file named "xyz.csv" exported from another system.

You are asked to import data to a MySQL Database table named "country".
The table definition is as follows:

Identify the action that imports the data from Workbench or MySQL Client to the database correctly.

A. Create a DIRECTORY LINK object on the database and use INSERT into mycountry SELECT * from mycountry.csv.

B. Use the LOAD DATA INFILE syntax to load data into the database table.

C. Convert the data into MDI and restore the MySQL data from it.

D. Use mysqlimport to load the mycountry.csv data file with the --csv option specified.

正確答案: B

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

最新更新

站內鏈接

聯系我們