Accurate & Verified 2023 New 1z1-908 Answers As Experienced in the Actual Test!
1z1-908 Certification Sample Questions certification Exam
Preparing for the MySQL 8.0 Database Administrator exam requires a combination of practical experience and dedicated study. Candidates should have a solid understanding of MySQL fundamentals and be comfortable with advanced concepts such as replication, clustering, and backup and recovery procedures.
NEW QUESTION # 23
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfiguring the default cluster from complete outage...
The instance 'host1:3377'' was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N]: y The instance 'host2:3377' was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N]: y Dba.rebootClusterFromCompleteOutage: The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadat a. Please use the most up to date instance: 'host1:3377'. (RuntimeError) Which statement is true?
- A. The instance deployed on host3 must be rebuilt with a backup from the primary instance.
- B. The active session instance is invalid and must be re-created by using the command shell.connect ('host3:3377').
- C. The cluster is running and there is at least one ONLINE instance.
- D. The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').
- E. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
Answer: D
NEW QUESTION # 24
Which two statements are true about raw binary backups? (Choose two.)
- A. They are faster than logical backups because the process is a simple file or file system copy.
- B. They are converted to a highly compressible binary format.
- C. The data format is identical to how MySQL stores the data on disk.
- D. The resulting files are easily human readable.
- E. They are required to obtain FIPS security compliance.
Answer: C,D
NEW QUESTION # 25
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 cluster has built-in high availability and updates group_replication_ip_whitelistto remove the unreachable nodes.
- C. The cluster will shut down to preserve data consistency.
- D. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
- 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: B,C
NEW QUESTION # 26
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 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 database changes on the master.
Answer: C,E
NEW QUESTION # 27
Which two are features of MySQL Enterprise Firewall? (Choose two.)
- A. blocking of potential threats by configuring pre-approved whitelists
- B. modifying SQL statement dynamically with substitutions
- C. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
- D. automatic locking of user accounts who break your firewall
- E. provides stateless firewall access to TCP/3306
Answer: A,B
NEW QUESTION # 28
Examine this SQL statement:
Which set of privileges will allow Tom to execute this SQL statement?
- A. GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%'; - B. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO
'tom'@'%'; - C. GRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%'; - D. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';
Answer: B
NEW QUESTION # 29
Which step or set of steps can be used to rotate the error log?
- A. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.
- B. Execute SET GLOBAL log_error = ‘<new error log file>’.
- C. Execute SET GLOBAL expire_logs_days=0to enforce a log rotation.
- D. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
Answer: A
Explanation:
Explanation/Reference: https://blog.pythian.com/mysql-log-rotation/
NEW QUESTION # 30
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 internal system accounts
- C. any user set as DEFINER for stored programs
- D. any user created without a password
- E. any new ROLE accounts
Answer: B,C
NEW QUESTION # 31
Which two queries are examples of successful SQL injection attacks? (Choose two.)
- A. SELECT user,passwd FROM members
WHERE user = '?';INSERT INTO members('user','passwd') VALUES
('[email protected]','secret');--'; - B. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
- C. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
- D. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
- E. SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';
- F. SELECT email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
'secret');--';
Answer: B,F
NEW QUESTION # 32
Which two are valid uses for binary logs on a MySQL instance? (Choose two.)
- A. point-in-time recovery
- B. logging the duration and locks for all queries
- C. recording the order in which queries are issued
- D. audit of all queries
- E. replication
Answer: A,C
NEW QUESTION # 33
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 moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
- B. It is not necessary because innodb_data_home_dir is already defined.
- C. It defines all innodb tablespace options relative to a starting parent directory.
- D. It allows scanning of other locations to discover more innodb tablespaces.
- E. It adds more temporary workspace in addition to the innodb_tmpdir location.
Answer: D
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html
NEW QUESTION # 34
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 FULLTEXT INDEX (Name);
- B. ALTER TABLE world.city ADD INDEX (Name);
- C. ALTER TABLE world.city ADD INDEX (Population);
- D. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
- E. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
- F. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
Answer: D
NEW QUESTION # 35
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 query returns exactly 125 rows.
- C. 35 rows from the city table are included in the result.
- D. The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
- E. It takes more than 8 milliseconds to sort the rows.
Answer: C,D
NEW QUESTION # 36
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. slow query log
- B. audit log
- C. binary log
- D. error log
- E. general query log
Answer: C
NEW QUESTION # 37
Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
- A. QN = 4
- B. QN = 5
- C. QN = 1
- D. QN = 2
- E. QN = 3
Answer: C,D
NEW QUESTION # 38
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- A. installing and configuring the Connection Control plugin
- B. avoiding concatenation of SQL statements and user-supplied values in an application
- C. using stored procedures for any database access
- D. using PREPARED STATEMENTS
Answer: C
Explanation:
Explanation/Reference: https://www.ptsecurity.com/ww-en/analytics/knowledge-base/how-to-prevent-sql-injection-attacks/
NEW QUESTION # 39
You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?
- A. It creates a logical backup of only the users database.
- B. It creates a logical backup of all metadata, but contains no table data.
- C. It creates a logical backup of all MySQL user accounts.
- D. It returns an error because the mysqldump command should have been used.
Answer: B
NEW QUESTION # 40
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 non-active binary logs are removed from the master.
- B. All databases, excluding master metadata, are backed up to the output file.
- C. All databases are backed up to the output file.
- D. All details regarding deleted logs and master metadata are captured in the output file.
- E. All binary logs are deleted from the master.
- F. All binary logs are backed up and then deleted.
Answer: B,E
NEW QUESTION # 41
Which two are characteristics of snapshot-based backups? (Choose two.)
- A. Snapshot backups can be used only in virtual machines.
- B. Snapshot-based backups greatly reduce time during which the database and applications are unavailable.
- C. A separate physical copy must be made before releasing the snapshot backup.
- D. There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.
- E. The frozen file system can be cloned to another virtual machine immediately into active service.
Answer: A,C
NEW QUESTION # 42
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 --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql
- C. mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql
- D. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
Answer: B
NEW QUESTION # 43
Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:
Which two statements are true? (Choose two.)
- A. The transactions table was created with innodb_file_per_table=OFF.
- B. Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.
- C. Executing ALTER TABLE transactions will enable you to free up disk space.
- D. Truncating the transactions table will free up the most disk space.
- E. Truncating the sales and leads table will free up disk space.
Answer: A,B
NEW QUESTION # 44
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. It executes flush tables with read lock.
- C. The backup created is a consistent data dump.
- D. It is a cold backup.
- E. This option uses the READ COMMITTED transaction isolation mode.
Answer: B,E
NEW QUESTION # 45
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 returns an error because the mysqldumpcommand should have been used.
- C. It creates a logical backup of all metadata, but contains no table data.
- D. It creates a logical backup of all MySQL user accounts.
Answer: C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/mysqlpump.html
NEW QUESTION # 46
How can mysql_multi be configured to allow MySQL instances to use the same port number?
- A. The instances have appropriate net masks set.
- B. The instances use different user accounts unique to each instance.
- C. The instances listen on different IP addresses.
- D. The instances use different socket names.
Answer: C
NEW QUESTION # 47
......
The Oracle 1Z0-908 Exam is a multiple-choice exam that consists of 80 questions. Candidates have 150 minutes to complete the exam, and the passing score is 63%. The exam is available in several languages, including English, Japanese, and Simplified Chinese. Upon passing the exam, candidates will receive the Oracle Certified Professional, MySQL 8.0 Database Administrator certification, which demonstrates their expertise in MySQL database administration and can help them advance their careers in the IT industry.
Certification Topics of 1z1-908 Exam PDF Recently Updated Questions: https://ensurepass.testkingfree.com/Oracle/1z1-908-practice-exam-dumps.html