992

Which statement would you use to add a role in MySQL?. SET ROLE. MAKE ROLE. CREATE ROLE. GRANT ROLE.

Which uniquely defines each user account identity in MySQL?. Username and host. Username. Username, host, and password. Username and password.

What statement allows you to assign a password to a MySQL user account?. GRANT PASSWORD. ASSIGN PASSWORD. NEW PASSWORD. SET PASSWORD. CREATE PASSWORD.

What type of backups do mysqldump and MySQL Shell take?. Operating System. Snapshot. Logical. Physical.

Your customer has a 75 GB MySQL database. They are using mysqldump to take a backup of their database, which is taking five hours to complete. What can your customer do to decrease the amount of time it takes to back up their database?. Back up the database by using mysqldump to send the backup to another server. Back up the database to a local drive. Use MySQL Enterprise Monitor. Use MySQL Enterprise Backup.

Which log file is used to perform a Point-in-time Recovery?. Undo log. Binary log. Audit log. Redo log.

Which data type would you use for a column to store large chunks of binary data such as images and audio files?. BLOB. VARCHAR. BIT. JSON.

When creating a table, which data type would you use for a column that contains only whole numbers (a number that is not a fraction)?. INT. DECIMAL (5,2). FLOAT. BIGNUM.

The replica connects to the source and asks for updated records. What command was issued for this to happen?. REPLICA RUN. START REPLICA. START RUN REPLICA. RUN REPLICA. REPLICA START.

By using MySQL replication, data can be replicated from source to replica. What are two advantages of MySQL replication?. In-memory cache. Automatic backup. Scale out. Analytics. Data compression.

Which replication is the default in MySQL?. Semi-synchronous. Asynchronous. Quasi-synchronous. Synchronous.

Which statement is true about MySQL Replication?. Data is copied from replica to source. Multiple replicas are possible. There can only be one source. Replication can only be asynchronous.

Which two MySQL features are available in the Community Edition but are fully supported in the Enterprise Edition?. MySQL Cluster Manager. MySQL Document Store. MySQL Router. Storage Engine NDB. MySQL Enterprise Backup.

What is the benefit of using MySQL Enterprise Thread Pool?. Observability. Monitoring. Availability. Scalability.

Which MySQL Enterprise Edition component or plug-in replaces real values with substitutes?. MySQL Enterprise Audit. MySQL Enterprise Masking. MySQL Enterprise Authentication. MySQL Transparent Data Encryption.

. How does MySQL Enterprise Firewall block SQL Injection attacks?. By matching the SQL statements against the allowlist. By hiding or obfuscating sensitive data. By protecting the database files and encrypting them using AES-256. By automatically and intelligently knowing beforehand when a SQL Injection is about to happen.

Which MySQL Enterprise Security tool allows DBAs to track user activities such as Who, What, When, How, Status, From Where, DB version, OS version, and option ?. MySQL Enterprise Transparent Data Encryption (TDE). MySQL Enterprise Audit. MySQL Enterprise Firewall. MySQL Enterprise Monitor.

Which three languages are supported by MySQL Shell?. JavaScript. Python. Perl. Java. PHP. SQL.

What are the minimum and maximum number of MySQL Servers you can have in an InnoDB Cluster?. Minimum 3 and maximum 9. Minimum 1 and maximum 5. Minimum 5 and maximum 9. Minimum 3 and maximum 7.

. What does the InnoDB Cluster provide?. Automatic failover. Automatic sharding. Automatic scaling. Automatic partitioning.

MySQL has many variables. Which two are mandatory MySQL variables?. tabledir. datadir. basedir. dbdir. filedir.

Which three statements are true about the HeatWave service?. Data updates in transactional storage are not immediately reflected in HeatWave analytics storage. Heatwave uses AutoML to automate the machine learning life cycle. HeatWave processes analytic queries directly from the InnoDB storage engine on compute nodes. HeatWave enables fast execution of analytic queries directly from memory nodes. HeatWave updates the analytics storage with user-schedulable Extract-Transform-Load processing. HeatWave offers the ability to query data from object store.

You install MySQL from binary archive and use the --initialize-insecure option to initialize the data directory. Why is this process insecure?. It removes all the MySQL Enterprise Security features. It prevents the MySQL server from starting up properly. It does not generate a root password. It disables all the logging done by the MySQL server.

Which two Autopilot features you are during initial DB System and Analytics cluster deployment?. Auto Parallel Loading. Auto Data Placement. Auto Encoding. Auto Provisioning. Auto Shape Prediction.

HeatWave is a fully-managed database service for MySQL in Oracle Cloud Infrastructure (OCI). Which three actions can be performed in the HeatWave cloud console without any SQL coding?. Reset user password. Delete a schema. Deploy MySQL instances. Create database tables. Enable high availability. Manage backups.

. What are the two ways to install MySQL on a Linux platform?. By using RPM packages. By using MySQL Installer. By using Yum/APT Repositories. By using. DMG disk image.

Which three operating systems are supported by MySQL?. macOS. Windows. Android. ios. Linux.

Which category includes privileges such as SYSTEM_USER and FIREWALL_ADMIN?. Dynamic Privileges. General Privileges. Runtime Privileges. Static Privileges.

How would you start the MySQL server without using the privilege system or by disabling the access control?. Use the --disable-grants command option. Use the --no-grants command option. Use the --block-privilege option. Use the --skip-grant-tables option.

. Why are indexes used in MySQL?. To speed up INSERT operations. To speed up DELETE operations. To speed up SELECT operations. To speed up ALTER operations. To speed up CREATE operations.

. A table has this specification: CREATE TABLE address ( id INT NOT NULL, last_name CHAR(30) NOT NULL, first_name CHAR (30) NOT NULL, city CHAR (30) NOT NULL, INDEX LASTFIRST (last_name, first_name) ); Which statement will NOT use an index?. SELECT * FROM address WHERE city='Chicago';. SELECT * FROM address WHERE last_name='Doe' AND first_name='John';. SELECT * FROM address WHERE last_name='Doe' AND (first_name='John' OR first_name='Other');. SELECT * FROM address WHERE last_name='Doe';.

. What two major editions of MySQL are available?. MySQL Industrial Edition. MySQL Developer Edition. MySQL Community Edition. MySQL Commercial Edition. MySQL Express Edition.

Why should one choose MySQL Enterprise Edition over MySQL Community/Standard Edition?. It provides tools and advanced features. It provides ACID properties. It provides NDB storage engine. It provides access to MySQL Connectors.

Where would you look to find easy-to-understand views that contain information about IO hot spots, locking, and costly SQL statements?. sys schema. Performance schema. mysql schema. Information schema.

Which monitoring tool is included with MySQL Enterprise Edition?. Oracle Automatic Database Diagnostic Monitor (ADDM. Oracle Enterprise Manager. Oracle GoldenGate. Oracle Exadata.

Which schema provides runtime statistics to monitor MySQL server execution at a low level?. sys schema. mysql schema. Information schema. Performance schema.

. Consider this SQL statement which is using the InnoDB storage engine and with global AUTOCOMMIT = 1: BEGIN; CREATE TABLE tl (c1 INT); CREATE TABLE t2 (c1 INT); ROLLBACK; What is the result after issuing the ROLLBACK command?. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK. Both the tables, t1 and t2, are created. Only the t1 table is created. Only the t2 table is created.

Assume that the database world exists and does not contain a table called poi. You execute this statement: CREATE TABLE world.poi (x INT, Y INT, z INT); What is the output?. The world.poi table is created in the default database. The poi table is created in the world database. The statement fails because world.poi is not a valid table name. The poi table is created in the default database.

Which MySQL storage engine is fully ACID compliant and also the default when creating a table?. Memory. InnoDB. MyISAM. Archive.

What type of join returns all records from the left table and the matched records from the right table?. Cross Join. Left Join. Right Join. Inner Join.

Which query will find rows in a table that have no counterparts in another table?. SELECT t1.name, t2.name2 FROM employee AS t1 INNER JOIN info AS t2 ON tl.name t2.name2;. SELECT t1.name, t2.name2 FROM employee t1 INNER JOIN info t2 WHERE t1.name = t2.name;. SELECT * FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id =! table2.id;. SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id = right_tbl.id WHERE right_tbl.id IS NULL;.

Which keyword can be used in a SQL statement to view information about how tables will be joined and in which order?. DECLARE. USE. HELP. EXPLAIN.

Which two statements are true about MySQL Enterprise Authentication?. MySQL Enterprise Authentication determines what operations the user can perform. MySQL Enterprise Authentication supports Windows Active Directory. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM). MySQL Enterprise Authentication automatically connects to Oracle Password Vault to verify user.

Which two statements about the download of MySQL Enterprise Backup are correct?. MySQL Enterprise Backup comes with all MySQL editions including the Community Edition. MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on https://www.mysql.com. MySQL Enterprise Backup comes with MySQL Connector and is freely available for download. MySQL Enterprise Backup is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com. MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).  .

Which backup method allows you to back up only the data that has changed since the last FULL backup?. Full. Incremental. Optimistic. Differential. Partial.

Which replication topology does NOT implement any conflict detection or resolution?. Replication conflicts are not possible in MySQL. MySQL Chain. Source-Replica. Source-Source.

Which three components are part of the core MySQL database architecture?. Optimizer. Disk Parity/RAID. Parser. mysqldump. Storage Engine. MySQL Router.

You just installed MySQL using a package manager on Linux. Where is the default data directory (that is, datadir) located that holds InnoDB log files such as undo and redo logs?. /usr/lib/mysql. /usr/local/mysql. /var/lib/mysql. /opt/mysql.

. How would you replicate between two InnoDB Clusters?. Set up MySQL Replication. Set up MySQL InnoDB Read Replicas. Set up MySQL InnoDB ClusterSet. Set up MySQL ReplicaSet.

Which three components can MySQL InnoDB Cluster use to achieve database high availability?. MySQL online hot backup, to keep data consistent and always ready to be used. MySQL Servers with Group Replication, to replicate data to all members of the cluster. MySQL Shell, to create and administer InnoDB Cluster using the built-in AdminAPI. MySQL Router, to ensure client requests are load balanced and routed to the correct server. MySQL X Plugin, to enable MySQL to use the X Protocol to speed up and monitor data replication.

Which edition of MySQL is HeatWave based on?. MySQL Enterprise Edition. MySQL Standard Edition. MySQL Community Edition. MySQL Cluster Carrier Grade Edition.

Under which category do FLOAT and DOUBLE data types fall?. Numeric Exact Value. Bit-value Type. Spatial Type. Numeric Approximate Value.

Which three components are part of the core MySQL database architecture?. Parser. Storage Engine. Optimizer. mysqldump. Disk Parity/RAID. MySQL Router.

What is true about MySQL Enterprise Transparent Data Encryption (TDE)?. It enables data-at-rest encryption with a strong symmetric algorithm. .Encryption key is stored in a centralized key memory location. Data is encrypted in real time after it is written to storage. It encrypts data-in-flight so that it is only visible unencrypted at the server and client.

Which statement is used to assign privileges to a MySQL user?. USE. GRANT. ALTER. SET. UPDATE.

You have created a full backup using MySQL Enterprise Backup and would like to restore that backup to a new MySQL Server. Which MySQL Enterprise Backup keyword allows you to perform a restore?. apply-log. load. restore. copy-back.

Which two options are true about the MySQL Long-Term Support release model?. Released every quarter. Ideal for fast-paced development environments. Includes bug fix and security patches only. Available only with MySQL Enterprise Edition. Allows backward compatibility.

In MySQL, the word "schema" is a synonym for which word?. Server. Table. View. Database. Instance.