[Jan 15, 2022] 1z1-908 certification guide Q&A from Training Expert CertkingdomPDF
1z1-908 Certification Overview Latest 1z1-908 PDF Dumps
NEW QUESTION 18
Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?
- A. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.
- B. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.
- C. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.
- D. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
Answer: D
NEW QUESTION 19
Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.
Which command will do this?
- A. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
- B. mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql
- C. mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql
- D. mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql
Answer: C
NEW QUESTION 20
Which step or set of steps can be used to rotate the error log?
- A. Execute SET GLOBAL log_error = '<new error log file>'.
- B. Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.
- C. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
- D. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.
Answer: D
NEW QUESTION 21
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It supports only non-blob datatypes.
- B. It decrypts data for use in memory.
- C. It enforces encryption from disk to memory and over network transmission.
- D. It supports all indexes transparently.
- E. It does not support the transportable tablespaces feature.
Answer: B,D
NEW QUESTION 22
Which three are characteristics of a newly created role? (Choose three.)
- A. It can be granted to user accounts.
- B. It can be renamed using the RENAME ROLE statement.
- C. It can be protected with a password.
- D. It can be dropped using the DROP ROLE statement.
- E. It is created as a locked account.
- F. It is stored in the mysql.role table.
Answer: A,C,D
NEW QUESTION 23
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 --datebase=mydb1 --database=mydb2 | mysql
- C. mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql
- D. mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql
Answer: A
NEW QUESTION 24
You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?
- A. It returns an error because the mysqldump command should have been used.
- B. It creates a logical backup of all MySQL user accounts.
- C. It creates a logical backup of only the users database.
- D. It creates a logical backup of all metadata, but contains no table data.
Answer: D
NEW QUESTION 25
Examine this command and output:
Which two options will improve the security of the MySQL instance? (Choose two.)
- A. Remove the world read/execute privilege from the accounting directory.
- B. Change the group ownership of the mysql directory to the mysql user group.
- C. Remove group read/write privileges from the private_key.pem file.
- D. Remove world read privileges from the server-cert.pem certificate file.
- E. Change the parent directory owner and group to mysql.
- F. Remove world read privileges from the public_key.pem file.
Answer: B,E
NEW QUESTION 26
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
- A. Start mysqld or mysqld_safe using different option files for each instance.
- B. Run MySQL Server docker containers.
- C. Use systemd with different settings for each instance.
- D. Use resource groups to lock different instances on separate CPUs.
- E. Run mysqld with --datadir defined for each instance.
- F. Use system tools to lock each instance to its own CPU.
Answer: A,C,E
NEW QUESTION 27
Which three actions are effective in capacity planning? (Choose three.)
- A. buying more RAM
- B. buying more CPU
- C. basing expected growth on an average of the last 3 years
- D. buying more disk
- E. adding circular replication nodes for increased DML capability
- F. monitoring OS resources for patterns
- G. consulting the application team about any future projects and use
- H. upgrading to the latest application version
Answer: C,F,G
NEW QUESTION 28
You plan to install MySQL Server by using the RPM download.
Which two statements are true? (Choose two.)
- A. You must manually initialize the data directory.
- B. The functionality is split among several RPM package files.
- C. MySQL uses the RPM relocatable installation target feature.
- D. The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.
- E. You can provide the root password interactively.
- F. You can find the root password in the error log after the first start.
Answer: D,F
NEW QUESTION 29
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 non-active binary logs are removed from the master.
- C. All details regarding deleted logs and master metadata are captured in the output file.
- D. All binary logs are deleted from the master.
- E. All databases, excluding master metadata, are backed up to the output file.
- F. All binary logs are backed up and then deleted.
Answer: D,E
NEW QUESTION 30
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
- A. primary indexes
- B. user privileges
- C. InnoDB Data Dictionary
- D. table data
- E. change buffer
- F. doublewrite buffer
Answer: C,F
NEW QUESTION 31
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. The DBA needs to execute FLUSH PRIVILEGES.
- B. John has not activated the role.
- C. John needs to reconnect to the database.
- D. The statement was blocked by MySQL Firewall.
Answer: B
NEW QUESTION 32
Examine this query and output:
Which two statements are true? (Choose two.)
- A. It takes more than 8 milliseconds to sort the rows.
- B. The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.
- C. 35 rows from the city table are included in the result.
- D. The query returns exactly 125 rows.
- E. The countrytable is accessed as the first table, and then joined to the city table.
Answer: B,C
NEW QUESTION 33
Examine these statements and output:
Which statement is true?
- A. The user is authenticated as the anonymous proxy user ‘’@’%’.
- B. The user failed to define a username and the connecting username defaulted to ‘’@’%’.
- C. The user is authorized as the accounting@localhostuser.
- D. The user is authorized as the rsmith@localhostuser.
- E. The user is logged in with --user=accountingas an option.
Answer: D
NEW QUESTION 34
Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
- A. QN = 1
- B. QN = 5
- C. QN = 3
- D. QN = 4
- E. QN = 2
Answer: A,E
NEW QUESTION 35
Examine the modified output:
Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)
- A. The master is most probably too busy to transmit data and the slave needs to wait for more data.
- 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 parallel slave threads are experiencing lock contention.
- 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 36
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. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
- B. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql
- C. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
- D. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
Answer: B
NEW QUESTION 37
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
- A. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
- 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 command can be renamed mysqlrepair so that it repairs tables by default.
Answer: D,E
NEW QUESTION 38
Examine the modified output:
Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)
- A. The master is most probably too busy to transmit data and the slave needs to wait for more data.
- 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 parallel slave threads are experiencing lock contention.
- E. The master is producing a large volume of events in parallel but the slave is processing them serially.
Answer: B,E
NEW QUESTION 39
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
- A. /etc/my.cnf
- B. /usr/bin
- C. /usr/mysql
- D. /usr
- E. /var/lib/mysql
Answer: B
NEW QUESTION 40
Examine this SQL statement:
Which set of privileges will allow Tom to execute this SQL statement?
- A. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO 'tom'@'%';
- B. GRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%'; - C. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';
- D. GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';
Answer: A
NEW QUESTION 41
......
For more info read reference:
Oracle 1Z0-908: MySQL 8.0 Database Administration
The Best Oracle 1z1-908 Study Guides and Dumps of 2022: https://www.certkingdompdf.com/1z1-908-latest-certkingdom-dumps.html