Online Access Free 1Z0-908 Practice Test

On examination, your MySQL installation datadir has become recursively world read/write/executable.
What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

• A.Data files could be deleted.
• B.MySQL binaries could be damaged, deleted, or altered.
• C.SQL injections could be used to insert bad data into the database.
• D.Extra startup time would be required for the MySQL server to reset the privileges.
• E.Users could overwrite configuration files.

t is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN;
SELECT * FROM t FOR UPDATE;
Which is true?

• A.If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.
• B.If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.
• C.mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.
• D.If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.

Which two methods allow a DBA to reset a user's password? (Choose two.)

• A.mysqladmin client program
• B.ALTER USER statement
• C.SET PASSWORD statement
• D.mysql_secure_installation utility
• E.GRANT statement

You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)

• A.They do not use additional disk space.
• B.The backup window is almost zero from the perspective of the application.
• C.They work best for transaction storage engines that can perform their own recovery when restored.
• D.They take roughly twice as long as logical backups.
• E.They do not back up views, stored procedures, or configuration files.
• F.They allow direct copying of table rows with operating system copy commands.
• G.There is a slight performance cost while the snapshot is active.

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

• A.MySQL server was not started due to a problem while executing process 2732.
• B.systemd found the mysqld service disabled and failed to start it.
• C.systemd waited for 30 seconds before timing out and start up failed.
• D.MySQL server continued to start up even though another process existed.
• E.systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.