1Z0-883 Online Practice Questions and Answers

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 all parameters for the login-path. The password is printed in plain text.

B. The command prints all parameters for the login-path. The password is shown only when you provide the password option.

C. The command prints all parameter for the login-path. The password is replaced with stars.

D. The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists.

A Mysql Server has been running an existing application successfully for six months.

The my.cnf is adjusted to contain the following additional configuration:

[mysqld]

Default-authentication-plugin=sha256_password

The Mysql Server is restarted without error.

What effect will the new configuration have in existing accounts?

A. They will have their passwords updated on start-up to sha256_password format.

B. They will have to change their password the next time they login to the server.

C. They are not affected by this configuration change.

D. They all connect via the secure sha256_password algorithm without any configuration change.

What are three actions performed by the mysql_secure_installation tool?

A. It prompts you to set the root user account password.

B. It checks whether file permissions are appropriate within datadir.

C. It asks to remove the test database, which is generated at installation time.

D. It can delete any anonymous accounts.

E. It verifies that all users are configuration with the longer password hash.

Consider the following table:

REATE TABLE ‘game’ (

‘id’ int (10) unsigned NOT NULL AUTO_INCREMENT,

‘keyword’ varchar (45) DEFAULT NULL,

‘date’ datetime NOT NULL,

PRIMARY KEY (‘id’ , ‘date’),

UNIQUE KEY ‘keyword_idx’ (‘keyword’ , ‘date’)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

PARTITION BY RANGE (TO_DAYS (date) ) (

PARTITION g201301 VALUES LESS THAN (TO_DAYS (‘2013-01-01 00:00:00’) ),

PARTITION g201302 VALUES LESS THAN (TO_DAYS (‘2013-02-01 00:00:00’) ),

PARTITION g201303 VALUES LESS THAN (TO_DAYS (‘2013-03-01 00:00:00’) ),

PARTITION g201304 VALUES LESS THAN (TO_DAYS (‘2013-04-01 00:00:00’) ),

PARTITION gMORES VALUES LESS THAN (MAXVALUE) );

Which method should used to add a new g201305 partition to the table?

A. ALTER TABLE games REORGANIZE PARTITION (gMORES) INTO g01305 VALUES LESS THAN (TO_DAYS (`2013-05-01 00:00:00') ), gMORES VALUES LESS THAN (MAXVALUE) );

B. ALTER TABLE games ADD PARTITION g201350 VALUES LESS THAN (TO_DAYS (`2013-05-01 00:00:00') );

C. ALTER TABLE games COALESCE PARTITION (gMORES) INTO g01305 VALUES LESS THAN (TO_DAYS (`2013-05-01 00:00:00') ), gMORES VALUES LESS THAN (MAXVALUE) );

D. ALTER TABLE games SPLIT PARTITION (gMORES) INTO g201305 VALUES LESS THAN (TO_DAYS (`2013-05-01 00:00:00') ), gMORES VALUES LESS THAN (MAXVALUE) );

E. ALTHER TABLE games DROP PATITION gMORES, ADD PARTITION g201305 VALUES LESS THAN (TO_DAYS (`2013-05-01 00:00:00') ), gMORES VALUES LESS THAN (MAXVALUE) );

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 is a shell script that invokes mysqld. Mysql.server is a wrapper for mysql_safe.

B. 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.

C. Mysqld is the server. Mysqld_safe causes the server to start up in data recovery mode. Mysql.server is a wrapper for mysqld_safe.

D. Mysql, mysqld.safe, and mysql.server reside in different locations but are all symlinked to the same script.

Which two statements are true about setting the per-thread buffers higher than required?

A. More memory per thread is beneficial in all scenarios.

B. It causes increased overhead due to initial memory allocation.

C. It can affect system stability during peak load times, due to swapping.

D. It requires increasing the thread_cache_size variable.

You are investigating the performance of the server and see the following information:

Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/ mutex/sql/LOCK_table_cache event is dominating other wait events.

The table_open_cache_overflows status variable is 0.

Which action should be taken to remove the performance bottleneck described here?

A. Decrease the value of table_definition_cache.

B. Increase the value of table_definition_cache.

C. Decrease the value of table_open_cache.

D. Increase the value of table_open_cache.

E. Decrease the value of table_open_cache_instances.

F. Increase the value of table_open_cache_instances.

Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication.

Which two statements are correct?

A. Both technologies use the TCP/IP stack as their primary transmission medium.

B. DRBD uses shared-disk technology.

C. Both technologies guarantee an identical copy of data on the secondary node.

D. Only MySQL can maintain a time-delayed copy of data on the secondary node.

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 exports tables with the most indexes first to assist with import speeds.

B. It ensures that unique indexes have no conflicts when the data is dumped.

C. It orders by primary key to assist in speeding up importing to InnoDB tables.

D. It must be specified so index data is dumped correctly when on-create-info is used.

Which three statements are true about memory buffer allocation by a MySQL Server?

A. Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.

B. Thread buffers are allocated when a client connects, and are freed when the client disconnects.

C. Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.

D. User buffers are allocated at server startup and freed when the user is dropped.

E. All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.