Oracle 1z0-888 Exam Questions Free Practice Test

Viewing page 2 out of 4 pages

Viewing questions 11-20 out of questions

Questions # 11:

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

Options:

will lock all storage engines for duration of backup

can back up a remote database server

allow a consistent backup to be taken

are able to back up specific items within a database

create automatically compressed backups

are always faster to restore than binary backups

Expert Solution

Questions # 12:

What two statements are true regarding FLUSH TABLES FOR EXPORT? (Choose two.)

Options:

It can be used to export TEMPORARY tables.

Table only exports when the table has its own tablespace.

The InnoDB Storage engine must be used for the table being exported.

It is the safest way to extract tables from the shared tablespace.

Partitioned tables are not supported.

Expert Solution

Questions # 13:

You are using replication and the binary log files on your master server consume a lot of disk space.

Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)

Options:

Execute the PURGE BINARY LOGS NOT USED command.

Edit the .index file to remove the files you want to delete.

Ensure that none of the attached slaves are using any of the binary logs you want to delete.

Remove all of the binary log files that have a modification date earlier than today.

Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.

Expert Solution

Questions # 14:

After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

Question # 14

What are the two most likely reasons for the slowness given this output? (Choose two.)

Options:

Date should be a TIMESTAMP field for better performance.

The User field is too long for most names.

The engine type is not appropriate to the application use.

Using default values for DATETIME causes table scans.

No indexes are defined.

Expert Solution

Questions # 15:

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?

Options:

max_connections requires the GLOBAL scope.

Its current user does not have the SUPER privilege.

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

Users can control only the max_user_connections variable.

Expert Solution

Questions # 16:

Consider the CHECK TABLE command.

In which two situations should this command be used? (Choose two.)

Options:

to find out why a query takes a long time to execute on a given table

to make sure a table has no structural problems

to improve performance by updating index distributing statistics on InnoDB tables

to repair table structure problem

to make sure that no table indexes are corrupted

Expert Solution

Questions # 17:

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a .mylogin.cnf file.

Which two are true about the login path feature? (Choose two.)

Options:

mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.

A .mylogin.cnf file can store at most one login path.

It provides a FIPS-compliant keyring for storing MySQL login details.

A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.

It is an alternative to storing the MySQL login details in a my.cnf file.

It provides means to help avoid accidentally exposing the MySQL login details.

Expert Solution

Questions # 18:

SQL injection is a common security threat.

Which two methods would help protect against this risk?

Options:

using stored procedures to validate values that are input

using SQL variables to secure input values

using prepared statements to handle unsecured values

installing the SQL Protection plugin to catch such attempts

starting the server with the –-injection-protection command-line option.

Expert Solution

Questions # 19:

Which three allocate memory per thread in MySQL? (Choose three.)

Options:

query cache

thread cache

read buffer

internal temporary table

sort buffer

InnoDB buffer pool instance

Expert Solution

Questions # 20:

The ‘applicationdb’ is using InnoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.

You investigate and gather this information:

Question # 20

Three tables are stored in the InnoDB shared tablespace and the details are as follows:

The table data_current has 1,000,000 rows.

The table data_reports has 1,500,000 rows.

The table data_archive has 4,500,000 rows.

Question # 20

You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storing it on your backup partition.

Question # 20

Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.

Which set of actions will allow you to free disk space back to the file system?

Options:

Enable compression on the table, causing InnoDB to release unused pages on disk to the file system:

1z0-888 Question 20 Option 1

Execute OPTIMIZE TABLE so that the InnoDB engine frees unused pages on disk back to the file system:

Set the server to use its own tablespace, and then alter the table so that data is moved from the shared tablespace to its own:

Take a backup, stop the server, remove the data files, and restore the backup:

Expert Solution

Viewing page 2 out of 4 pages

Viewing questions 11-20 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