移动端

  • 题王微信公众号

    题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

多选题 Which two file types must be included in a closed database backup taken with operating system commands?()

A

data files

B

control file

C

password file

D

online redo log files

E

initialization parameter file

单选题 Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database?()

A

Shut down the database.

B

Set the appropriate parameters in init.ora file.

C

Start the database in NOMOUNT state.

D

Issue the ALTER DATABASE ARCHIVELOG command.

E

Open the database.

F

Take a full closed backup.

多选题 Which two are true regarding external tables? ()

A

External tables can be updated. 

B

External tables are read-only tables. 

C

Indexes can be created on external tables. 

D

Indexes cannot be created on external tables.

单选题 The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan?()

A

ALTER TABLE employees monitor index employee_idx_fk; 

B

ALTER INDEX employee_idx_fk monitoring on; 

C

ALTER TABLE employees monitor all indexes; 

D

ALTER INDEX employee_idx_fk monitoring usage; 

单选题 Which statement correctly describes the function of Oracle9i Cache Fusion feature?()

A

It provides each session with its own view of the database at a different point in the past. 

B

It enables you to execute scalable applications on a clustered database without having to partition the users or the database tables. 

C

It lets you dynamically reassign memory in your database buffer cache to different block buffer sizes. 

D

It allows you to add new sites to multimaster replication environment without quiescing the master definition site.

最新资讯

首页 上一页 1 2 3 4 5 下一页 尾页 /

到第