Online Access Free 1Z0-920 Practice Test

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

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

You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?

• A.Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.
• B.Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.
• C.Use mysqldump with the - -changesonly option.
• D.Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.
• E.Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.

Which three components can MySQL InnoDB Cluster use to Achieve database high availability?

• A.MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI.
• B.MySQL Router to ensure client requests are load balanced and routed to the correct servers.
• C.MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.
• D.MySQL Servers with Group Replication to replicate data to all members of the cluster.
• E.MySQL Online Hot Backup to keep data consistent and always ready to be used.

An Oracle Cloud Infrastructure customer already has many database instances configured and running in the cloud; however, they are reporting that they are unable to create any more instances.
What could be the problem?

• A.The customer account might have reached resource quota/limits.
• B.The customer does not have proper user rights.
• C.The customer has not kept up with their patching requirements; new instances cannot be created unless the majority or the template of existing instances are up-to-date.
• D.The customer reached the database instance limit of 32.

You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired? Which command should you use?

• A.CREATE USER 'jenny'@'%' WITH HASHED(password,'SecretPass123!'), PASSWORD EXPIRE
• B.CREATE USER ,jenny,0,%t IDENTIFIED BY 'SecretPass123!' PASSWORD EXPIRE;
• C.CREATE USER 'jenny *@'localhost' IDENTIFIED WITH HASH PASSWORD('SecretPass123!')
• D.CREATE USER 'jenny'@'localhost' IDENTIFIED BY ('SecretPass123!','256', Expired)
• E.CREATE USER 'jenny'@'%' IDENTIFIED WITH sha256_password BY 'SecretPass123!';