移动端

  • 题王微信公众号

    题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

多选题 Which three statements are true regarding the fine/x7fgrained auditing (FGA)?()

A

FGA is possible on SELECT statements only.

B

The audit trail for FGA is stored in the FGA_LOG$ table.

C

The audit trail for FGA is stored in the AUD_LOG$ table.

D

FGA enables a SQL predicate to define when to audit an event.

E

FGA audits DELETE statements only when audit columns are specified.

F

FGA includes the SQL statement used by the user as part of the audit event entry.

多选题 Which two statements are true about a bitmap index? ()

A

It is recommended for the columns that have unique values.

B

It can be converted to a B-tree index by using the ALTER INDEX command.

C

It has a bitmap segment for each distinct value in the key column, containing a string of bits in which each bit represents the presence or absence of a key column value.

D

Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.

多选题 You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()

A

Set the UNDO_RETENTION parameter to AUTO.

B

Create an initial undo segment in undotablespace.

C

Set the UNDO_RETENTION parameter to 900 or more

D

Set the initialization parameter UNDO_MANAGEMENT to AUTO

E

Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

多选题 You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time?()

A

By multiplexing the control files

B

By multiplexing the redo log files

C

By decreasing the size of redo log files

D

By configuring mean time to recover (MTTR) to a lower value

E

By setting the UNDO_RETENTION parameter to a higher value

单选题 You work as a database administrator for Certkiller .com. As a result of performance analysis, you created an index on theprod_namecolumn of the  Certkiller prodtable, which contains about ten thousand rows. Later, you updated a product name in the table.  How does this change affect the index?()

A

A leaf will be marked as invalid.

B

An update in a leaf row takes place.

C

The index will be updated automatically at commit.

D

A leaf row in the index will be deleted and inserted.

E

The index becomes invalid when you make any updates

单选题 The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine.  What kind of information is stored is stored in this file?()

A

OracleSIDsonly

B

Oracle homes only

C

Oracle install timestamp

D

Oracle inventory pointer files

E

Oracle database creation timestamp

F

OracleSIDsand Oracle homes only

G

OracleSIDs, Oracle homes and flag for auto startup

单选题 While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective?()

A

configure the database to run in ARCHIVELOG mode

B

configure the Flash Recovery Area to enable automatic database backup

C

schedule the database backup using DBMS_JOB package after creating the database

D

schedule the database backup using Recovery Manager (RMAN)commands after creating the database

E

schedule the database backup using Database Configuration Assistant (DBCA)while creating the database

最新资讯

1 2 3 4 5 下一页 尾页 /

到第