Free Oracle 1Z0-920 Exam Dumps Questions & Answers

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

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

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

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

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

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

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

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

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