최신 1z1-908 무료덤프 - Oracle MySQL 8.0 Database Administrator

문제1

Which two statements are true about the mysqld-auto.cnf file? (Choose two.)

A. It is read and processed at the beginning of startup configuration.

B. This file is for storing MySQL server_uuid values only.

C. This file is for logging purposes only and is never processed.

D. It is always updated with changes to system variables.

E. It is read and processed at the end of startup configuration.

F. This file is for storing MySQL Server configuration options in ISON format.

정답: D,E

문제2

Which condition is true about the use of the hash join algorithm?

A. The smallest of the tables in the join must fit in memory as set by join_buffer_size.

B. The query must access no more than two tables.

C. No index can be used for the join.

D. At least one of the tables in the join must have a hash index.

정답: B

문제3

Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

A. /usr/bin

B. /var/lib/mysql

C. /etc/my.cnf

D. /usr

E. /usr/mysql

정답: B

문제4

A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user's mysql credentials to satisfy this requirement? (Choose three.)

A. $MYSQL_HOME/my.cnf file

B. DATADIR/mysqld-auto.cnf file

C. $HOME/.mysql/auth/login file

D. $HOME/.mysqlrc file

E. $HOME/.my.cnf file

F. $HOME/.mylogin.cnf file

G. /etc/my.cnf file

정답: A,B,G

문제5

Examine this command, which executes successfully:

Which two statements are true? (Choose two.)

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

B. A raw backup is created.

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

D. A single-file backup is created.

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

정답: A,C

문제6

Which two are features of MySQL Enterprise Firewall? (Choose two.)

A. automatic locking of user accounts who break your firewall

B. provides stateless firewall access to TCP/3306

C. blocking of potential threats by configuring pre-approved whitelists

D. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands

E. modifying SQL statement dynamically with substitutions

정답: C,D

문제7

Your my.cnf file contains these settings:

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?

A. long_query_time=5
log_throttle_queries_not_using_indexes=5

B. long_query_time=5
min_examined_row_limit=5000

C. long_query_time=5
log_throttle_queries_not_using_indexes=5
min_examined_row_limit=5000

D. log_throttle_queries_not_using_indexes=5

E. log_throttle_queries_not_using_indexes=5
min_examined_ row_limit=5000

F. long_query_time=5

G. min_examined_row_limit=5000

정답: E

문제8

You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO 'user1';
How can you proceed with your transaction with the least interruption?

A. Change the default database and re-execute the failed statement in your transaction.

B. Close the connection, reconnect, and start the transaction again.

C. Roll back the transaction and start the transaction again in the same session.

D. Re-execute the failed statement in your transaction.

정답: D

문제9

Which two statements are true about using backups of the binary log? (Choose two.)

A. Multiple binary logs can be applied in parallel for faster data restoration.

B. Multiple binary logs can be used to restore data.

C. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.

D. They allow for point-in-time recovery of the data.

E. Binary logs can always be used to unapply unwanted schema changes.

정답: D,E

문제10

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

A. It supports only non-blob datatypes.

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

C. It decrypts data for use in memory.

D. It does not support the transportable tablespaces feature.

E. It supports all indexes transparently.

정답: C,E

최신 1z1-908 무료덤프 - Oracle MySQL 8.0 Database Administrator

우리와 연락하기

유용한 링크

최신 업데이트