Free Oracle 1Z1-920 Exam Dumps Questions & Answers

The user -os-user'@"localhost" was created to monitor connections and shut down the server, and was granted these privileges:
GRANT PROCESS, SHUTDOWN ON *.* TO "OS-user*@"localhost';
Which three are commands that the os-user can execute?

• A.KILL PROCESS;
• B.SHOW BINLOG EVENTS;
• C.GRANT PROXY
• D.SHUTDOWN
• E.SHOW PROCESSLIST;
• F.SHOW STATUS;

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.
Which two options should you include in the MySQL configuration file?

• A.audit-log=FORCE_PLUS_PERMANENT
• B.LOAD PLUGIN=AUDIT_LOG
• C.audit_log_permanent=ON
• D.plugin-load=audit_log.so
• E.plugin-audit=ON, ALWAYS

You execute this statement:
SELECT NULL=NULL;
What is the result?

• A.0
• B.FALSE
• C.TRUE
• D.1
• E.NULL

Which four authentication protocols are allowed when using MySQL Enterprise Authentication?

• A.authentication using SHA-256 password hashing
• B.connections through the local host via the UNIX socket file
• C.authentication via Pluggable Authentication Modules (PAMs)
• D.SECURID authentication and authorization identity
• E.Simple Authentication and Security Layer
• F.Native Windows services

The MySQL Replication Environment (Master and Slave) is prepared.
What two are options for connecting a Java application to the MySQL Master and Slave?
A)

B)

C)

D)

• A.Option C
• B.Option A
• C.Option B
• D.Option D