Pass Your MySQL Database Administration 1Z0-888 Exam Easily with Accurate PDF Questions [Feb 26, 2022]
1Z0-888 Certification Exam Dumps Questions in here
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.
Brief Details
Following are the quick details related to the Oracle 1z0-888 Certification Exam
Exam Code: 1z0-888
Exam Price: $245 (USD) Price may vary for a country based on the localized currency rates
Duration: 120 minutes
Exam Name: MySQL 5.7 Database Administrator
Exam Voucher: Candidates can purchase the exam vouchers on Oracle Education Portal. Voucher is valid for 6 months from the date of issue and is like a gift voucher which will get forfeited if not used within 6 months.
Exam type: Multiple Choice Questions
Pass Score: 58%
Exam Mode: Online Proctored Exam. Candidates can take the examination from any place at any time as per their convenience. Candidates also have the option to give exams at any of the authorized training centers. Candidates can select the exam mode based on their convenience at the time of registration.
Exam Registration: Candidates willing to appear for the exam have to purchase the exam voucher. Post purchasing the voucher, the candidate can register for the examination on Oracle Education Portal
NEW QUESTION 55
The InnoDB tablespace is corrupted and you start the server with option --innodb_force_recover=4.
Which backup method would you use to reload the corrupted InnoDB tables?
- A. A text backup. InnoDB does not allow you to make binary backups while the server is running.
- B. A text backup. A binary backup will still contain the corrupted segments.
- C. a binary backup taken with MySQL Enterprise Backup that can back up even corrupted tables
- D. a binary backup that uses transportable tablespaces and allows you to reload a corrupted table
Answer: A
Explanation:
An innodb_force_recovery setting of 4 or greater places InnoDB in read-only mode.
Reference: https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
NEW QUESTION 56
Which two statements describe how InnoDB recovery works?
- A. There will in general be lost committed transactions after a crash using the default settings.
- B. It is required to enable binlog_gtid_simple_recovery to perform a crash recovery.
- C. It is always required to enable innodb_force_recovery to perform a crash recovery.
- D. It is recommended to set innodb_force_recovery = 1 as part of normal operations.
- E. InnoDB blocks some operations when innodb_force_recovery is set to greater than 0.
- F. InnoDB handles most crash recoveries automatically.
Answer: C,E
NEW QUESTION 57
The 'applicationdb' is using InnoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.
You investigate and gather this information:
* The table data_current has 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archive has 4,500,000 rows.
Three tables are stored in the InnoDB shared tablespace and the details are as follows:
You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storing it on your backup partition.
Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?
- A. Execute OPTIMIZE TABLE so that the InnoDB engine frees unused pages on disk back to the file system:
- B. Take a backup, stop the server, remove the data files, and restore the backup:
- C. Set the server to use its own tablespace, and then alter the table so that data is moved from the shared tablespace to its own:
- D. Enable compression on the table, causing InnoDB to release unused pages on disk to the file system:
Answer: D
NEW QUESTION 58
You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema.
* Total dataset size is 200G with an average schema size of 2G.
* The data is transient and is not backed up and can be repopulated easily.
* Performance and responsiveness of the DB is paramount.
* The query pattern for the DB instance is split 90/10 read/write.
* DB host is dedicated server with 256G RAM and 64 cores.
One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.
Which four configuration file edits might your colleague have performed to cause the negative DB performance? (Choose four.)
- A. innodb_flush_method=O_DIRECT
- B. Innodb_flush_log_at_trx_commit=1
- C. query_cache_size = 2G
query_cache_enabled=1 - D. sync_binlog=10
- E. table_open_cache = 64
innodb_buffer_pool_instances=64 - F. innodb_buffer_pool_size=200G
log_bin=mysql -bin - G. max_heap_table_size = 2G
tmp_table_size=2G - H. innodb_flush_log_at_trx_commit=0
Answer: A,C,E,F
NEW QUESTION 59
The Performance Schema includes these tables related to status variables:
Which two facts are true about these tables? (Choose two.)
- A. All these tables have the same number of rows.
- B. The variable values in global_status are the sum of those in status_by_thread grouped by the variable name.
- C. The global_status table is equivalent to the SHOW GLOBAL STATUS statement.
- D. The session_status table is equivalent to status_by_thread for the current thread.
- E. The variable values in status_by_account are the sum of those in status_by_host and status_by_user grouped by the variable name.
Answer: D,E
NEW QUESTION 60
Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysqlclient to connect to the server and send clear text passwords?
- A. INSTALL PLUGIN mysql_cleartext_password SONAME
'mysql_cleartext_password.so'; - B. SET GLOBAL mysql_cleartext_passwords=1;
- C. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'
- D. mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com
- E. mysql --protocol=PLAIN -uroot -p -h dbhost.example.com
Answer: B,D
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
NEW QUESTION 61
An employee cannot access the company database. You check the connection variables:
A look at the user privileges shows:
What is a valid explanation for why one of the users is unable to connect to the database?
- A. Joe has exceeded the max_user_connections global limit.
- B. connect_timeout is too small to allow a connection to occur.
- C. All users are blocked because max_user_connections is accumulated over the host account information.
- D. Kay is already connected elsewhere and attempting to log in again.
- E. Bob has max_user_connections set to zero, which blocks all his connections.
Answer: A
NEW QUESTION 62
The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO 'webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO 'webadmin'@'%';
A user successfully connects to the database as webadmin and created a stored procedure named get_reports.
The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?
- A. The user will get an error because he or she does not have the permission to drop stored procedures.
- B. The stored procedure named get_reports will be dropped.
- C. The user will get an error because he or she did not put the database name in front of the stored procedure name.
- D. The user will get an error because he or she did not use the ALTER statement to drop the stored procedure.
Answer: B
NEW QUESTION 63
A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?
- A. using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY `secret_password'
- B. using GRANT ... REQUIRE X509 AND REQUIRE ISSUER `/C=.....' AND REQUIRE SUBJECT `/C=.....'
- C. using GRANT USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY `secret_password'
- D. using GRANT ... REQUIRE SSL for a secure connection
Answer: B
NEW QUESTION 64
A MySQL instance has this configuration values set:
A transaction involving a single InnoDB INSERTstatement commits.
Which list of locations is in the sequence of disk writes for this transaction?
- A. redo log, binary log, doublewrite buffer, and tablespace
- B. doublewrite buffer, redo log, tablespace, and binary log
- C. redo log, doublewrite buffer, tablespace, and binary log
- D. binary log, redo log, doublewrite buffer, and tablespace
Answer: D
NEW QUESTION 65
Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)
- A. It is a global buffer.
- B. It caches index blocks for all storage engine tables.
- C. It caches index blocks for MyISAM tables only.
- D. It caches index blocks for InnoDB tables only.
- E. It is set on a per-connection basis.
Answer: C,E
NEW QUESTION 66
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 AS sha256_user WITH sha256_password 'imbatman';
- C. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY 'iambatman';
- D. CREATE USER 'webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY 'imbatman';
- E. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS 'imbatman';
- F. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY 'imbatman';
Answer: C,E
NEW QUESTION 67
You have installed the validate_password plug-in and set the validate_password_policy variable.
Which validation is affected by the validate_password_policy setting?
- A. the amount of delay after an incorrect password is entered
- B. whether a new password is rejected if it contains a word found in a dictionary file.
- C. whether a new password is rejected if it contains the current user's username.
- D. the length of time before a newly created password expires
Answer: B
NEW QUESTION 68
What does the Performance Schema provide?
- A. insight into the internal working of MySQL
- B. recommendations for schema changes
- C. auto-tuning based on settings and ongoing workload
- D. a text-based version of MySQL Enterprise Monitor
Answer: A
Explanation:
https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html
NEW QUESTION 69
How does the InnoDB storage engine handle deadlocks when they are detected?
- A. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
- B. The transaction isolation level determines which transaction is rolled back.
- C. Both the affected transactions will be rolled back.
- D. One of the affected transactions will be rolled back, the other is allowed to proceed.
- E. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.
Answer: D
NEW QUESTION 70
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data.
The SHOW SLAVE STATUSindicates these values:
RELAY_LOG_FILE=hostname-relay-bin.00004
RELAY_LOG_POS=1383
Which command set would make the slave current?
- A. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
- B. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
- C. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;
- D. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = 'hostname- relay-bin.00004', RELAY_LOG_POS = 1383;
Answer: B
NEW QUESTION 71
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?
- A. rpl-recovery-rank
- B. server-id
- C. log_bin
- D. enable-master-start
- E. log-master-updates
- F. master-logging
Answer: B,C
Explanation:
Explanation/Reference:
Reference: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in- mysql
NEW QUESTION 72
Examine the mysqldumpslow output:
Which two options could explain the slow query?
- A. A full table scan is being used.
- B. No index has been defined on the filtered column.
- C. There are 108 queries still being executed.
- D. A table lock is causing delays.
- E. There is network congestion between client and server.
Answer: A,E
NEW QUESTION 73
Examine the mydata table and SELECT statements:
You issue:
mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?
- A. one
- B. one row and a next-key lock for supremum
- C. five
- D. one row and a gap-lock
Answer: C
NEW QUESTION 74
A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?
- A. using GRANT ... REQUIRE X509 AND REQUIRE ISSUER '/C=.....' AND REQUIRE SUBJECT '/C=.....'
- B. using GRANT USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY 'secret_password'
- C. using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY 'secret_password'
- D. using GRANT ... REQUIRE SSL for a secure connection
Answer: A
NEW QUESTION 75
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. enabling and using SSL for connections to the MySQL database
- B. starting the server with --bind-address=0.0.0.0 specified
- C. disabling connections from named pipes or socket files (depending on the operating system of the server)
- D. installing MySQL on the application server, and running the database and application on the same server
- E. running the server with --skip-networking specified
- F. limiting logins to originate from the application server or the server's subnet
Answer: A,D
NEW QUESTION 76
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?
- A. The User field is too long for most names.
- B. Date should be a TIMESTAMP field for better performance.
- C. No indexes are defined.
- D. Using default values for DATETIME causes table scans.
- E. The engine type is not appropriate to the application use.
Answer: C,E
NEW QUESTION 77
......
Aim of the Certificate Exam
The certification exam is designed to help the candidate excel and command his future progression. It is designed to
- Provide individuals with a mark of excellence that is extremely recognized by the clients and seeks within across the industries
- Empower individuals to execute tasks with confidence and skill
- Differentiate individual in a crowded job market
Verified 1Z0-888 dumps Q&As 100% Pass in First Attempt Guaranteed Updated Dump: https://drive.google.com/open?id=1U-W6YG8vyaeQ0-dZolcnSqyM_MRS0VLP
Updated 1Z0-888 Exam Practice Test Questions: https://www.passleadervce.com/MySQL-Database-Administration/reliable-1Z0-888-exam-learning-guide.html