Free Oracle 1Z0-920 Exam Dumps Questions & Answers

Which statement would you use to remove the population column from the city table?

• A.DELETE population FROM city;
• B.ALTER TABLE city LESS population;
• C.ALTER TABLE city DELETE population;
• D.ALTER TABLE city DROP population;
• E.DROP population FROM city;

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

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

Which three options are valid reasons for using a primary key in a table?

• A.increasing performance when using select statements
• B.to make it easier to change the PRIMARY KEY value
• C.automatic storage of data in a sorted order
• D.maintaining a history of row insertions or updates
• E.exporting data faster with mysqldump
• F.preventing duplicate keys

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

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

Which is true about inserting an additional line in a single document stored in MySQL document store?

• A.The path specified must be an array position past the end of an array using the JSON_POSITION statement.
• B.You specify the new element's position in the JSON_ARRAY_INSERT statement.
• C.Any new lines can only be inserted at the end of the document.
• D.You cannot insert a single line, you have to replace the entire document with a new document.