Latest [Nov 29, 2021] 1Z0-908 Exam with Accurate MySQL 8.0 Database Administrator PDF Questions
Take a Leap Forward in Your Career by Earning Oracle 86 Questions
Introduction to Oracle 1Z0-908: MySQL 8.0 Database Administrator Exam
Oracle 1Z0-908: MySQL 8.0 Database Administrator Administration Exam assesses the abilities of the Database Administrators and System Administrators who have at least 1 year of experience in RAC and Grid Infrastructure. The candidates should have the ability to install, manage, tracking, tuning, and restoring RAC databases, cluster, and Oracle Automatic Storage Management (ASM). They should have a good understanding of the architectures of the ASM, Clusterware, and Oracle RAC databases. They should also know how to install, setup, backup, and recovery monitoring and tuning of these components.
Oracle Real Application Clusters (RAC) in database computing is a choice for Oracle Database software developed by Oracle Corporation, it provides clustering software and high availability in Oracle database environments. With the Enterprise Version, Oracle Corporation includes RAC, provided the nodes are clustered using Oracle Clusterware. Oracle RAC allows several machines when accessing a single database, to run Oracle RDBMS software simultaneously, offering to cluster.
The Oracle Grid Infrastructure for an independent server is the Oracle software that offers system support for a database including the file system, volume management, and automation of the restart process. If you want to utilize the Oracle restart or Oracle Automatic Storage Management (ASM) services, you have to install Oracle grid infrastructure before installing Oracle Database.
NEW QUESTION 29
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 master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
- C. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- D. Replication will fail because of inconsistent numbers in 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: C
NEW QUESTION 30
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 31
Which two are true about binary logs used in asynchronous replication? (Choose two.)
- A. They contain events that describe only administrative commands run on the master.
- B. They are pulled from the master to the slave.
- C. They contain events that describe database changes on the master.
- D. They contain events that describe all queries run on the master.
- E. They are pushed from the master to the slave.
Answer: C,E
Explanation:
Explanation/Reference: https://www.oracle.com/technetwork/community/developer-day/mysql-replication-presentation-
485890.pdf (14)
NEW QUESTION 32
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 33
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)
- A. Mark can grant the r_read@localhost role to another user.
- B. Mark can revoke the r_read@localhost role from another role.
- C. Mark must connect from localhost to activate the r_read@localhost role.
- D. Mark can grant the privileges assigned to the r_read@localhost role to another user.
- E. ADMIN OPTION allows Mark to drop the role.
- F. ADMIN OPTION causes the role to be activated by default.
Answer: D,E
NEW QUESTION 34
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. UDP
- B. X Protocol
- C. shared memory
- D. SOCKET
- E. named pipes
- F. TCP/IP
Answer: C,E,F
NEW QUESTION 35
You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?
- A. Use a text editor to create a new defaults file and encrypt it from Linux prompt.
- B. Use mysql_secure_installation to encrypt stored login credentials.
- C. Use mysql_config_editor to create an encrypted file.
- D. Use the AES_ENCRYPT() MySQL function on the option file.
Answer: C
NEW QUESTION 36
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 37
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_log_file_size=1G
- B. innodb_flush_log_at_trx_commit=1
- C. sync_binlog=0
- D. innodb_undo_directory=/dev/shm
- E. max_connections=10000
- F. buffer_pool_size=24G
- G. innodb_doublewrite=0
Answer: A,B,E
NEW QUESTION 38
Which command enables rule-based MySQL Auditing capabilities?
- A. shell> mysql < audit_log_filter_linux_install.sql
- B. shell> mysqld --initialize --log-raw=audit.log
- C. mysql> INSTALL COMPONENT audit_log;
- D. mysql> INSTALL PLUGIN audit_log;
Answer: A
NEW QUESTION 39
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 40
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?
- A. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
- B. MySQL Router is configured based on the information in files in directory_path.
- C. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
- D. MySQL Router is restarted.
Answer: A
NEW QUESTION 41
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?
- A. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
- B. MySQL Router is configured based on the information in files in directory_path.
- C. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
- D. MySQL Router is restarted.
Answer: A
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter.html
NEW QUESTION 42
There are five MySQL instances configured with a working group replication.
Examine the output of the group members:
Which two statements are true about network partitioning in the cluster? (Choose two.)
- A. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
- B. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- C. The cluster will shut down to preserve data consistency.
- D. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.
- E. A manual intervention to force group members to be only the working two instances is required.
Answer: A,C
NEW QUESTION 43
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 44
You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)
- A. Create the backup by using the --set-gtid-purged=OFF option.
- B. Remove the @@GLOBAL.gtid_purged statement from the dump file.
- C. Stop all instances except the primary read/write master instance and run the restore.
- D. Remove the group replication plugin from each instance before restoring.
- E. Remove the @@GLOBAL.gtid_executed statement from the dump file.
- F. Restore using the --set-gtid-purged=OFF option.
Answer: A,B
NEW QUESTION 45
You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?
- A. binary log
- B. slow query log
- C. error log
- D. general query log
- E. audit log
Answer: A
NEW QUESTION 46
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 47
Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members
- A. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
- B. WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
(‘[email protected]’,‘secret’);--‘; - C. SELECT email,passwd FROM members
- D. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
- E. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
- F. WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
(‘[email protected]’, ‘secret’);--‘;
SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘;
Answer: C,D
NEW QUESTION 48
......
Oracle 1Z0-908: MySQL 8.0 Database Administrator Certification Path
The Oracle Certified Expert, Oracle 1Z0-908: MySQL 8.0 Database Administrator certification is for Database Development Systems Managers and Database Administrators with at least 1 year of RAC and Grid Infrastructure experience. It is also recommended to understand high availability concepts and clustering. To earn this certificate, you should have the ability to install, manage, monitor, and recover RAC databases, Clusterware, and ASM environments. You will get a complete understanding of the architecture of the Clusterware, ASM, and RAC databases while preparing for the exam with the help of 1Z0-908 practice test. After earning this certification, you will gain the skills of installing, setup, backup and recovery, tuning, and monitoring of these components.
The candidates should have to complete one of the following Certification or Training:
Oracle Database 12c Certified Professional
Oracle Database Administration 2019 Certified Professional
Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator
Oracle Database 10g Real Applications Clusters Certified Expert
Certifications:
Oracle Database 11g Certified Professional
1Z0-908 practice exams are great sources for the preparation of the exam but they do not meet the requirement of the training. To meet the requirement of the training course must be offered by Oracle University Training Center, Oracle Authorized Education Center, Oracle Authorized Partner, or Oracle Workforce Development Program. Courses can be a live virtual class, training on demand, learning subscription, or instructor-led in-class.
Authentic Best resources for 1Z0-908 Online Practice Exam: https://www.topexamcollection.com/1Z0-908-vce-collection.html
Practice To 1Z0-908 - TopExamCollection Remarkable Practice On your MySQL 8.0 Database Administrator Exam: https://drive.google.com/open?id=1mDROueBqN24PQLnGh-Ii8EvCzjZConWv
