ITPub博客

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...

201.Examine the following PL/SQL block:SET SERVEROUTPUT ON SET LONG 10000 DECLARE   report clob;BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();  DBMS_OUTPUT.PUT_LINE(report);END;Which statement describes the effect of the execution of the above PL/SQL block?A. ...

258.Which two statements are true regarding the SQL Repair Advisor? (Choose two.)A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statementcrash.C. The SQL Repa...

633.Which three statements must be true before transporting a tablespace from a database on oneplatform to a database on another platform? (Choose three.)A. Both source and target database must be the same character setB. Both source and target database must have the same endian formatC. The COM...

454.If a job references a schedule that has been disabled, what will be the result?A. The job will be automatically disabled.B. The job will never execute.C. The job will attempt to execute but will fail.D. The job will inherit the DEFAULT_SCHEDULE schedule.E. A schedule object cannot be disabl...

520.Which of the following are not disabled by default?A. JobsB. ChainsC. WindowsD. Window groupsE. ScheduleAnswer: E