Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-888 - MySQL 5.7 Database Administrator

Oracle 1z0-888 Premium Access     Download Demo    
Page: 1 / 4
Total 124 questions

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.

Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

A.

It caches index blocks for MyISAM tables only.

B.

It caches index blocks for all storage engine tables.

C.

It is a global buffer.

D.

It is set on a per-connection basis.

E.

It caches index blocks for InnoDB tables only.

When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file? (Choose two.)

A.

it contains the binary log.

B.

it contains a general tablespace.

C.

it is the default location for all new tables that you create.

D.

it contains the system tablespace.

E.

it contains the redo log.

F.

it contains the undo log.

You want to dump only data from the userdata table.

Which mysqldump command argument is required to accomplish this?

A.

- -no-create-info to skip writing CREATE TABLE statements

B.

- -single-transaction as this obtains a consistent view of data only

C.

- -data-only as this specifies that only data is to be dumped

D.

- -table=userdata in order to dump only the data from the userdata table

You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

A.

the mysql_upgrade script

B.

the mysql client with the --ignore-password-hashing option

C.

the mysql_secure_installation script to update server security settings

D.

the mysql client with the --enable-cleartext-plugin option

E.

the install plugin command for the mysql_cleartext_password plugin

A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

The MySQL Server is restarted without error.

What effect will the new configuration have on existing account?

A.

They are not affected by this configuration change.

B.

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

C.

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

D.

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

A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance? (Choose two.)

A.

a backup created with mysqldump --all-databases

B.

a backup created using FLUSH TABLES … FOR EXPORT

C.

an up-to-date replication slave

D.

a file system-level snapshot

E.

a file system copy created while MySQL was shut down.

old_alter_table is disabled as shown.

mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table:

mysql> ALTER TABLE orders DROP PARTITION p1, p3;

What is the outcome of executing this statement?

A.

All data in p1 and p3 partitions is removed and the table definition is changed.

B.

All data in p1 and p3 partitions is removed, but the table definition remains unchanged.

C.

Only the first partition (p1) will be dropped because only one partition can be dropped at any time.

D.

It results in a syntax error because you cannot specify more than one partition in the same statement.

What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

A.

using SSL when transporting data over remote networks

B.

using the sql_mode=STRICT_SECURE after connections are established for encrypted communications

C.

setting --skip-networking when remote connections are not required

D.

setting specific GRANT privileges to limit remote authentication

E.

setting --mysql_secure_configuration to enable paranoid mode

Consider:

What does the range value in the type column mean?

A.

You can use an index and return rows that fall within a range of values.

B.

The table will be scanned over a certain range of values.

C.

This type of index uses the range hash.

D.

There is a range of indexes that can be used.