移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings, you find that the following parameter has been set in the parameter file of the database: REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE?()

A

to enable operating system authentication for a remote client

B

to restrict the scope of administration to identical operating systems

C

to allow the start up and shut down of the database from a remote client

D

to enable the administration of the operating system from a remote client

E

to disable the administration of the operating system from a remote client

单选题 According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()

A

The backup is similar to image copy.

B

The backup contains all used data blocks.

C

The backup contains only unused data blocks.

D

The backup contains all data blocks changed since the last incremental level 1 backup.

多选题 Which two statements about Automatic Storage Management (ASM) are true?()

A

ASM provides mirroring on file by file basis.

B

ASM provides automatic load balancing across all ASM disks.

C

ASM supports the Oracle database and operating system files.

D

ASM can be used to store trace files, alert log files, and the server parameter file (SPFILE).

单选题 You work as a database administrator for Certkiller .com. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective?()

A

Save the baseline in the database

B

Save the baseline in the Database Control Home Page

C

Create a procedure to read and apply the baseline to disk I/O metrics

D

Apply the baseline to the disk I/O metrics in the Mange Metrics page

E

Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd

单选题 You work as a database administrator for Certkiller .com. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows:  ERROR at Line 1:  ORA-10635: Invalid segment ortablespacetype What could be the reason?()

A

The table is partitioned

B

The table name is wrong.

C

It is an index-Organized table (IOT)

D

The table is stored in locally managedtablespace.

E

The table is stored in atablespacewhere segment space is managed manually.

单选题 Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this statement have on the database?()

A

The extents in undo tablespace retain data until the next full database backup.

B

The extents containing committed data in the undo tablespace are never overwritten.

C

The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.

D

The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down.

多选题 Which three statements are true regarding the fine-grained 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.

最新资讯

1 2 3 4 5 下一页 尾页 /

到第