Question: 1
You have installed the validate_password plug-in and set the validate_password_policy variable. Which validation is affected by the validate_password_policy setting?
A. whether a new password is rejected if it contains a word found in a dictionary file.
B. whether a new password is rejected if it contains the current user’s username.
C. the amount of delay after an incorrect password is entered
D. the length of time before a newly created password expires
Answer: A
Question: 2
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. log-master-updates
B. rpl-recovery-rank
C. server-id
D. enable-master-start
E. log-bin
F. master-logging
Answer: C,E
Question: 3
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. executing REVOKE LOAD FROM *.*
B. setting the --local-service=0 option when starting mysqld
C. executing REVOKE FILE FROM *.*
D. executing REVOKE FILE ON *.* FROM ‘ ’ @’%’
E. setting the --local-infile=0 option when starting mysqld
F. setting the --open-files-limit=0 option when starting mysqld
Answer: F
Question: 4
Which two statements are true about InnoDB auto-increment locking? (Choose two.)
A. InnoDB never uses table-level locks.
B. InnoDB always protects auto-increment updates with a table-level lock
C. InnoDB does not use locks to enforce auto-increment uniqueness.
D. The auto-increment lock can be a table-level lock.
E. Some settings for innodb_autoinc_lock_mode can help reduce locking.
Answer: D,E
Visit Our Site For Further Details:
https://www.exam4help.com/oracle/1z0-888-dumps.html
No comments:
Post a Comment