A. A primary key must have been created.
B. A mapping table must have been created.
C. An overflow tablespace must have been specified.
D. The PCTTHRESHOLD option must have been specified.
您可能感兴趣的试卷
你可能感兴趣的试题
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command：
RMAN> RESTORE CONTROLFILE；
Which two operations do you need to perform after restoring the control file from backup？（）
A. shut down and restart the instance
B. add new tempfiles to the temporary tablespaces after recovery
C. perform a media recovery and open the database with the RESETLOGS option
D. perform a media recovery and bring the database to NOARCHIVELOG mode
Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery：
RMAN> RUN {
2> SET UNTIL SEQUENCE 230 THREAD 1；
3> ALTER DATABASE MOUNT；
4> RESTORE DATABASE；
5> RECOVER DATABASE；
6> ALTER DATABASE OPEN RESETLOGS；
7> }；
With reference to this scenario， which statement is true？（）
A. RMAN recovers up to log sequence 230， but not including 230.
B. RMAN returns an error because the log sequence number mentioned in the command should be 229.
C. RMAN returns an error because the log sequence number mentioned in the command may never be missing.
D. RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
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
A. The EVENT parameter was not set
B. The SQL_TRACE parameter is set to FALSE
C. The Enterprise Manager Grid Control is not used
D. The STATISTICS_LEVEL parameter is set to BASIC
E. The TIMED_STATISTICS parameter is set to FALSE
A. CPU usage
B. degree of parallelism
C. number of open cursors
D. number of sorts performed
E. idle time for blocking sessions
F. number of disk I/O operations performed
G. number of memory I/O operations performed
A. It keeps track of changes in the background processes.
B. It records the system change number （SCN） in the control file.
C. It writes audit records for user changes to the change tracking file.
D. It records any changes to the listened configuration in the listener.ora file.
E. It records any changes to the database parameters in the change tracking file.
F. It records the physical location of all the changes that are made to the database in the change tracking file.
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below：
SGA_TARGET= 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario？ （）
A. A maximum of 3 GB can be allocated to shared pool
B. The value for SGA_TARGET can be increased up to a maximum of 15 GB
C. A total of 14 GB memory will be allocated to the automatically tuned memory components.
D. Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
F. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
A. when you need to disable the index usage
B. when you need to change storage options
C. when you need to enable index monitoring
D. when you need to move the index to another tablespace
A. configure a default device for RMAN backups
B. temporarily disable the retention policy for RMAN backups
C. configure automatic channel allocation for RMAN backups
D. use the CONFIGURE command to reconfigure the recovery window to 60 days
A. create a hash cluster to store the data
B. create an index cluster to store the data
C. create a partitioned table to store the data
D. create a sorted hash cluster to store the data
E. create a heap table with rowid to store the data
最新试题
Consider the recovery steps in each of the cases given below： Case 1： Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files， open the database using the RESETLOGS option. Back up the database. Case 2： Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3：Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？ （）
You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to recreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to recreate the indexes？（）
One of the tablespaces is readonly in your database. The loss of all control files forced you to recreate the control file. Which operation do you need to perform after recreating the control file and opening the database？（）
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）
Your database operates in ARCHIVELOG mode. Usermanaged consistent backups are performed every Sunday night. On Tuesday， client A drops a table at 8：00 a.m. as follows： SQL> DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9：00 a.m. on the same table as follows： SQL> SELECT * FROM cust_ord;SELECT * FROM cust_ord* ERROR at line 1： ORA00942： table or view does not exist Client B needs the dropped table and reports the problem to you. With reference to this scenario， which action should you take？（）
Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup？（）
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancelbased recovery？（）
You lost the PRODSTD tablespace， which was read/write. The tablespace was readonly when the last backup was performed. How would you recover the tablespace？（）