Online Access Free 1Z1-920 Practice Test

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?

• A.Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.
• B.Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.
• C.Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.
• D.Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.

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.--uncompress-and-apply-log
• B.--uncompress
• C.--decompress
• D.--copy-back-and-apply-log
• E.--apply-log-and-copy-back

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

• A.You must have an IPSec VPN to connect to an Oracle Linux instance.
• B.You must have an Internet gateway to connect to a public address on an Oracle Linux instance.
• C.You can connect directly to the VCN without a define subnet.
• D.Your instance does not have a public IP address, so you cannot connect with a public subnet.
• E.You can connect directly to an instance over the internet, without a public IP address.

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

• A.Groups must be in even numbers; 2, 4, 6, 8.
• B.Networks must be in separate regions.
• C.smaller VM's work best - with a maximum of eight vCPU's and 16GB of RAM
• D.The number of machines per group must be 3, 5, 7 or 9.
• E.Use Network-attached storage (NAS) for the data files.
• F.isolated machine resources
• G.use SSD's for data and replication logs

Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:

What is the result after issuing the rollback command?

• A.Both the tables, t1 and t2, are created.
• B.Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.
• C.Only the t1 table is created.
• D.Only the t2 table is created.