Oracle MySQL 8.0 Database Administrator - 1Z0-908 Exam Practice Test

A. Data files could be deleted.

B. SQL injections could be used to insert bad data into the database.

C. Users could overwrite configuration files.

D. MySQL binaries could be damaged, deleted, or altered.

E. Extra startup time would be required for the MySQL server to reset the privileges.

A. user privileges

B. InnoDB Data Dictionary

C. change buffer

D. table data

E. doublewrite buffer

F. primary indexes

A. GRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';

B. GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';

C. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO
'tom'@'%';

D. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';

A. --host=192.0.2.1

B. --password

C. --socket=/tmp/mysql.sock

D. --database=world

E. --protocol=UDP

F. --shared-memory-base-name=world

G. --port=3306

H. --protocol=pipe

I. --user=admin

A. It can be used to create and edit SSL certificates and log locations.

B. It manages the configuration of the MySQL Firewall feature.

C. It will use [client] options by default unless you provide --login-path.

D. It can move datadir to a new location.

E. It manages the configuration of client programs.

F. It manages the configuration of user privileges for accessing the server.

G. It provides an interface to change my.cnf files.

A. Encrypt the file system to avoid needing exact file-system permissions.

B. Restrict the number of OS users that have access at the OS level.

C. Ensure appropriate file system privileges for OS users and groups.

D. Run MySQL server as the root user to prevent incorrect sudo settings.

E. Keep the entire software stack on one OS host.

F. Minimize the number of non-MySQL Server-related processes running on the server host.