[Nov-2023] 1Z0-908 Exam Dumps, 1Z0-908 Practice Test Questions [Q25-Q41]

Rate this post

[Nov-2023] 1Z0-908 Exam Dumps, 1Z0-908 Practice Test Questions

Attested 1Z0-908 Dumps PDF Resource [2023]

Oracle 1Z0-908: MySQL 8.0 Database Administrator exam is an essential certification for database administrators who want to demonstrate their expertise in managing and administering MySQL databases. It is a valuable certification that can help individuals advance their careers in the field of database administration. 1Z0-908 exam covers a wide range of topics related to MySQL database administration and is based on the latest version of MySQL.

Oracle 1Z0-908 certification exam is recognized worldwide and is highly valued by employers. MySQL 8.0 Database Administrator certification is proof of your proficiency in MySQL database administration and will help you stand out from other candidates when applying for jobs. 1Z0-908 exam is also a great way to validate your skills and knowledge in MySQL database administration and gain more confidence in your abilities.

NO.25 Examine this command, which executes successfully:
shell> mysqldump –master-data=2 –single-transaction –result-file=dump.sql mydb Which two statements are true? (Choose two.)

It executes flush tables with read lock.

It enforces consistent backups for all storage engines.

The backup created is a consistent data dump.

This option uses the READ COMMITTED transaction isolation mode.

It is a cold backup.

NO.26 You have an installation of MySQL 8 on Oracle Linux.
Consider the outputs:

Which statement is true about disk temporary tables for this installation?

Only internal temporary tables from the optimizer will be created in tmpdir.

Temporary tables will use the InnoDB temporary tablespace located in datadir.

Temporary tables are created in tmpdir only if configured to use MyISAM.

Temporary tables are created in tmpdir only after they reach tmp_tabie_size.

Temporary tables will use the InnoDB temporary tablespace located in /tmp.

NO.27 You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

MySQL writes SDI to the binary log for distributed backups.

MySQL keeps InnoDB metadata changes in .sdi files in datadir.

The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).

MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.

MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

NO.28 Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:

Which statement is true?

Each slave thread is responsible for updating a specific database.

Cross-database constraints can cause database inconsistency.

Increasing slave_parallel_workers will improve high availability.

Setting slave_preserve_commit_order to on will improve data consistency.

Setting slave_parallel_type=DATABASE won’t work for circular replication; it should be set to LOGICAL_CLOCK.

Setting transaction_allow_batching to on will improve data consistency.

NO.29 Which statement is true about cold backups?

They are backups taken from snapshots of a running database.

They are backups taken from OS copy commands.

They are good to use if only data structures must be backed up but not log files.

They are good to use when many users are online accessing the database.

NO.30 Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

QN = 3

QN = 5

QN = 1

QN = 4

QN = 2

NO.31 A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)

ibtmp1

undo_001

ib_buffer_pool

ibdata1

mysql.ibd

ib_logfile0

NO.32 You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your data. Examine your backup requirement:
* The MySQL system being backed up can never be unavailable or locked to the client applications.
* The recovery from the backup must work on any system.
* Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?

Take a physical backup of the MySQL system.

Use the Clone Plugin to copy the data to another MySQL system.

Take a logical backup of the MySQL system.

Take your backup from a slave of the MySQL system.

NO.33 Examine this command, which executes successfully:
mysqlpump -–user=root –password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)

information_schema

world

employee

sys

mysql

Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/

NO.34 Which four connection methods can MySQL clients specify with the –protocol option when connecting to a MySQL server? (Choose four.)

TCP

SOCKET

PIPE

DIRECT

IPv6

FILE

IPv4

MEMORY

NO.35 You want to dump all databases with names that start with “db”.
Which command will achieve this?

mysqlpump –include-tables=db.% –result-file=all_db_backup.sql

mysqlpump > all_db_backup.sql

mysqlpump –include-databases=db –result-file=all_db_backup.sql

mysqlpump –include-databases=db% –result-file=all_db_backup.sql

NO.36 Examine these commands and output:

Which connection ID is holding the metadata lock?

NO.37 Which three are characteristics of a newly created role? (Choose three.)

It can be dropped using the DROP ROLE statement.

It is stored in the mysql.role table.

It is created as a locked account.

It can be renamed using the RENAME ROLE statement.

It can be granted to user accounts.

It can be protected with a password.

NO.38 Which three are characteristics of a newly created role? (Choose three.)

It can be dropped using the DROP ROLE statement.

It is stored in the mysql.role table.

It is created as a locked account.

It can be renamed using the RENAME ROLE statement.

It can be granted to user accounts.

It can be protected with a password.

Explanation
https://dev.mysql.com/doc/refman/8.0/en/roles.html
https://www.mysqltutorial.org/mysql-roles/

NO.39 Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

GRANT ALL PRIVILEGES ON ‘world’.’city’ TO ‘tom’@’%’;
GRANT SELECT (‘code’) ON ‘world’.’country’ TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.* TO ‘tom’@’%’;
GRANT ALL PRIVILEGES ON ‘world’.’country’ TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.’city’ TO ‘tom’@’%’; GRANT SELECT ON ‘world’.* TO ‘tom’@’%’;

GRANT UPDATE ON ‘world’.’city’ TO ‘tom’@’%’; GRANT SELECT ON ‘world’.’country’ TO
‘tom’@’%’;

NO.40 Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)

MyISAM

NDB

MEMORY

Leave a Reply Cancel reply