[Feb 29, 2024] New 2024 Oracle 1z1-908 Exam Dumps with PDF from Exams4sures (Updated 142 Questions) [Q41-Q64]

NO.41 Examine these commands and output:

Which connection ID is holding the metadata lock?

NO.42 Which two are true about binary logs used in asynchronous replication? (Choose two.)

NO.43 Examine the modified output:

Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)

NO.44 Which two methods allow a DBA to reset a user’s password? (Choose two.)

NO.45 Examine this command, which executes successfully:

Which two statements are true? (Choose two.)

NO.46 Examine this command and output:

Which two statements are true? (Choose two.)

NO.47 Examine these commands and output:

Which connection ID is holding the metadata lock?

NO.48 Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema() Which two statements are true? (Choose two.)

NO.49 There are five MySQL instances configured with a working group replication.
Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)

NO.50 Examine this snippet from the binary log file named binlog.000036:

The rental table was accidentally dropped, and you must recover the table.
You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.
Which command will complete the recovery?

NO.51 A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1. Confirm that secure_file_priv=’/var/tmp’
2. mysql> DROP TABLE shop.customers;
3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)

NO.52 You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTERcommand are correct.
Examine the GTID information from both master and slave:

Which statement is true?

NO.53 You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

NO.54 Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?

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

NO.56 You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of –ssl-mode will do this?

NO.57 How can mysql_multi be configured to allow MySQL instances to use the same port number?

NO.58 A colleague complains about slow response time on your website.
Examine this query and output:

What is the most likely cause for the high number of lock waits?

NO.59 You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

NO.60 You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade.
Examine the message sequence generated during the first start of MySQL 8.0.18:

Which step or set of steps will resolve the errors?

NO.61 Examine this query and its output:

Which two statements are true? (Choose two.)

NO.62 MySQL programs look for option files in standard locations.
Which method will show the option files and the order in which they are read?

NO.63 A MySQL server is monitored using MySQL Enterprise Monitor’s agentless installation.
Which three features are available with this installation method? (Choose three.)

NO.64 You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?