ITPub博客

（17）The INV_HISTORY table is created using the command:CREATE TABLE INV_HISTORY(  inv_no NUMBER(3),  inv_date DATE,  inv_amt NUMBER(10,2))partition by ...

（16）Because of a logical corruption in your production database,you wanted to perform Tablespace Point in Time Recovery(TSPITR).But before you start the recovery,you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects thatwould be dropped whe...

（15）You are in the process of creating a virtual private catalog in your Oracle Database 11g database.The PROD1,PROD2,and PROD3 Oracle Database 10g databases are registered in the base recovery catalog.The database user who owns the base recovery catalog is CATOWNER.CATOWNER executes th...

（14）Which two statements are true regarding hot patching?(Choose two.)A. It requires relinking of the Oracle binary.B. It does not require database instance shutdown.C. It can detect conflicts between two online patches.D. It is available for installing all patches on all platforms....

（13）View the Exhibit that sets the threshold for the Current Open Cursors Count metric.Why is the Significance Level threshold type not available in the threshold setting?A. because AWR baseline is not enabledB. because Current Open Cursors Count is not a basic metricC. because the ...

（12）You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.After some days,you want to change the status of the database backup and you issued the following command:RMAN>CHANGE BACKUPSET 231 NOKEEP;What is the implication of this command?...

（11）View the Exhibit to examine the metrics with a threshold.Which statement is true regarding the Number of Transactions(per second)metric?A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.B. The statistics for the metric values...

（10）Consider the following scenario for your database:Backup optimization is enabled in RMAN.The recovery window is set to 7 days in RMAN.The most recent backup to disk for the TOOLS tablespace was taken on November 3,2007.The TOOLS tablespace is read-only since November 4,2007....

（9）Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?A. It returns space usage of only BasicFile LOB chunks.B. It returns space usage of only SecureFile LOB chunks.C. It returns both BasicFile and SecureFile LOB space usage fo...

（8）Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?A. It cannot be done in parallel.B. It can be done at the table level or partition level.C. It does not require additional storage because the operation is done online.D. ...

（7）You need to configure fine-grained access control to external network resources from within your database.You create an access control list(ACL)using the DBMS_NETWORK_ACL_ADMIN package.Which statement is true regarding the ACL created?A. It is a list of remote database links stored i...

（6）You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11.The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1...

（5）Examine the section of the Health Check report given below:DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')Run Name:HM_RUN_1061 Run Id:1061Check Name:Data Block IntegrityCheck Mode:REACTIVEStatus:COMPLETED...

（4）Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.)A. a jobB. a programC. a scheduleD. a PL/SQL procedure答案：（A、B、C）

（3）Your database is in ARCHIVELOG mode.You have two online redo log groups,each of which contains one redo member.When you attempt to start the database,you receive the following errors:ORA-00313:open failed for members of log group 1 of thread 1ORA-00312:online log 1 thread 1:'D:\REDO0...

（2）You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold.Which statement factors in this consideration while increasing the size of the moving window.?A.The collection level for the AWR should be set...

（1）While deploying a new application module,the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced.Which two statements describe the consequences?(Choose two.)A.The plan baselines can be evolved over time to produce bet...

到此，Oracle 11G 1Z0-052的所有题目的解析都给大家总结完了。大家在我的博文目录中，可以看到所有题目的解析。希望大家参考、练习、顺利通过OCP考试！

（188）You receive complaints  from users  regarding the high waiting time for their transactions.On investigation, you find that some users are not committing their transactions though they are not performing any activity for a long time.As a result, SQL statements need to wait for...

（187）Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)A. Avoid coding unnecessary long-running transactions.B. Allow the database to handle locks in default locking mode.C. Always explicitly code the loc...