[UPDATED 2022] Oracle 1Z0-888 Questions Prepare with Free Demo of PDF
NEW 2022 Certification Sample Questions 1Z0-888 Dumps & Practice Exam
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.
NEW QUESTION 24
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)
- 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 25
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 mysql client to connect to the server and send clear text passwords?
(Choose two.)
- A. SET GLOBAL mysql_cleartext_passwords=1;
- B. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'
- C. mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com
- D. mysql --protocol=PLAIN -uroot -p -h dbhost.example.com
- E. INSTALL PLUGIN mysql_cleartext_password SONAME 'mysql_cleartext_password.so';
Answer: A,C
NEW QUESTION 26
A crucial database, 'db_prod', just disappeared from your production MySQL instance.
In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you identified this command from a customer facing application:
SELECT id FROM users WHERE login='payback!';DROP DATABASE db_prod;'
Which three methods could have been used to prevent this SQL injection attack from happening?
- A. using SSL/TLS on your outward facing web servers (https://) to encrypt all user sessions
- B. validating all user input before sending it to the database server
- C. changing all passwords for the MySQL account 'root'@'%'immediately after losing an employee who knew the current password
- D. removing any remaining anonymous accounts from your MySQL instance
- E. using a hashing or encryption method to secure all user passwords in your MySQL tables
- F. giving limited privileges to accounts used by application servers to interact with their backing databases
- G. writing your client code to properly escape all user input
Answer: C,D,E
NEW QUESTION 27
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 28
This output is from a SHOW SLAVE STATUS:
What would cause the SQL_Delay variable to have a value of 360?
- A. The master has performed a large transaction, which will take 360 seconds to complete on the slave.
- B. The slave was configured for delayed replication with a delay of six minutes.
- C. The network latency between the master and the slave is 360 milliseconds.
- D. The slave will need an estimated 360 seconds to update the remaining contents from the relay log.
Answer: B
NEW QUESTION 29
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_connectionsglobal limit.
- B. All users are blocked because max_user_connectionsis accumulated over the host account information.
- C. connect_timeout is too small to allow a connection to occur.
- D. Kay is already connected elsewhere and attempting to log in again.
- E. Bob has max_user_connectionsset to zero, which blocks all his connections.
Answer: A
NEW QUESTION 30
Host slave1 has ip address 192.0.2.10.
Host slave2 has ip address 203.0.113.50
Examine these commands:
Why did this error occur?
- A. The mysqld instance has not been restarted after creating the login path.
- B. There is no password defined in the login path.
- C. The .mylogin.cnf file is not readable.
- D. The DNS is not configured correctly for slave1 host.
- E. The host on the command line is not defined in the login path.
Answer: C
NEW QUESTION 31
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 32
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.
Answer: D,E
Explanation:
Explanation
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 }
NEW QUESTION 33
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 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:
Reference:
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
NEW QUESTION 34
Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?
- A. setting the --open-files-limit=0 option when starting mysqld
- B. executing REVOKE FILE FROM *_*
- C. executing REVOKE FILE ON *_* FROM ` `@'%'
- D. executing REVOKE LOAD FROM *.*
- E. setting the --local-service=0 option when starting mysqld
- F. setting the --local-infile=0 option when starting mysqld
Answer: A
NEW QUESTION 35
You created a backup of the worlddatabase with this command:
shell> mysqldump --opt world > dump.sql
Which two will import the data from dump.sql? (Choose two.)
- A. shell> mysql test < dump.sql
- B. mysql> USE test; mysql> LOAD DATA INFILE 'dump.sql';
- C. shell> mysqladmin recover test dump.sql
- D. mysql>USE test; mysql>SOURCE dump.sql;
- E. shell> mysqlimport test dump.sql
Answer: B,E
Explanation:
Explanation/Reference:
NEW QUESTION 36
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?
- A. --master-data
- B. --skip-opt
- C. --single-transaction
- D. --lock-all-tables
- E. --create-apply-log
Answer: B,D
NEW QUESTION 37
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. 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. - 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 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 38
Consider the ANALYZE TABLE command.
In which two situations should this command be used?
- A. when you need to find out why a query is taking a long time to execute
- B. after large amounts of table data have changed
- C. when you want to check a tables structure to see if it may have been damaged and needs repair
- D. when you want to update index distribution statistics
Answer: B,D
NEW QUESTION 39
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 webadminand created a stored procedure named get_reports.The next day, the user logs in again as webadminand 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 user will get an error because he or she did not use the ALTERstatement to drop the stored procedure.
- C. The stored procedure named get_reportswill be dropped.
- D. The user will get an error because he or she did not put the database name in front of the stored procedure name.
Answer: C
NEW QUESTION 40
An employee cannot access the company database. You check the connection variables:
A look at the user privileges shows:
What is a valid 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 41
You attempt to connect to a MySQL Server by using the mysqlclient program. However, you receive this notice:
What would you run to fix the issue?
- A. the install plugincommand for the mysql_cleartext_passwordplugin
- B. the mysqlclient with the --enable-cleartext-pluginoption
- C. the mysql_secure_installationscript to update server security settings
- D. the mysql_upgradescript
- E. the mysqlclient with the --ignore-password-hashingoption
Answer: C
Explanation:
Explanation/Reference: http://planet.mysql.com/entry/?id=34077
NEW QUESTION 42
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 time the query took is the sum of all timer_waitvalues.
- C. The event with event_id = 8945is a child of the event with event_id=8944.
- D. The query read data from the data file rather than directly from the buffer pool.
Answer: A
NEW QUESTION 43
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 -mysql_secure_configuration to enable paranoid mode
- C. setting -skip-networking when remote connections are not required
- D. using SSL when transporting data over remote networks
- E. setting specific grant privileges to limit remote authentication
Answer: C,D,E
NEW QUESTION 44
......
1Z0-888 Deluxe Study Guide with Online Test Engine: https://www.actualcollection.com/1Z0-888-exam-questions.html