移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

多选题 Which two statements are correct about database transportation? ()

A

The source and target platforms must be the same

B

Redo logs, control files and temp files are also transported

C

The transported database must have the same database identifier (DBID) as the source database and cannot be changed

D

The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

E

Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

单选题 You executed the following PL/SQL block successfully: The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis.()

A

with the CPU Usage finding if it is less than 90

B

without the CPU Usage finding if it is less than 90

C

with the CPU Usage finding for snapshots below 90

D

with the CPU Usage finding for snapshots not between 150 and 162

单选题 You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? ()

A

to minimize plan regression due to the use of a new optimizer version

B

to completely avoid the use of new plans generated by a new optimizer version

C

to prevent plan capturing when the SQL statement is executed after the database upgrade

D

to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

多选题 Which two initialization parameters would you set to enable Automatic Shared Memory Management?()

A

set SHARED_POOL_SIZE to zero

B

set STATISTICS_LEVEL to BASIC

C

set SGA_TARGET to a non-zero value

D

set DB_CACHE_SIZE to a non-zero value

E

set STATISTICS_LEVEL to TYPICAL or ALL

多选题 Which three statements are true about windows?()

A

Only one window can be open at any given time

B

Consumer groups are associated with windows

C

Windows work with job classes to control resource allocation

D

The database service name must be provided during windows creation

E

Windows can automatically start job or change resource allocation among jobs for various time periods.

单选题 You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?()

A

It must be executed from the Oracle Database 11g environment.

B

It must be executed only after the SYSAUX tablespace has been created.

C

It must be executed from the environment of the database that is being upgraded.

D

It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

E

It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

单选题 Examine the following RMAN script: Which statement describes the purpose of the script?()

A

The data file is checked for physical corruption and backed up if found clean.

B

The backup of data file 5 is performed and the interactive messages during the backup are suppressed.

C

The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.

D

The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

多选题 Which of the following objects can be directly referenced by a window object? ()

A

Schedule object

B

Program object

C

Job object

D

Resource plan

E

Resource consumer group

多选题 Which three functions are performed by the SQL Tuning Advisor? ()

A

Building the SQL profile

B

Recommending optimization of materialized views

C

Checking query objects for missing and stale statistics

D

Recommending bitmap, function-based, and B-tree indexes

E

Recommending restructuring SQL queries that are using bad plans

单选题 While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?()

A

It updates the existing SQL profiles with current statistics

B

It makes the statistics information available to GATHER_STATS_JOB

C

It initiates the statistics collection process by running GATHER_STATS_JOB

D

It logs a warning message in the alert log so that the DBA can perform statistics collection manually

最新资讯

1 2 3 4 5 下一页 尾页 /

到第