Oracle Oracle Certifications 1Z0-908 Questions & Answers

• Question 21:

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

  A. ALTER USER statement

  B. mysql_secure_installation utility

  C. SET PASSWORD statement

  D. mysqladmin client program

  E. GRANT statement

  Correct Answer: AC

• Question 22:

  Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

  A. It supports only non-blob datatypes.

  B. It does not support the transportable tablespaces feature.

  C. It supports all indexes transparently.

  D. It decrypts data for use in memory.

  E. It enforces encryption from disk to memory and over network transmission.

  Correct Answer: CD

  Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/faqs-tablespace- encryption.html

• Question 23:

  Which statement is true about cold backups?

  A. They are backups taken from snapshots of a running database.

  B. They are backups taken from OS copy commands.

  C. They are good to use if only data structures must be backed up but not log files.

  D. They are good to use when many users are online accessing the database.

  Correct Answer: A

• Question 24:

  You wish to store the username and password for a client connection to MySQL server in a file on a local file system.

  Which is the best way to encrypt the file?

  A. Use the AES_ENCRYPT() MySQL function on the option file.

  B. Use mysql_secure_installation to encrypt stored login credentials.

  C. Use a text editor to create a new defaults file and encrypt it from Linux prompt.

  D. Use mysql_config_editor to create an encrypted file.

  Correct Answer: D

  Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/password-security- user.html

• Question 25:

  Your MySQL server is running on the Microsoft Windows platform.

  Which three local connection protocols are available to you? (Choose three.)

  A. named pipes

  B. shared memory

  C. SOCKET

  D. X Protocol

  E. UDP

  F. TCP/IP

  Correct Answer: ABF

  Reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/mysql-installer- workflow.html

• Question 26:

  Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)

  A. DESCRIBE manufacturing.parts;

  B. SELECT * FROM information_schema.statistics WHERE table_schema='manufacturing' AND TABLE_NAME='parts';

  C. SHOW INDEXES FROM manufacturing.parts;

  D. SELECT * FROM information_schema.COLUMN_STATISTICS;

  E. EXPLAIN SELECT INDEXES FROM manufacturing.parts;

  Correct Answer: BD

  Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT912

• Question 27:

  Examine this command, which executes successfully:

  

  Which two statements are true? (Choose two.)

  A. A single-file backup is created.

  B. The backup operation will finish only when backup-and-apply-log is executed.

  C. The --backup-dir option holds temporary output, status, and metadata files.

  D. The backup operation will finish only when apply-log is executed.

  E. A raw backup is created.

  Correct Answer: CD

• Question 28:

  Which three actions are effective in capacity planning? (Choose three.)

  A. buying more RAM

  B. monitoring OS resources for patterns

  C. adding circular replication nodes for increased DML capability

  D. buying more CPU

  E. buying more disk

  F. basing expected growth on an average of the last 3 years

  G. consulting the application team about any future projects and use

  H. upgrading to the latest application version

  Correct Answer: BFG

• Question 29:

  Examine this command and output:

  

  Which two options will improve the security of the MySQL instance? (Choose two.)

  A. Remove group read/write privileges from the private_key.pem file.

  B. Remove world read privileges from the server-cert.pem certificate file.

  C. Change the group ownership of the mysql directory to the mysql user group.

  D. Remove world read privileges from the public_key.pem file.

  E. Change the parent directory owner and group to mysql.

  F. Remove the world read/execute privilege from the accounting directory.

  Correct Answer: CE

• Question 30:

  Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.

  Which two sets of actions when completed will accomplish this? (Choose two.)

  A. Use SET GLOBAL binlog_expire_logs_seconds= and restart the server.

  B. Set binlog_expire_logs_seconds in my.cnf.

  C. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.

  D. Use SET PERSIST binlog_expire_logs_seconds=.

  E. Use PURGE BINARY LOGS to .

  F. Use SET GLOBAL binlog_expire_logs_seconds= and run the FLUSH BINARY LOGS command.

  Correct Answer: AD

  Reference: https://severalnines.com/database-blog/my-mysql-database-out-disk-space