Online Access Free 1Z0-920 Practice Test

Which two are advantages of using Document Store in MySQL?

• A.MySQL can store XML as a schema-less database
• B.MySQL provides a NoSQL API to access the document store
• 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

What SQL keyword must be specified when creating a foreign key constraint?

• A.an index on the foreign key
• B.unique PRIMARY key values for both child and parent tables
• C.a TRIGGER on the child table for cascading delete statements
• D.a REFERENCES in the child table to the parent table
• E.the SET_FOREGIN variable in the my .cnf file

You want to create an encrypted table. So, you enter this command:
CREATE TABLE 'test_encryption2% (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'server_name' varchar(15) NOT NULL,
PRIMARY KEY ('id') ) ENGINE=MYISAM AUTO_INCREMENT=l DEFAULT CHARSET=latin1 ENCRYPTION = 'Y1; You receive the following error:
ERROR 1031 (HY000): Table storage engine for 'test_encryption2' doesn't have this option Which statement correctly explains the reason for this error?

• A.The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.
• B.You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.
• C.The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.
• D.The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.

Which two statements about the download of MySQL Enterprise Backup are correct?

• A.MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on http://www.mysql.com.
• B.MySQL Enterprise Backup is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com.
• C.MySQL Enterprise Backup comes with all MySQL editions including community edition.
• D.MySQL Enterprise Backup comes with MySQL Connector and is freely available for download.
• E.MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).

You have a MySQL Server instance (running with Port# 3306) monitored by the Service Manager in MySQL Enterprise Monitor. You cloned the MySQL Database instance and configured it to be a replicated MySQL instance as Slave using Port# 3316 on the same machine as the Master Server. The replication configuration is working correctly. The Master and Slave Servers are running.
You are trying to add the newly created MySQL Slave instance to the Monitor. The Service Manager in MySQL Enterprise Monitor notifies you that the new instance is successfully added; however, it is not added correctly at the newly added configuration points to the old Master monitored items. The Monitor shows only one monitored MySQL instance for Master and Slave.
Which two are possible reasons for this problem?

• A.The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
• B.The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.
• C.The MASTER and SLAVE are grouped as one instance for monitoring.
• D.The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
• E.All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.