Best Quality Oracle 1z1-908 Exam Questions PassLeader Realistic Practice Exams [2021]
Critical Information To MySQL 8.0 Database Administrator Pass the First Time
NEW QUESTION 29
Examine this query and output:
Which two statements are true? (Choose two.)
- A. The country table is accessed as the first table, and then joined to the city table.
- B. The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
- C. 35 rows from the city table are included in the result.
- D. It takes more than 8 milliseconds to sort the rows.
- E. The query returns exactly 125 rows.
Answer: B,C
NEW QUESTION 30
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
- A. InnoDB Data Dictionary
- B. change buffer
- C. table data
- D. primary indexes
- E. doublewrite buffer
- F. user privileges
Answer: A,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/innodb-system-tablespace.html
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. 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.
- C. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- D. A manual intervention to force group members to be only the working two instances is required.
- E. The cluster has built-in high availability and updates group_replication_ip_whitelistto remove the unreachable nodes.
Answer: A,E
NEW QUESTION 32
Which two MySQL Server accounts are locked by default? (Choose two.)
- A. any user created with a username, but missing the host name
- B. any user created without a password
- C. any internal system accounts
- D. any new ROLE accounts
- E. any user set as DEFINER for stored programs
Answer: C,E
NEW QUESTION 33
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)
- A. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on; - 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. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1; - E. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency - F. On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
Answer: E,F
NEW QUESTION 34
Which four are types of information stored in the MySQL data dictionary? (Choose four.)
- A. performance metrics
- B. InnoDB buffer pool LRU management data
- C. stored procedure definitions
- D. table definitions
- E. server runtime configuration
- F. server configuration rollback
- G. view definitions
- H. access control lists
Answer: C,D,F,G
NEW QUESTION 35
Examine these statements, which execute successfully:
TRUNCATE test; BEGIN;
INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK;
SELECT id FROM test;
Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)
- A. InnopB
- B. MEMORY
- C. BLACKHOLE
- D. ARCHIVE
- E. MyISAM
- F. NDB
Answer: C,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. /etc/my.cnf
- C. /var/lib/mysql
- D. /usr/bin
- E. /usr
Answer: D
NEW QUESTION 37
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It supports only non-blob datatypes.
- B. It supports all indexes transparently.
- C. It enforces encryption from disk to memory and over network transmission.
- D. It decrypts data for use in memory.
- E. It does not support the transportable tablespaces feature.
Answer: B,D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/faqs-tablespace-encryption.html
NEW QUESTION 38
Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)
- A. named pipes
- B. TCP/IP
- C. X Protocol
- D. SOCKET
- E. shared memory
- F. UDP
Answer: A,B,E
NEW QUESTION 39
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
- A. Use resource groups to lock different instances on separate CPUs.
- B. Start mysqld or mysqld_safe using different option files for each instance.
- C. Use systemd with different settings for each instance.
- D. Use system tools to lock each instance to its own CPU.
- E. Run MySQL Server docker containers.
- F. Run mysqld with --datadir defined for each instance.
Answer: B,C,F
NEW QUESTION 40
Which two are true about binary logs used in asynchronous replication? (Choose two.)
- A. They contain events that describe only administrative commands run on the master.
- B. They are pulled from the master to the slave.
- C. They are pushed from the master to the slave.
- D. They contain events that describe all queries run on the master.
- E. They contain events that describe database changes on the master.
Answer: C,E
NEW QUESTION 41
Examine these statements and output:
Which statement is true?
- A. The user is authorized as the accounting@localhostuser.
- B. The user is authorized as the rsmith@localhostuser.
- C. The user is logged in with --user=accountingas an option.
- D. The user failed to define a username and the connecting username defaulted to ‘’@’%’.
- E. The user is authenticated as the anonymous proxy user ‘’@’%’.
Answer: B
NEW QUESTION 42
Which three statements are true about MySQL replication? (Choose three.)
- A. Binary logs contain only transactions originating from a single MySQL instance.
- B. A replication user must have the SELECT privilege for all tables that need to be replicated.
- C. Each slave must have its own MySQL user for replication.
- D. Any instance can have multiple slaves, but it can have only one master.
- E. Replication can use only TCP/IP connections.
- F. Binary logging must be enabled on the master in order to replicate to other instances.
- G. Each instance in a replication topology must have a unique server ID.
Answer: B,F,G
NEW QUESTION 43
User account baduser@hostname on your MySQL instance has been compromised.
Which two commands stop any new connections using the compromised account? (Choose two.)
- A. ALTER USER baduser@hostname PASSWORD DISABLED;
- B. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
- C. ALTER USER baduser@hostname DEFAULT ROLE NONE;
- D. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
- E. ALTER USER baduser@hostname ACCOUNT LOCK;
Answer: D,E
NEW QUESTION 44
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 the master has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
- B. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
- 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 does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
Answer: D
Explanation:
Explanation/Reference: https://bugs.mysql.com/bug.php?id=86643
NEW QUESTION 45
Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)
- A. NDB
- B. ARCHIVE
- C. InnoDB
- D. MyISAM
- E. MEMORY
Answer: D,E
Explanation:
Explanation/Reference: https://zetcode.com/mysql/storageengines/
NEW QUESTION 46
Which three are characteristics of a newly created role? (Choose three.)
- A. It is created as a locked account.
- B. It can be renamed using the RENAME ROLE statement.
- C. It can be protected with a password.
- D. It is stored in the mysql.role table.
- E. It can be granted to user accounts.
- F. It can be dropped using the DROP ROLE statement.
Answer: C,E,F
NEW QUESTION 47
......
1z1-908 EXAM DUMPS WITH GUARANTEED SUCCESS: https://www.passleader.top/Oracle/1z1-908-exam-braindumps.html
Best Quality Oracle 1z1-908 Exam Questions: https://drive.google.com/open?id=1pBgEYU3gTeUojcybDTzr_nvHAyQR-KHZ