移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

多选题 Which two options describe how MySQL Server allocates memory?()

A

Thread memory is pre-allocated up to thread_cache_size for performance

B

Each connection may have its own per-thread memory allocations

C

Global memory resources are allocated at server startup

D

Each thread allocates memory from a global pool

多选题 Which two statements are true about InnoDB auto-increment locking?()

A

The auto-increment lock can be a table-level lock

B

InnoDB never uses table-level locks

C

Some settings for innodb_autoinc_lock_mode can help reduce locking

D

InnoDB always protects auto-increment updates with a table-level lock

多选题 Which three are properties of the MyISAM storage engine?()

A

Transaction support

B

FULLTEXT indexing for text matching

C

Table and page level locking support

D

Foreign key support

E

Geospatial indexing

F

HASH index support

G

Table level locking only

单选题 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

多选题 The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?()

A

A primary key must exist for creation of a clustered index

B

A clustered index allows fulltext searching within InnoDB

C

The first unique index is always used as a clustered index and not a primary key

D

A clustered index provides direct access to a page containing row data

E

If no indexes exist, a hidden clustered index is generated based on row IDs

F

A primary key is used as a clustered index

G

A clustered index is a grouping of indexes from different tables into a global index for faster searching

多选题 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

多选题 Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?()

A

Mysql> USE sakila; LOAD DATA INFILE 'sakila2013.sql';

B

Shell> mysql –u root –p sakila sakila2013.sql

C

Shell> mysql import –u root –p sakila sakila2013.sql

D

Shell> mysql  –u root -p  –e 'use sakila; source sakila2013.sql'

E

Shell> mysql  –u root  –p  –silent < sakila2013.sql

多选题 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

最新资讯

1 2 3 4 5 下一页 尾页 /

到第