Oracle 1Z0-888 Real Exam Questions Test Engine Dumps Training With 155 Questions
1Z0-888 Actual Questions Answers PDF 100% Cover Real Exam Questions
NEW QUESTION 83
Which statement is true about tablespaces?
- A. All tablespace files must be in the directory specified by the -datadir option.
- B. General tablespaces can be configured to span multiple files.
- C. The system tablespace can be configured to span multiple files.
- D. All tables must be in either the system tablespace or a general tablespace.
Answer: D
Explanation:
https://dev.mysql.com/doc/refman/8.0/en/general-tablespaces.html
NEW QUESTION 84
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. The secondary indexes are optimized for unique key look-ups.
- B. There are three indexes on the table.
- C. There is a redundant index on the dept_no column.
- D. The selectivity of the dept_no column is the best of the indexed columns.
- E. There is a redundant index on the emp_no column.
- F. The values on the emp_no column must be unique.
Answer: A,E
NEW QUESTION 85
You have installed MySQL on Oracle Linux 7 using the official RPM distribution, and SELinux is set to
"permissive".
Examine this extract of the my.cnf file:
You issue this command to start MySQL Server:
systemctl start mysqld@replica
On which port is the server listening?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION 86
What is the best method for monitoring Group Replication conflict resolution?
- A. the SHOW STATUS command
- B. the SHOW PROCESSLIST command
- C. the INFORMATION_SCHEMA tables
- D. the INNODB Lock Monitor details
- E. the PERFORMANCE_SCHEMA tables
Answer: E
NEW QUESTION 87
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 88
Consider:
What does the range value in the type column mean?
- A. There is a range of indexes that can be used.
- B. You can use an index and return rows that fall within a range of values.
- C. The table will be scanned over a certain range of values.
- D. This type of index uses the range hash.
Answer: D
NEW QUESTION 89
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. Edit the .index file to remove the files you want to delete.
- B. Execute the PURGE BINARY LOGS NOT USED command.
- C. Remove all of the binary log files that have a modification date earlier than today.
- D. Ensure that none of the attached slaves are using any of the binary logs you want to delete.
- E. Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.
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 }
Answer: D,E
NEW QUESTION 90
You have created a backup of the 'sales' database with the command:
Which two procedures can be used to restore the 'orders' table from the backup?
- A.
- B.
- C.
- D.
Answer: A,C
NEW QUESTION 91
Which statement is correct about how InnoDB storage engine uses disk space?
- A. It stores data, index and undo information in tablespace file(s).
- B. It stores its data, index and undo information in .MYD and .MYI files.
- C. It stores data in .MYD files, index information in .MYI files, and undo information in the common tablespace.
- D. It stores data in .MYD files and its index and undo information in the common tablespace.
- E. It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.
Answer: A
NEW QUESTION 92
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 93
A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:
You execute a 'SHOW CREATE TABLE mytable" on the slave:
The table mytable on the slave contains:
You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?
- A. SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";
- B. SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";
BEGIN; COMMIT;
SET GTID_NEXT="AUTOMATIC"; - C. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
- D. SET GLOBAL enforce_gtid_consistency=ON
- E. SET GTID_NEXT="CONSISTENCY";
BEGIN; COMMIT;
SET GTID_NEXT="AUTOMATIC";
Answer: C
NEW QUESTION 94
You have a config file for a running DB with this excerpt:
[mysqld]
tmp_table_size=16M
sort_buffer_size=256k
To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:
mysql> SET GLOBAL tmp_table_size=32000000;
mysql> SET sort_buffer_size=2000000;
This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.
Which three best describe this scenario? (Choose three.)
- A. The query benefited from tmp_table_size increase.
- B. The query benefited from sort_buffer_size increase.
- C. Session variables are not persistent across server restarts.
- D. Global variables are not persistent across server restarts.
- E. The query benefited from sort_buffer_size and tmp_table_size increases.
- F. sort_buffer_size should match tmp_table_size to be optimal.
Answer: A,B,C
NEW QUESTION 95
You have a MySQL instance with the following variables in the /etc/my.cnf file:
You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)
- A. The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW
- B. Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.
- C. Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.
- D. You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.
- E. The statement would fail because you cannot update more than one row at a time when using -binlogformat = ROW.
Answer: B,C
NEW QUESTION 96
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 97
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 98
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-typeis 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? (Choose two.)
- A. THREAD_ID 21has stopped running.
- B. At most, two schemas are being updates concurrently.
- C. The slave is configured with slave_parallel_workers= 4
- 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: C,E
NEW QUESTION 99
You have installed the validate_passwordplug-in and set the validate_password_policyvariable.
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
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
NEW QUESTION 100
......
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.
Test4Cram 1Z0-888 Exam Practice Test Questions: https://www.test4cram.com/1Z0-888_real-exam-dumps.html
1Z0-888 Exam questions and answers: https://drive.google.com/open?id=1E8O2akmJVRZUKm-S9JmX6t01scORkbvP