1z1-908 Exam Practice Questions prepared by Oracle Professionals
Use Valid New 1z1-908 Questions - Top choice Help You Gain Success
NEW QUESTION # 47
Examine these commands and output:
Which connection ID is holding the metadata lock?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
- F. 5
Answer: C
NEW QUESTION # 48
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 has been removed from the cluster by using the command STOP GROUP_REPLICATION;
- C. It can be recovered from a donor instance on host3 by cloning using the command cluster.rejoinInstance ('<user>@host3:3377')
- D. It has been expelled from the cluster because of a transaction error.
- E. It can rejoin the cluster by using the command dba.rebootClusterFromCompleteOutage()
Answer: E
NEW QUESTION # 49
Which three are requirements for a secure MySQL Server environment? (Choose three.)
- A. Keep the entire software stack on one OS host.
- B. Run MySQL server as the root user to prevent incorrect sudo settings.
- C. Restrict the number of OS users that have access at the OS level.
- D. Ensure appropriate file system privileges for OS users and groups.
- E. Encrypt the file system to avoid needing exact file-system permissions.
- F. Minimize the number of non-MySQL Server-related processes running on the server host.
Answer: A,D,E
NEW QUESTION # 50
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. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql
- B. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
- C. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
- D. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
Answer: D
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html By default --all-databases won't backup ndbinfo schema this can be done via
--include-database=%https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html#mysqlpump-restrictions
NEW QUESTION # 51
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 adds more temporary workspace in addition to the innodb_tmpdir location.
- C. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
- D. It is not necessary because innodb_data_home_dir is already defined.
- E. It defines all innodb tablespace options relative to a starting parent directory.
Answer: A
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html
NEW QUESTION # 52
Which four are types of information stored in the MySQL data dictionary? (Choose four.)
- A. access control lists
- B. performance metrics
- C. stored procedure definitions
- D. table definitions
- E. view definitions
- F. InnoDB buffer pool LRU management data
- G. server runtime configuration
- H. server configuration rollback
Answer: C,D,E,H
NEW QUESTION # 53
Which two are use cases of MySQL asynchronous replication? (Choose two.)
- A. It allows backup to be done on the slave without impacting the master.
- B. It guarantees near real-time replication between a master and a slave.
- C. MySQL Enterprise Backup will automatically back up from an available slave.
- D. You can scale reads by adding multiple slaves.
- E. You can scale writes by creating a replicated mesh.
Answer: A,D
NEW QUESTION # 54
Which three are characteristics of a newly created role? (Choose three.)
- A. It is created as a locked account.
- B. It is stored in the mysql.role table.
- C. It can be renamed using the RENAME ROLE statement.
- D. It can be granted to user accounts.
- E. It can be protected with a password.
- F. It can be dropped using the DROP ROLE statement.
Answer: D,E,F
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/roles.html
https://www.mysqltutorial.org/mysql-roles/
NEW QUESTION # 55
Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.
Which two sets of actions when completed will accomplish this? (Choose two.)
- A. Set binlog_expire_logs_seconds in my.cnf.
- B. Use PURGE BINARY LOGS to <binlog_name>.
- C. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
- D. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
- E. Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.
- F. Use SET PERSIST binlog_expire_logs_seconds=<value>.
Answer: C,F
NEW QUESTION # 56
MySQL is installed on a Linux server with this configuration:
Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?
- A. Add default_authentication_plugin=sha256_password in the configuration file.
- B. Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.
- C. Add default_authentication_plugin=mysql_native_password in the configuration file.
- D. Set validate-user-plugins=caching_sha2_password in the configuration file.
Answer: A
NEW QUESTION # 57
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. REQUIRED
- B. VERIFY_CA
- C. DISABLED
- D. PREFERRED
- E. VERIFY_IDENTITY
Answer: A
NEW QUESTION # 58
Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)
- A. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.
- B. It only stops and restarts all InnoDB Cluster instances.
- C. It is not mandatory that all instances are running and reachable before running the command.
- D. It performs InnoDB Cluster instances rolling restart.
- E. It stops and restarts all InnoDB Cluster instances and initializes the metadata.
- F. It only starts all InnoDB Cluster instances.
- G. It reconfigures InnoDB Cluster if the cluster was stopped.
Answer: C,D
NEW QUESTION # 59
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)
- A. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - B. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on; - C. Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID; - D. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency - E. On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - F. Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;
Answer: D,E
NEW QUESTION # 60
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. 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.
- B. The cluster has built-in high availability and updates group_replication_ip_whitelistto remove the unreachable nodes.
- C. A manual intervention to force group members to be only the working two instances is required.
- D. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- E. The cluster will shut down to preserve data consistency.
Answer: B,E
NEW QUESTION # 61
Which statement is true about displaying and retrieving data with MySQL Enterprise Monitor Query Analyzer?
- A. The Query Analyzer can plot a CPU utilization graph for remote hosts with a MySQL Enterprise Service Manager's built-in Agent installation.
- B. The Query Analyzer graph view range selector can extend to cover the same hour over multiple days.
- C. It is possible to export statements included in a graph selection in CSV format.
- D. It is possible to filter a Query Analyzer view graph by database and by table.
Answer: C
NEW QUESTION # 62
Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'.
Which command will do this?
- A. mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql
- B. mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql
- C. mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql
- D. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
Answer: C
NEW QUESTION # 63
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. slow query log
- B. error log
- C. binary log
- D. general query log
- E. audit log
Answer: C
NEW QUESTION # 64
You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade.
Examine the message sequence generated during the first start of MySQL 8.0.18:
Which step or set of steps will resolve the errors?
- A. Start mysqld again using the --upgrade=FORCE option.
- B. Execute: mysqlcheck --repair mysql columns_priv event proc proxies_priv tables_priv.
- C. Remove the redo logs. Replace the MySQL binaries with the 5.7.28 binaries. Prepare the tables for upgrade. Upgrade to 8.0.18 again.
- D. Execute: mysqlcheck --check-upgrade mysql columns_priv event proc proxies_priv tables_priv.
- E. Go to the <datadir>/mysql directory and execute: myisamchk --update-state columns_priv event proc proxies_priv tables_priv.
Answer: A
NEW QUESTION # 65
Which three are types of information stored in the MySQL data dictionary? (Choose three.)
- A. access control lists
- B. stored procedure definitions
- C. view definitions
- D. InnoDB buffer pool LRU management data
- E. server runtime configuration
- F. performance metrics
- G. server configuration rollback
Answer: C,E,F
NEW QUESTION # 66
Which two are features of MySQL Enterprise Firewall? (Choose two.)
- A. automatic locking of user accounts who break your firewall
- B. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
- C. modifying SQL statement dynamically with substitutions
- D. provides stateless firewall access to TCP/3306
- E. blocking of potential threats by configuring pre-approved whitelists
Answer: B,E
NEW QUESTION # 67
Which two are valid uses for binary logs on a MySQL instance? (Choose two.)
- A. replication
- B. point-in-time recovery
- C. logging the duration and locks for all queries
- D. audit of all queries
- E. recording the order in which queries are issued
Answer: B,E
NEW QUESTION # 68
Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema() Which two statements are true? (Choose two.)
- A. The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.
- B. Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.
- C. Connections driven by MySQL Router are not affected by the command.
- D. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
- E. The command drops the mysql_innodb_cluster_metadata schema and re-creates it.
- F. Group Replication will be dissolved and all metadata purged.
Answer: C,D
NEW QUESTION # 69
......
What is the duration, language, and format of Oracle 1Z0-908: MySQL 8.0 Database Exam
- Section 2: 45%
- This exam is offered in only English.
- Section 1: 60%
- This exam consists of 90 questions.
- There is a time limit of 140 minutes for the exam.
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.
1z1-908 Exam Practice Materials Collection: https://www.torrentvalid.com/1z1-908-valid-braindumps-torrent.html
Get Latest and 100% Accurate 1z1-908 Exam Questions: https://drive.google.com/open?id=1lQJRTkvq4uIHlaZt1LCO4YRrY3oHrRdt