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: 2 / 4
Total 124 questions

You are asked to examine user accounts and find:

Which two statements will best secure this environment? (Choose two.)

A.

DROP USER ‘’@’localhost’;

B.

ALTER USER ‘’@’localhost’ PASSWORD = ‘secret_password’;

C.

ALTER USER bob@’%’ IDENTIFIED BY ‘secret_password’;

D.

ALTER USER ‘root’@’localhost’ ACCOUNT LOCK;

E.

ALTER USER bob PASSWORD = ‘secret_password’;

F.

REVOKE ALL PRIVILEGES FROM ‘’@’localhost’;

Consider:

Which statement best describes the meaning of the value for the key_len column?

A.

It shows how many bytes will be used from each index row.

B.

It shows the number of characters indexed in the key.

C.

It shows the total size of the index row.

D.

It shows how many columns in the index are examined.

You want to immediately stop access to a database server for remote user ‘mike’@’client.example.com’. This user is currently not connected to the server.

Which two actions can you take to stop any access from the user?

A.

Use ALTER USER ‘mike’@’client.example.com’ PASSWORD EXPIRE;

B.

Use REVOKE ALL PRIVILEGES FROM ‘mike’@’client.example.com’;

C.

Execute the mysql_secure_installation command.

D.

Use DROP USER ‘mike’@’client.example.com’;

E.

Use GRANT USAGE ON *.* TO ‘mike’@’client.example.com’ MAX_USER_CONNECTIONS=0;

F.

Use ALTER USER ‘mike’@’client.example.com’ ACCOUNT LOCK;

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

The Performance Schema includes these tables related to status variables:

Which two facts are true about these tables? (Choose two.)

A.

The variable values in global_status are the sum of those in status_by_thread grouped by the variable name.

B.

All these tables have the same number of rows.

C.

The global_status table is equivalent to the SHOW GLOBAL STATUS statement.

D.

The variable values in status_by_account are the sum of those in status_by_host and status_by_user grouped by the variable name.

E.

The session_status table is equivalent to status_by_thread for the current thread.

Which two options describe how MySQL Server allocates memory? (Choose two.)

A.

Each connection may have its own per-thread memory allocations.

B.

Thread memory is pre-allocated up to thread_cache_size for performance.

C.

Each thread allocates memory from a global pool.

D.

Global memory resources are allocated at server startup.

One of your colleagues is trying to make a change using the mysql command-line client for his or her application session.

The colleague instant messages you this command:

mysql> SET SESSION max_connections = 200;

Why does the command fail?

A.

max_connections requires the GLOBAL scope.

B.

Its current user does not have the SUPER privilege.

C.

max_connections is not a dynamic variable. You need to change the config file and restart the database.

D.

Users can control only the max_user_connections variable.

Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:

Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

A.

The log_bin variable is set to OFF on the slave.

B.

server_id is not unique.

C.

The max_connections variable on the slave needs to be increased.

D.

The shared_memory_base_name variable must match the master.

E.

The version of the slave is newer that the version of the master.

Which storage option for MySQL data directory typically offers the worst performance in a highly concurrent, OLTP-heavy, IO-bound workload?

A.

battery-backed locally-attached RAID 5 array

B.

iSCSI Lun

C.

SAN (Fibre Channel) Lun

D.

NFS (Networked File System) mount

Which are three facts about backups with mysqldump? (Choose three.)

A.

will lock all storage engines for duration of backup

B.

can back up a remote database server

C.

allow a consistent backup to be taken

D.

are able to back up specific items within a database

E.

create automatically compressed backups

F.

are always faster to restore than binary backups