Pass 1Z0-908 Exam Latest Practice Questions Updated on Jan 12, 2024
Oracle 1Z0-908 Study Guide Archives
Oracle 1Z0-908 exam consists of 85 multiple-choice questions that need to be answered within 150 minutes. Candidates need to score a minimum of 63% to pass the exam and receive the certification. 1Z0-908 exam is available in English and Japanese languages and can be taken at Pearson VUE testing centers or online. MySQL 8.0 Database Administrator certification is valid for three years and can be renewed by passing a relevant exam or earning a higher-level certification.
NEW QUESTION # 32
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 does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
- B. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- C. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
- D. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- E. Replication will work.
Answer: D
NEW QUESTION # 33
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes.
Examine the current GTID information:
You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover.
Which set of actions would allow the slave to continue replicating without erroneous transactions?
RESET MASTER;
- A. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- - B. bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - C. SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
RESET SLAVE; - D. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
RESET MASTER; - E. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
Answer: C
NEW QUESTION # 34
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- A. using PREPARED STATEMENTS
- B. installing and configuring the Connection Control plugin
- C. avoiding concatenation of SQL statements and user-supplied values in an application
- D. using stored procedures for any database access
Answer: D
Explanation:
Explanation/Reference: https://www.ptsecurity.com/ww-en/analytics/knowledge-base/how-to-prevent-sql-injection-attacks/
NEW QUESTION # 35
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. employee
- B. mysql
- C. world
- D. sys
- E. information_schema
Answer: D,E
Explanation:
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/
NEW QUESTION # 36
You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:
What statement is true about the start attempt?
- A. MySQL server continued to start up even though another process existed.
- B. MySQL server was not started due to a problem while executing process 2732.
- C. systemd waited for 30 seconds before timing out and start up failed.
- D. systemd found the mysqld service disabled and failed to start it.
- E. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.
Answer: E
NEW QUESTION # 37
Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)
- A. It only stops and restarts all InnoDB Cluster instances.
- B. It is not mandatory that all instances are running and reachable before running the command.
- C. It only starts all InnoDB Cluster instances.
- D. It reconfigures InnoDB Cluster if the cluster was stopped.
- E. It performs InnoDB Cluster instances rolling restart.
- F. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.
- G. It stops and restarts all InnoDB Cluster instances and initializes the metadata.
Answer: B,E
NEW QUESTION # 38
You plan to install MySQL Server by using the RPM download.
Which two statements are true? (Choose two.)
- A. The functionality is split among several RPM package files.
- B. You can provide the root password interactively.
- C. MySQL uses the RPM relocatable installation target feature.
- D. You can find the root password in the error log after the first start.
- E. The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.
- F. You must manually initialize the data directory.
Answer: D,E
NEW QUESTION # 39
Examine this query and output:
Which two statements are true? (Choose two.)
- A. The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
- B. The query returns exactly 125 rows.
- C. 35 rows from the city table are included in the result.
- D. The country table is accessed as the first table, and then joined to the city table.
- E. It takes more than 8 milliseconds to sort the rows.
Answer: A,C
NEW QUESTION # 40
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. buffer_pool_size=24G
- C. sync_binlog=0
- D. innodb_doublewrite=0
- E. max_connections=10000
- F. innodb_flush_log_at_trx_commit=1
- G. innodb_undo_directory=/dev/shm
Answer: A,E,F
Explanation:
Explanation/Reference: https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon- rds-for-mysql-part-1-parameters-related-to-performance/
NEW QUESTION # 41
Which two are true about binary logs used in asynchronous replication? (Choose two.)
- A. They contain events that describe database changes on the master.
- B. They contain events that describe all queries run on the master.
- C. They are pushed from the master to the slave.
- D. They are pulled from the master to the slave.
- E. They contain events that describe only administrative commands run on the master.
Answer: A,C
NEW QUESTION # 42
A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)
- A. ibtmp1
- B. ib_buffer_pool
- C. ib_logfile0
- D. ibdata1
- E. mysql.ibd
- F. undo_001
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'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' 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'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';
Answer: C
NEW QUESTION # 44
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 does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
- B. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- C. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
- D. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- E. Replication will work.
Answer: D
NEW QUESTION # 45
You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your data.
Examine your backup requirement:
* The MySQL system being backed up can never be unavailable or locked to the client applications.
* The recovery from the backup must work on any system.
* Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?
- A. Take a logical backup of the MySQL system.
- B. Take a physical backup of the MySQL system.
- C. Use the Clone Plugin to copy the data to another MySQL system.
- D. Take your backup from a slave of the MySQL system.
Answer: A
NEW QUESTION # 46
Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup
--optimistic-busy-tables="^finance\.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?
- A. The redo logs are backed up only if there are changes showing for the transactions tables.
- B. The redo logs are not backed up at all.
- C. The archive tables are backed up first, then the transaction tables and redo logs.
- D. The transaction tables are backed up first, then the archive tables and redo logs.
- E. The redo logs are backed up first, then the transaction and archive tables.
Answer: A
NEW QUESTION # 47
Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)
- A. IPv6
- B. FILE
- C. PIPE
- D. IPv4
- E. MEMORY
- F. SOCKET
- G. DIRECT
- H. TCP
Answer: C,E,F,H
NEW QUESTION # 48
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. The command drops the mysql_innodb_cluster_metadata schema and re-creates it.
- C. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
- D. Group Replication will be dissolved and all metadata purged.
- E. Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.
- F. Connections driven by MySQL Router are not affected by the command.
Answer: C,F
NEW QUESTION # 49
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. audit log
- B. error log
- C. slow query log
- D. binary log
- E. general query log
Answer: D
NEW QUESTION # 50
Which two commands will display indexes on the partstable in the manufacturing schema? (Choose two.) \
- A. SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
AND TABLE_NAME=’parts’; - B. DESCRIBE manufacturing.parts;
- C. SHOW INDEXES FROM manufacturing.parts;
- D. SELECT * FROM information_schema.COLUMN_STATISTICS;
- E. EXPLAIN SELECT INDEXES FROM manufacturing.parts;
Answer: A,D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912
NEW QUESTION # 51
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
- A. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
- B. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
- C. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
- D. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
- E. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
Answer: A,B
NEW QUESTION # 52
......
Oracle 1Z0-908 certification exam is an excellent way for MySQL database administrators to demonstrate their skills and expertise, and it can help them advance their careers. By earning this certification, candidates can prove to employers that they have the technical skills and knowledge required to manage and maintain MySQL databases effectively. Additionally, the certification can help candidates stand out in a competitive job market and increase their earning potential.
Oracle 1z1-908 (MySQL 8.0 Database Administrator) Certification Exam is designed for professionals who want to demonstrate their skills and knowledge in managing and administering MySQL databases. 1Z0-908 exam is ideal for database administrators, developers, and IT professionals who are responsible for designing, implementing, and maintaining MySQL databases. MySQL 8.0 Database Administrator certification exam covers a wide range of topics, including database installation and configuration, security, backup and recovery, performance tuning, and high availability.
1Z0-908 Questions Prepare with Learning Information: https://www.examprepaway.com/Oracle/braindumps.1Z0-908.ete.file.html
Download 1Z0-908 Mock Test Study Material: https://drive.google.com/open?id=1wnB8HGmAbjC2ffz4g4s0OY7xYA-ynIld