[May-2023] MySQL Database Administration 1z1-908 Exam Practice Test Questions Dumps Bundle!
2023 Updated 1z1-908 PDF for the 1z1-908 Tests Free Updated Today!
NEW QUESTION # 51
Which two commands will display indexes on the partstable in the manufacturing schema? (Choose two.) \
- A. SHOW INDEXES FROM manufacturing.parts;
- B. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
- C. SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
AND TABLE_NAME=’parts’; - D. SELECT * FROM information_schema.COLUMN_STATISTICS;
- E. DESCRIBE manufacturing.parts;
Answer: C,D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912
NEW QUESTION # 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?
- A. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
- B. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- C. Replication will work.
- D. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
- E. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
Answer: E
Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643
NEW QUESTION # 53
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 master: --binlog-ignore-db=example
- B. on master: --replicate-ignore-db=example
- C. on slave: --replicate-wild-ignore=example.%
- D. on slave: --replicate-ignore-db=example
- E. on slave: --binlog-ignore-db=example
Answer: B
NEW QUESTION # 54
Examine this list of MySQL data directory binary logs:
binlog.000001
binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)
- A. All databases are backed up to the output file.
- B. All details regarding deleted logs and master metadata are captured in the output file.
- C. All binary logs are backed up and then deleted.
- D. All non-active binary logs are removed from the master.
- E. All databases, excluding master metadata, are backed up to the output file.
- F. All binary logs are deleted from the master.
Answer: E,F
NEW QUESTION # 55
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. --host=192.0.2.1
- B. --shared-memory-base-name=world
- C. --password
- D. --user=admin
- E. --protocol=UDP
- F. --socket=/tmp/mysql.sock
- G. --port=3306
- H. --database=world
- I. --protocol=pipe
Answer: A,B,C,I
NEW QUESTION # 56
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 allows scanning of other locations to discover more innodb tablespaces.
- B. It is not necessary because innodb_data_home_diris already defined.
- C. It adds more temporary workspace in addition to the innodb_tmpdirlocation.
- D. It moves all innodb tablespaces to the /innodb_extrasdirectory to enable a new innodb_data_home_dirto be defined.
- E. It defines all innodb tablespace options relative to a starting parent directory.
Answer: B
NEW QUESTION # 57
Which two methods allow a DBA to reset a user's password? (Choose two.)
- A. SET PASSWORD statement
- B. GRANT statement
- C. mysqladmin client program
- D. ALTER USER statement
- E. mysql_secure_installation utility
Answer: A,D
NEW QUESTION # 58
Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY 'P@ssw0rd';
GRANT r_world_rd TO john;
Examine these statements issued by user John:
What is the reason for the error?
- A. John has not activated the role.
- B. The DBA needs to execute FLUSH PRIVILEGES.
- C. John needs to reconnect to the database.
- D. The statement was blocked by MySQL Firewall.
Answer: A
NEW QUESTION # 59
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
- A. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
- B. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
- C. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
- D. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
Section: (none)
Explanation - E. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
Answer: A,D
NEW QUESTION # 60
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)
- A. Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC; - B. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - C. On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - D. Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID; - E. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on; - F. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency
Answer: C,F
NEW QUESTION # 61
Which step or set of steps can be used to rotate the error log?
- A. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
- B. Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.
- C. Execute SET GLOBAL log_error = '<new error log file>'.
- D. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.
Answer: D
NEW QUESTION # 62
You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)
- A. ibbackupfiles
- B. *.ibdfiles
- C. *.sdifiles
- D. ib_logfile*files
- E. *.CSMfiles
Answer: B,D
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/innodb-backup.html
NEW QUESTION # 63
Examine this query:
What information does this query provide?
- A. total memory used across all connections associated with the user on thread number 10
- B. total memory used by connection number 10
- C. total memory used by the first 10 connections
- D. total memory used by the first 10 threads
- E. total memory used by thread number 10
- F. total memory used across all connections associated with the user on connection number 10
Answer: B
NEW QUESTION # 64
Which two statements are true about the mysql_config_editor program? (Choose two.)
- A. It manages the configuration of the MySQL Firewall feature.
- B. It can move datadir to a new location.
- C. It manages the configuration of client programs.
- D. It manages the configuration of user privileges for accessing the server.
- E. It can be used to create and edit SSL certificates and log locations.
- F. It will use [client] options by default unless you provide --login-path.
- G. It provides an interface to change my.cnf files.
Answer: C,F
NEW QUESTION # 65
Which three are types of information stored in the MySQL data dictionary? (Choose three.)
- A. server runtime configuration
- B. InnoDB buffer pool LRU management data
- C. performance metrics
- D. view definitions
- E. stored procedure definitions
- F. access control lists
- G. server configuration rollback
Answer: A,C,D
NEW QUESTION # 66
......
Fully Updated Dumps PDF - Latest 1z1-908 Exam Questions and Answers: https://www.practicematerial.com/1z1-908-exam-materials.html
100% Free 1z1-908 Exam Dumps to Pass Exam Easily: https://drive.google.com/open?id=1Xh3hYJxVcarNQTXLQeT0obO7aFWIVlpS
