Pass4itsure > Oracle > Oracle Certifications > 1Z0-888 > 1Z0-888 Online Practice Questions and Answers

1Z0-888 Online Practice Questions and Answers

Questions 4

Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space. What will happen when this occurs?

A. The server will crash.

B. The server suspends that INSERT operation until space becomes available.

C. An error message will be returned to the client .Server Error: ER_IO

D. The server suspends operations for all storage engines until space becomes available.

Buy Now
Questions 5

A MySQL database uses all InnoDB tables and is configured as follows; You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.

Which two arguments will you pass to mysqldump to achieve this? (Choose two.)

A. --skip-opt

B. --lock-all-tables

C. --create-apply-log

D. --single-transaction

E. --master-data

Buy Now
Questions 6

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.

Buy Now
Questions 7

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

Buy Now
Questions 8

Consider:

Which statement best describes the meaning of the values in the ref columns?

A. world.City.CountryCode is used as the primary key for the Country table.

B. No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.

C. world.City.CountryCode is used to sort the rows in the City table.

D. No indexed columns are used to select rows from the Country table. The world.City.CountryCode column is used to select rows in the City table.

Buy Now
Questions 9

An employee cannot access the company database. You check the connection variables:

A look at the user privileges shows: What is a valid explanation for why one of the users is unable to connect to the database?

A. Bob has max_user_connections set to zero, which blocks all his connections.

B. All users are blocked because max_user_connections is accumulated over the host account information.

C. connect_timeout is too small to allow a connection to occur.

D. Joe has exceeded the max_user_connections global limit.

E. Kay is already connected elsewhere and attempting to log in again.

Buy Now
Questions 10

The InnoDB tablespace is corrupted and you start the server with option --innodb_force_recover=4. Which backup method would you use to reload the corrupted InnoDB tables?

A. a binary backup that uses transportable tablespaces and allows you to reload a corrupted table

B. A text backup. A binary backup will still contain the corrupted segments.

C. A text backup. InnoDB does not allow you to make binary backups while the server is running.

D. a binary backup taken with MySQL Enterprise Backup that can back up even corrupted tables

Buy Now
Questions 11

At which stage during query processing does MySQL create a query's execution plan?

A. Optimizing

B. Parsing

C. Executing

D. Authorizing

Buy Now
Questions 12

You are installing MySQL Server 5.7 from a tarball package. You have already set up the correct PATH environment variable and configured your /etc/my.cnf file.

Which command will correctly prepare a data directory?

A. service mysqld prepare-init

B. mysqld_safe --initialize ...

C. mysql -u root -p < support-files/mysqldb.sql

D. mysqld_safe --user=mysql

E. mysqld --initialize ...

Buy Now
Questions 13

A general purpose MySQL instance is configured with the following options:

--slow-query-log --long-query-time=.0001 --log-queries-not-using-indexes --log-slow-admin-queries --general-log --log-bin --binlog-format=STATEMENT --innodb-flush-log-at-trx-commit=1

Which three statements are true for most workloads? (Choose three.)

A. The Slow Query Log records more data than the General Query Log.

B. The General Query Log records more data than the Slow Query Log.

C. The Slow Query Log records more data than the Binary Log.

D. The Binary Log records more data than the General Query Log.

E. The Binary Log records more data than the Slow Query Log.

F. The General Query Log records more data than the Binary Log.

Buy Now
Exam Code: 1Z0-888
Exam Name: MySQL 5.7 Database Administrator
Last Update: Jan 18, 2025
Questions: 155
10%OFF Coupon Code: SAVE10

PDF (Q&A)

$49.99

VCE

$55.99

PDF + VCE

$65.99