Oracle 1Z0-920 問題集

質問 1：
Which query will find rows in a table that have no counterpart in another table?
A. SELECT t1.name, t2.name2FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;
B. SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;
C. SELECT t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;
D. SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;
正解：D

質問 2：
Which three statements describe MySQL Enterprise Backup?
A. MySQL Enterprise Backup provides the point-in-time recovery functionality.
B. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
C. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
D. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.
E. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.
正解：A,C,E

質問 3：
An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysq1dump and mysq1 client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore.
What two are benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?
A. MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.
B. mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.
C. MySQL Enterprise Backup does not back up system data so that it is much faster.
D. mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.
E. mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.
正解：B,D

質問 4：
Which is true about inserting an additional line in a single document stored in MySQL document store?
A. You cannot insert a single line, you have to replace the entire document with a new document.
B. Any new lines can only be inserted at the end of the document.
C. The path specified must be an array position past the end of an array using the JSON_POSITION statement.
D. You specify the new element's position in the JSON_ARRAY_INSERT statement.
正解：D

質問 5：
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. 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.
B. 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.
C. Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.
D. 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

質問 6：
You have a backup image file that is backed up using MySQL Enterprise Backup with the -compress option:
/home/mysq1/backup/full/mybackup/myimage. Img

You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?
A.

B.

C.

D.

E.

正解：D