1Z0-920試験無料問題集（70題）「Oracle MySQL 2019 Implementation Essentials 認定」

出題：1

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

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

B. isolated machine resources

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

D. Networks must be in separate regions.

E. use SSD's for data and replication logs

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

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

正解：A,F,G 解答を投票する

出題：2

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 optimized and replicated.

C. The table statistics will be stored.

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

正解：B 解答を投票する

出題：3

Which activity will take place if a table is created with both the compression and encryption options?

A. The tablespace data is encrypted first and then compression is performed.

B. The compression is performed before tablespace data is encrypted.

C. The compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted.

D. The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Which two statements are true about the creation or use of a Virtual Cloud Network (VCN)?

A. You can connect directly to an instance over the internet, without a public IP address.

B. Your instance does not have a public IP address, so you cannot connect with a public subnet.

C. You must have an Internet gateway to connect to a public address on an Oracle Linux instance.

D. You can connect directly to the VCN without a define subnet.

E. You must have an IPSec VPN to connect to an Oracle Linux instance.

正解：A,D 解答を投票する

出題：5

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 encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.

B. You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what 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. The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.

正解：A 解答を投票する

出題：6

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 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Which two methods help prevent MySQL security risks?

A. Grant only permissions that a user requires.

B. Allow unauthorized clients to connect to the server.

C. Use a firewall to control access to MySQL ports.

D. Transmit plain (unencrypted) data over networks.

E. Ensure that MySQL accounts have short and easy passwords.

F. Use the secure installation script "mysql_alays_secure_installation".

正解：B,D 解答を投票する

1Z0-920試験無料問題集「Oracle MySQL 2019 Implementation Essentials 認定」