Online Access Free 1Z0-920 Practice Test

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

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

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

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

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.mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.
• B.MySQL Enterprise Backup does not back up system data so that it is much faster.
• 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.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.
• E.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.

Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?

• A.A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
• B.A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent
• C.A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database
• D.A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
• E.A browser-based wizard to remotely deploy the MySQL Monitor Agent

Which two statements are correct about MySQL Enterprise Edition?

• A.MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance.
• B.Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances.
• C.Oracle MySQL Enterprise tools & plugins are available as optional services (installation Feature Pack I/II).
• D.MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network.
• E.MySQL configuration can be changed in /etc/lib/myi.cnf.