[2022] 1Z0-888 Exam Dumps, Test Engine Practice Test Questions
Pass 1Z0-888 exam [Mar 24, 2022] Updated 155 Questions
MySQL 5.7 Database Administrator
Preparation Guide for Oracle 1z0-888 Certification Exam
Introduction
The MySQL 5.7 Database Administrator Certification Exam certifies the candidate has an understanding of MySQL Database technology. This certificate is also known as Oracle 1z0-888 Exam which is a benchmark for experience and expertise recognized by employers across the globe.
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
NEW QUESTION 77
Consider:
Which statement best describes the meaning of the values in the ref columns?
- A. world.City.CountryCode is used to sort the rows in the City table.
- B. No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.
- C. world.City.CountryCode is used as the primary key for the Country table.
- D. No indexed columns are used to select rows from the Country table. The world.City.CountryCode column is used to select rows in the City table.
Answer: B
NEW QUESTION 78
You want to create the first configuration file for a new installation of MySQL.
- You will start mysqldmanually (not automate it to start when the host machine starts or execute as a service).
- You will stop mysqldusing mysqladmin.
- You will interact with mysqldby using only the command-line client mysql.
Which option identifies a maximal set of sections where you can put the "max_allowed_packet=16M" parameter without creating a problem?
- A. [mysqld] and [mysqladmin]
- B. [mysqladmin]
- C. [mysqld]
- D. [mysql] and [mysqladmin]
- E. [mysql] and [mysqld]
- F. [mysql]
- G. [mysql] and [mysqld] and [mysqladmin]
Answer: F
Explanation:
https://dev.mysql.com/doc/refman/8.0/en/program-variables.html
NEW QUESTION 79
Consider the join_buffer_sizeparameter in MySQL Server.
Which two statements are true about the join buffer? (Choose two.)
- A. The join buffer is global and can be changed only by restarting the server.
- B. The join buffer is used to process sorts when complex joins are being performed.
- C. The join buffer is set per connection.
- D. The value should be increased if the client performs several SELECToperations.
- E. The value should be increased from the default if the query joins large rows without using an index.
Answer: B,E
Explanation:
Explanation/Reference:
NEW QUESTION 80
Which three options are most likely to be changed for production form their default values?
- A. max_connections
- B. character_set_system
- C. innodb_buffer_pool_size
- D. innodb_log_file_size
- E. join_buffer_size
- F. port
- G. max_user_connections
Answer: C,D,F
NEW QUESTION 81
Which MySQL utility copies the master instance to a slave instance on the same host?
- A. mysqlserverclone
- B. mysqlfailover
- C. mysqlrplsync
- D. mysqldbcopy
Answer: A
NEW QUESTION 82
What is the order of tables shown in an EXPLAINoutput?
- A. It lists tables in the order in which their data will be read.
- B. It lists tables from the most optimized to the least optimized.
- C. It lists tables from the smallest to the largest.
- D. It lists tables in the order in which they are specified in the statement that is being explained.
Answer: D
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
NEW QUESTION 83
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 84
A MySQL replication slave is set up as follows:
* Uses all InnoDB tables
* Receives ROW-based binary logs
* Has the read-only option
The replication slave has been found in an error state.
You check the MySQL error log file and find these entries:
What are two possible causes for this error to occur?
- A. For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
- B. The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.
- C. The applications have the SUPER privilege, which allows them to update rows.
- D. The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases >
/data/datA.sql - E. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
Answer: A,D
NEW QUESTION 85
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
Explanation:
Explanation/Reference:
Reference: https://stackoverflow.com/questions/3663515/mysql-what-is-the-key-buffer
NEW QUESTION 86
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. Dateshould be a TIMESTAMPfield for better performance.
- B. The User field is too long for most names.
- C. Using default values for DATETIMEcauses table scans.
- D. No indexes are defined.
- E. The engine type is not appropriate to the application use.
Answer: D,E
NEW QUESTION 87
Which two statements are true regarding the creating of new MySQL physical and logical backups?
- A. Logical backups are human-readable whereas physical backups are not.
- B. Physical backups are usually faster than text backups.
- C. Logical backups are always larger than physical backups.
- D. Physical backups are usually slower than text backups.
- E. Physical backups can be used to recover from data corruption.
Answer: B,E
NEW QUESTION 88
Which are three facts about backups with mysqldump?
- A. will lock all storage engines for duration of backup
- B. allow a consistent backup to be taken
- C. can back up a remote database server
- D. create automatically compressed backups
- E. are always faster to restore than binary backups
- F. are able to back up specific items within a database
Answer: B,C,F
NEW QUESTION 89
After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?
- A. The mysql service has already been started on the same port.
- B. The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
- C. The /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to 127.0.0.1, which is already in use.
- D. You failed to specify the port number 3306 to the command to start the server, so it is defaulting to port
80, which is in use by the built-in web server. - E. The mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.
Answer: E
NEW QUESTION 90
You are using the Performance Schema to investigate replication on a slave which has a single master.
The option slave-parallel-type is set to DATABASE.
Assume that all instruments and consumers are enabled and all threads are instrumented. Which two facts can be concluded from the given output?
- A. THREAD_ID 21 has stopped running.
- B. The slave is configured with slave_parallel_workers = 4
- C. At most, two schemas are being updates concurrently.
- D. The server needs more cores to use all slave threads.
- E. The slave cannot process the relay log fast enough to use all threads.
- F. The salve has two intermediate relay slaves connected to it.
Answer: B,E
NEW QUESTION 91
What are two benefits of using the --tab option with mysqldump? (Choose two.)
- A. It is possible to restore the data in parallel.
- B. It can be piped directly into a running server.
- C. The schema and data are automatically dumped to separate files.
- D. It can be used together with --all-databases.
Answer: A,D
NEW QUESTION 92
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. 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 93
When you examine a new MySQL installation with default configuration, you find a file called ibdata1in the database directory. Which two statements are true about this file? (Choose two.)
- A. it is the default location for all new tables that you create.
- B. it contains the binary log.
- C. it contains a general tablespace.
- D. it contains the system tablespace.
- E. it contains the undo log.
- F. it contains the redo log.
Answer: A,D
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
NEW QUESTION 94
Consider these global status variables:
Which two conclusions can be made from the output? (Choose two.)
- A. All max_connections were in use at 2018-03-22 14:54:06
- B. There are 510 connections to MySQL at the time of the output.
- C. There are 140 Performance Schema threads at the time of the output.
- D. There are more connections being idle than executing queries.
- E. The thread cache has been configured with thread_cache_size set to at least 6.
Answer: B,D
NEW QUESTION 95
Which three allocate memory per thread in MySQL?
- A. sort buffer
- B. thread cache
- C. read buffer
- D. query cache
- E. InnoDB buffer pool instance
- F. internal temporary table
Answer: A,C,E
NEW QUESTION 96
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. Add a second dump for the 'mysql' database; --all-databases does not include it.
- C. Use the --flush-privileges with mysqldump.
- D. After the restore, log in to the database and execute FLUSH PRIVILEGES.
Answer: B
NEW QUESTION 97
You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?
- A. Invoke mysqld with the --initialize option.
- B. Invoke mysql with the --initialize option.
- C. Run the create_system_tables.sql file
- D. Run the mysql_unpack.sql file
Answer: A
Explanation:
Reference: https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization- mysqld.html
NEW QUESTION 98
A master-slave replication setup has the slave showing this error:
On the master server, the binary logs show:
What could explain this error? (Choose two.)
- A. binlog_cache_size=1024 is too small and transactions are lost.
- B. The sync_relay_log=1000 setting on the slave is too small.
- C. sync_binlog=0 and the master server crashed.
- D. binlog_format=STATEMENT and a non-deterministic query was executed.
- E. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.
Answer: A,E
NEW QUESTION 99
Consider:
Which statement best describes the meaning of the value for the key_len column?
- A. It shows the number of characters indexed in the key.
- B. It shows how many bytes will be used from each index row.
- C. It shows how many columns in the index are examined.
- D. It shows the total size of the index row.
Answer: B
NEW QUESTION 100
You are investigating the performance of a query which selects data from an InnoDB table.
Consider this Performance Schema diagnostics output for the query:
Which statement is true about the output?
- A. The query did not find its table in the table definition cache.
- B. The event with event_id = 8945 is a child of the event with event_id=8944.
- C. The query read data from the data file rather than directly from the buffer pool.
- D. The time the query took is the sum of all timer_wait values.
Answer: A
NEW QUESTION 101
......
Oracle 1Z0-888 Real 2022 Braindumps Mock Exam Dumps: https://www.test4engine.com/1Z0-888_exam-latest-braindumps.html
Oracle 1Z0-888 Actual Questions and 100% Cover Real Exam Questions: https://drive.google.com/open?id=1Zh-wzbt6bgMlDCs6qcfzlsWbaGAH3nES