移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 You have forgotten the root user account password. You decide to reset the password and execute the following: Shell> /etc/init.d/mysql stop Shell> /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?()

A

–skip-networking, to prohibit access from remote locations

B

–reset-grant-tables, to start the server with only the mysql database accessible

C

–read-only,to set all data to read-only except for super users

D

–old-passwords, to start Mysql to use the old password format while running without the grant tables

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

单选题 Oracle创建()来处理连接到实例的用户进程的请求。

A

服务器进程

B

SGA

C

应用程序代码

D

网络服务进程

多选题 Which two statements are true when row archival management is enabled?()

A

The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

B

The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

C

The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

D

The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

E

The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

单选题 Which statement is true concerning dropping a pluggable database (PDB)?()

A

The PDB must be open in read-only mode.

B

The PDB must be in mount state.

C

The PDB must be unplugged.

D

The PDB data files are always removed from disk.

E

A dropped PDB can never be plugged back into a multitenant container database (CDB).

多选题 Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()

A

You can use RMAN stored scripts

B

Recovery is faster if data is stored in catalog in addition to the control file

C

You can store backup information of all registered databases in one place

D

Database backups are automatically deleted when they are older than the specified time period

1 2 3 4 5 下一页 尾页 /

到第