1Z0-888 Online Practice Questions and Answers

Examine the mydata table and SELECT statements:

You issue:

mysql> begin;

mysql> update mydata set a=0 where b=3;

How many rows are now protected by locks with the default InnoDB configuration?

A. one

B. one row and a next-key lock for supremum

C. one row and a gap-lock

D. five

Which two methods accurately monitor the size of your total database size over time? (Choose two.)

A. monitoring the Innodb_rows_inserted status variable

B. monitoring the innodb_redo_log_size variable

C. monitoring the information_schema.TABLES table

D. monitoring datadir size in the operating system

E. monitoring cumulative Innodb_page_size increase

F. monitoring the performance_schema_hosts_size variable

Host slave1 has ip address 192.0.2.10. Host slave2 has ip address 203.0.113.50

Examine these commands:

Why did this error occur?

A. The host on the command line is not defined in the login path.

B. The mysqld instance has not been restarted after creating the login path.

C. There is no password defined in the login path.

D. The DNS is not configured correctly for slave1 host.

E. The .mylogin.cnf file is not readable.

Which three tasks are handled by the optimizer? (Choose three.)

A. Decide which indexes to use.

B. Rewrite the WHERE clause.

C. Parse the query.

D. Change the order in which the tables are joined.

E. Validate the query.

F. Execute the query.

G. Verify that the user is allowed to execute the query.

Consider the table people with the definition:

The application uses a query such as:

SELECT * FROM people WHERE YEAR(Birthday) = 1980;

The query is not using an index.

Which two methods can be used to allow the query to use an index? (Choose two.)

A. Change the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.

B. Add a functional index for YEAR(Birthday).

C. Execute ANALYZE TABLE to update the index statistics.

D. Add a generated column calculating YEAR(Birthday) and index that column.

E. Add FORCE INDEX (Birthday) to the query.

Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

A. It relies on the shared disk architecture being visible to both servers.

B. It is provided by means of IP-level disk replication.

C. It implements High Availability by using the .NET Connector's load balancing capabilities.

D. It is a shared-nothing architecture.

Which statement is correct about how InnoDB storage engine uses disk space?

A. It stores data in .MYD files and its index and undo information in the common tablespace.

B. It stores data in .MYD files, index information in .MYI files, and undo information the common tablespace.

C. It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.

D. It stores its data, index and undo information in .MYD and .MYI files.

E. It stores data, index and undo information in tablespace file(s).

While attempting to set up a new replication slave on host `192.168.0.25' with the user `replication', you encounter this error:

What should you do to resolve this error?

A. Add the user replication@192.168.0.25 with the correct password to the master.

B. Edit the DNS table on the master to include the domain name for the IP address of 192.168.0.25.

C. Edit the my.ini file on the slave so that the master-host variable is equal to the IP address of the master, and restart the slave.

D. Add the user replication@192.168.0.25 with the correct password to the slave.

Recently, users on mostly-write MySQL database have been complaining of slowdowns or stalls in their applications.

Which option is most likely to have a positive effect on the server's health and performance?

A. Reduce the size of redo logs to improve storage efficiency.

B. Increase the size of redo logs.

C. Lower innodb_max_dirty_pages_pct to flush more often.

D. Move redo logs to /dev/shm to improve their speed.

Assuming that a user has correct privileges, which Linux console command will fail to shut down a MySQL server?

A. mysqld -e 'shutdown'

B. service mysqld stop

C. mysqladmin shutdown

D. mysql -e 'shutdown'