Online Access Free 1Z1-920 Exam Questions

You have created your Compute instance using an Oracle-provided Oracle Linux image.
You want to log in to your OCI Compute instance using SSH. Which three items do you need for this process?

• A.SSH public key
• B.Public IP address
• C.The root user
• D.The opc user
• E.User Password
• F.SSH private key

Which best describes database horizontal scale-out architecture deployment in MySQL in a read-heavy environment?

• A.Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.
• B.Allocating more CPU to the database instance to improve throughput performance.
• C.Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.
• D.Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.
• E.Increasing the storage capacity so that the database can store more data to scale.

You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?

• A.Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.
• B.Go to the configuration section (MEM) and configure the default login credentials.
• C.Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.
• D.Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.
Which two options should you include in the MySQL configuration file?

• A.plugin-audit=ON, ALWAYS
• B.plugin-load=audit_log.so
• C.audit_log_permanent=ON
• D.audit-log=FORCE_PLUS_PERMANENT
• E.LOAD PLUGIN=AUDIT_LOG

Which statement adds a column with the largest integer data type?

• A.ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;
• B.ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);
• C.ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);
• D.ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;