Oracle 1z1-883 Value Pack (Frequently Bought Together)

You have a login-path named "adamlocal" that was created by using the mysql_config_editor command.
You need to check what is defined for this login_path to ensure that it is correct for you deployment.
You execute this command:
$ mysql_config_editor print -login-path=adamlocal
What is the expected output of this command?

• A. The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists.
• B. The command prints all parameter for the login-path. The password is replaced with stars.
• C. The command prints all parameters for the login-path. The password is shown only when you provide the -password option.
• D. The command prints all parameters for the login-path. The password is printed in plain text.

The following commands are available in the Linux binary distributions of Mysql:
-Mysqld -Mysqld_safe -Mysql.server
What is the correct description of each of these commands?

• A. Mysqld is the server.
  Mysqld_safe causes the server to start up in data recovery mode.
  Mysql.server is a wrapper for mysqld_safe.
• B. Mysql, mysqld.safe, and mysql.server reside in different locations but are all symlinked to the
  same script.
• C. Mysqld is a shell script that starts mysql.server.
  Mysqld_safe causes the server to start up in data recovery mode.
  Mysql.server is the server.
• D. Mysqld is the server.
  Mysqld_safe is a shell script that invokes mysqld.
  Mysql.server is a wrapper for mysql_safe.

You have been notified that the 'apps' . 'reports' table has been accidentally truncated.
You have single file mysqldump backup available taken prior to the truncate. The backup contains all the tables from the instance, and the 'apps' . 'reports' table must be restored without affecting the other remaining databases and tables.
Which restore option is suitable in this scenario?

• A. Execute mysqldump on the backup,sql file and apply - filter arguments to obtain only the 'apps' . 'reportys' table.
• B. Restore the backup to another databases instance and obtain a copy of the reports table individually.
• C. Execute LOAD DATA INFILE 'backup.sql' SCHEMA='apps' TABLE= 'reports'
• D. Extract the 'apps' . 'reports' table from the backup using the SOURCE command.

What are four capabilities of the mysql client program?

• A. Creating and dropping databases
• B. Creating and administering users
• C. Creating, dropping, and modifying tables and indexes
• D. Shutting down the server by using the SHUTDOWN command
• E. Displaying replication status information
• F. Initiating a binary backup of the database by using the START BACKUP command

You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead.
You execute the following commands:
ServerB commands:
Shell> mysqldump -u root -h server -no-data apps userdata | mysql -u root -p apps
Shell> mysql -u root -p -h server -e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;'
Shell> mysqldump -u root -p -h server -no-create-info -order-by-primary apps userdata | mysql -u root -p apps
What effect does the - order-by-primary argument have on the mysqldump command?

• A. It must be specified so index data is dumped correctly when -on-create-info is used.
• B. It orders by primary key to assist in speeding up importing to InnoDB tables.
• C. It ensures that unique indexes have no conflicts when the data is dumped.
• D. It exports tables with the most indexes first to assist with import speeds.