Assume Oracle 1z1-908 Dumps PDF Are going to be The Best Score
MySQL Database Administration 1z1-908 Exam and Certification Test Engine
NEW QUESTION # 50
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
- A. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
- B. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
- C. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
- D. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
- E. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
Section: (none)
Explanation
Answer: A,E
NEW QUESTION # 51
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. ibbackupfiles
- B. ib_logfile*files
- C. *.CSMfiles
- D. *.sdifiles
- E. *.ibdfiles
Answer: B,E
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/innodb-backup.html
NEW QUESTION # 52
Which two statements are true about the mysqld-auto.cnf file? (Choose two.)
- A. It is read and processed at the beginning of startup configuration.
- B. This file is for storing MySQL server_uuid values only.
- C. This file is for storing MySQL Server configuration options in ISON format.
- D. It is always updated with changes to system variables.
- E. This file is for logging purposes only and is never processed.
- F. It is read and processed at the end of startup configuration.
Answer: D,F
NEW QUESTION # 53
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?
- A. avoiding concatenation of SQL statements and user-supplied values in an application
- B. using PREPARED STATEMENTS
- C. using stored procedures for any database access
- D. installing and configuring the Connection Control plugin
Answer: C
Explanation:
Explanation/Reference: https://www.ptsecurity.com/ww-en/analytics/knowledge-base/how-to-prevent-sql-injection-attacks/
NEW QUESTION # 54
Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)
- A. cluster.forceQuorumUsingPartitionOf()
- B. cluster.setPrimaryInstance()
- C. dba.checkInstanceConfiguration()
- D. dba.createCluster()
- E. dba.configureLocalInstance()
- F. dba.configureInstance()
- G. cluster.addInstance()
Answer: A,B
NEW QUESTION # 55
Which two statements are true about the binary log encryption feature? (Choose two.)
- A. When enabled it encrypts existing binary logs.
- B. It can be set at run time.
- C. It encrypts any connecting slaves connection thread.
- D. It requires a keyring plugin.
- E. It can be activated per session.
Answer: C,E
NEW QUESTION # 56
Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
- A. QN = 1
- B. QN = 4
- C. QN = 2
- D. QN = 3
- E. QN = 5
Answer: A,C
NEW QUESTION # 57
MySQL is installed on a Linux server with this configuration:
Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?
- A. Add default_authentication_plugin=mysql_native_password in the configuration file.
- B. Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.
- C. Add default_authentication_plugin=sha256_password in the configuration file.
- D. Set validate-user-plugins=caching_sha2_password in the configuration file.
Answer: C
NEW QUESTION # 58
Your my.cnf file contains these settings:
You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?
- A. min_examined_row_limit=5000
- B. log_throttle_queries_not_using_indexes=5
- C. log_throttle_queries_not_using_indexes=5
min_examined_ row_limit=5000 - D. long_query_time=5
log_throttle_queries_not_using_indexes=5 - E. long_query_time=5
- F. long_query_time=5
log_throttle_queries_not_using_indexes=5
min_examined_row_limit=5000 - G. long_query_time=5
min_examined_row_limit=5000
Answer: C
NEW QUESTION # 59
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 is not necessary because innodb_data_home_dir is already defined.
- B. It defines all innodb tablespace options relative to a starting parent directory.
- C. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
- D. It adds more temporary workspace in addition to the innodb_tmpdir location.
- E. It allows scanning of other locations to discover more innodb tablespaces.
Answer: E
Explanation:
Explanation
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html
NEW QUESTION # 60
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 decrypts data for use in memory.
- D. It enforces encryption from disk to memory and over network transmission.
- E. It does not support the transportable tablespaces feature.
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/faqs-tablespace-encryption.html
NEW QUESTION # 61
Which two are use cases of MySQL asynchronous replication? (Choose two.)
- A. It allows backup to be done on the slave without impacting the master.
- B. You can scale writes by creating a replicated mesh.
- C. You can scale reads by adding multiple slaves.
- D. It guarantees near real-time replication between a master and a slave.
- E. MySQL Enterprise Backup will automatically back up from an available slave.
Answer: A,C
NEW QUESTION # 62
Which two methods allow a DBA to reset a user's password? (Choose two.)
- A. mysqladmin client program
- B. GRANT statement
- C. mysql_secure_installation utility
- D. SET PASSWORD statement
- E. ALTER USER statement
Answer: D,E
NEW QUESTION # 63
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. The DBA needs to execute FLUSH PRIVILEGES.
- C. John needs to reconnect to the database.
- D. John has not activated the role.
Answer: D
NEW QUESTION # 64
Examine this statement and output:
You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)
- A. QN = 1
- B. QN = 4
- C. QN = 2
- D. QN = 3
- E. QN = 5
Answer: A,C
NEW QUESTION # 65
......
Oracle 1z1-908 Exam comprises of 80 multiple-choice questions that need to be completed within a time frame of 150 minutes. 1z1-908 exam is conducted online and can be taken from anywhere in the world. The candidate needs to score a minimum of 64% to pass the exam and earn the certification. The Oracle 1z1-908 Exam is an ideal certification for IT professionals who want to demonstrate their expertise in MySQL 8.0 database administration and advance their career in this field.
Use 1z1-908 Exam Dumps (2023 PDF Dumps) To Have Reliable 1z1-908 Test Engine: https://torrentking.practicematerial.com/1z1-908-questions-answers.html
