Prepare 1z1-908 Question Answers - 1z1-908 Exam Dumps [Q23-Q39]

Prepare 1z1-908 Question Answers - 1z1-908 Exam Dumps

Real Oracle 1z1-908 Exam Questions [Updated 2023]

The Oracle 1z1-908 exam consists of 80 multiple-choice questions that need to be answered in 150 minutes. The questions are designed to test the candidate's knowledge of MySQL architecture, server configuration, backup and recovery, security, monitoring and tuning, and troubleshooting. 1z1-908 exam is available in English and Japanese.

If you are interested in becoming a MySQL database administrator, the Oracle 1Z0-908 Exam is an excellent certification to pursue. Passing the exam demonstrates your skills and knowledge in MySQL 8.0 database administration, and it can open up new career opportunities for you. With the rise in demand for MySQL database administrators, there has never been a better time to pursue this certification.

Oracle 1Z0-908, also known as the MySQL 8.0 Database Administrator exam, is a certification test geared towards individuals looking to demonstrate their expertise in administering MySQL databases. 1z1-908 exam specifically tests candidates on their knowledge of MySQL architecture, installation, configuration, maintenance, and security.

NEW QUESTION # 23
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. ibtmp1
B. mysql.ibd
C. undo_001
D. ibdata1
E. ib_logfile0
F. ib_buffer_pool

Answer: B,F

NEW QUESTION # 24
Examine this query and output:

Which two statements are true? (Choose two.)

A. 35 rows from the city table are included in the result.
B. The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
C. It takes more than 8 milliseconds to sort the rows.
D. The query returns exactly 125 rows.
E. The country table is accessed as the first table, and then joined to the city table.

Answer: A,B

NEW QUESTION # 25
t is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN;
SELECT * FROM t FOR UPDATE;
Which is true?

A. If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.
B. If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.
C. mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.
D. If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.

Answer: B

NEW QUESTION # 26
The mysqld instance has the connection control plugin enabled with these settings:
connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000 The minimum and maximum delays need to be increased to 3000 and 5000, respectively.
A command is executed:
mysql> SET GLOBAL connection_control_min_connection_delay=3000;
What is the result?

A. Only the minimum connection value is increased to 3000.
B. The minimum value increases to 3000 and the maximum value increases to 4000.
C. The minimum connection value is changed to 2000.
D. An error is returned.

Answer: A

NEW QUESTION # 27
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?

A. Execute: mysqlcheck --repair mysql columns_priv event proc proxies_priv tables_priv.
B. Execute: mysqlcheck --check-upgrade mysql columns_priv event proc proxies_priv tables_priv.
C. Go to the <datadir>/mysql directory and execute: myisamchk --update-state columns_priv event proc proxies_priv tables_priv.
D. Start mysqld again using the --upgrade=FORCE option.
E. Remove the redo logs. Replace the MySQL binaries with the 5.7.28 binaries. Prepare the tables for upgrade. Upgrade to 8.0.18 again.

Answer: D

NEW QUESTION # 28
Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.
Which command will do this?

A. mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql
B. mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql
C. mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql
D. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql

Answer: A

NEW QUESTION # 29
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)

A. X Protocol
B. named pipes
C. TCP/IP
D. SOCKET
E. shared memory
F. UDP

Answer: B,C,E

NEW QUESTION # 30
Examine this command and output:

Which two statements are true? (Choose two.)

A. The lock is at the metadata object level.
B. The lock is a row-level lock.
C. The lock is at the table object level.
D. The lock is an exclusive lock.
E. The lock is a shared lock.
F. The lock is an intentional lock.

Answer: C,D

NEW QUESTION # 31
What does the binlog dump thread do?

A. It acquires a lock on the binary log for reading each event to be sent to the slave.
B. It reads the relay log and executes the events contained in them.
C. It connects to the master and asks it to send updates recorded in its binary logs.
D. It monitors and schedules the rotation/deletion of the binary logs.

Answer: C

NEW QUESTION # 32
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?

A. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
B. RESET MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
C. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
D. RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
E. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;

Answer: B

NEW QUESTION # 33
Examine this statement and output:

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

A. QN = 3
B. QN = 1
C. QN = 4
D. QN = 2
E. QN = 5

Answer: B,D

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

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

Answer: A,B,F

Explanation:
Explanation/Reference:

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

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

Answer: B

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

NEW QUESTION # 36
Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)

A. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
B. It fails if any of the roles is specified in the mandatory_roles variable.
C. Existing connections can continue to use the roles' privileges until they reconnect.
D. It fails if at least one of the roles does not exist.
E. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
F. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.

Answer: C,E

NEW QUESTION # 37
A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)

A. network-related information and network characteristics
B. security-related advisor warnings
C. CPU utilization
D. operating system memory utilization
E. disk usage and disk characteristics including disk advisors warnings
F. MySQL Replication monitoring
G. MySQL Query Analysis data

Answer: B,E,G

NEW QUESTION # 38
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?