移动端

  • 题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | Oracle认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

多选题 A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. Which two will optimize the security of this setup?()

A

Disabling connections from named pipes or socket files (depending on the operating system of the server)

B

Enabling and using SSL for connections to the Mysql database

C

Installing Mysql on the application server, and running the database and application on the same server

D

Starting the server with – bind- address=0.0.0.0 specified

E

Running the server with – skip-networking specified

F

Limiting logins to originate from the application server or the server's subnet'

单选题 Which statement is true about the log-output variable?()

A

It is a static variable and can be set only at MySQL server startup

B

It enables and starts the General Query Log

C

It sets the target location for the binary logs generated by the MySQL sever

D

It specifies output destinations for the slow and General Query logs

多选题 Consider the MySQL Enterprise Audit plugin, You add the following lines to the my.cnf configuration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attempt to start up the MySQL service and notice that it fails to start. Which two statements would explain why the service did not start?()

A

FORCE_PLUS_PERMANENT is not valid for the audit-log option

B

The audit_log.so library does not exist

C

The audit_log.so library is in a location that is different from that defined by the plugin_dir option

D

The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command

E

The audit log file does not exist in which to write audit events

F

The audit_log.so library is not an executable file

单选题 Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql> CALL prepare_db ( ); Mysql> LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql> SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?()

A

12; only top-level statements and stored procedure events are logged

B

111; top-level statements and all lower-level statements are logged

C

3; only the top-level statements are logged

D

102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event

单选题 Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?()

A

MySQL Replication

B

Distributed Replication Block Device

C

Windows Server Failover Clustering

D

MySQL Cluster

多选题 When backing up a replication slave, which three should also be backed up in addition to data?()

A

The master.info and relay.info files

B

The relay log files

C

The relay index file

D

Mysql.slave_master_info table

E

Mysql.slave_relay_log_info table

F

Mysql.slave_worker_info table

单选题 You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?()

A

STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE

B

STOP SLAVE; BEGIN; SET GTID_IGNORE=aaa-bbb-ccc-ddd-eee: 3; COMMIT; START SLAVE

C

STOP SLAVE; SETGTID_NEXT=aaa-bbb-ccc-ddd-eee: 3; BEGIN; COMMIT; SET GTID_NEXT=AUTOMATIC; START SLAVE

D

STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE

单选题 Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?()

A

Mysqlaccess

B

Mysqldump

C

Mysqlshow

D

Mysqlslow

E

Mysqldumpslow

最新资讯

1 2 3 4 5 下一页 尾页 /

到第