最新的Oracle 1Z1-920免費考試真題

問題1

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

You want to clear the account whitelist for the * fwuser" @* localhost* user. Which statement should you run to accomplish this?
A)

B)

C)

D)

A. Option D

B. Option B

C. Option C

D. Option A

正確答案: A

問題2

You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?

A. You can expect an outage of your MySQL OCI instance during the planned time..

B. There are no maintenance operations planned. You need to do them manually.

C. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.

D. You need to agree to the maintenance windows. If not, you are not affected by the outage.

正確答案: A

問題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 storage space will be reduced.

B. The table will be checked for errors and repaired.

C. The table statistics will be stored.

D. The table will be optimized and replicated.

正確答案: D

問題4

Which three are recommended configurations for installing and running MySQL InnoDB Cluster?

A. isolated machine resources

B. Use Network-attached storage (NAS) for the data files.

C. use SSD's for data and replication logs

D. Networks must be in separate regions.

E. Groups must be in even numbers; 2, 4, 6, 8.

F. The number of machines per group must be 3, 5, 7 or 9.

G. smaller VM's work best - with a maximum of eight vCPU's and 16GB of RAM

正確答案: B,E,F

問題5

When using an Oracle Cloud Infrastructure Compute Instance with MySQL Enterprise Edition installed, you have two choices for backup destinations. What are these two choices?

A. Both Cloud storage and local storage

B. Flash-archive recovery area

C. Cloud tape library

D. Cloud storage only

正確答案: A,D

說明：（僅 Fast2test 成員可見）

問題6

You want to create an encrypted table. So, you enter this command:
CREATE TABLE 'test_encryption2% (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'server_name' varchar(15) NOT NULL,
PRIMARY KEY ('id') ) ENGINE=MYISAM AUTO_INCREMENT=l DEFAULT CHARSET=latin1 ENCRYPTION = 'Y1; You receive the following error:
ERROR 1031 (HY000): Table storage engine for 'test_encryption2' doesn't have this option Which statement correctly explains the reason for this error?

A. The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.

B. The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.

C. The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.

D. You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.

正確答案: B

問題7

Which three statements describe MySQL Enterprise Backup?

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

B. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.

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

D. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.

E. MySQL Enterprise Backup provides the point-in-time recovery functionality.

正確答案: B,D,E

最新的Oracle MySQL 2019 Implementation Essentials - 1Z1-920免費考試真題

聯系我們

站內鏈接

最新更新