A Fully Updated 2022 1Z0-888 Exam Dumps - PDF Questions and Testing Engine
Easy Success Oracle 1Z0-888 Exam in First Try
Oracle 1Z0-888 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
NEW QUESTION 83
You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?
- A. apply-log
- B. log-bin
- C. binlog_format=STATEMENT
- D. gtid_enable
- E. bonlog_format=ROW
Answer: B
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/point-in-time-recovery.html
NEW QUESTION 84
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 SSL for a secure connection
- B. using GRANT USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY `secret_password'
- C. using GRANT ... REQUIRE X509 AND REQUIRE ISSUER `/C=.....' AND REQUIRE SUBJECT `/C=.....'
- D. using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY `secret_password'
Answer: C
NEW QUESTION 85
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. After the restore, log in to the database and execute FLUSH PRIVILEGES.
- B. Use the -flush-privileges with mysqldump.
- C. Add a second dump for the `mysql' database; --all-databases does not include it.
- D. Use the -grants option to include GRANT statements in the dump.
Answer: C
NEW QUESTION 86
On a master server that is using statement-based replication, a table of log data has become very large.
You decide to delete 100,000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)
- A. Use the LIMIT clause in conjunction with the ORDER BY clause.
- B. Change the replication mode to MIXED before issuing any delete statements when the LIMIT clause is used.
- C. If the data modification is non-deterministic, the query optimizer will resolve any potential issues.
- D. Use the LIMIT clause to limit the deletion to 100,000 rows.
Answer: A,B
NEW QUESTION 87
What is the best method for monitoring Group Replication conflict resolution?
- A. the INNODBLock Monitor details
- B. the SHOW STATUScommand
- C. the SHOW PROCESSLISTcommand
- D. the PERFORMANCE_SCHEMAtables
- E. the INFORMATION_SCHEMAtables
Answer: D
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/8.0/en/group-replication-monitoring.html
NEW QUESTION 88
A MySQL database uses all InnoDB tables and is configured as follows;
You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this? (Choose two.)
- A. --skip-opt
- B. --master-data
- C. --single-transaction
- D. --create-apply-log
- E. --lock-all-tables
Answer: A,E
NEW QUESTION 89
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 event with event_id = 8945 is a child of the event with event_id=8944.
- B. The time the query took is the sum of all timer_wait values.
- C. The query read data from the data file rather than directly from the buffer pool.
- D. The query did not find its table in the table definition cache.
Answer: D
NEW QUESTION 90
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. 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. - B. The mysql service has already been started on the same port.
- C. 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.
- D. 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. - E. The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
Answer: C
NEW QUESTION 91
You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size.
You start to restore your backup with this command;
shell> mysql -u root -p < backup.sql
After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.
Which is the most likely explanation for this slowdown?
- A. The MySQL server is taking a periodical snapshot of data so it can resume the restore if it is interrupted mid-way.
- B. Secondary indexes no longer fit into the buffer pool.
- C. InnoDB has filled the redo log and now must flush the pages.
- D. InnoDB is doing CRC32 checks over the tablespace data as it grows.
- E. The MySQL server has stopped inserting data to check index consistency.
Answer: E
NEW QUESTION 92
An admin attempts to enforce stronger security by using these commands:
The admin then leaves the system running with the specified changes. What are two remaining security concerns?
- A. The name of the dictionary file is too obvious.
- B. The validate_password plug-in has not been loaded.
- C. validate_password_dictionary_file cannot be set without restarting the MySQL instance.
- D. The dictionary file word list is too short.
- E. validate_password_policy cannot be set without restarting the MySQL instance.
- F. The dictionary file is an insecure location.
Answer: A,F
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?
- A. it contains the binary log.
- B. it contains the redo log.
- C. it contains a general tablespace.
- D. it is the default location for all new tables that you create.
- E. it contains the system tablespace.
- F. it contains the undo log.
Answer: D,E
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
NEW QUESTION 94
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. Using default values for DATETIMEcauses table scans.
- B. Dateshould be a TIMESTAMPfield for better performance.
- C. The engine type is not appropriate to the application use.
- D. The User field is too long for most names.
- E. No indexes are defined.
Answer: C,E
NEW QUESTION 95
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 binary log.
- B. it contains the redo log.
- C. it contains a general tablespace.
- D. it is the default location for all new tables that you create.
- E. it contains the system tablespace.
- F. it contains the undo log.
Answer: D,E
Explanation:
Reference:
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
NEW QUESTION 96
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 with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
- C. Start the MySQL Server with -initialize-insecureto force a password reset procedure on the command line.
- D. Start the MySQL Server with --init-filepointing to SQL that executes an ALTER USER statement to change the root user password.
- E. Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.
Answer: A,D
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html
NEW QUESTION 97
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 a backup to be created under reduced load
- B. to allow the remaining events to be processed on the slave while not receiving new events from the master
- 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 for point-in-time recovery on the slave
Answer: A,E
NEW QUESTION 98
You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?
- A. apply-log
- B. log-bin
- C. binlog_format=STATEMENT
- D. gtid_enable
- E. bonlog_format=ROW
Answer: B
Explanation:
Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/point-in-time- recovery.html
NEW QUESTION 99
After rebooting the host, you attempt to start the mysqldservice. 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 mysqldservice has already been started on the same port.
- B. The mysql.sockfile in the MySQL /tmpdirectory was not removed after the reboot, so mysqldstill thinks there is an active server running.
- C. The network service process in the server is frozen, so all TCP/IPconnections are paused and cannot be reused.
- D. The /etc/hostsfile does not have a valid IP entry for mysqld localhost, so it is binding to
127.0.0.1, which is already in use. - E. You failed to specify the port number 3306to the command to start the server, so it is defaulting to port 80, which is in use by the built-in web server.
Answer: B
NEW QUESTION 100
You are remotely logged in to MySQL as the user "backup".
The account has temporarily been granted full privileges WITH GRANTto perform the actions required.
You want to change the password for the locally existing "backup" user.
Select the three commands which will perform the required action. (Choose three.)
- A. ALTER USER `backup' IDENTIFIED BY `password';
- B. ALTER USER `backup'@'localhost' IDENTIFIED BY `password';
- C. SET PASSWORD = `password';
- D. ALTER USER USER() IDENTIFIED BY `password';
- E. SET PASSWORD FOR `backup'@'localhost' = PASSWORD(`password')
- F. SET PASSWORD FOR `backup'@'localhost' = `password';
- G. CREATE USER `backup'@'localhost' IDENTIFIED BY `password';
Answer: B,D,G
NEW QUESTION 101
A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance?
- A. a file system-level snapshot
- B. an up-to-date replication slave
- C. a backup created with mysqldump --all-databases
- D. a backup created using FLUSH TABLES ... FOR EXPORT
- E. a file system copy created while MySQL was shut down.
Answer: A,C
NEW QUESTION 102
Consider the join_buffer_sizeparameter in MySQL Server.
Which two statements are true about the join buffer?
- A. The value should be increased if the client performs several SELECToperations.
- B. The value should be increased from the default if the query joins large rows without using an index.
- C. The join buffer is set per connection.
- D. The join buffer is global and can be changed only by restarting the server.
- E. The join buffer is used to process sorts when complex joins are being performed.
Answer: B,E
NEW QUESTION 103
What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)
- A. using the sql_mode=STRlCT_SECURE after connections are established for encrypted communications
- B. setting --skip-networking when remote connections are not required
- C. setting specific grant privileges to limit remote authentication
- D. using SSL when transporting data over remote networks
- E. setting --mysql_secure_configuration to enable paranoid mode
Answer: B,C,D
NEW QUESTION 104
Consider the key buffer in a MySQL server. Which two statements are true about this feature?
- A. It is set on a per-connection basis.
- B. It caches index blocks for MyISAM tables only.
- C. It is a global buffer.
- D. It caches index blocks for InnoDB tables only.
- E. It caches index blocks for all storage engine tables.
Answer: A,B
Explanation:
Explanation/Reference:
Reference: https://stackoverflow.com/questions/3663515/mysql-what-is-the-key-buffer
NEW QUESTION 105
Which two are considered good security practices when using passwords? (Choose two.)
- A. Use one-way encryption for storage of passwords.
- B. Use simple keyboard actions that give mixed letters.
- C. Choose short passwords to save on storage space.
- D. Do not use dictionary-based words.
- E. Store passwords external to the database.
Answer: A,D
Explanation:
Reference: https://stackoverflow.com/questions/14798275/best-way-to-store-passwords-in- mysql-database
NEW QUESTION 106
......
1Z0-888 Study Material, Preparation Guide and PDF Download: https://www.prep4sureguide.com/1Z0-888-prep4sure-exam-guide.html
Best 1Z0-888 Exam Dumps for the Preparation of Latest Exam Questions: https://drive.google.com/open?id=1nvTTl3GmPLiRFgEguEgSsgCKhBiUJjQI