Updated Sep-2022 Exam Engine or PDF for the 1Z0-888 Tests Free Updated Today!
Ultimate Guide to Prepare 1Z0-888 with Accurate PDF Questions
Target Audience
The Oracle 1z0-888 Certification Exam is targeted to the candidates having experience of working with MySQL Database technology and looking to pursue a career as an Oracle Certified Professional MySQL 5.7 Database Administrator OCP specialist in the field of MySQL Database technology.
Exam Content
The examination consists of 75 Questions. Candidates should score 58% to clear the examination.
Formats of Question
- Single Response Multiple-choice questions: Only One correct response from the given options best suits the statement or answers the question.
- Multiple Response Multiple-choice questions: Two or More Correct response from the given options best suits the statement or answers the question.
Exam Duration
Candidates will have 120 minutes for attempting 75 questions. So, it becomes important for the candidates to time-box the exam and restrict spending too much time on one question or one topic.
Exam Results
The Oracle 1z0-888 certification is a pass or fail examination and the candidate has to score a minimum of 58% to be termed as pass in the certification exam.
Candidates will receive an email with the result from Oracle within 30 minutes of completing the Certification exam. Exam results are also available on the CertView web portal and the candidate can visit the portal and login to the CertView account to view the exam results and get further details.
For more info visit:
MySQL 5.7 Database Administrator
NEW QUESTION 70
Consider the join_buffer_sizeparameter in MySQL Server.
Which two statements are true about the join buffer? (Choose two.)
- A. The join buffer is used to process sorts when complex joins are being performed.
- B. The join buffer is global and can be changed only by restarting the server.
- C. The value should be increased from the default if the query joins large rows without using an index.
- D. The value should be increased if the client performs several SELECToperations.
- E. The join buffer is set per connection.
Answer: A,C
NEW QUESTION 71
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?
- A. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY
'imbatman'; - B. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH
sha256_password 'imbatman'; - C. CREATE USER 'webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY 'imbatman';
- D. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY 'iambatman';
- E. CREATE USER WITH sha256_password 'sha256_user'@'192.0.2.10' IDENTIFIED AS
' webdesign' USING 'imbatman'; - F. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS 'imbatman';
Answer: D,F
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
NEW QUESTION 72
You want to create a temporary table named OLD_INVENTORYin the OLD_INVENTORYdatabase on the master server. This table is not to be replicated to the slave server.
Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)
- A. Use the --replicate-ignore-tableoption with the value equal to
OLD_INVENTORY.OLD_INVENTORYand restart mysqldbefore creating the temporary table. - B. Set binlog_format=MIXED with the --replicate-ignore-temp-table option.
- C. Stop SQL_THREADon the slave until you have finished using the OLD_INVENTORYtemporary table.
- D. Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.
- E. Change the binlog_formatoption to ROW and restart mysqld before you create the OLD_INVENTORYtable.
Answer: A,D
NEW QUESTION 73
Consider the key buffer in a MySQL server. Which two statements are true about this feature?
- A. It caches index blocks for InnoDB tables only.
- B. It is set on a per-connection basis.
- C. It is a global buffer.
- D. It caches index blocks for MyISAM tables only.
- E. It caches index blocks for all storage engine tables.
Answer: B,D
Explanation:
Explanation/Reference:
Reference: https://stackoverflow.com/questions/3663515/mysql-what-is-the-key-buffer
NEW QUESTION 74
You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)
- A. Ensure that none of the attached slaves are using any of the binary logs you want to delete.
- B. Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.
- C. Remove all of the binary log files that have a modification date earlier than today.
- D. Execute the PURGE BINARY LOGS NOT USED command.
- E. Edit the .index file to remove the files you want to delete.
Answer: A,B
Explanation:
A: To safely purge binary log files, follow this procedure:
1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading.
2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS.
3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up to date, this is the last log file on the list.
4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
5. Purge all log files up to but not including the target file.
Syntax:
PURGE { BINARY | MASTER } LOGS
{ TO `log_name' | BEFORE datetime_expr }
NEW QUESTION 75
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 'employee'@'localhost' IDENTIFIED BY 'more_secrets';mysql> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost';
- C. 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 ''@'';
- D. mysql> CREATE USER 'robert'@'localhost' IDENTIFIED BY 'secret_password';mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
Answer: C
NEW QUESTION 76
You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:
What would you run to fix the issue?
- A. the mysql_upgrade script
- B. the mysql client with the --enable-cleartext-plugin option
- C. the install plugin command for the mysql_cleartext_password plugin
- D. the mysql_secure_installation script to update server security settings
- E. the mysql client with the --ignore-password-hashing option
Answer: D
NEW QUESTION 77
A crucial database, `db_prod', just disappeared from your production MySQL instance. In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you identified this command from a customer facing application:
SELECT id FROM users WHERE login='payback!';DROP DATABASE db_prod;' Which three methods could have been used to prevent this SQL injection attack from happening?
- A. giving limited privileges to accounts used by application servers to interact with their backing databases
- B. using a hashing or encryption method to secure all user passwords in your MySQL tables
- C. removing any remaining anonymous accounts from your MySQL instance
- D. validating all user input before sending it to the database server
- E. using SSL/TLS on your outward facing web servers (https://) to encrypt all user sessions
- F. changing all passwords for the MySQL account `root'@'%' immediately after losing an employee who knew the current password
- G. writing your client code to properly escape all user input
Answer: B,C,F
NEW QUESTION 78
Which statement best describes a "warm" backup?
- A. It only backs up "warm" data, that is, data that has been recently modified.
- B. It is similar to a "hot" backup, but differs in that it does not permit write operations.
- C. It is similar to a "cold" backup, but differs in that it permits write operations.
- D. It backs up the binary log, which contains the most recent "warm" changes.
Answer: A
Explanation:
A warm backup site is already stocked with hardware representing a reasonable facsimile of that found in your data center. To restore service, the last backups from your off-site storage facility must be delivered, and bare metal restoration completed, before the real work of recovery can begin.
https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/4/html/ introduction_to_system_administration/s2-disaster-recovery-sites
NEW QUESTION 79
Which two are considered good security practices when using passwords? (Choose two.)
- A. Choose short passwords to save on storage space.
- B. Use simple keyboard actions that give mixed letters.
- C. Use one-way encryption for storage of passwords.
- D. Do not use dictionary-based words.
- E. Store passwords external to the database.
Answer: C,D
NEW QUESTION 80
After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:
What are the two most likely reasons for the slowness given this output? (Choose two.)
- A. The User field is too long for most names.
- B. No indexes are defined.
- C. The engine type is not appropriate to the application use.
- D. Date should be a TIMESTAMP field for better performance.
- E. Using default values for DATETIME causes table scans.
Answer: B,C
NEW QUESTION 81
Which two statements are true about InnoDB auto-increment locking? (Choose two.)
- A. InnoDB never uses table-level locks.
- B. Some settings for innodb_autoinc_lock_mode can help reduce locking.
- C. InnoDB always protects auto-increment updates with a table-level lock
- D. InnoDB does not use locks to enforce auto-increment uniqueness.
- E. The auto-increment lock can be a table-level lock.
Answer: B,E
NEW QUESTION 82
Suppose you are adding rows to a MyISAM table and the --datadirlocation runs out of disk space.
What will happen when this occurs?
- A. An error message will be returned to the client .Server Error: ER_IO
- B. The server suspends that INSERT operation until space becomes available.
- C. The server suspends operations for all storage engines until space becomes available.
- D. The server will crash.
Answer: B
NEW QUESTION 83
Which statement is correct about how InnoDB storage engine uses disk space?
- A. It stores data in .MYD files, index information in .MYI files, and undo information in the common tablespace.
- B. It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.
- C. It stores its data, index and undo information in .MYD and .MYI files.
- D. It stores data, index and undo information in tablespace file(s).
- E. It stores data in .MYD files and its index and undo information in the common tablespace.
Answer: D
NEW QUESTION 84
The Performance Schema includes these tables related to status variables:
Which two facts are true about these tables? (Choose two.)
- A. The variable values in global_statusare the sum of those in status_by_threadgrouped by the variable name.
- B. The global_statustable is equivalent to the SHOW GLOBAL STATUSstatement.
- C. The variable values in status_by_accountare the sum of those in status_by_hostand status_by_user grouped by the variable name.
- D. All these tables have the same number of rows.
- E. The session_statustable is equivalent to status_by_threadfor the current thread.
Answer: C,E
NEW QUESTION 85
......
Pass Oracle With PracticeDump Exam Dumps: https://testking.practicedump.com/1Z0-888-exam-questions.html