How would you restrict a user Joe from accessing all MySQL database objects?

• A.CREATE USER 'joe'@'0.0.0.0' SET Password=PASSWORD('% ! %')
• B.Insert Joe's name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.
• C.REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'joe'@'%';
• D.CREATE USER ' joe'@1' %' DENY ALL PRIVILEGES
• E.UPDATE mysql.user SET Password=PASSWORD('Invalid') WHERE User='joe';

Comment: *

Name: *

Email: *

Verification: *

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.SHOW BINLOG EVENTS;
• B.SHOW STATUS;
• C.KILL PROCESS;
• D.SHUTDOWN
• E.SHOW PROCESSLIST;
• F.GRANT PROXY

Comment: *

Name: *

Email: *

Verification: *

Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:

What is the result after issuing the rollback command?

• A.Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.
• B.Only the t2 table is created.
• C.Both the tables, t1 and t2, are created.
• D.Only the t1 table is created.

Comment: *

Name: *

Email: *

Verification: *

After installing MySQL 8.0, you initialize the data directory with the --initialize command. Which two are places where you can find the root password?

• A.The root_pw variable stored in the mysq1.install table.
• B.The root password inserted in the error log set by the --log-error=[file_name] variable
• C.The root password is not given and is blank. You must manually set the root password.
• D.The root password displayed on the screen via a [warning] message.
• E.As root, execute the show password command by using the SHA-256 password encryption plug-in.

Comment: *

Name: *

Email: *

Verification: *

What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

• A.Tablespace keys are managed manually behind the scenes.
• B.Enables data-at-rest encryption by encrypting the physical files of the database.
• C.Data is encrypted automatically, in real time, after it is written to storage.
• D.Encryption key is stored in a centralized key memory location

Comment: *

Name: *

Email: *

Verification: *