[Nov-2021] Verified Oracle Exam Dumps with 1Z0-888 Exam Study Guide
Best Quality Oracle 1Z0-888 Exam Questions ExamcollectionPass Realistic Practice Exams [2021]
NEW QUESTION 66
You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?
- A. --quick
- B. --tab
- C. --single-transaction
- D. --skip-buffer
Answer: A
NEW QUESTION 67
You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?
- A. gtid_enable
- B. bonlog_format=ROW
- C. apply-log
- D. binlog_format=STATEMENT
- E. log-bin
Answer: E
NEW QUESTION 68
Why should you be selective when granting the PROCESS privilege to an account?
- A. It allows a client to see another user's queries with the SHOW PROCESSLIST command.
- B. It allows a client to process scripts.
- C. It allows the use of stored routines.
- D. It allows a client to control running processes on a server.
Answer: D
NEW QUESTION 69
A MySQL instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.
Which two will optimize the security of this setup? (Choose two.)
- A. disabling connections from named pipes or socket files (depending on the operating system of the server)
- B. starting the server with --bind-address=0.0.0.0 specified
- C. running the server with --skip-networking specified
- D. enabling and using SSL for connections to the MySQL database
- E. limiting logins to originate from the application server or the server's subnet
- F. installing MySQL on the application server, and running the database and application on the same server
Answer: D,F
NEW QUESTION 70
What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)
- A. using SSL when transporting data over remote networks
- B. setting --mysql_secure_configuration to enable paranoid mode
- C. setting specific GRANT privileges to limit remote authentication
- D. setting --skip-networking when remote connections are not required
- E. using the sql_mode=STRICT_SECURE after connections are established for encrypted communications
Answer: A,C,D
NEW QUESTION 71
The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a
.mylogin.cnf file.
Which two are true about the login path feature?
- A. A .mylogin.cnf file can store at most one login path.
- B. It is an alternative to storing the MySQL login details in a my.cnf file.
- C. It provides a FIPS-compliant keyring for storing MySQL login details.
- D. It provides means to help avoid accidentally exposing the MySQL login details.
- E. A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
- F. mysql_config_editor is the only MySQL-provided utility that can print the values stored in
.mylogin.cnf.
Answer: B,D
NEW QUESTION 72
Consider the index information for the dept_emp table in the employee's schema:
Which two conclusions can be made based on the output of the query? (Choose two.)
- A. There is a redundant index on the dept_no column.
- B. The values on the emp_no column must be unique.
- C. There are three indexes on the table.
- D. The secondary indexes are optimized for unique key look-ups.
- E. The selectivity of the dept_no column is the best of the indexed columns.
- F. There is a redundant index on the emp_no column.
Answer: D,F
NEW QUESTION 73
Which two are considered good security practices when using passwords? (Choose two.)
- A. Do not use dictionary-based words.
- B. Use one-way encryption for storage of passwords.
- C. Store passwords external to the database.
- D. Choose short passwords to save on storage space.
- E. Use simple keyboard actions that give mixed letters.
Answer: A,B
Explanation:
Reference: https://stackoverflow.com/questions/14798275/best-way-to-store-passwords-in- mysql-database
NEW QUESTION 74
You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.
Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash? (Choose two.)
- A. CREATE USER WITH sha256_password 'sha256_user'@'192.0.2.10' IDENTIFIED AS 'webdesign' USING 'imbatman';
- B. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS 'imbatman';
- C. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH sha256_password
'imbatman'; - D. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY 'imbatman';
- E. CREATE USER 'webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY
'imbatman'; - F. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY 'iambatman';
Answer: B,F
NEW QUESTION 75
An admin attempts to enforce stronger security by using these commands:
The admin then leaves the system running with the specified changes. What are two remaining security concerns?
- A. The validate_passwordplug-in has not been loaded.
- B. validate_password_policycannot be set without restarting the MySQL instance.
- C. The dictionary file is an insecure location.
- D. The name of the dictionary file is too obvious.
- E. The dictionary file word list is too short.
- F. validate_password_dictionary_filecannot be set without restarting the MySQL instance.
Answer: C,D
NEW QUESTION 76
These details are shown when logged in to an account:
Which set of statements would match the accounts shown?
- A. mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> CREATE USER ''@'' IDENTIFIED BY 'valid_password' WITH PROXY
'employee'@'localhost'; - B. mysql> CREATE USER 'robert'@'localhost' IDENTIFIED BY 'secret_password'; mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
- C. mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost';
- D. mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> GRANT PROXY ON 'employee'@'localhost' TO ''@'';
Answer: D
NEW QUESTION 77
old_alter_tableis disabled as shown.
mysql> SELECT @@old_alter_table;
Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?
- A. All data in p1 and p3 partitions is removed, but the table definition remains unchanged.
- B. Only the first partition (p1) will be dropped because only one partition can be dropped at any time.
- C. All data in p1 and p3 partitions is removed and the table definition is changed.
- D. It results in a syntax error because you cannot specify more than one partition in the same statement.
Answer: A
NEW QUESTION 78
An admin attempts to enforce stronger security by using these commands:
The admin then leaves the system running with the specified changes. What are two remaining security concerns? (Choose two.)
- A. validate_password_dictionary_file cannot be set without restarting the MySQL instance.
- B. The dictionary file is in an insecure location.
- C. The name of the dictionary file is too obvious.
- D. The dictionary file word list is too short.
- E. validate_password_policy cannot be set without restarting the MySQL instance.
- F. The validate_password plug-in has not been loaded.
Answer: B,C
NEW QUESTION 79
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)
- A. master-logging
- B. server-id
- C. log-master-updates
- D. log_bin
- E. enable-master-start
- F. rpl-recovery-rank
Answer: B,D
Explanation:
Explanation/Reference: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql
NEW QUESTION 80
Which two methods accurately monitor the size of your total database size over time? (Choose two.)
- A. monitoring cumulative Innodb_page_size increase
- B. monitoring the innodb_redo_log_size variable
- C. monitoring the information_schema.TABLES table
- D. monitoring the Innodb_rows_inserted status variable
- E. monitoring datadir size in the operating system
- F. monitoring the performance_schema_hosts_size variable
Answer: C,F
NEW QUESTION 81
......
Authentic Best resources for 1Z0-888: https://www.examcollectionpass.com/Oracle/1Z0-888-practice-exam-dumps.html