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

A. ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;

B. ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;

C. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);

D. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);

You just installed MySQL by Using a Package Manager on Linux. Where are the default InnoDB redo log files stored?

A. /usr/mysql

B. /var/lib/mysql

C. /var/lib/mysql/innodb

D. /usr/bin/logs

E. /usr/redo

F. /etc/my.cnf

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

A. MySQL Servers with Group Replication to replicate data to all members of the cluster.

B. MySQL Online Hot Backup to keep data consistent and always ready to be used.

C. MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI.

D. MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.

E. MySQL Router to ensure client requests are load balanced and routed to the correct servers.

Which three are levels in which MySQL Enterprise Monitor provides access control?

A. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services

B. Asset visibility: the rights to access data collected from hosts or MySQL instances

C. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration

D. Specific data access: the rights to view specific types of potentially sensitive data

E. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent

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. --uncompress-and-apply-log

B. --apply-log-and-copy-back

C. --copy-back-and-apply-log

D. --uncompress

E. --decompress

The user -os-user'@"localhost" was created to monitor connections and shut down the server, and was

granted these privileges:

GRANT PROCESS, SHUTDOWN ON *.* TO "OS-user*@"localhost';

Which three are commands that the os-user can execute?

A. SHOW PROCESSLIST;

B. SHUTDOWN

C. SHOW STATUS;

D. SHOW BINLOG EVENTS;

E. KILL PROCESS;

F. GRANT PROXY

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 CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database

C. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

D. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent

E. A browser-based wizard to remotely deploy the MySQL Monitor Agent

What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?

A. Email

B. Browser pop-ups

C. Direct support call from an Oracle representative

D. SMS-notification tab on the dashboard

E. Application-to-application messaging

Which two are advantages of using Document Store in MySQL?

A. MySQL provides a NoSQL API to access the document store

B. MySQL can store XML as a schema-less database

C. MySQL is a document database allowing PDF and Word documents

D. MySQL provides a native data type to index PDF documents

E. MySQL provides a native data type to store JSON data as a document

Which two statements are true about MySQL Enterprise Authentication?

A. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.

B. MySQL Enterprise Authentication determines what operation the user can perform.

C. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).

D. MySQL Enterprise Authentication supports Windows Active Directory.

E. MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..