[2024] Pass your 1Z0-908 exam with this 100% Free 1Z0-908 Braindump
View All 1Z0-908 Actual Exam Questions, Answers and Explanations for Free
Oracle 1z1-908 (MySQL 8.0 Database Administrator) Exam is a certification exam designed to test the knowledge and skills of individuals who work with MySQL 8.0 databases. 1Z0-908 exam is intended for database administrators, developers, and other IT professionals who work with MySQL databases on a regular basis. Candidates who pass the exam will be certified as MySQL 8.0 Database Administrators and will have demonstrated their proficiency in the installation, configuration, optimization, and maintenance of MySQL 8.0 databases.
NEW QUESTION # 30
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; then execute 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; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;
Answer: C
NEW QUESTION # 31
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 will shut down to preserve data consistency.
- B. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- C. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
- D. A manual intervention to force group members to be only the working two instances is required.
- E. 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.
Answer: A,C
NEW QUESTION # 32
Examine this statement, which executes successfully:
You want to improve the performance of this query:
Which change enables the query to succeed while accessing fewer rows?
- A. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
- B. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
- C. ALTER TABLE world.city ADD INDEX (Name);
- D. ALTER TABLE world.city ADD INDEX (Population);
- E. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- F. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
Answer: D
NEW QUESTION # 33
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It enforces encryption from disk to memory and over network transmission.
- B. It does not support the transportable tablespaces feature.
- C. It decrypts data for use in memory.
- D. It supports all indexes transparently.
- E. It supports only non-blob datatypes.
Answer: C,D
NEW QUESTION # 34
Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema() Which two statements are true? (Choose two.)
- A. Group Replication will be dissolved and all metadata purged.
- B. Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.
- C. The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.
- D. The command drops the mysql_innodb_cluster_metadata schema and re-creates it.
- E. Connections driven by MySQL Router are not affected by the command.
- F. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
Answer: E,F
NEW QUESTION # 35
Examine this statement, which executes successfully:
Now examine this query:
Which two statements can do this? (Choose two.)
- A. ALTER TABLE employees -
ADD INDEX ((MONTH(birth_date))); - B. ALTER TABLE employees -
ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned))); - C. ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month); - D. ALTER TABLE employees -
ADD INDEX (birth_date); - E. ALTER TABLE employees -
ADD INDEX (birth_date DESC); - F. ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL, ADD INDEX (birth_month);
Answer: E,F
NEW QUESTION # 36
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
- A. /usr/mysql
- B. /usr
- C. /etc/my.cnf
- D. /usr/bin
- E. /var/lib/mysql
Answer: D
NEW QUESTION # 37
Examine this command and output:
Which two statements are true? (Choose two.)
- A. The lock is at the table object level.
- B. The lock is an exclusive lock.
- C. The lock is an intentional lock.
- D. The lock is a row-level lock.
- E. The lock is a shared lock.
- F. The lock is at the metadata object level.
Answer: B,D
NEW QUESTION # 38
Which two statements are true about the mysql_config_editor program? (Choose two.)
- A. It manages the configuration of user privileges for accessing the server.
- B. It manages the configuration of the MySQL Firewall feature.
- C. It provides an interface to change my.cnf files.
- D. It can be used to create and edit SSL certificates and log locations.
- E. It manages the configuration of client programs.
- F. It can move datadir to a new location.
- G. It will use [client] options by default unless you provide --login-path.
Answer: E,G
NEW QUESTION # 39
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 is not necessary because innodb_data_home_dir is already defined.
- 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 defines all innodb tablespace options relative to a starting parent directory.
- E. It allows scanning of other locations to discover more innodb tablespaces.
Answer: E
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html
NEW QUESTION # 40
Which two statements are true about MySQL server multi-source replication? (Choose two.)
- A. It relies on relay_log_recovery for resilient operations.
- B. It needs to be re-instanced after a crash to maintain consistency.
- C. It must use GTID replication.
- D. It uses only time-based replication conflict resolution.
- E. It does not attempt to detect or resolve replication conflicts.
- F. It is not compatible with auto-positioning.
Answer: C,D
NEW QUESTION # 41
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- A. using stored procedures for any database access
- B. using PREPARED STATEMENTS
- C. avoiding concatenation of SQL statements and user-supplied values in an application
- D. installing and configuring the Connection Control plugin
Answer: A
NEW QUESTION # 42
Which two tools are available to monitor the global status of InnoDB locking? (Choose two.)
- A. SHOW TABLE STATUS;
- B. INFORMATION_SCHEMA.INNODB_TABLESTATS
- C. SHOW STATUS;
- D. SHOW ENGINE INNODB STATUS;
- E. INFORMATION_SCHEMA.STATISTICS
- F. INFORMATION_SCHEMA.INNODB_METRICS
Answer: B,E
NEW QUESTION # 43
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'.* TO 'tom'@'%';
- B. GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%'; - C. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO
'tom'@'%'; - D. GRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';
Answer: C
NEW QUESTION # 44
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
- A. Use system tools to lock each instance to its own CPU.
- B. Run MySQL Server docker containers.
- C. Use resource groups to lock different instances on separate CPUs.
- D. Use systemd with different settings for each instance.
- E. Start mysqld or mysqld_safe using different option files for each instance.
- F. Run mysqld with --datadir defined for each instance.
Answer: D,E,F
NEW QUESTION # 45
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. The parallel slave threads are experiencing lock contention.
- D. The master is producing a large volume of events in parallel but the slave is processing them serially.
- E. One or more large tables do not have primary keys.
Answer: B,D
NEW QUESTION # 46
Which three are types of information stored in the MySQL data dictionary? (Choose three.)
- A. server runtime configuration
- B. performance metrics
- C. server configuration rollback
- D. InnoDB buffer pool LRU management data
- E. view definitions
- F. access control lists
- G. stored procedure definitions
Answer: A,B,E
NEW QUESTION # 47
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 fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
- B. Replication will work.
- 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 # 48
......
1Z0-908 dumps Free Test Engine Verified By It Certified Experts: https://www.prep4sureguide.com/1Z0-908-prep4sure-exam-guide.html
1Z0-908 Exam Free Practice Test with100% Accurate Answers: https://drive.google.com/open?id=162ChgheFIwLWb7wMOFu76gSeGiuk8_nL