Oracle MySQL Cloud Service 2018 Implementation Essentials

QUESTION NO: 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 t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2; C. SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id; D. SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;

Correct Answer: D

QUESTION NO: 2
When working with the Linux operating system on a database cloud instance (non-RAC), which user accounts are available for database and non-database administration?

A. root, opc-administrator, and oracle through sudo B. opc, oracle, and root (through sudo) C. administrator, opc, and oracle D. admin, ora-cloud, and oracle E. cloud-admin, oracle, and root

Correct Answer: B

QUESTION NO: 3
The following backup command is executed:
mysqlbackup --defaults-file=config/mysqlbackup.cnf --compress --port=3306 --host=127.0.0.1
--user=mysqlbackup --password --suspend-at-end backup
*** log started **
....
160308 14:43:00 mysqlbackup: INFO: Copying /home/mysql/data/07/test/xmltable.ibd (Barracuda file format).
160308 14:43:00 mysqlbackup: INFO: Completing the copy of innodb files.
160308 14:43:00 mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
160308 14:43:00 mysqlbackup: INFO: Starting to lock all the tables...
160308 14:43:00 mysqlbackup: INFO: All tables are locked and flushed to disk mysqlbackup: INFO:
--suspend-at-end option is specified.
160308 14:43:00 mysqlbackup: INFO: Suspending the backup procedure to wait until the marker file
'/home/mysql/backup/full/mybackup/datadir/ibbackup_suspended' is deleted.
....
*** log ended **
Which option allows mysqlbackup to continue backing up the rest of the data?

A. An external program or manual work is to be executed to complete the backup and the marker file
"/home/mysql/backup/full/mybackup/datadir/ibbackup_suspended' should be removed intentionally.
After the file is removed, mysqlbackup will continue B. Log in to the MySQL server and identify the processid, which issues GLOBAL READ LOCK. Connect the mysql session and terminate the session for the identified "processed" .mysqlbackup will continue C. Run a mysql command as follows.mysqlbackup will continue. mysql> resume mysqlbackup; D. Run a mysql command as follows,.mysqlbackup will continue. mysql>UNLOCK TABLES; E. Issue a SIGTERM to the mysqlbackup process.mysqlbackup will continue

Correct Answer: A

QUESTION NO: 4
Which three backup scenarios can be accommodated with MySQL Enterprise Backup? (Choose three.)

A. making partial backup and optimistic backup B. creating a cloud backup C. making a backup directly into tape device by using MySQL Enterprise Backup Media Management Software (MMS) D. converting a database backup from another database vendor to MySQL E. making a single file backup by creating backups in single-file format

Correct Answer: B,C,E

QUESTION NO: 5
Which two architecture options can provide Active/Active Master configuration for the MySQL Database?

A. Deploy MySQL Cluster on the following machines:Machine 1: MySQL Node+ MySQL Management NodeMachine 2: MySQL Node+ MySQL Management NodeMachine 3: Data NodeMachine 4: Data NodeApplication can access MySQL Node on Machine 1 or Machine 2 for Active/Active Configuration. B. Execute the following on the 2x MySQL Server Instancesmysql> ALTER REPLICATION set mode= active; C. 2x MySQL Server Instances should be deployed on two machines with shared NFS volume. Datadir points to the shared folder. Applications can access either one of the MySQL Servers for the same set of data. D. Configure MySQL Replication between two MySQL Database instances and setting Replication mode = active. E. Configure MySQL Replication for two MySQL Database instances with circular Replication Topology, where two different applications with each using different database schemas connecting to a specified MySQL Database Instance.MySQL Database Instance1 < -----Replication---> MySQL Database Instance 2Application A connecting to MySQL Database Instance 1 for schema db1Application B connecting to MySQL Database Instance 2 for schema db2

Correct Answer: D,E

QUESTION NO: 6
An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysqldump and mysql 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 are two 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 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. C. 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. D. MySQL Enterprise Backup does not back up system data so that it is much faster. E. mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.

Correct Answer: C,E

QUESTION NO: 7
You create two database tables as shown by the following CREATE TABLE statements:
CREATE TABLE parent (
parent_id INT,
name_first VARCHAR(30),
name_last VARCHAR(30),
PRIMARY KEY (parent_id)
);
CREATE TABLE child (
child_id INT,
parent_id INT,
name_first VARCHAR(30),
name_last VARCHAR(30),
PRIMARY KEY (child_id)
);
After populating both tables with data, which statement would produce an output of only the parents' first and last names and the first and last names of the related children?

A. SELECT * .name_first, *.name_last FROM BOTH parent, child WHERE parent_id IS EQUAL; B. SELECT name_first, name_last FROM parent, child LEFT JOIN parent_id WHERE parent_id = child_id; C. SELECT p1.name_first, p1.name_last, c1.name_first, c1.name_last FROM parent p1 LEFT JOIN child c1 ON (c1.parent_id=p1.parent_id); D. SELECT * FROM parent, child LEFT JOIN (child) ON (child.parent_id=parent.parent_id);

Correct Answer: B

QUESTION NO: 8
A Cloud 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 does not have proper user rights. B. The customer account might have reached its compute quota. C. The customer reached the database instance limit of 32. D. 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.

Correct Answer: C

QUESTION NO: 9
Which three features are available only on MySQL Enterprise Workbench?

A. GUI for MySQL Enterprise Backup B. Database Migration inclusive Support C. MySQL Audit Log Inspector D. Database Design E. Visual Performance Dashboard

Correct Answer: A,C,D

QUESTION NO: 10
Your system is being swamped by business users running multiple ad hoc queries. What is a valid way to limit the resources for a particular user?

A. MAX_QUERIES_PER_HOUR B. MAX_QUERY_SIZE C. MAX_CONNECTIONS D. MAX_UPDATES_PER_DAY E. CONNECTIONS_PER_HOUR

Correct Answer: A

Oracle MySQL Cloud Service 2018 Implementation Essentials - 1z1-320 Exam Questions