Which statement would create an index by using the first 10 characters of the name column in the customer table (assuming that name is a nonbinary string type?)

• A. CREATE INDEX part_of_name ON customer.name LIMIT 10 CHAR;
• B. CREATE INDEX (10) ON (customer.name);
• C. CREATE SUB INDEX part_of_name ON (customer, name, 10);
• D. CREATE INDEX part_of_name ON customer (name(10));
• E. CREATE PARTIAL INDEX part-of_name ON customer (name, 10);

What are two key differences between the use of ndbd and ndbmtd?

• A. In the event of critical errors, ndbd generates all trace in error log, whereas ndbmtd generates a trace file with the name pattern ndb_node_id_trace.log.trace_id_tthread_id.
• B. ndbd can be configured as ndbmtd by applying the option - - mtd.
• C. In the event of critical errors, ndbd generates a trace file with the name ndb_node_id_trace.log.trace_id, whereas ndbmtd generates a trace file with the name pattern ndb_node_id_trace.log.trace_id_tthread_id
• D. ndbd is single-threaded mode.ndbmtd runs by default in single-threaded mode; you must configure it to use multithreads.
• E. ndbd is single-threaded mode; however, ndbmtd runs by default in multithreaded mode.

You get a Maintenance notification about your Oracle MySQL Cloud Service. What are the implications?

• A. There are no maintenance operations planned. You need to do them manually.
• B. You can expect an outage of your MySQL Cloud Service during the planned time.
• C. You need to agree to the maintenance windows. If not, you are not affected by the outage.
• D. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.

You have a backup image file that is backed up using MySQL Enterprise Backup with the - - compress option:
/home/mysql/backup/full/mybackup/myimage.img
mysqlbackup.cnf is shown as follows:
[mysqlbackup]
backup-dir=/home/mysql/backup/full/mybackup
backup-image=/home/mysql/backup/full/mybackup/myimage.img
You are required to perform a database restore to a new machine to provision the database.
Which command can provision the new database in the datadir as /home/mysql/data/MEB?

• A. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB apply-log-and-copy-back
• B. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB copy-back-and-apply-log
• C. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB image-to-dir
• D. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB restore-and-apply-log
• E. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB image-to-dir-and-apply-log