Free Oracle 1Z1-888 Exam Dumps Questions & Answers

The /myfolder/my.cnf file has option set:
[mysqld]
skip-log-bin
/myfolder2/my.cnf has this option set:
[mysqld]
log-bin = /valid/path/to/mysqlbinlog
All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.
You start an instance by using this command line:
mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf What is the outcome?

• A.  MySQL fails to start due to the conflicting options in the configuration files.
• B.  MySQL starts and Binary Logging is enabled.
• C.  MySQL fails to start due to conflicting options on the command line.
• D.  MySQL starts but Binary Logging is disabled.

You have created a backup of the 'sales' database with the command:

Which two procedures can be used to restore the 'orders' table from the backup? (Choose two.)

• A. 
• B. 
• C. 
• D. 

You have set innodb_stats_auto_recalc to OFF.
For tables using persistent statistics, what is the outcome of this change?

• A.  InnoDB no longer automatically updates index statistics after 10% of the rows in a table change.
• B.  InnoDB no longer automatically updates index statistics after the table structure is altered.
• C.  InnoDB no longer automatically updates index statistics after an ANALYZE TABLE statement.
• D.  InnoDB no longer automatically updates index statistics after a CREATE TABLE statement.

Examine the mysqldumpslow output:

Which two options could explain the slow query?

• A.  There is network congestion between client and server.
• B.  There are 108 queries still being executed.
• C.  A table lock is causing delays.
• D.  A full table scan is being used.
• E.  No index has been defined on the filtered column.

You want to create the first configuration file for a new installation of MySQL.
- You will start mysqldmanually (not automate it to start when the host machine starts or execute as a service).
- You will stop mysqldusing mysqladmin.
- You will interact with mysqldby using only the command-line client mysql.
Which option identifies a maximal set of sections where you can put the "max_allowed_packet=16M" parameter without creating a problem?

• A.  [mysql] and [mysqld] and [mysqladmin]
• B.  [mysqld]
• C.  [mysqladmin]
• D.  [mysqld] and [mysqladmin]
• E.  [mysql] and [mysqld]
• F.  [mysql]
• G.  [mysql] and [mysqladmin]