1z1-908 Practice Exam and Study Guides - Verified By ActualTestsIT Updated 86 Questions
2021 Updated Verified Pass 1z1-908 Study Guides & Best Courses
NEW QUESTION 35
You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?
- A. Use a text editor to create a new defaults file and encrypt it from Linux prompt.
- B. Use mysql_secure_installation to encrypt stored login credentials.
- C. Use mysql_config_editor to create an encrypted file.
- D. Use the AES_ENCRYPT() MySQL function on the option file.
Answer: C
NEW QUESTION 36
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 email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
'secret');--'; - C. SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';
- D. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
- E. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
- F. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
Answer: B,E
NEW QUESTION 37
You want to check the values of the sort_buffer_sizesession variables of all existing connections.
Which performance_schematable can you query?
- A. global_variables
- B. variables_by_thread
- C. session_variables
- D. user_variables_by_thread
Answer: C
Explanation:
Explanation/Reference: https://dev.mysql.com/worklog/task/?id=6629
NEW QUESTION 38
Which three statements are true about MySQL replication? (Choose three.)
- A. Any instance can have multiple slaves, but it can have only one master.
- B. Each slave must have its own MySQL user for replication.
- C. Binary logs contain only transactions originating from a single MySQL instance.
- D. Each instance in a replication topology must have a unique server ID.
- E. Replication can use only TCP/IP connections.
- F. A replication user must have the SELECT privilege for all tables that need to be replicated.
- G. Binary logging must be enabled on the master in order to replicate to other instances.
Answer: D,F,G
NEW QUESTION 39
Examine the modified output:
Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)
- A. This value shows only I/O latency and is not indicative of the size of the transaction queue.
- B. The master is producing a large volume of events in parallel but the slave is processing them serially.
- C. One or more large tables do not have primary keys.
- D. The parallel slave threads are experiencing lock contention.
- E. The master is most probably too busy to transmit data and the slave needs to wait for more data.
Answer: A,B
NEW QUESTION 40
A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user's mysql credentials to satisfy this requirement? (Choose three.)
- A. /etc/my.cnf file
- B. $HOME/.mysql/auth/login file
- C. $HOME/.my.cnf file
- D. $HOME/.mysqlrc file
- E. DATADIR/mysqld-auto.cnf file
- F. $HOME/.mylogin.cnf file
- G. $MYSQL_HOME/my.cnf file
Answer: A,E,G
NEW QUESTION 41
Which two are use cases of MySQL asynchronous replication? (Choose two.)
- A. It guarantees near real-time replication between a master and a slave.
- B. You can scale writes by creating a replicated mesh.
- C. It allows backup to be done on the slave without impacting the master.
- D. You can scale reads by adding multiple slaves.
- E. MySQL Enterprise Backup will automatically back up from an available slave.
Answer: C,D
NEW QUESTION 42
t is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN;
SELECT * FROM t FOR UPDATE;
Which is true?
- A. If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.
- B. mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.
- C. If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.
- D. If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.
Answer: D
NEW QUESTION 43
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 moves all innodb tablespaces to the /innodb_extrasdirectory to enable a new innodb_data_home_dirto be defined.
- C. It adds more temporary workspace in addition to the innodb_tmpdirlocation.
- D. It is not necessary because innodb_data_home_diris already defined.
- E. It allows scanning of other locations to discover more innodb tablespaces.
Answer: D
NEW QUESTION 44
Which two are features of MySQL Enterprise Firewall? (Choose two.)
- A. blocking of potential threats by configuring pre-approved whitelists
- B. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
- C. automatic locking of user accounts who break your firewall
- D. modifying SQL statement dynamically with substitutions
- E. provides stateless firewall access to TCP/3306
Answer: A,D
NEW QUESTION 45
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_undo_directory=/dev/shm
- B. sync_binlog=0
- C. buffer_pool_size=24G
- D. max_connections=10000
- E. innodb_flush_log_at_trx_commit=1
- F. innodb_log_file_size=1G
- G. innodb_doublewrite=0
Answer: D,E,F
NEW QUESTION 46
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. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.
- B. MySQL server continued to start up even though another process existed.
- 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: A
NEW QUESTION 47
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
- A. /usr
- B. /var/lib/mysql
- C. /usr/mysql
- D. /etc/my.cnf
- E. /usr/bin
Answer: E
NEW QUESTION 48
Which four are types of information stored in the MySQL data dictionary? (Choose four.)
- A. performance metrics
- B. table definitions
- C. server configuration rollback
- D. InnoDB buffer pool LRU management data
- E. stored procedure definitions
- F. access control lists
- G. view definitions
- H. server runtime configuration
Answer: B,C,E,G
NEW QUESTION 49
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)
- A. It decrypts data for use in memory.
- B. It supports only non-blob datatypes.
- C. It supports all indexes transparently.
- D. It enforces encryption from disk to memory and over network transmission.
- E. It does not support the transportable tablespaces feature.
Answer: A,C
NEW QUESTION 50
Which command enables rule-based MySQL Auditing capabilities?
- A. shell> mysqld --initialize --log-raw=audit.log
- B. shell> mysql < audit_log_filter_linux_install.sql
- C. mysql> INSTALL COMPONENT audit_log;
- D. mysql> INSTALL PLUGIN audit_log;
Answer: B
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/audit-log-filtering.html
NEW QUESTION 51
......
How much Oracle 1Z0-908: MySQL 8.0 Database Exam Cost
The price of the Oracle 1Z0-908 Exam is USD 245, for more information related to the Oracle 1Z0-908 Exam please visit Oracle website.
Ultimate Guide to the 1z1-908 - Latest Edition Available Now: https://www.actualtestsit.com/Oracle/1z1-908-exam-prep-dumps.html
2021 Updated Verified Pass 1z1-908 Exam - Real Questions & Answers: https://drive.google.com/open?id=1NKVm-r7oH9Md7L-5q0sJvtUpvbNX9frm