Authentic 1Z0-888 Dumps - Free PDF Questions to Pass
Guaranteed Accomplishment with Newest Oct-2022 FREE 1Z0-888
NEW QUESTION 27
Which two capabilities are granted with the SUPER privilege?
- A. allowing a client to kill other client connections
- B. allowing change of the server runtime configuration
- C. allowing client accounts to take over the account of another user
- D. allowing a client to shut down the server
Answer: A,D
NEW QUESTION 28
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. The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases > /data/datA.sql
- B. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
- C. The applications have the SUPER privilege, which allows them to update rows.
- D. The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.
- E. For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
Answer: A,E
NEW QUESTION 29
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?
- A. log_bin
- B. server-id
- C. log-master-updates
- D. master-logging
- E. rpl-recovery-rank
- F. enable-master-start
Answer: A,B
NEW QUESTION 30
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. validating all user input before sending it to the database server
- B. writing your client code to properly escape all user input
- C. removing any remaining anonymous accounts from your MySQL instance
- D. using SSL/TLS on your outward facing web servers (https://) to encrypt all user sessions
- E. using a hashing or encryption method to secure all user passwords in your MySQL tables
- F. changing all passwords for the MySQL account `root'@'%' immediately after losing an employee who knew the current password
- G. giving limited privileges to accounts used by application servers to interact with their backing databases
Answer: C,E,F
NEW QUESTION 31
You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default --basedirvalue) for your operating system.
Which step should you perform before defining your own databases and database tables?
- A. Create a configuration file containing default-storage-engine=InnoDB.
- B. Set an exception in the host machine's firewall to allow external users to talk to mysqld.
- C. Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges.
- D. Execute a command with a minimal form of: mysql --initialize
- E. Register mysqldas a service that will start automatically on this host machine.
Answer: A
NEW QUESTION 32
Consider these global status variables:
Which two conclusions can be made from the output? (Choose two.)
- A. There are 140 Performance Schema threads at the time of the output.
- B. The thread cache has been configured with thread_cache_size set to at least 6.
- C. There are more connections being idle than executing queries.
- D. All max_connections were in use at 2018-03-22 14:54:06
- E. There are 510 connections to MySQL at the time of the output.
Answer: C,E
NEW QUESTION 33
How does the InnoDB storage engine handle deadlocks when they are detected?
- A. Both the affected transactions will be rolled back.
- B. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
- C. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.
- D. One of the affected transactions will be rolled back, the other is allowed to proceed.
- E. The transaction isolation level determines which transaction is rolled back.
Answer: D
Explanation:
Reference:
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks.html
NEW QUESTION 34
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 X509 AND REQUIRE ISSUER '/C=.....' AND REQUIRE SUBJECT '/C=.....'
- B. using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY 'secret_password'
- C. using GRANT ... REQUIRE SSL for a secure connection
- D. using GRANT USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY 'secret_password'
Answer: A
NEW QUESTION 35
Consider:
Which statement best describes the meaning of the value for the key_lencolumn?
- A. It shows how many bytes will be used from each index row.
- B. It shows the total size of the index row.
- C. It shows the number of characters indexed in the key.
- D. It shows how many columns in the index are examined.
Answer: A
NEW QUESTION 36
Consider the join_buffer_sizeparameter in MySQL Server.
Which two statements are true about the join buffer? (Choose two.)
- 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 used to process sorts when complex joins are being performed.
- E. The join buffer is global and can be changed only by restarting the server.
Answer: B,D
Explanation:
Explanation/Reference:
NEW QUESTION 37
These details are shown when logged in to an account:
Which set of statements would match the accounts shown?
mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
- A. mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> GRANT PROXY ON 'employee'@'localhost' TO ''@'';
- B. mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK; - C. mysql> CREATE USER ''@'' IDENTIFIED BY 'valid_password' WITH PROXY
'employee'@'localhost';
mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; - D. mysql> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost';
mysql> CREATE USER 'robert'@'localhost' IDENTIFIED BY 'secret_password';
Answer: A
Explanation:
Explanation/Reference:
NEW QUESTION 38
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?
- A. log_bin
- B. server-id
- C. log-master-updates
- D. master-logging
- E. rpl-recovery-rank
- F. enable-master-start
Answer: A,B
Explanation:
Reference:
https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in- mysql
NEW QUESTION 39
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 backup created using FLUSH TABLES ... FOR EXPORT
- B. a file system copy created while MySQL was shut down.
- C. a file system-level snapshot
- D. a backup created with mysqldump --all-databases
- E. an up-to-date replication slave
Answer: C,D
NEW QUESTION 40
The MySQL installation includes the mysql_config_editorutility for managing login paths stored in a
.mylogin.cnffile.
Which two are true about the login path feature?
- A. A .mylogin.cnffile can store at most one login path.
- B. A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
- C. It is an alternative to storing the MySQL login details in a my.cnffile.
- D. It provides means to help avoid accidentally exposing the MySQL login details.
- E. It provides a FIPS-compliant keyring for storing MySQL login details.
- F. mysql_config_editoris the only MySQL-provided utility that can print the values stored in
.mylogin.cnf.
Answer: C,D
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html
NEW QUESTION 41
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
Explanation:
Reference: http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html
NEW QUESTION 42
You have a MySQL instance with the following variables in the /etc/my.cnffile:
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 statement would fail because you cannot update more than one row at a time when using -- binlog-format = ROW.
- B. You would receive an error on the statement because you cannot update a different database that what is specified with the USEstatement.
- 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. The changes caused by the UPDATEstatement are logged to the binary log because the instance is using --binlog-format = ROW
- E. 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-formatvalue set to STATEMENT.
Answer: C,E
NEW QUESTION 43
Which three tasks are handled by the optimizer? (Choose three.)
- A. Execute the query.
- B. Change the order in which the tables are joined.
- C. Validate the query.
- D. Rewrite the WHEREclause.
- E. Verify that the user is allowed to execute the query.
- F. Decide which indexes to use.
- G. Parse the query.
Answer: A,D,G
NEW QUESTION 44
......
1Z0-888 Braindumps PDF, Oracle 1Z0-888 Exam Cram: https://pass4itsure.passleadervce.com/MySQL-Database-Administration/reliable-1Z0-888-exam-learning-guide.html