移动端

  • 题王微信公众号

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

其他类 | 计算机考试

单选题 If a backup is expired, which of the following is true?()  

A

 It can never be used for a restore/recover operation.

B

 Oracle will remove the backup set pieces from the flash recovery area.

C

 The backup has been used at least once to restore and recover the database.

D

 The backup is no longer valid because of a resetlogs operation.

E

 The physical backup set pieces are missing from the media.

单选题 在Oracle中,事务中使用下列SQL语句不会引起锁定()。

A

SELECT

B

INSERT

C

UPDATE

D

DELETE

单选题 You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?()

A

RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE

B

RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE

C

RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE 

D

RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE

单选题 在SQL*PLUS中显示数据库例程的内存分配情况,可用命令()

A

show all

B

show mem

C

show memory

D

show sga

E

show rel

单选题 You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:RMAN> REPORT NEED BACKUP days 3;What would be the output of this command?()

A

 a list of files that require a backup within three days

B

 a list of files that have not been backed up for three days

C

 a list of files that RMAN recommends be backed up only once in every three days, based on low volatility

D

 a list of files for which a backup has already been performed and may need a backup after three days

多选题 下列选项中,属于系统全局区(SGA)的是()。

A

数据缓冲区

B

重做日志缓冲区

C

SQL共享池

D

数据连接池

多选题 Which two statements are true about the primary key constraint in a table? ()

A

It is not possible to disable the primary key constraint.

B

It is possible to have more than one primary key constraint in a single table.

C

The primary key constraint can be referred by only one foreign key constraint.

D

The primary key constraint can be imposed by combining more than one column.

E

The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.

单选题 You need to create a partitioned table to store historical data and you issued the following command:   CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL (NUMTOYMINTERVAL(1,’month’)) STORE IN (tbs1,tbs2,tbs3) ( PARTITION p1 VALUES LESS THAN(TO_DATE(’1-1-2005’, ’dd-mm-yyyy’)), PARTITION p2 VALUES LESS THAN(TO_DATE(’1-1- 2007’, ’dd-mm-yyyy’)))  AS SELECT * FROM purchases WHERE time_id < TO_DATE(’1-1-2007’,’dd-mm-yyyy’);   What is the outcome of the above command?()  

A

 It returns an error because the range partitions P1 and P2 should be of the same range.

B

 It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.

C

 It creates two range partitions of varying range. For data beyond ’1-1-2007,’ it creates partitions with a width of one month each.

D

 It returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match the number of range partitions (P1,P2) specified.

单选题 You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch.  What do you do?()  

A

 Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed,bring the disk group online again.

B

 Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced,reset the parameter to  its original value.

C

 You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced, add the disk back into the disk group and allow ASM to rebuild it.

D

 If you are using any setting other than REDUNDANCY EXTERNAL for your disk group,you will have to recover any data on that disk from a backup. The database will be unavailable until you can  correct the problem and perform recovery.

E

 Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.

1 2 3 4 5 下一页 尾页 /

到第