违法和不良信息举报 联系客服
免费注册 登录

Which command would correctly start a TSPITR of the USERS ta

题目
单选题
Which command would correctly start a TSPITR of the USERS tablespace？（）
A

 recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary ，，c/oracle/auxiliary

B

 recover tablespace users time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary； time ，， 10/06/2008：22：42：00 auxiliary destination ，，c/oracle/auxiliary

C

 recover tablespace users to point-in.

D

 recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary

E

 recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

多选题
You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）
A

Reregistering the target database in recovery catalog

B

Transporting the new tablespaces to the recovery catalog database

C

Syncronizing the recovery catalog with the target database control file

D

Performing a fresh backup of the target database to include the new data files in the catalog database


正确答案： B,C
解析： 暂无解析

第2题：

单选题
Examine the CREATE DISKGROUP command used to create a disk group：   SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY  DISK ’ORCL： FRA3’ NAME misc1， ’ORCL： FRA4’ NAME misc2；   In which situation would you use this method of disk group creation？（）
A

 When two-way disk mirroring is required for the allocation units

B

 When three-way disk mirroring is required for the allocation units

C

 When using hardware mirroring or RAID

D

 When disk mirroring is required for the Automatic Storage Management （ASM） disks


正确答案： C
解析： 暂无解析

第3题：

多选题
ou are using the flash recovery area （fast recovery area in 11g Release 2） to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is （jetting filled up very fast and it is running out of space.  Your database flash recovery area is low on specie and you have no more room on disk. Proactively， which two options could you use to make more space available in the flash recovery（）
A

Change the RMAN archived log deletion policy.

B

Use the RMAN CROSSCHECK command to reclaim the archived log space.

C

Change the RMAN retention policy to retain backups for a shorter period of time.

D

Use OS command to move files from the flash recovery area to some other location.


正确答案： A,B
解析： 暂无解析

第4题：

单选题
Which statement is true regarding virtual private catalogs?（）
A

A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.

B

The virtual private catalog owner cannot create and modify the stored scripts.

C

The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.

D

To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database


正确答案： B
解析： 暂无解析

第5题：

多选题
You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? （）(Choose three.)
A

Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.

B

A resumable statement is suspended only if an out of space error occurs.

C

When a resumable statement is suspended, the transaction that contains the statement is also suspended.

D

A resumable statement can only be suspended and resumed once during the execution of the statement.

E

You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session


正确答案： A,C,E
解析： 暂无解析

第6题：

单选题
How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed？（）
A

 Issue the ALTER DISKGROUP ... ADD DISK command.

B

 Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.

C

 Issue the ALTER DISKGROU

D

 Retrieve the disk from the Recycle Bin after the operation completes.


正确答案： C
解析： 暂无解析

第7题：

多选题
Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（） (Choose three.)
A

Both source and target database must be the same character set

B

Both source and target database must have the same endian format

C

The COMPATIBLE parameter must be the same in the source and target databases.

D

The minimum compatibility level for both the source and target database must be 10.0.0.

E

All read-only and offline data files that belong to the tablespace to be transported must be platform aware.


正确答案： A,D
解析： 暂无解析

第8题：

多选题
Which two changes and their effect on the system can be tested by using the Database Replay feature？（）
A

multiplexing of the control file

B

adding the redo log member to the database

C

database and operating system upgrades

D

changing the database storage to ASM-managed storage


正确答案： B,C
解析： 暂无解析

第9题：

单选题
You executed the following PL/SQL block successfully：   VARIABLE tname VARCHAR2（20）  BEGIN dbms_addm.insert_finding_directive （NULL， DIR_NAME=>’Detail CPU Usage’， FINDING_NAME=>’CPU Usage’， MIN_ACTIVE_SESSIONS=>0， MIN_PERC_IMPACT=>90）；  ：tname ：= ’database ADDM task4’； dbms_addm.analyze_db（：tname， 150， 162）；  END； /    Then you executed the following command：   SQL> SELECT dbms_addm.get_report（：tname） FROM DUAL；   The above command produces Automatic Database Diagnostic Monitor （ADDM） analysis（）
A

 with the CPU Usage finding if it is less than 90

B

 without the CPU Usage finding if it is less than 90

C

 with the CPU Usage finding for snapshots below 90

D

 with the CPU Usage finding for snapshots not between 150 and 162


正确答案： C
解析： 暂无解析

第10题：

单选题
If a backup set is expired， what can you do to correct the problem？（）
A

 Change the retention criteria.

B

 Make the lost backup set pieces available to RMAN again.

C

 Run the crosscheck command to correct the location for the backup set piece contained in the metadata.

D

 Nothing. The backup set piece is lost forever.

E

 Call Oracle support，their assistance is required.


正确答案： C
解析： 暂无解析

更多相关问题
相关内容