移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?()

A

When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.

B

When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.

C

When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.

D

When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

多选题 Examine the following commands for redefining a table with Virtual Private Database (VPD) policies: Which two statements are true about redefining the table?()

A

All the triggers for the table are disabled without changing any of the column names or column types in the table.

B

The primary key constraint on the EMPLOYEES table is disabled during redefinition.

C

VPD policies are copied from the original table to the new table during online redefinition.

D

You must copy the VPD policies manually from the original table to the new table during online redefinition.

多选题 Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()

A

Allocates memory for RMAN backup and restore operations

B

Allocates memory for shared and private SQL areas

C

Contains a cursor area for storing runtime information about cursors

D

Contains stack space

E

Contains a hash area performing hash joins of tables

多选题 Which three statements are true about Oracle Data Pump export and import operations?()

A

You can detach from a data pump export job and reattach later.

B

Data pump uses parallel execution server processes to implement parallel import.

C

Data pump import requires the import file to be in a directory owned by the oracle owner.

D

The master table is the last object to be exported by the data pump.

E

You can detach from a data pump import job and reattach later.

多选题 You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?()

A

User session data

B

Stack space

C

Private SQL area

D

Location of the runtime area for DML and DDL Statements

E

Location of a part of the runtime area for SELECT statements

多选题 Which two are prerequisites for performing a flashback transaction?()

A

Flashback Database must be enabled.

B

Undo retention guarantee for the database must be configured.

C

EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

D

Supplemental logging must be enabled.

E

Recycle bin must be enabled for the database.

F

Block change tracking must be enabled tor the database.

多选题 Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?()

A

The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

B

The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

C

All the components may be moved into SYSAUX tablespace.

D

All the components may be moved from the SYSAUX tablespace.

单选题 In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?()

A

Setting a metric threshold

B

Implementing Database Resource Manager

C

Enabling resumable timeout for user sessions

D

Decreasing the value of the IDLE_TIME resource limit in the default profile

多选题 Examine these two statements:Which three are true about the MRKT tablespace?()

A

The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.

B

The MRKT tablespace may be dropped if it has no contents.

C

Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

D

No more data files can be added to the tablespace.

E

The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

最新资讯

1 2 3 4 5 下一页 尾页 /

到第