1z0-320 무료 덤프문제 온라인 액세스

Which four options are valid reasons for using a PRIMARY KEY in a table?

• A.Maintaining a history of row insertions or updates
• B.Increasing performance when using SELECT statements
• C.Automatic storage of data in a sorted order
• D.Exporting data faster with mysqldump
• E.Auto-generating values via AUTO_INCREMENT
• F.Preventing duplicate keys
• G.Eliminating the need for accessing the database cache

When working with the Linux operating system on a database cloud instance (non-RAC), which user accounts are available for database and non-database administration?

• A.root, opc-administrator, and oracle through sudo
• B.cloud-admin, oracle, and root
• C.admin, ora-cloud, and oracle
• D.opc, oracle, and root (through sudo)
• E.administrator, opc, and oracle

For accessing a new default MySQL Cloud Service (CS) cloud environment, you used the "Create SSH Keys function" during the guided MySQL CS setup. You want to use Putty from your Windows Client. Identify the correct steps.

• A.Use the provided private key for authentication.
• B.Open Port 22 on your MySQL CS Instance and convert the private key to ppk format. This new private key can be used for authentication.
• C.Convert the private key to ppk format first, and use the new private key for authentication.
• D.You open Port 22 on your MySQL CS Instance and configure Putty with the provided private key.

A keyfile has been generated as follows:
# openssl rand 32 -hex >keyfile
# cat keyfile
6a1d325e6ef0577f3400b7cd624ae574f5186d0da2eeb946895de418297ed75b
You are required to do a backup on the MySQL database using MySQL Enterprise Backup with encryption.
Which option can perform the backup with the keyfile provided in order to encrypt the backup files?

• A.# mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup - timestamp backup
• B.# mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key=keyfile -
  -backup-dir=/var/tmp/backup backup-to-image
• C.# mysqlbackup - - backup-image=/backups/image.enc - - encrypt- - encrypt-key=keyfile - - backup-dir=/var/tmp/backup backup-to-image
• D.# mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key-file= keyfile -
  -backup-dir=/var/tmp/backup backup-to-image
• E.# mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup backup

The following backup command is executed:
mysqlbackup --defaults-file=config/mysqlbackup.cnf --compress --port=3306 --host=127.0.0.1
--user=mysqlbackup --password --suspend-at-end backup
*** log started **
....
160308 14:43:00 mysqlbackup: INFO: Copying /home/mysql/data/07/test/xmltable.ibd (Barracuda file format).
160308 14:43:00 mysqlbackup: INFO: Completing the copy of innodb files.
160308 14:43:00 mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
160308 14:43:00 mysqlbackup: INFO: Starting to lock all the tables...
160308 14:43:00 mysqlbackup: INFO: All tables are locked and flushed to disk mysqlbackup: INFO:
--suspend-at-end option is specified.
160308 14:43:00 mysqlbackup: INFO: Suspending the backup procedure to wait until the marker file
'/home/mysql/backup/full/mybackup/datadir/ibbackup_suspended' is deleted.
....
*** log ended **
Which option allows mysqlbackup to continue backing up the rest of the data?

• A.Issue a SIGTERM to the mysqlbackup process.mysqlbackup will continue
• B.An external program or manual work is to be executed to complete the backup and the marker file
  "/home/mysql/backup/full/mybackup/datadir/ibbackup_suspended' should be removed intentionally.
  After the file is removed, mysqlbackup will continue
• C.Run a mysql command as follows.mysqlbackup will continue. mysql> resume mysqlbackup;
• D.Log in to the MySQL server and identify the processid, which issues GLOBAL READ LOCK. Connect the mysql session and terminate the session for the identified "processed" .mysqlbackup will continue
• E.Run a mysql command as follows,.mysqlbackup will continue. mysql>UNLOCK TABLES;