当前分类： OCP 11G认证考试
问题：单选题Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）A User processB Server...
查看答案
问题：单选题Consider the following scenario for your database: Which statement is true regarding the backup of the TOOLS tablespace?（）A The RMAN backup fails because the TOOLS tablespace is read-onlyB The RMAN skips the backup of the tablespace because backup o...
问题：单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）A Segment AdvisorB SQL Access AdvisorC Undo AdvisorD SQL Tuning Advisor...
问题：多选题Which of the following are valid settings for the NLS_COMP parameter?（）AASCIIBANSICBINARYDMONOLINGUALEMULTILINGUAL...
问题：单选题Your archive-log destination directory runs out of space. What is the impact of this on the database?（）A None. The database will switch over to the stand-by archive-log destination directory. B A warning message will be written to the alert log of the ...
问题：单选题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 ...
问题：多选题Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）Afailures because a data file is renamed by errorBfailures when no standby database is configuredCfailures that require no archive logs to be applied for rec...
问题：多选题On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）Afixed tablesBheap tablesCexternal tablesDtemporary tablesEIndex-Organized Tables (IOTs)...
问题：单选题Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）A SQL Repair AdvisorB SQL OptimizerC SQL Access AdvisorD SQL Tuning Advisor SQL...
问题：单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）A Drop the affected tablespace, r...
问题：单选题Which steps are mandatory to enable Direct NFS?（） 1. Mount all required file systems using the kernel NFS driver. 2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS. 3. Replace the ODM library libo...
问题：单选题The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）A to prevent the creation of an excessive number of scheduler job classesB to allow the Automated M...
问题：单选题The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）A statistics recommendationsB SQL Pro...
问题：单选题The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）A CREATE SYNONYM ord FOR orders; This c...
问题：多选题When does a transaction complete?（）Awhen a DELETE statement is executedBwhen a ROLLBACK command is executedCwhen a PL/SQL anonymous block is executedDwhen a data definition language (DDL) statement is executedEwhen a TRUNCATE statement is executed afte...
问题：单选题Examine the following command: SQL ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）A The shrink operation touches every block in the BOOKING tableB The high-water mark (HWM) for the BOOKING...
问题：单选题In which cases is reference partitioning effective in enhancing performance?（）A It is effective only in partition pruning.B It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.C It is e...
问题：多选题Which two statements regarding a SQL profile are true?（）AIt is built by Automatic Tuning Optimizer.BIt cannot be stored persistently in the data dictionary.CIt can be used by the query optimizer automatically.DIt can be created manually by using the CR...
问题：单选题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 ...
问题：多选题Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（）ABackup retention policyBDefault backup device typeCDefault destinations for backupsDMultiple backup device types for single backupEDef...
