Exam Questions and Answers for 1Z0-908 Study Guide Questions and Answers!
MySQL 8.0 Database Administrator Certification Sample Questions and Practice Exam
Oracle 1z1-908 exam is an excellent certification exam for IT professionals who have experience in MySQL database administration. MySQL 8.0 Database Administrator certification helps individuals to validate their skills and knowledge in the field and enhance their career prospects. Candidates can prepare for the exam by acquiring hands-on experience in database administration and studying the concepts and features of MySQL 8.0. With the right preparation, candidates can pass the exam and earn the certification, which will help them stand out in the competitive job market.
NEW QUESTION # 41
Which three are types of information stored in the MySQL data dictionary? (Choose three.)
- A. server runtime configuration
- B. server configuration rollback
- C. access control lists
- D. InnoDB buffer pool LRU management data
- E. performance metrics
- F. view definitions
- G. stored procedure definitions
Answer: A,E,F
NEW QUESTION # 42
Examine this command and output:
Which two statements are true? (Choose two.)
- A. The lock is an exclusive lock.
- B. The lock is at the table object level.
- C. The lock is an intentional lock.
- D. The lock is a row-level lock.
- E. The lock is a shared lock.
- F. The lock is at the metadata object level.
Answer: A,B
NEW QUESTION # 43
Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)
- A. FILE
- B. PIPE
- C. SOCKET
- D. IPv4
- E. MEMORY
- F. DIRECT
- G. IPv6
- H. TCP
Answer: B,C,E,H
NEW QUESTION # 44
Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members
- A. SELECT email,passwd FROM members
- B. WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
(‘[email protected]’, ‘secret’);--‘;
SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘; - C. WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
(‘[email protected]’,‘secret’);--‘; - D. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
- E. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
- F. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
Answer: A,F
NEW QUESTION # 45
Examine these entries from the general query log:
All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?
- A. All statements execute without error.
- B. Connection 25 experiences a lock wait timeout.
- C. Connection 24 experiences a lock wait timeout.
- D. A deadlock occurs immediately.
- E. A deadlock occurs after innodb_lock_wait_timeout seconds.
Answer: E
NEW QUESTION # 46
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. ib_logfile0
- B. ibtmp1
- C. mysql.ibd
- D. ib_buffer_pool
- E. ibdata1
- F. undo_001
Answer: C,D
NEW QUESTION # 47
You are asked to review possible options for a new MySQL instance. It will be a large, busy reporting data warehousing instance.
[mysql]
innodb_data_file_path=
Which two configurations would satisfy long-term storage demands? (Choose two.)
- A. ibdatal:12M;/tmp/ibdata2:12M:autoextend
- B. ibdatal:12M;ibdata2:12M;ibdata3:12M
- C. ibdatal:12M:autoextend
- D. ibdatal:12M:autoextend;ibdata2:12M:autoextend
- E. ibdatal:12M
- F. ibdatal:12M;ibdata2:12M:autoextend
Answer: B,E
NEW QUESTION # 48
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. 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;
- 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. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300; - 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-10167;
Answer: B
NEW QUESTION # 49
You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database.
Which replication filter contributes to your goal?
- A. on slave: --replicate-wild-ignore=example.%
- B. on slave: --binlog-ignore-db=example
- C. on master: --replicate-ignore-db=example
- D. on master: --binlog-ignore-db=example
- E. on slave: --replicate-ignore-db=example
Answer: C
NEW QUESTION # 50
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)
- A. ADMIN OPTION causes the role to be activated by default.
- B. Mark can grant the r_read@localhost role to another user.
- C. ADMIN OPTION allows Mark to drop the role.
- D. Mark can revoke the r_read@localhost role from another role.
- E. Mark can grant the privileges assigned to the r_read@localhost role to another user.
- F. Mark must connect from localhost to activate the r_read@localhost role.
Answer: C,E
NEW QUESTION # 51
Which three sets of item information are visible in the mysql system database? (Choose three.)
- A. time zone information and definitions
- B. rollback segments
- C. help topics
- D. performance monitoring information
- E. information about table structures
- F. plugins
- G. audit log events
Answer: B,C,F
NEW QUESTION # 52
Examine this statement, which executes successfully:
You want to improve the performance of this query:
Which change enables the query to succeed while accessing fewer rows?
- A. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
- B. ALTER TABLE world.city ADD INDEX (Name);
- C. ALTER TABLE world.city ADD INDEX (Population);
- D. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
- E. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
- F. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
Answer: A
NEW QUESTION # 53
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. shared memory
- B. named pipes
- C. TCP/IP
- D. X Protocol
- E. UDP
- F. SOCKET
Answer: A,B,C
NEW QUESTION # 54
Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)
- A. NDB
- B. ARCHIVE
- C. MyISAM
- D. MEMORY
- E. InnoDB
Answer: C,D
NEW QUESTION # 55
Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)
- A. It fails if any of the roles is specified in the mandatory_roles variable.
- B. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
- C. It fails if at least one of the roles does not exist.
- D. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
- E. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
- F. Existing connections can continue to use the roles' privileges until they reconnect.
Answer: E,F
NEW QUESTION # 56
You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host
192.0.2.1:3306. You wish to connect directly to the world database.
Which four options need to be specified to complete this task with a single command? (Choose four.)
- A. --port=3306
- B. --socket=/tmp/mysql.sock
- C. --host=192.0.2.1
- D. --database=world
- E. --protocol=pipe
- F. --password
- G. --user=admin
- H. --shared-memory-base-name=world
- I. --protocol=UDP
Answer: C,E,F,H
NEW QUESTION # 57
Examine this query and output:
Which two statements are true? (Choose two.)
- A. The query returns exactly 125 rows.
- B. The country table is accessed as the first table, and then joined to the city table.
- C. The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
- D. 35 rows from the city table are included in the result.
- E. It takes more than 8 milliseconds to sort the rows.
Answer: C,D
NEW QUESTION # 58
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It decrypts data for use in memory.
- B. It enforces encryption from disk to memory and over network transmission.
- C. It supports only non-blob datatypes.
- D. It supports all indexes transparently.
- E. It does not support the transportable tablespaces feature.
Answer: A,D
NEW QUESTION # 59
Which three are characteristics of a newly created role? (Choose three.)
- A. It is created as a locked account.
- B. It can be dropped using the DROP ROLE statement.
- C. It can be renamed using the RENAME ROLE statement.
- D. It can be granted to user accounts.
- E. It can be protected with a password.
- F. It is stored in the mysql.role table.
Answer: B,D,E
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/roles.html
https://www.mysqltutorial.org/mysql-roles/
NEW QUESTION # 60
Which two are valid uses for binary logs on a MySQL instance? (Choose two.)
- A. point-in-time recovery
- B. recording the order in which queries are issued
- C. logging the duration and locks for all queries
- D. audit of all queries
- E. replication
Answer: A,B
NEW QUESTION # 61
What is the correct syntax for using transparent data encryption with an existing InnoDB table?
- A. ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;
- B. ALTER TABLE t1 ENCRYPTION='Y';
- C. ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';
- D. ALTER TABLE t1 SET TDE = 'ON';
Answer: C
NEW QUESTION # 62
You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?
- A. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql
- B. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
- C. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
- D. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
Answer: B
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html By default --all-databases won't backup ndbinfo schema this can be done via
--include-database=%https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html#mysqlpump-restrictions
NEW QUESTION # 63
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 relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;
- D. The slave needs to be restored from backup.
Answer: B
NEW QUESTION # 64
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?
- A. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- B. Replication will work.
- C. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
- D. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- E. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
Answer: A
Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643
NEW QUESTION # 65
Which two queries are examples of successful SQL injection attacks? (Choose two.)
- A. SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';
- B. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
- C. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
- D. SELECT email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
'secret');--'; - E. SELECT user,passwd FROM members
WHERE user = '?';INSERT INTO members('user','passwd') VALUES
('[email protected]','secret');--'; - F. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
Answer: D,F
NEW QUESTION # 66
......
1Z0-908 certification dumps - MySQL Database Administration 1Z0-908 guides - 100% valid: https://www.braindumpsvce.com/1Z0-908_exam-dumps-torrent.html
100% Pass Your 1Z0-908 at First Attempt with BraindumpsVCE: https://drive.google.com/open?id=1SXWMrizWH687jNyvFMPLOAHiY0ll3I-t