You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your dat
a. Examine your backup requirement:
The MySQL system being backed up can never be unavailable or locked to the client applications.
The recovery from the backup must work on any system.
Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?

• A.Use the Clone Plugin to copy the data to another MySQL system.
• B.Take a physical backup of the MySQL system.
• C.Take a logical backup of the MySQL system.
• D.Take your backup from a slave of the MySQL system.

Comment: *

Name: *

Email: *

Verification: *

Which three are characteristics of a newly created role? (Choose three.)

• A.It can be dropped using the DROP ROLEstatement.
• B.It is stored in the mysql.roletable.
• C.It is created as a locked account.
• D.It can be renamed using the RENAME ROLEstatement.
• E.It can be granted to user accounts.
• F.It can be protected with a password.

Comment: *

Name: *

Email: *

Verification: *

Which two queries are examples of successful SQL injection attacks? (Choose two.)

• A.SELECT user,passwd FROM members
  WHERE user = '?';INSERT INTO members('user','passwd') VALUES
  ('[email protected]','secret');--';
• B.SELECT email,passwd FROM members
  WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
  'secret');--';
• C.SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
• D.SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
• E.SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
• F.SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';

Comment: *

Name: *

Email: *

Verification: *

You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?

• A.It is not necessary because innodb_data_home_dir is already defined.
• B.It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
• C.It defines all innodb tablespace options relative to a starting parent directory.
• D.It adds more temporary workspace in addition to the innodb_tmpdir location.
• E.It allows scanning of other locations to discover more innodb tablespaces.

Comment: *

Name: *

Email: *

Verification: *

Which step or set of steps can be used to rotate the error log?

• A.Execute SET GLOBAL log_error = ‘<new error log file>’.
• B.Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.
• C.Execute SET GLOBAL expire_logs_days=0to enforce a log rotation.
• D.Rename the error log file on disk, and then execute FLUSH ERROR LOGS.

Comment: *

Name: *

Email: *

Verification: *