最新的Oracle 1Z1-888免費考試真題

問題1

When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?

A. it contains the undo log.

B. it contains the binary log.

C. it contains the redo log.

D. it is the default location for all new tables that you create.

E. it contains the system tablespace.

F. it contains a general tablespace.

正確答案: D,E

說明：（僅 Fast2test 成員可見）

問題2

You are investigating the performance of the server and see this information:
* events_waits_summary_global_by_event_namein the Performance Schema shows that the wait/synch/mutex/sql/LOCK_table_cacheevent is dominating other wait events.
* The Table_open_cache_overflowsstatus variable is 0.
Which action should be taken to remove the performance bottleneck described here?

A. Increase the value of table_open_cache_instances.

B. Decrease the value of table_open_cache.

C. Decrease the value of table_definition_cache.

D. Increase the value of table_open_cache.

E. Decrease the value of table_open_cache instances.

F. Increase the value of table_definition_cache.

正確答案: A

問題3

Which two statements are true regarding MySQL security? (Choose two.)

A. The mysqld process should be run as root or administrator.

B. The root or administrator users should own all files and directories to which the server writes.

C. The mysqld process should not be run as root or administrator.

D. The mysql user needs to have sudo privileges.

E. The mysqld process owner should own all files and directories to which the server writes.

正確答案: B,C

問題4

What three are correct statements about MySQL backups? (Choose three.)

A. They are used to prevent data corruption.

B. They are used to set up the initial binary log files.

C. They are used to set up a test system.

D. They are used to set up a replication slave.

E. They are used to prevent data theft.

F. They are used to recover data.

正確答案: B,D,F

說明：（僅 Fast2test 成員可見）

問題5

What are two benefits of using the --tab option with mysqldump? (Choose two.)

A. It can be used together with --all-databases.

B. The schema and data are automatically dumped to separate files.

C. It is possible to restore the data in parallel.

D. It can be piped directly into a running server.

正確答案: A,C

問題6

A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

A. The sync_relay_log=1000 setting on the slave is too small.

B. binlog_cache_size=1024 is too small and transactions are lost.

C. binlog_format=STATEMENT and a non-deterministic query was executed.

D. sync_binlog=0 and the master server crashed.

E. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

正確答案: B,E

問題7

You have installed MySQL on Oracle Linux 7 using the official RPM distribution, and SELinux is set to
"permissive".
Examine this extract of the my.cnf file:

You issue this command to start MySQL Server:
systemctl start mysqld@replica
On which port is the server listening?

A. 3303

B. 3301

C. 3302

D. 3304

正確答案: B

問題8

A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

A. using GRANT USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY `secret_password'

B. using GRANT ... REQUIRE SSL for a secure connection

C. using GRANT ... REQUIRE X509 AND REQUIRE ISSUER `/C=.....' AND REQUIRE SUBJECT `/C=.....'

D. using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY `secret_password'

正確答案: C

問題9

Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

A. executing REVOKE FILE ON *_* FROM ` `@'%'

B. setting the --open-files-limit=0 option when starting mysqld

C. setting the --local-service=0 option when starting mysqld

D. executing REVOKE FILE FROM *_*

E. executing REVOKE LOAD FROM *.*

F. setting the --local-infile=0 option when starting mysqld

正確答案: B

最新的Oracle MySQL 5.7 Database Administrator - 1Z1-888免費考試真題

聯系我們

站內鏈接

最新更新