Oracle 1z0-888 Exam Questions Free Practice Test

Viewing page 3 out of 4 pages

Viewing questions 21-30 out of questions

Questions # 21:

You enable binary logging on MySQL Server with the configuration:

binlog-format=STATEMENT

log-bin

Which database updates are logged on the master server to the binary log by default?

Options:

all updates except to the TEMPDB database

all updates except to the PERFORMANCE_SCHEMA database

all updates not involving temporary tables

all updates to the default database, except temporary tables

all updates to all databases

Expert Solution

Questions # 22:

Host slave1 has ip address 192.0.2.10.

Host slave2 has ip address 203.0.113.50

Examine these commands:

Question # 22

Why did this error occur?

Options:

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

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

There is no password defined in the login path.

The DNS is not configured correctly for slave1 host.

The .mylogin.cnf file is not readable.

Expert Solution

Questions # 23:

An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be “rolled forward” to provide all the latest data.

The SHOW SLAVE STATUS indicates these values:

RELAY_LOG_FILE=hostname-relay-bin.00004

RELAY_LOG_POS=1383

Which command set would make the slave current?

Options:

STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = ‘hostname-relay-bin.00004’,

RELAY_LOG_POS = 1383;

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;

Expert Solution

Questions # 24:

Consider the table people with this definition:

Question # 24

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

Options:

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

Add a functional index for YEAR(Birthday).

Execute ANALYZE TABLE to update the index statistics.

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

Add FORCE INDEX (Birthday) to the query.

Expert Solution

Questions # 25:

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

Options:

monitoring the Innodb_rows_inserted status variable

monitoring the innodb_redo_log_size variable

monitoring the information_schema.TABLES table

monitoring datadir size in the operating system

monitoring cumulative Innodb_page_size increase

monitoring the performance_schema_hosts_size variable

Expert Solution

Questions # 26:

Consider the join_buffer_size parameter in MySQL Server.

Which two statements are true about the join buffer? (Choose two.)

Options:

The value should be increased if the client performs several SELECT operations.

The join buffer is set per connection.

The join buffer is used to process sorts when complex joins are being performed.

The value should be increased from the default if the query joins large rows without using an index.

The join buffer is global and can be changed only by restarting the server.

Expert Solution

Questions # 27:

You have a config file for a running DB with this excerpt:

[mysqld]

tmp_table_size=16M

sort_buffer_size=256k

To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:

mysql> SET GLOBAL tmp_table_size=32000000;

mysql> SET sort_buffer_size=2000000;

This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.

Which three best describe this scenario?

Options:

Global variables are not persistent across server restarts.

Session variables are not persistent across server restarts.

The query benefited from sort_buffer_size increase.

sort_buffer_size should match tmp_table_size to be optimal.

The query benefited from tmp_table_size increase.

The query benefited from sort_buffer_size and tmp_table_size increases.

Expert Solution

Questions # 28:

What is the order of tables shown in an EXPLAIN output?

Options:

It lists tables from the smallest to the largest.

It lists tables in the order in which their data will be read.

It lists tables from the most optimized to the least optimized.

It lists tables in the order in which they are specified in the statement that is being explained.

Expert Solution

Questions # 29:

Which statement is true about tablespaces?

Options:

All tablespace files must be in the directory specified by the –-datadir option.

General tablespaces can be configured to span multiple files.

All tables must be in either the system tablespace or a general tablespace.

The system tablespace can be configured to span multiple files.

Expert Solution

Questions # 30:

There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.

The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults.

A restore of the second instance is attempted from the mysqlbackup archive using this command:

mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back

Upon starting the second MySQL instance, you notice that the data does not match the expected backup. Which command-line option is required to successfully update the second instance?

Options:

--restore=2

--copy-back-from-log

--backup-instance=/var/lib/mysql/instance2

--instance=/var/lib/mysql/instance2

--defaults-file=/etc/mysql/instance2.cnf

Expert Solution

Viewing page 3 out of 4 pages

Viewing questions 21-30 out of questions

New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Pass the Oracle MySQL Database Administration 1z0-888 Questions and answers with CertsForce