Based on Official Syllabus Topics of Actual Oracle 1Z0-908 Exam
Free 1Z0-908 Dumps are Available for Instant Access
Oracle 1z1-908 certification is valuable for individuals who want to pursue a career in database administration. It demonstrates their proficiency in working with MySQL 8.0, which is a popular open-source relational database management system. MySQL 8.0 Database Administrator certification can also help individuals to enhance their skills and knowledge in database administration, which can lead to better job opportunities and higher salaries.
NEW QUESTION # 19
Which condition is true about the use of the hash join algorithm?
- A. The query must access no more than two tables.
- B. At least one of the tables in the join must have a hash index.
- C. No index can be used for the join.
- D. The smallest of the tables in the join must fit in memory as set by join_buffer_size.
Answer: A
NEW QUESTION # 20
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; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;
- B. The slave needs to be restored from backup.
- C. The relay logs from the master should be used to replace the corrupted relay logs.
- D. The slave relay logs should be deleted; then execute START SLAVE;
Answer: C
NEW QUESTION # 21
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 the AES_ENCRYPT() MySQL function on the option file.
- B. Use mysql_secure_installation to encrypt stored login credentials.
- C. Use mysql_config_editor to create an encrypted file.
- D. Use a text editor to create a new defaults file and encrypt it from Linux prompt.
Answer: C
NEW QUESTION # 22
You want to check the values of the sort_buffer_size session variables of all existing connections.
Which performance_schema table can you query?
- A. variables_by_thread
- B. session_variables
- C. user_variables_by_thread
- D. global_variables
Answer: B
NEW QUESTION # 23
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. TCP/IP
- B. SOCKET
- C. shared memory
- D. named pipes
- E. X Protocol
- F. UDP
Answer: A,C,D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/mysql-installer-workflow.html
NEW QUESTION # 24
You want to dump all databases with names that start with "db".
Which command will achieve this?
- A. mysqlpump > all_db_backup.sql
- B. mysqlpump --include-databases=db --result-file=all_db_backup.sql
- C. mysqlpump --include-databases=db% --result-file=all_db_backup.sql
- D. mysqlpump --include-tables=db.% --result-file=all_db_backup.sql
Answer: B
NEW QUESTION # 25
Which four are types of information stored in the MySQL data dictionary? (Choose four.)
- A. performance metrics
- B. server configuration rollback
- C. access control lists
- D. table definitions
- E. view definitions
- F. InnoDB buffer pool LRU management data
- G. server runtime configuration
- H. stored procedure definitions
Answer: B,D,E,H
NEW QUESTION # 26
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. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
- C. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql
- D. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
Answer: C
NEW QUESTION # 27
You are using an existing server with a new configuration. MySQL Server fails to start.
Examine this snapshot of the error log:
Which action would allow the server to start?
- A. Create a new ib_logfile0 file of size 26214400.
- B. Execute mysqladmin flush-logs.
- C. First run mysqld --initialize to refresh the Size of ib_logfile.
- D. Remove ib_logfile0 and ib_logfile1 files from the file system.
Answer: C
NEW QUESTION # 28
All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.
You must configure InnoDB Cluster to use SSL for group communication.
Which two statements are true? (Choose two.)
- A. Configuring SSL group communication also configures SSL distributed recovery.
- B. SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.
- C. If only some InnoDB Cluster members are enabled for SSL group communication, and
--ssl-mode=PREFERRED, communication will fall back to unencrypted connection. - D. SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.
- E. SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).
- F. An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.
Answer: B,E
NEW QUESTION # 29
Examine this command and output:
Which statement is true?
- A. Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.
- B. Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.
- C. Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.
- D. Firewall_access_granted is the number of connections granted from whitelisted hosts.
Answer: A
NEW QUESTION # 30
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
- A. /usr/bin
- B. /usr
- C. /usr/mysql
- D. /var/lib/mysql
- E. /etc/my.cnf
Answer: A
NEW QUESTION # 31
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 PASSWORD DISABLED;
- B. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
- C. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
- D. ALTER USER baduser@hostname ACCOUNT LOCK;
- E. ALTER USER baduser@hostname DEFAULT ROLE NONE;
Answer: B,D
NEW QUESTION # 32
Which two are features of MySQL Enterprise Firewall? (Choose two.)
- A. automatic locking of user accounts who break your firewall
- B. modifying SQL statement dynamically with substitutions
- C. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
- D. blocking of potential threats by configuring pre-approved whitelists
- E. provides stateless firewall access to TCP/3306
Answer: B,D
NEW QUESTION # 33
Examine this partial output for InnoDB Cluster status:
Which statement explains the state of the instance deployed on host2?
- A. It can rejoin the cluster by using the command cluster.addInstance('<user>@host3:3377')
- B. It can rejoin the cluster by using the command dba.rebootClusterFromCompleteOutage()
- C. It has been removed from the cluster by using the command STOP GROUP_REPLICATION;
- D. It has been expelled from the cluster because of a transaction error.
- E. It can be recovered from a donor instance on host3 by cloning using the command cluster.rejoinInstance ('<user>@host3:3377')
Answer: B
NEW QUESTION # 34
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 restarted.
- C. MySQL Router is configured based on the information in files in directory_path.
- D. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
Answer: A
NEW QUESTION # 35
You have an installation of MySQL 8 on Oracle Linux.
Consider the outputs:
Which statement is true about disk temporary tables for this installation?
- A. Only internal temporary tables from the optimizer will be created in tmpdir.
- B. Temporary tables will use the InnoDB temporary tablespace located in /tmp.
- C. Temporary tables will use the InnoDB temporary tablespace located in datadir.
- D. Temporary tables are created in tmpdir only if configured to use MyISAM.
- E. Temporary tables are created in tmpdir only after they reach tmp_tabie_size.
Answer: A
NEW QUESTION # 36
......
The Most In-Demand 1Z0-908 Pass Guaranteed Quiz : https://skillsoft.braindumpquiz.com/1Z0-908-exam-material.html