移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?()

A

Mount the database

B

Open the database in NORMAL mode

C

Open the database in RESTRICTED mode

D

Open the database with the RESETLOGS option

多选题 To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()

A

Multiple change tracking files can be created for a database.

B

The change tracking file must be created after the first level 0 backup.

C

RMAN does not support backup and recovery of the change tracking file.

D

The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

单选题 How many different calendars does Oracle 11g support?()

A

22

B

7

C

6

D

15

E

2

多选题 Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()

A

You can use RMAN stored scripts

B

Recovery is faster if data is stored in catalog in addition to the control file

C

You can store backup information of all registered databases in one place

D

Database backups are automatically deleted when they are older than the specified time period

多选题 Evaluate the following statements: What are the two consequences of the above statements?()

A

Partitions of PURCHASE_ORDER_ITEMS have system-generated names.

B

Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.

C

Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.

D

The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.

E

Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

单选题 Which of the following most closely represents an image copy? ()

A

Unix cp command of a file

B

Bit-by-bit copy of a file

C

Windows COPY command of a file 

D

All of the above

多选题 The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()

A

All the related indexes and views are automatically dropped

B

The flashback drop feature can recover only the table structure

C

Only the related indexes are dropped whereas views are invalidated

D

The flashback drop feature can recover both the table structure and its data

单选题 You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?()

A

A different procedure is required to restore a database from compressed backups 

B

The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies. 

C

Using this command to create backups minimizes the bandwidth consumed.

D

Using this command to create backups improves the performance of the backup process 

多选题 You have enabled backup optimization for the RMAN environment.Identify two criteria on which RMAN will skip the file, if it has already been backed up.()

A

The data file backup is done with multiple channels

B

The data files is in the read-write mode after being backed up in the read only mode

C

The backup was taken after the data files was taken offline-normal or is in the read only mode

D

The data file backup complies with the back retention policy and the backup duplexing feature

单选题 You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?()

A

Set metric threshold

B

Implement Database Resource Manager

C

Enable resumable timeout for user sessions

D

Add directives to Automatic Database Diagnostic Monitor (ADDM)

最新资讯

1 2 3 4 5 下一页 尾页 /

到第