[2024] Pass 1Z0-908 Exam - Real Questions and Answers

1Z0-908 Exam Questions Get Updated [2024] with Correct Answers

Oracle 1z1-908: MySQL 8.0 Database Administrator exam is an important certification for any database administrator working with MySQL. Passing 1Z0-908 exam demonstrates a high level of skill and knowledge, and opens up new opportunities for career advancement and professional growth.

 

NEW QUESTION # 74
Examine these statements and output:

Which statement is true?

• A. The user is authenticated as the anonymous proxy user ‘’@’%’.
• B. The user is authorized as the rsmith@localhostuser.
• C. The user is logged in with --user=accountingas an option.
• D. The user is authorized as the accounting@localhostuser.
• E. The user failed to define a username and the connecting username defaulted to ‘’@’%’.

Answer: B

NEW QUESTION # 75
You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?

• A. audit log
• B. error log
• C. slow query log
• D. general query log
• E. binary log

Answer: E

NEW QUESTION # 76
Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema() Which two statements are true? (Choose two.)

• A. The command drops the mysql_innodb_cluster_metadata schema and re-creates it.
• B. Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.
• C. The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.
• D. Group Replication will be dissolved and all metadata purged.
• E. Connections driven by MySQL Router are not affected by the command.
• F. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.

Answer: E,F

NEW QUESTION # 77
Which three are characteristics of a newly created role? (Choose three.)

• A. It can be protected with a password.
• B. It is created as a locked account.
• C. It is stored in the mysql.role table.
• D. It can be granted to user accounts.
• E. It can be dropped using the DROP ROLE statement.
• F. It can be renamed using the RENAME ROLE statement.

Answer: A,D,E

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

NEW QUESTION # 78
You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO 'user1';
How can you proceed with your transaction with the least interruption?

• A. Change the default database and re-execute the failed statement in your transaction.
• B. Re-execute the failed statement in your transaction.
• C. Close the connection, reconnect, and start the transaction again.
• D. Roll back the transaction and start the transaction again in the same session.

Answer: B

NEW QUESTION # 79
Which statement is true about displaying and retrieving data with MySQL Enterprise Monitor Query Analyzer?

• A. It is possible to filter a Query Analyzer view graph by database and by table.
• B. It is possible to export statements included in a graph selection in CSV format.
• C. The Query Analyzer graph view range selector can extend to cover the same hour over multiple days.
• D. The Query Analyzer can plot a CPU utilization graph for remote hosts with a MySQL Enterprise Service Manager's built-in Agent installation.

Answer: B

NEW QUESTION # 80
You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?

• A. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
• B. It defines all innodb tablespace options relative to a starting parent directory.
• C. It adds more temporary workspace in addition to the innodb_tmpdir location.
• D. It is not necessary because innodb_data_home_dir is already defined.
• E. It allows scanning of other locations to discover more innodb tablespaces.

Answer: E

Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html

NEW QUESTION # 81
Which command enables rule-based MySQL Auditing capabilities?

• A. shell> mysqld --initialize --log-raw=audit.log
• B. mysql> INSTALL COMPONENT audit_log;
• C. mysql> INSTALL PLUGIN audit_log;
• D. shell> mysql < audit_log_filter_linux_install.sql

Answer: D

Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/audit-log-filtering.html

NEW QUESTION # 82
Which two MySQL Server accounts are locked by default? (Choose two.)

• A. any user created with a username, but missing the host name
• B. any internal system accounts
• C. any user created without a password
• D. any user set as DEFINER for stored programs
• E. any new ROLE accounts

Answer: B,D

NEW QUESTION # 83
How can mysql_multi be configured to allow MySQL instances to use the same port number?

• A. The instances use different user accounts unique to each instance.
• B. The instances listen on different IP addresses.
• C. The instances have appropriate net masks set.
• D. The instances use different socket names.

Answer: B

NEW QUESTION # 84
Your MySQL environment has asynchronous position based-replication with one master and one slave.
The slave instance had a disk I/O problem, so it was stopped.
You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.
You restart MySQL Server.
How can replication be restored?

• A. The slave relay logs should be deleted; then execute START SLAVE;
• B. The relay logs from the master should be used to replace the corrupted relay logs.
• C. The slave needs to be restored from backup.
• D. The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

Answer: B

NEW QUESTION # 85
User account baduser@hostname on your MySQL instance has been compromised.
Which two commands stop any new connections using the compromised account? (Choose two.)

• A. ALTER USER baduser@hostname DEFAULT ROLE NONE;
• B. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
• C. ALTER USER baduser@hostname ACCOUNT LOCK;
• D. ALTER USER baduser@hostname PASSWORD DISABLED;
• E. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;

Answer: B,C

NEW QUESTION # 86
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

• A. table data
• B. change buffer
• C. doublewrite buffer
• D. InnoDB Data Dictionary
• E. primary indexes
• F. user privileges

Answer: C,D

Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/innodb-system-tablespace.html

NEW QUESTION # 87
Examine these commands and output:

Which connection ID is holding the metadata lock?

• A. 0
• B. 1
• C. 2
• D. 3
• E. 4
• F. 5

Answer: A

NEW QUESTION # 88
You recently upgraded your MySQL installation to MySQL 8.0.
Examine this client error:

Which option will allow this client to connect to MySQL Server?

• A. ALTER USER user -
  IDENTIFIED WITH caching_sha2_password
  BY 'password';
• B. ALTER USER user -
  IDENTIFIED WITH mysql_native_password
  BY 'password';
• C. ALTER USER user -
  IDENTIFIED WITH sha256_password -
  BY 'password';
• D. [mysqld]
  default_authentication_plugin=mysql_native_password
• E. [mysqld]
  default_authentication_plugin=sha256_password
• F. [mysqld]
  default_authentication_plugin=caching_sha2_password

Answer: C

NEW QUESTION # 89
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.)

• A. mysql.ibd
• B. undo_001
• C. ib_buffer_pool
• D. ib_logfile0
• E. ibtmp1
• F. ibdata1

Answer: A,C

NEW QUESTION # 90
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.)

• A. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.
• B. The cluster has built-in high availability and updates group_replication_ip_whitelistto remove the unreachable nodes.
• C. The cluster will shut down to preserve data consistency.
• D. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
• E. A manual intervention to force group members to be only the working two instances is required.

Answer: B,C

NEW QUESTION # 91
......

Practice 1Z0-908 Questions With Certification guide Q&A from Training Expert TestSimulate: https://www.testsimulate.com/1Z0-908-study-materials.html