[Oct-2023] Latest Oracle 1z1-908 Certification Practice Test Questions

Verified 1z1-908 Dumps Q&As - 1 Year Free & Quickly Updates

NEW QUESTION # 54
Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?

• A. MySQL Router is restarted.
• B. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
• C. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
• D. MySQL Router is configured based on the information in files in directory_path.

Answer: B

Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter.html

NEW QUESTION # 55
Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members

• A. WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
  (‘[email protected]’,‘secret’);--‘;
• B. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
• C. WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
  (‘[email protected]’, ‘secret’);--‘;
  SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘;
• D. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
• E. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
• F. SELECT email,passwd FROM members

Answer: E,F

NEW QUESTION # 56
Examine this command, which executes successfully:
shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)

• A. It enforces consistent backups for all storage engines.
• B. This option uses the READ COMMITTED transaction isolation mode.
• C. The backup created is a consistent data dump.
• D. It executes flush tables with read lock.
• E. It is a cold backup.

Answer: B,D

NEW QUESTION # 57
You have semi-synchronous replication configured and working with one slave.
rpl_semi_sync_master_timeout has never been reached.
You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.
Which two statements are true? (Choose two.)

• A. Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.
• B. No committed transactions are lost.
• C. As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.
• D. Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.
• E. A small amount of committed transactions may be lost in case they were committed just before the disk failure.
• F. The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master.

Answer: E,F

NEW QUESTION # 58
Examine the modified output:

Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)

• A. This value shows only I/O latency and is not indicative of the size of the transaction queue.
• B. The master is most probably too busy to transmit data and the slave needs to wait for more data.
• 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: A,D

Explanation:
Explanation

NEW QUESTION # 59
Which three statements are true about MySQL replication? (Choose three.)

• A. Binary logging must be enabled on the master in order to replicate to other instances.
• B. Replication can use only TCP/IP connections.
• C. Any instance can have multiple slaves, but it can have only one master.
• D. Each slave must have its own MySQL user for replication.
• E. Each instance in a replication topology must have a unique server ID.
• F. A replication user must have the SELECT privilege for all tables that need to be replicated.
• G. Binary logs contain only transactions originating from a single MySQL instance.

Answer: A,E,F

NEW QUESTION # 60
You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnfparameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

• A. systemdattempted to start mysqld, found another systemd mysqldprocess running, and shut it down.
• B. MySQL server continued to start up even though another process existed.
• C. systemdwaited for 30 seconds before timing out and start up failed.
• D. MySQL server was not started due to a problem while executing process 2732.
• E. systemd found the mysqldservice disabled and failed to start it.

Answer: A

NEW QUESTION # 61
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 --datebase=mydb1 --database=mydb2 | mysql
• C. mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql
• D. mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql

Answer: D

NEW QUESTION # 62
You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?

• A. It creates a logical backup of only the usersdatabase.
• B. It creates a logical backup of all metadata, but contains no table data.
• C. It returns an error because the mysqldumpcommand should have been used.
• D. It creates a logical backup of all MySQL user accounts.

Answer: B

Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/mysqlpump.html

NEW QUESTION # 63
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. A manual intervention to force group members to be only the working two instances is required.
• B. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
• C. 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.
• D. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
• E. The cluster will shut down to preserve data consistency.

Answer: D,E

NEW QUESTION # 64
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. systemd found the mysqld service disabled and failed to start it.
• B. MySQL server continued to start up even though another process existed.
• C. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.
• D. MySQL server was not started due to a problem while executing process 2732.
• E. systemd waited for 30 seconds before timing out and start up failed.

Answer: C

NEW QUESTION # 65
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. sync_binlog=0
• B. innodb_doublewrite=0
• C. innodb_flush_log_at_trx_commit=1
• D. innodb_undo_directory=/dev/shm
• E. buffer_pool_size=24G
• F. max_connections=10000
• G. innodb_log_file_size=1G

Answer: C,F,G

NEW QUESTION # 66
Examine this statement and output:

Which two SQL statements can jsmith execute? (Choose two.)

• A. UPDATE world.country SET Name=CONCAT('New ',Name);
• B. UPDATE world.country SET Name='new' WHERE Name='old';
• C. UPDATE world.country SET Name='one' LIMIT 1;
• D. UPDATE world.country SET Name='all';
• E. UPDATE world.country SET Name='first' ORDER BY Name LIMIT

Answer: B,D

NEW QUESTION # 67
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTERcommand are correct.
Examine the GTID information from both master and slave:

Which statement is true?

• A. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
• B. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
• C. Replication will work.
• D. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
• E. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.

Answer: D

Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643

NEW QUESTION # 68
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. Execute this on the slave to enable GTID:
  START SLAVE IO_THREAD WITH GTID;
• C. Execute this on the slave to enable GTID:
  RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;
• D. Enable GTID by executing this on the master and the slave:
  SET GLOBAL GTID_ENABLED=on;
• E. On the slave, alter the MySQL master connection setting with:
  CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
• F. Restart MySQL (master and slave) with these options enabled:
  --gtid_mode=ON
  --log-bin
  --log-slave-updates
  --enforce-gtid-consistency

Answer: E,F

NEW QUESTION # 69
Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)

• A. ARCHIVE
• B. InnoDB
• C. NDB
• D. MyISAM
• E. MEMORY

Answer: D,E

NEW QUESTION # 70
Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY 'P@ssw0rd';
GRANT r_world_rd TO john;
Examine these statements issued by user John:

What is the reason for the error?

• A. John has not activated the role.
• B. John needs to reconnect to the database.
• C. The DBA needs to execute FLUSH PRIVILEGES.
• D. The statement was blocked by MySQL Firewall.

Answer: A

NEW QUESTION # 71
On examination, your MySQL installation datadir has become recursively world read/write/executable.
What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

• A. Extra startup time would be required for the MySQL server to reset the privileges.
• B. Data files could be deleted.
• C. SQL injections could be used to insert bad data into the database.
• D. MySQL binaries could be damaged, deleted, or altered.
• E. Users could overwrite configuration files.

Answer: A,B

NEW QUESTION # 72
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?

• A. RESET MASTER;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• B. RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;
• C. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• D. RESET MASTER;
  SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• E. RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

Answer: D

NEW QUESTION # 73
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: B,E

Explanation:
Explanation
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html

NEW QUESTION # 74
......

Oracle 1z1-908 (MySQL 8.0 Database Administrator) certification exam is an essential certification program for individuals seeking to validate their skills and knowledge in database administration. MySQL 8.0 Database Administrator certification exam is designed to test the candidate's ability to install, configure, and manage the MySQL database system. It is a comprehensive exam that covers all aspects of MySQL database administration, including security, performance tuning, backup and recovery, and high availability.

 

Latest 2023 Realistic Verified 1z1-908 Dumps - 100% Free 1z1-908 Exam Dumps: https://www.testsimulate.com/1z1-908-study-materials.html