2023 1z1-908 Dumps PDF - 1z1-908 Real Exam Questions Answers
Valid 1z1-908 Test Answers & Oracle 1z1-908 Exam PDF
NEW QUESTION # 30
Which two are true about binary logs used in asynchronous replication? (Choose two.)
- A. They are pulled from the master to the slave.
- B. They contain events that describe all queries run on the master.
- C. They are pushed from the master to the slave.
- D. They contain events that describe only administrative commands run on the master.
- E. They contain events that describe database changes on the master.
Answer: C,E
Explanation:
Explanation/Reference: https://www.oracle.com/technetwork/community/developer-day/mysql-replication-presentation-
485890.pdf (14)
NEW QUESTION # 31
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 has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
- C. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
- D. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
- E. Replication will work.
Answer: C
Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643
NEW QUESTION # 32
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. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.
- C. systemd waited 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 mysqld service disabled and failed to start it.
Answer: B
NEW QUESTION # 33
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. UDP
- B. named pipes
- C. TCP/IP
- D. X Protocol
- E. shared memory
- F. SOCKET
Answer: B,C,E
NEW QUESTION # 34
Examine this statement and output:
Which two SQL statements can jsmith execute? (Choose two.)
- A. UPDATE world.country SET Name='first' ORDER BY Name LIMIT
- B. UPDATE world.country SET Name=CONCAT('New ',Name);
- C. UPDATE world.country SET Name='one' LIMIT 1;
- D. UPDATE world.country SET Name='all';
- E. UPDATE world.country SET Name='new' WHERE Name='old';
Answer: D,E
NEW QUESTION # 35
Which two are valid uses for binary logs on a MySQL instance? (Choose two.)
- A. replication
- B. logging the duration and locks for all queries
- C. audit of all queries
- D. recording the order in which queries are issued
- E. point-in-time recovery
Answer: D,E
NEW QUESTION # 36
Examine these statements and output:
Which statement is true?
- A. The user is authorized as the rsmith@localhost user.
- B. The user failed to define a username and the connecting username defaulted to ''@'%'.
- C. The user is logged in with --user=accounting as an option.
- D. The user is authorized as the accounting@localhost user.
- E. The user is authenticated as the anonymous proxy user ''@'%'.
Answer: A
NEW QUESTION # 37
Which three statements are true about MySQL replication? (Choose three.)
- A. Replication can use only TCP/IP connections.
- B. A replication user must have the SELECT privilege for all tables that need to be replicated.
- 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. Binary logging must be enabled on the master in order to replicate to other instances.
- F. Each instance in a replication topology must have a unique server ID.
- G. Binary logs contain only transactions originating from a single MySQL instance.
Answer: B,E,F
NEW QUESTION # 38
Examine this command and output:
Which two statements are true? (Choose two.)
- A. The lock is an exclusive lock.
- B. The lock is a shared lock.
- C. The lock is at the metadata object level.
- D. The lock is an intentional lock.
- E. The lock is at the table object level.
- F. The lock is a row-level lock.
Answer: A,F
NEW QUESTION # 39
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 does not attempt to detect or resolve replication conflicts.
- C. It is not compatible with auto-positioning.
- D. It uses only time-based replication conflict resolution.
- E. It must use GTID replication.
- F. It needs to be re-instanced after a crash to maintain consistency.
Answer: D,E
NEW QUESTION # 40
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 # 41
Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)
- A. InnoDB
- B. MyISAM
- C. MEMORY
- D. NDB
- E. ARCHIVE
Answer: B,C
NEW QUESTION # 42
Examine this query and output:
Which two statements are true? (Choose two.)
- A. It takes more than 8 milliseconds to sort the rows.
- B. The query returns exactly 125 rows.
- C. The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.
- D. The countrytable is accessed as the first table, and then joined to the city table.
- E. 35 rows from the city table are included in the result.
Answer: C,E
NEW QUESTION # 43
Examine this list of MySQL data directory binary logs:
binlog.000001
binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)
- A. All binary logs are deleted from the master.
- B. All non-active binary logs are removed from the master.
- C. All binary logs are backed up and then deleted.
- D. All details regarding deleted logs and master metadata are captured in the output file.
- E. All databases, excluding master metadata, are backed up to the output file.
- F. All databases are backed up to the output file.
Answer: A,E
NEW QUESTION # 44
You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)
- A. *.CSM files
- B. *.ibd files
- C. *.sdi files
- D. ibbackup files
- E. ib_logfile* files
Answer: B,E
NEW QUESTION # 45
Which three are characteristics of a newly created role? (Choose three.)
- A. It can be dropped using the DROP ROLE statement.
- B. It is created as a locked account.
- C. It is stored in the mysql.role table.
- D. It can be granted to user accounts.
- E. It can be renamed using the RENAME ROLE statement.
- F. It can be protected with a password.
Answer: A,D,F
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/roles.html
https://www.mysqltutorial.org/mysql-roles/
NEW QUESTION # 46
Which two statements are true about MySQL Enterprise Backup? (Choose two.)
- A. It creates logical backups.
- B. It supports backup of a remote MySQL system.
- C. It supports restoring to a remote MySQL system.
- D. It supports backing up only table structures.
- E. It can perform hot or warm backups.
- F. It supports the creation of incremental backups.
Answer: E,F
NEW QUESTION # 47
Which statement is true about cold backups?
- A. They are backups taken from snapshots of a running database.
- B. They are good to use when many users are online accessing the database.
- C. They are good to use if only data structures must be backed up but not log files.
- D. They are backups taken from OS copy commands.
Answer: A
NEW QUESTION # 48
Examine the modified output:
Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)
- A. The parallel slave threads are experiencing lock contention.
- B. The master is most probably too busy to transmit data and the slave needs to wait for more data.
- C. One or more large tables do not have primary keys.
- D. The master is producing a large volume of events in parallel but the slave is processing them serially.
- E. This value shows only I/O latency and is not indicative of the size of the transaction queue.
Answer: D,E
NEW QUESTION # 49
......
1z1-908 Exam Dumps - PDF Questions and Testing Engine: https://www.actualpdf.com/1z1-908_exam-dumps.html
Realistic 1z1-908 Exam Dumps with Accurate & Updated Questions: https://drive.google.com/open?id=1AWvGfXKSNTl_BZxeS2jsR-UqlOANWis_
