移动端

  • 题王微信公众号

    题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 You have a login-path named "adamlocal" that was created by using the mysql_config_editor command. You need to check what is defined for this login_path to ensure that it is correct for you deployment. You execute this command: $mysql_config_editor print –login-path=adamlocal What is the expected output of this command?()

A

The command prints all parameter for the login-path. The password is replaced with stars

B

The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists

C

The command prints all parameters for the login-path. The password is shown only when you provide the  –password option

D

The command prints all parameters for the login-path. The password is printed in plain tex

多选题 Which two statements are true regarding partitioning in Mysql?()

A

Tables with BLOB and TEXT columns cannot be partitioned

B

Partitioning allows easier management of smaller data sets for certain queries

C

Partitioning allows different columns to be stored in separate files

D

The partitioning expression is an integer or function that returns an integer value or NULL value

E

Partitioning is only available for those storage engines that implements it natively

单选题 Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?()

A

A syntax error will result as you cannot specify more than one partition in the same statement

B

All data in p1 and p3 partitions are removed and the table definition is changed

C

All data in p1 and p3 partitions are removed, but the table definition remains unchanged

D

Only the first partition (p1) will be dropped as only one can be dropped at any time

单选题 You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?()

A

Increase the value of table_definition_cache

B

Increase the value of table_open_cache_instances

C

Decrease the value of table_open_cache_instances

D

Increase the value of table_open_cache

E

Decrease the value of table_definition_cache

F

Decrease the value of table_open_cache

多选题 Which two are correct steps in taking a binary backup of MyISAM tables?()

A

Always stop the server prior to the backup

B

Stop the server or lock the tables prior to the backup

C

Stop the server or lock the databases prior to the backup

D

Make a copy of the .frm, .myd, and the .myi files

E

Make a copy of the binary log and tablespace files

多选题 Which two are true regarding MySQL binary and text backups?()

A

Binary backups are usually faster than text backups

B

Binary backups are usually slower than text backups

C

Text backups are human-readable while binary backups are not

D

Binary backups are not portable across different operating systems

多选题 Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?()

A

Mysql NDB Cluster

B

Mysql Replication

C

Distributed Replicated Block Device (DRBD) and Mysql

D

Windows Cluster and Mysql

E

Solaris Cluster and Mysql

多选题 Which two statements are true about setting the per-thread buffers higher than required?()

A

More memory per thread is beneficial in all scenarios

B

It causes increased overhead due to initial memory allocation

C

It can affect system stability during peak load times, due to swapping

D

It requires increasing the thread_cache_size variable

最新资讯

1 2 3 4 5 下一页 尾页 /

到第