ITPub博客

466.What can you determine about the following linguistic sorts based only on their names?1. GERMAN2. FRENCH_MA. 1 is a monolingual sort.B. 2 is a monolingual sort.C. 1 is case insensitive.D. Both 1 and 2 are case insensitive.E. Case sensitivity is unknown.Answer: Alinguistic: 语法; ...

608.You are managing a 24*7 database. The backup strategy for the database is to performuser-managed backups.Identify two prerequisites to perform the backups. (Choose two.)A. The database must be opened in restricted mode.B. The database must be configured to run in ARCHIVELOG mode.C. The tabl...

570.What methods of point-in-time recovery are available? (Choose all that apply.)A. Change-basedB. Cancel-basedC. Time-basedD. Sequence number-basedE. Transaction number-basedAnswer: ABCD参考：http://blog.csdn.net/leshami/article/details/7909887(Oracle 基于用户管理的不完全恢复)  &nbsp...

707. Because of a logical corruption in the EMPLOYES tables, you want to perform TablespacePoint-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, youqueried the TS_PITR_CHECK view and you realized that the table has a referential constraint withDEPARTMENTS th...

585.What type of backup is stored in a proprietary RMAN format?A. Backup setB. Image copyC. Backup sectionD. Backup groupAnswer: Aproprietary: 专有的

500.You opened the encryption wallet and then issued the following command:SQL>CREATE TABLESPACE securespaceDATAFILE '/home/user/oradata/secure01.dbf'SIZE 150MENCRYPTION USING '3DES168'DEFAULT STORAGE(ENCRYPT);Then you closed the wallet. Later, you issued the following command to create the EM...

389.The _______ writes the Flashback Database logs in the flash recovery area.A. FLSHB. FLDBC. RVWRD. RVRWE. FBDAAnswer: CRVWR= Recovery Writer ProcessRVWR writes flashback data from the flashback buffer in the SGA to the flashback logs. RVWR also creates flashback logs and performs some ...

607.Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consistent backup is taken every Sunday.-On Tuesday the instance terminates abnormally because the disk on which control files are located getscorruptedThe disk having active online redo log files is also corru...

437.Within a resource-plan definition, what differentiates a top-level plan from a subplan?A. A subplan has the PLAN_SUB parameter value set to SUB.B. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in theresource-plan definition.C. There is no difference in the r...

524.What are three benefits of using ASM? (Choose three.)A. Ease of disk administration and maintenanceB. Load balancing across physical disksC. Software RAID-1 data redundancy with double or triple mirrorsD. Automatic recovery of failed disksAnswer: ABCD错误C在软件层面的RAID-1(RAID 1通过磁...

111.Which three statements are true regarding persistent lightweight jobs? (Choose three.)A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.B. The user cannot set privileges on persistent lightweight jobs.C. Persistent lightweight jobs are usefu...

701. A user receives the following error while performing a large volume of inserts into a table:The issue is resolved by increasing the space quota on the USERS tablespace for the user. But the usermay perform such transaction in the future. You want to ensure that the command waits rather than...

711. The following command is executed to shut down an Automatic Storage Management (ASM)instance:SQL>SHUTDOWN ABORT;Which two statements describe the consequences of the above command? (Choose two.)A.The disk groups are orderly dismounted.B.The ASM instance requires recovery when it is started...

26.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schemaowned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalogschema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242,...

196.What is the purpose of the catalog command?A. To review RMAN control file and recovery catalog metadata and ensure that its correctB. To delete RMAN backup-related metadata from the recovery catalogC. To create metadata in the control file and the recovery catalog related to backup set pieces...

148.Which dependent object will get invalidated even if it is not affected by the table edefinition?A. packagesB. triggersC. synonymsD. viewsAnswer: B在线重定义之后，新表没有此触发器触发器定义：CREATE OR REPLACE TRIGGER tr_t before update on table_before显然，触发器定义的语句ON部分就已经...

48.View the Exhibit to examine the error obtained during the I/O calibration process. There are no datafiles on raw devices. What is the reason for this error?A. The DISK_ASYNCH_IO parameter is set to TRUE.B. The FILESYSTEMIO_OPTIONS parameter is set to NONE.C. Another session runs the I/O cali...

223.You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a movingwindow baseline. Which action would you take before performing this task?A. Compute the baseline statistics.B. Take an immediate AWR snapshot.C. Decrease the window size for the baseline.D. Dec...

374.Which of the following statements are true regarding the Recycle Bin? (Choose all that apply.)A. The Recycle Bin is a physical storage area for dropped objects.B. The Recycle Bin is a logical container for dropped objects.C. The Recycle Bin stores the results of a Flashback Drop operation.D....

347.What does the output on this report indicate?RMAN> report need backup;RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1Report of files with less than 1 redundant backupsFile #bkps Name5 0 C:\ORACLE\ORADATA\ORCL\MY_DATA_01.DBFA. The my_data_01...