Online Access Free 1Z0-908 Practice Test

You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?

• A.It creates a logical backup of all metadata, but contains no table data.
• B.It returns an error because the mysqldump command should have been used.
• C.It creates a logical backup of all MySQL user accounts.
• D.It creates a logical backup of only the users database.

Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)

• A.NDB
• B.MyISAM
• C.ARCHIVE
• D.InnoDB
• E.MEMORY

Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'.
Which command will do this?

• A.mysqlbinlog --read-from-remote-server --raw | sed 's/mydb1/mydb2/g' | mysql
• B.mysqlbinlog --rewrite-db='mydb1->mydb2' | mysql
• C.mysqlbinlog --rewrite-db='mydb1' --rewrite-db='mydb2' | mysql
• D.mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql

Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)

• A.X Protocol
• B.named pipes
• C.UDP
• D.shared memory
• E.TCP/IP
• F.SOCKET

Examine Joe's account:
CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*'
GRANT ALL PRIVILEGES ON *.* TO 'joe'@'%'
All existing connections for joe are killed.
Which two commands will stop joe establishing access to the MySQL instance? (Choose two.)

• A.ALTER USER 'joe'@'%' SET password='*invalid*'
• B.REVOKE USAGE ON *.* FROM 'joe'@'%'
• C.ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE
• D.REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'
• E.ALTER USER 'joe'@'%' ACCOUNT LOCK
• F.ALTER USER 'joe'@'%' PASSWORD HISTORY 0