1Z0-888 Practice Test Questions Updated 155 Questions
Oracle 1Z0-888 Dumps - Secret To Pass in First Attempt
NEW QUESTION 61
What is the best method for monitoring Group Replication conflict resolution?
- A. the INFORMATION_SCHEMAtables
- B. the SHOW STATUScommand
- C. the PERFORMANCE_SCHEMAtables
- D. the SHOW PROCESSLISTcommand
- E. the INNODBLock Monitor details
Answer: C
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/8.0/en/group-replication-monitoring.html
NEW QUESTION 62
Consider the index information for the dept_emptable in the employee's schema:
Which two conclusions can be made based on the output of the query?
- A. The secondary indexes are optimized for unique key look-ups.
- B. There is a redundant index on the dept_nocolumn.
- C. There are three indexes on the table.
- D. The selectivity of the dept_nocolumn is the best of the indexed columns.
- E. The values on the emp_nocolumn must be unique.
- F. There is a redundant index on the emp_nocolumn.
Answer: A,F
NEW QUESTION 63
Consider the table people with this definition:
The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)
- A. Change the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.
- B. Execute ANALYZE TABLE to update the index statistics.
- C. Add FORCE INDEX (Birthday) to the query.
- D. Add a functional index for YEAR(Birthday).
- E. Add a generated column calculating YEAR(Birthday) and index that column.
Answer: A,C
NEW QUESTION 64
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. --tab
- B. --skip-buffer
- C. --single-transaction
- D. --quick
Answer: D
NEW QUESTION 65
You have just created a replication slave from a backup of the master made with mysqldump:
You try to log in to the slave with the application user, but fail as follows:
The login works on the master.
Which two changes to the process can fix the issue?
- A. Use the --grants option to include GRANT statements in the dump.
- B. After the restore, log in to the database and execute FLUSH PRIVILEGES.
- C. Use the --flush-privileges with mysqldump.
- D. Add a second dump for the 'mysql' database; --all-databases does not include it.
Answer: D
NEW QUESTION 66
You are using GTIDSin replication. You need to skip a transaction with the GTIDof aaa-bbb-ccc-ddd- eee:3on a slave.
Which procedure would you execute from a MySQL prompt?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION 67
You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.
Which 2 things should you investigate?
- A. Check the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.
- B. Check the difference between the InnoDB status values "Log Sequence number" and "Last Checkpoint" positions then compare that to the total size of the redo log.
- C. Check the rate of change in the status value Select_scan and compare to the rate of change in Com_select.
- D. Check the difference between the InooDB status values "Trx id counter" and "Purge done for" and compare to the state substatus of the main "Main thread"
- E. Check the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.
Answer: A,B
NEW QUESTION 68
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. Using default values for DATETIME causes table scans.
- D. The engine type is not appropriate to the application use.
- E. No indexes are defined.
Answer: D,E
NEW QUESTION 69
You have been tasked with creating a QA MySQL instance on a DB host, which already has one large instance in /var/lib/mysql/running as the mysqluser. The MySQL configuration file for the existing instance includes:
The default instance was installed using the OS package manager. The latest binaries for both client and server are already in ENV PATH.
The new instance will run as a different user from the existing instance for security purposes.
You create the new data directory successfully and move on to initialize the new DATADIR.
You verify the output to confirm the operation's success:
[mysqlQA@linux /var/lib/]$ mysqld --initialize --datadir=/var/lib/mysql_QA 2>&1 | tail -n3
2018-05-03T12:16:10.928809Z 0 [ERROR] Could not open file '/var/log/mysqld.log' for error logging:
Permission denied
2018-05-03T12:16:10.928841Z 0 [ERROR] Aborting
[mysqlQA@linux /var/lib/]$
The initialization of the instance has failed.
What would you do to enable the initialization to succeed?
- A. Use --no-defaults to ignore the existing config file in the default PATH.
- B. Pass --log-error=/var/lib/mysql_QA/mysqld.log.
- C. Change permissions on /var/log/mysqld.log to allow writes.
- D. Use mysql_install_db.
Answer: D
Explanation:
mysql_install_db handles initialization tasks that must be performed before the MySQL server, mysqld, is ready to use.
Reference: https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
NEW QUESTION 70
You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this? (Choose two.)
- A. Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.
- B. Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.
- C. Start the MySQL Server with -initialize-insecure to force a password reset procedure on the command line.
- D. Start the MySQL Server with --init-file pointing to SQL that executes an ALTER USER statement to change the root user password.
- E. Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
Answer: A,D
NEW QUESTION 71
The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:
Which two options would help avoid the long wait in the future?
- A. Increase the value of the innodb_read_io_threads option.
- B. Change the table to use HASH indexes instead of BTREE indexes.
- C. Increase the size of the InnoDB buffer pool.
- D. Deactivate the query cache.
- E. Increase the value of the innodb_lock_wait_timeout option.
- F. Set the value of innodb_adaptive_hash_index to zero.
Answer: A,C
NEW QUESTION 72
You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.
What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?
- A. to allow for point-in-time recovery on the slave
- B. to allow a backup to be created under reduced load
- C. to prevent schema changes from propagating to the slave before they are validated
- D. to prevent any transaction experiencing a deadlock
- E. to allow the remaining events to be processed on the slave while not receiving new events from the master
Answer: A,B
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 MyISAM tables only.
- B. It caches index blocks for InnoDB tables only.
- C. It caches index blocks for all storage engine tables.
- D. It is a global buffer.
- E. It is set on a per-connection basis.
Answer: A,E
Explanation:
Reference:
https://stackoverflow.com/QUESTION NO:s/3663515/mysql-what-is-the-key-buffer
NEW QUESTION 74
When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?
- A. it contains the redo log.
- B. it contains the system tablespace.
- C. it contains the binary log.
- D. it is the default location for all new tables that you create.
- E. it contains a general tablespace.
- F. it contains the undo log.
Answer: B,D
Explanation:
Reference: https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
NEW QUESTION 75
Which three statements correctly describe MySQL InnoDB Cluster?
- A. The cluster can be operated in multimaster mode with conflict detection for DML statements.
- B. There is support for automatic failover when one node fails.
- C. It provides fully synchronous replication between the nodes.
- D. Each query will be executed in parallel across the nodes.
- E. The data is automatically shared between the nodes.
- F. All MySQL client programs and connectors can be used for executing queries.
Answer: B,D,F
NEW QUESTION 76
......
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.
Oracle 1Z0-888 Exam Dumps [2022] Practice Valid Exam Dumps Question: https://pass4sure.test4cram.com/1Z0-888_real-exam-dumps.html