Latest Oracle 1z1-320 Actual Free Exam Questions & Community Discussion, Page 1

Question #1

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's configuration can be saved by Oracle Enterprise Manager so that configuration changes can be tracked.

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 can be hosted using Oracle VM for hard-partitioned virtualization installations.

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

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

Discussion 0

Correct Answer: A,B,C,E Vote an answer

Question #2

You have the MySQL 5.7 database running. MySQL Enterprise Backup 3.12 is installed and it is used to back up the MySQL 5.7 database. The backup has failed. Identify the reason.

A. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x with the MySQL 5.7 extension pack.

B. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x providing that the MySQL 5.7 is pre-registered in the MySQL Enterprise Backup configuration file.

C. MySQL Workbench must be installed with MySQL Enterprise Backup to enable the backup to run successfully.

D. mysqlbackup with MySQL Enterprise Backup 3.x must be executed once with the - -upgrade on MySQL 5.7 database to allow the mysql.backup_progress and mysql.backup_history tables to be patched.

E. MySQL Enterprise Backup 3.x does not support MySQL 5.7. MySQL Enterprise Backup 4.x or later is required to back up MySQL 5.7.

Discussion 0

Correct Answer: A Vote an answer

Question #3

You are requested to export data from a set of the following tables in the database 'world_x'.
Tables (country, countryinfo, location)
Which two options would allow you to export data as files?

A. using mysqldump to dump multiple tables in a database in one command line:# mysqldump -u<user>- h<host> -P<port> -p world_x country countryinfo location> mydump.sql

B. using MySQL Client and the - -dump option to dump the tables to files:# mysql -u<user> -p -h<host>
-P<port> -- dump world_x.country world_x.countryinfo world_x.location

C. using MySQL Client and EXPORT <table> TO <file> to export data one by one:mysql>EXPORT world_x.country TO '/output/country.txt';mysql>EXPORT world_x.countryinfo TO
'/output/countryinfo.txt';mysql>EXPORT world_x.location TO '/output/location.txt';

D. using MySQL Client and SELECT ...INTO OUTFILE '<filename>' from <TABLE> to export data one by one:mysql>select * into outfile '/output/country.txt' from world_x.country;mysql>select * into outfile '/output/countryinfo.txt' from world_x.countryinfo;mysql>select * into outfile
'/output/location.txt' from world_x.location;

E. using mysqlexport to export multiple tables in a database in one command line:# mysqlexport -u<user>- h<host> -P<port> -p world_x country countryinfo location> mydump.sql

Discussion 0

Correct Answer: A,D Vote an answer

Question #4

The user 'fwuser'@'localhost' was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database.
You executed commands:

You want to clear the account whitelist for the 'fwuser'@'localhost' user. Which statement would you run to accomplish this?

A. CALL mysql.sp_reload_firewall_rules ('fwuser@localhost');

B. SET mysql.sp_set_firewall_mode= 'RECORDING';

C. CALL mysql.sp_set_firewall_mode ('fwuser@localhost', 'CLEAR');

D. DELETE TABLE INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST;

Discussion 0

Correct Answer: C Vote an answer

Question #5

You use MySQL Enterprise Monitor for a group of MySQL servers. In recent weeks, the MySQL Enterprise Monitor has slowed down significantly.
Which two preventative actions should you take if your number of monitored MySQL instances has changed?

A. Tune the InnoDB Buffer Pool of the MySQL Enterprise Monitor Repository database. This can have a significant impact on performance (innodb_buffer_pool_size).

B. Increase the necessary operating system swap space (Linux): mkswap /dev/sdx; swapon/dev/sdx,
/etc/fstab.

C. Increase the disk space with at least 10% of the database size.

D. Increase the amount of RAM available to the JVM installed with Tomcat. The JVM memory settings are defined by the JAVA_OPTS line of the setenv file, which sets the environment variables for Tomcat (--JvmMs/-Xms and -JvmMx/-Xmx).

Discussion 0

Correct Answer: A,C Vote an answer

Question #6

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.
Identify the correct statement.

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. MySQL Enterprise Monitor creates the required users automatically.

C. The super privilege is required when starting, stopping, or restarting monitored MySQL databases.

D. Monitoring metrics need super and root privileges because they are not available for a less-privileged user.

Discussion 0

Correct Answer: A Vote an answer

Question #7

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 sha_256PASSWORD by 'SecretPass123!';

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

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

Discussion 0

Correct Answer: D Vote an answer

Question #8

Name three ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances.

A. Direct support call from an Oracle representative

B. SMS

C. Email

D. Notification tab on the dashboard

E. Browser pop-ups

Discussion 0

Correct Answer: B,C,D Vote an answer

Question #9

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

B. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the KEY VAULT file.

C. TDE supports at-rest encryption for InnoDB tables stored in file-per-table tablespaces.

D. Both MyISAM and InnoDB table can be encrypted by setting the keyring_engine =ALL variable in the MySQL configuration file.

Discussion 0

Correct Answer: C Vote an answer

Question #10

You have configured MySQL Enterprise Transparent Data Encryption (TDE). What command would you use to encrypt a table?

A. UPDATE TABLE SET ENCRYPTION = 'ON';

B. ALTER TABLE <table> ENCRYPTION = 'Y';

C. ALTER INSTANCE ROTATE INNODB MASTER KEY;

D. ALTER mysql.encryption SET tde_status = 'YES';

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Oracle 1z1-320 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z1-320 Demo