1z0-888 Practice Exam Questions with Answers MySQL 5.7 Database Administrator Certification

--skip-opt

--lock-all-tables

--create-apply-log

--single-transaction

--master-data

allowing change of the server runtime configuration

allowing a client to shut down the server

allowing client accounts to take over the account of another user

allowing a client to kill other client connections

It stores data in .MYD files and its index and undo information in the common tablespace.

It stores data in .MYD files, index information in .MYI files, and undo information the common tablespace.

It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.

It stores its data, index and undo information in .MYD and .MYI files.

It stores data, index and undo information in tablespace file(s).

battery-backed locally-attached RAID 5 array

iSCSI Lun

SAN (Fibre Channel) Lun

NFS (Networked File System) mount

Run the create_system_tables.sql file

Run the mysql_unpack.sql file

Invoke mysqld with the --initialize option.

Invoke mysql with the --initialize option.

Set binlog_format=MIXED with the --replicate-ignore-temp-table option.

Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.

Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.

Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.

Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

enabling and using SSL for connections to the MySQL database

running the server with –-skip-networking specified

disabling connections from named pipes or socket files (depending on the operating system of the server)

starting the server with –-bind-address=0.0.0.0 specified

limiting logins to originate from the application server or the server’s subnet

installing MySQL on the application server, and running the database and application on the same server

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.

Physical backups can be used to recover from data corruption.

Logical backups are human-readable whereas physical backups are not.

Logical backups are always larger than physical backups.

Physical backups are usually slower than text backups.

Physical backups are usually faster than text backups.

Yes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.

Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.

No. The UNDO tablespaces must remain on the same file system as the system tablespaces.

No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.

Change the replication mode to MIXED before issuing any delete statements when the LIMIT clause is used.

If the data modification is non-deterministic, the query optimizer will resolve any potential issues.

Use the LIMIT clause to limit the deletion to 100,000 rows.

Use the LIMIT clause in conjunction with the ORDER BY clause.

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

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

Execute the mysql_secure_installation command.

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

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

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

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.