MySQL Database Administration 1z1-908 Practice Test Engine: Try These 86 Exam Questions
Guaranteed Success in MySQL Database Administration 1z1-908 Exam Dumps
How to book the Oracle 1Z0-908: MySQL 8.0 Database Exam
If you are looking to appear in the Oracle 1Z0-908: MySQL 8.0 Database Exam, you can do so by either redeeming a voucher that you must buy from Oracle or paying directly with a credit card. After payment, you can schedule the test via Oracle’s external testing provider, PearsonVue.
NEW QUESTION 49
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 50
Examine this command, which executes successfully:
cluster.addInstance('<user>@<host>:<port>', {recoveryMethod: 'clone'})
Which three statements are true? (Choose three.)
- A. It is always slower than {recoveryMethod: 'incremental'}.
- B. The account used to perform this recovery needs the BACKUP_ADMIN privilege.
- C. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.
- D. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.
- E. InnoDB tablespaces outside the datadir are able to be cloned.
- F. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.
Answer: A,B,F
NEW QUESTION 51
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)
- A. dba.createCluster()
- B. cluster.addInstance()
- C. cluster.setPrimaryInstance()
- D. dba.configureLocalInstance()
- E. dba.configureInstance()
- F. dba.checkInstanceConfiguration()
- G. cluster.forceQuorumUsingPartitionOf()
Answer: C,G
NEW QUESTION 52
Examine this command, which executes successfully:
shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)
- A. This option uses the READ COMMITTED transaction isolation mode.
- B. It is a cold backup.
- C. The backup created is a consistent data dump.
- D. It enforces consistent backups for all storage engines.
- E. It executes flush tables with read lock.
Answer: A,E
NEW QUESTION 53
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. *.sdifiles
- B. *.ibdfiles
- C. *.CSMfiles
- D. ib_logfile*files
- E. ibbackupfiles
Answer: B,D
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/innodb-backup.html
NEW QUESTION 54
Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=
Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?
- A. VERIFY_CA
- B. PREFERRED
- C. VERIFY_IDENTITY
- D. DISABLED
- E. REQUIRED
Answer: E
NEW QUESTION 55
Examine this command, which executes successfully:
mysqlpump -–user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)
- A. information_schema
- B. mysql
- C. employee
- D. world
- E. sys
Answer: A,E
Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/
NEW QUESTION 56
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 ROLEstatement.
- C. It can be protected with a password.
- D. It is created as a locked account.
- E. It is stored in the mysql.roletable.
- F. It can be dropped using the DROP ROLEstatement.
Answer: A,C,F
Explanation:
Explanation/Reference:
NEW QUESTION 57
You plan to take daily full backups, which include the ndbinfoand 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
Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/
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 PASSWORD DISABLED;
- E. ALTER USER baduser@hostname ACCOUNT LOCK;
Answer: A,E
NEW QUESTION 59
Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)
- A. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
- B. It fails if any of the roles is specified in the mandatory_roles variable.
- C. It fails if at least one of the roles does not exist.
- D. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
- E. Existing connections can continue to use the roles' privileges until they reconnect.
- F. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
Answer: A,E
NEW QUESTION 60
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 61
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.pemcertificate file.
- B. Remove the world read/execute privilege from the accountingdirectory.
- C. Remove world read privileges from the public_key.pemfile.
- D. Change the parent directory owner and group to mysql.
- E. Change the group ownership of the mysqldirectory to the mysqluser group.
- F. Remove group read/write privileges from the private_key.pemfile.
Answer: D,E
NEW QUESTION 62
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage()
Reconfiguring the default cluster from complete outage…
The instance ‘host1:3377'’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
The instance ‘host2:3377’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’. (RuntimeError) Which statement is true?
- A. The cluster is running and there is at least one ONLINEinstance.
- B. The instance deployed on host3must be synchronized from a donor deployed on host1by using the command cluster.addInstance(‘host1:3377’).
- C. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
- D. The active session instance is invalid and must be re-created by using the command shell.connect (‘host3:3377’).
- E. The instance deployed on host3must be rebuilt with a backup from the primary instance.
Answer: B
NEW QUESTION 63
You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?
- A. It returns an error because the mysqldumpcommand should have been used.
- B. It creates a logical backup of only the usersdatabase.
- C. It creates a logical backup of all MySQL user accounts.
- D. It creates a logical backup of all metadata, but contains no table data.
Answer: D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/mysqlpump.html
NEW QUESTION 64
......
What is the duration, language, and format of Oracle 1Z0-908: MySQL 8.0 Database Exam
- This exam is offered in only English.
- Certification Validity period: 3 years.
- Passing score:
- This exam consists of 90 questions.
- There is a time limit of 140 minutes for the exam.
- Section 1: 60%
- The type of questions is Multiple Choice Questions.
- Section 3: 33%
- Section 2: 45%
Oracle database certifications require periodic recertification. To hold your certification inactive condition, you must update to the new edition within 1 year of Oracle’s credential withdrawal.
Test Engine to Practice 1z1-908 Test Questions: https://www.passsureexam.com/1z1-908-pass4sure-exam-dumps.html
Oracle 1z1-908 Daily Practice Exam New 2021 Updated 86 Questions: https://drive.google.com/open?id=1fBPNIQvwrSA_a-yhAYVkM9KWjGA6r9Ql