移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

多选题 What are three methods to reduce Mysql server exposure to remote connections?()

A

Setting — skip-networking when remote connections are not required

B

Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications

C

Setting specific GRANT privilege to limit remote authentication

D

Setting – mysql_secure_configuration to enable paranoid mode

E

Using SSL when transporting data over remote networks

多选题 You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?()

A

Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY

B

Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table

C

Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table

D

Set binlog_format=MIXED with the – replicate-ignore-temp-table option

E

Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table

单选题 You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?()

A

Mysqld uses internal configuration versioning and reverts to the previous configuration

B

When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes

C

The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes

D

Mysqld prints to the error log about an unknown variable, and then exits

单选题 An employee cannot access the company database. You check the connection variables: What is a valid explanation for why one of the users is unable to connect to the database?()

A

Bob has max_user_connections set to zero, which blocks all his connections

B

Joe has exceeded the max_user_connections global limit

C

All users are blocked because max_user_connections is accumulated over the host account information

D

Kay is already connected elsewhere and attempting to log in again

E

Connect_timeout is too small to allow a connection to occur

多选题 In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?()

A

Syntax when writing queries involving JOINS

B

Memory usage when working with the data 

C

Character set mapping index hash size

D

Disk usage when storing data

单选题 Consider the Mysql Enterprise Audit plugin. Which statement is true when you identify a connection event that has used external authentication?()

A

The attribute STATUS is set to the string EXTERNAL_AUTH

B

The attribute PRIV_USER contains the username

C

The event type that is given in the attribute NAME is EXTERNAL_AUTH

D

There is no differentiation between native and external authentication events

E

External authentication is managed through external auditing logs

F

The PROXY_PRIV user shows a username if external authentication is used

单选题 You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?()

A

The snapshot size will continue to grow as changes to the volume are made

B

The snapshots take a significant amount of disk space as they are a duplicate copy of the data

C

The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup

D

The system keeps a copy of changes in memory and can cause an out of memory event

最新资讯

1 2 3 4 5 下一页 尾页 /

到第