Attention please! Here is the shortcut to pass your Newest 1z0-908 pdf exam! Get yourself well prepared for the Oracle Database Hotest 1z0-908 practice MySQL 8.0 Database Administrator exam is really a hard job. But don’t worry! We We, provides the most update 1z0-908 vce. With We latest 1z0-908 real exam questions, you’ll pass the Oracle Database Jun 05,2022 Hotest 1z0-908 pdf dumps MySQL 8.0 Database Administrator exam in an easy way
We Geekcert has our own expert team. They selected and published the latest 1z0-908 preparation materials from Official Exam-Center.
The following are the 1z0-908 free dumps. Go through and check the validity and accuracy of our 1z0-908 dumps.We have sample questions for 1z0-908 free dumps. You can download and check the real questions of updated 1z0-908 dumps.
Question 1:
Which three are characteristics of a newly created role? (Choose three.)
A. It can be dropped using the DROP ROLE statement.
B. It is stored in the mysql.role table.
C. It is created as a locked account.
D. It can be renamed using the RENAME ROLE statement.
E. It can be granted to user accounts.
F. It can be protected with a password.
Correct Answer: AEF
Question 2:
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. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb-bbbb-bbbbbbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:110167;
C. RESET SLAVE; SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa–aaaaaaaaaaaa:1-10300;
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;
Correct Answer: D
Question 3:
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_flush_log_at_trx_commit=1
B. buffer_pool_size=24G
C. innodb_log_file_size=1G
D. sync_binlog=0
E. innodb_doublewrite=0
F. max_connections=10000
G. innodb_undo_directory=/dev/shm
Correct Answer: ACF
Reference: https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-foramazon-rds-for-mysql-part-1-parameters-related-to-performance/
Question 4:
Which statement is true about InnoDB persistent index statistics?
A. Updating index statistics is an I/O expensive operation.
B. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
C. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
D. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
E. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
F. Tables are scanned and index statistics recalculated when an instance is restarted.
Correct Answer: D
Reference: https://mariadb.com/kb/en/innodb-persistent-statistics/
Question 5:
Which two are features of MySQL Enterprise Firewall? (Choose two.)
A. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
B. blocking of potential threats by configuring pre-approved whitelists
C. modifying SQL statement dynamically with substitutions
D. automatic locking of user accounts who break your firewall
E. provides stateless firewall access to TCP/3306
Correct Answer: BC
Question 6:
You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of –ssl-mode will do this?
A. PREFERRED
B. VERIFY_CA
C. REQUIRED
D. VERIFY_IDENTITY
Correct Answer: C
Reference: https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/apigateway/10-0/install-configure-upgrade/enable-ssl-connections-for-mysql.html
Question 7:
Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid [root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?
A. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.
B. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.
C. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
D. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.
Correct Answer: C
Question 8:
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
Correct Answer: C
Reference: https://www.ptsecurity.com/ww-en/analytics/knowledge-base/how-to-prevent-sql-injectionattacks/
Question 9:
Examine these entries from the general query log:
All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?
A. Connection 24 experiences a lock wait timeout.
B. Connection 25 experiences a lock wait timeout.
C. A deadlock occurs immediately.
D. All statements execute without error.
E. A deadlock occurs after innodb_lock_wait_timeout seconds.
Correct Answer: E
Question 10:
You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO `user1\’;
How can you proceed with your transaction with the least interruption?
A. Roll back the transaction and start the transaction again in the same session.
B. Re-execute the failed statement in your transaction.
C. Change the default database and re-execute the failed statement in your transaction.
D. Close the connection, reconnect, and start the transaction again.
Correct Answer: B
Question 11:
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. The statement was blocked by MySQL Firewall.
B. John has not activated the role.
C. John needs to reconnect to the database.
D. The DBA needs to execute FLUSH PRIVILEGES.
Correct Answer: B
Question 12:
Which two statements are true about MySQL server multi-source replication? (Choose two.)
A. It is not compatible with auto-positioning.
B. It needs to be re-instanced after a crash to maintain consistency.
C. It uses only time-based replication conflict resolution.
D. It relies on relay_log_recovery for resilient operations.
E. It does not attempt to detect or resolve replication conflicts.
F. It must use GTID replication.
Correct Answer: CF
Question 13:
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)
A. Mark can grant the privileges assigned to the r_read@localhost role to another user.
B. ADMIN OPTION causes the role to be activated by default.
C. Mark can grant the r_read@localhost role to another user.
D. Mark can revoke the r_read@localhost role from another role.
E. ADMIN OPTION allows Mark to drop the role.
F. Mark must connect from localhost to activate the r_read@localhost role.
Correct Answer: AE
Question 14:
Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?
A. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.
B. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.
C. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
D. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM
tablespace.
Correct Answer: C
Reference: https://www.mysql.com/products/enterprise/tde.html
Question 15:
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 defines all innodb tablespace options relative to a starting parent directory.
B. It is not necessary because innodb_data_home_dir is already defined.
C. It allows scanning of other locations to discover more innodb tablespaces.
D. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
E. It adds more temporary workspace in addition to the innodb_tmpdir location.
Correct Answer: B