A fully updated 2023 1Z0-908 Exam Dumps exam guide from training expert PassReview
Provides complete coverage of every objective on exam and exam preparation 1Z0-908
Oracle 1Z0-908 certification exam is a challenging exam that requires candidates to have a thorough understanding of MySQL database concepts, as well as hands-on experience with MySQL 8.0. 1Z0-908 exam consists of 80 multiple-choice questions that must be completed within a time frame of 150 minutes. The passing score for the exam is 66%, and candidates who pass the exam are awarded the Oracle Certified Professional, MySQL 8.0 Database Administrator certification.
Oracle 1Z0-908 exam is incredibly challenging, with a passing score of 63% required. Successful completion of the exam grants you the title of Oracle Certified Professional, MySQL 8.0 Database Administrator. In preparing for the exam, candidates are encouraged to familiarize themselves with the MySQL 8.0 documentation and practice using the MySQL shell, running MySQL commands, and configuring MySQL settings.
NEW QUESTION # 50
Examine this query and output:
Which two statements are true? (Choose two.)
- A. The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.
- B. The countrytable is accessed as the first table, and then joined to the city table.
- C. 35 rows from the city table are included in the result.
- D. The query returns exactly 125 rows.
- E. It takes more than 8 milliseconds to sort the rows.
Answer: A,C
NEW QUESTION # 51
Examine the modified output:
Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)
- A. The parallel slave threads are experiencing lock contention.
- B. This value shows only I/O latency and is not indicative of the size of the transaction queue.
- C. One or more large tables do not have primary keys.
- D. The master is most probably too busy to transmit data and the slave needs to wait for more data.
- E. The master is producing a large volume of events in parallel but the slave is processing them serially.
Answer: B,E
Explanation:
Explanation
NEW QUESTION # 52
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:
Which statement is true?
- A. Replication will work.
- B. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- C. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- D. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
- E. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
Answer: B
NEW QUESTION # 53
Examine this statement, which executes successfully:
Now examine this query:
Which two statements can do this? (Choose two.)
- A. ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL, ADD INDEX (birth_month); - B. ALTER TABLE employees -
ADD INDEX (birth_date DESC); - C. ALTER TABLE employees -
ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned))); - D. ALTER TABLE employees -
ADD INDEX ((MONTH(birth_date))); - E. ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month); - F. ALTER TABLE employees -
ADD INDEX (birth_date);
Answer: A,B
NEW QUESTION # 54
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: C
NEW QUESTION # 55
Which two methods allow a DBA to reset a user's password? (Choose two.)
- A. SET PASSWORD statement
- B. mysqladmin client program
- C. GRANT statement
- D. ALTER USER statement
- E. mysql_secure_installation utility
Answer: A,D
NEW QUESTION # 56
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
- A. /var/lib/mysql
- B. /usr/bin
- C. /usr/mysql
- D. /usr
- E. /etc/my.cnf
Answer: B
NEW QUESTION # 57
The data in this instance is transient; no backup or replication will be required. It is currently under performing.
* The database size is static and including indexes is 19G.
* Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:
The OS metrics indicate that disk is a bottleneck. Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)
- A. innodb_flush_log_at_trx_commit=1
- B. innodb_undo_directory=/dev/shm
- C. buffer_pool_size=24G
- D. innodb_doublewrite=0
- E. max_connections=10000
- F. innodb_log_file_size=1G
- G. sync_binlog=0
Answer: A,E,F
NEW QUESTION # 58
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 IDENTIFIED WITH mysql_no_login;
- B. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
- C. ALTER USER baduser@hostname DEFAULT ROLE NONE;
- D. ALTER USER baduser@hostname ACCOUNT LOCK;
- E. ALTER USER baduser@hostname PASSWORD DISABLED;
Answer: A,D
NEW QUESTION # 59
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It enforces encryption from disk to memory and over network transmission.
- B. It supports only non-blob datatypes.
- C. It does not support the transportable tablespaces feature.
- D. It decrypts data for use in memory.
- E. It supports all indexes transparently.
Answer: D,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/faqs-tablespace-encryption.html
NEW QUESTION # 60
Which command enables rule-based MySQL Auditing capabilities?
- A. mysql> INSTALL PLUGIN audit_log;
- B. shell> mysql < audit_log_filter_linux_install.sql
- C. mysql> INSTALL COMPONENT audit_log;
- D. shell> mysqld --initialize --log-raw=audit.log
Answer: B
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/audit-log-filtering.html
NEW QUESTION # 61
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)
- A. ADMIN OPTION allows Mark to drop the role.
- B. Mark can grant the r_read@localhost role to another user.
- C. Mark can revoke the r_read@localhost role from another role.
- D. Mark can grant the privileges assigned to the r_read@localhost role to another user.
- E. ADMIN OPTION causes the role to be activated by default.
- F. Mark must connect from localhost to activate the r_read@localhost role.
Answer: A,D
NEW QUESTION # 62
Which two queries are examples of successful SQL injection attacks? (Choose two.)
- A. SELECT email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
'secret');--'; - B. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
- C. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
- D. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
- E. SELECT user,passwd FROM members
WHERE user = '?';INSERT INTO members('user','passwd') VALUES
('[email protected]','secret');--'; - F. SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';
Answer: A,B
NEW QUESTION # 63
Which three requirements must be enabled for group replication? (Choose three.)
- A. primary key or primary key equivalent on every table
- B. binary log checksum
- C. binary log MIXED format
- D. binary log ROW format
- E. semi-sync replication plugin
- F. slave updates logging
- G. replication filters
Answer: A,C,E
NEW QUESTION # 64
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. undo_001
- B. ibdata1
- C. ib_buffer_pool
- D. mysql.ibd
- E. ib_logfile0
- F. ibtmp1
Answer: C,D
NEW QUESTION # 65
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?
RESET MASTER;
- A. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
RESET MASTER; - B. bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - C. SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - D. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- - E. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
Answer: C
NEW QUESTION # 66
Examine this command and output:
Which two options will improve the security of the MySQL instance? (Choose two.)
- A. Remove world read privileges from the server-cert.pem certificate file.
- B. Remove the world read/execute privilege from the accounting directory.
- C. Change the parent directory owner and group to mysql.
- D. Remove world read privileges from the public_key.pem file.
- E. Change the group ownership of the mysql directory to the mysql user group.
- F. Remove group read/write privileges from the private_key.pem file.
Answer: C,E
NEW QUESTION # 67
Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
- A. QN = 4
- B. QN = 2
- C. QN = 5
- D. QN = 3
- E. QN = 1
Answer: B,E
NEW QUESTION # 68
MySQL programs look for option files in standard locations.
Which method will show the option files and the order in which they are read?
- A. shell> mysqld --help --verbose
- B. shell> mysqladmin --debug
- C. mysql> SHOW GLOBAL VARIABLES;
- D. shell> mysql --print-defaults
Answer: B
NEW QUESTION # 69
......
Oracle 1Z0-908 Exam measures a candidate's ability to install, configure, and maintain MySQL 8.0 databases. 1Z0-908 exam also tests the candidate's understanding of MySQL 8.0 security features, backup and recovery techniques, and performance tuning. 1Z0-908 exam has a total of 90 questions, and candidates have 150 minutes to complete them.
Tested Material Used To 1Z0-908: https://www.passreview.com/1Z0-908_exam-braindumps.html
Steps Necessary To Pass The 1Z0-908 Exam: https://drive.google.com/open?id=1r8yOonJom2NGoCiTAA5cCFxRekw6Qbby