ITPub博客

（298）While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available.What would the optimizer do in this situation?A. It updates the existing SQL profiles with current statistics.B. It makes the statistics informat...

（297）View the Exhibit for some of the parameter settings. You start a session and issue the following command:SQL>CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;What is the outcome of the above command?A. The index is not used by the optimizer but is main...

（296）You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.What is t...

（295）Which statement about using RMAN stored scripts is true?A. To create and execute an RMAN stored script, you must use a recovery catalog.B. When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C. ...

（294）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答案：（B）

（293）Observe the following warning in an RMAN session of your database instance:WARNING: new failures were found since last LIST FAILURE commandWhich statement describes the scenario that must have produced this warning?A. The CHANGE FAILURE command has detected new failures recorded in...

（292）You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc.Which two statements are true regarding this oranfstab file? (Choose two.)A. Its entries are specific to a single database.B. It contains file systems that have been ...

（291）ENCRYPT_TS is an encrypted tablespace that contains tables with data.Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?A. The data is decrypted during SORT and JOIN operations.B. The data rema...

（290）What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)A. ORACLE_BASE should be set explicitly.B. An Oracle base should have only one Oracle home created in it.C. Flash recovery area and da...

（289）You are managing the APPPROD database as a DBA which is not using the Oracle-managed files.You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed ...

（288）You are maintaining the SALES database. You have added a new disk to a disk group.Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?A. ASM...

（287）Evaluate the following command:SQL> CREATE TABLE design_data (id NUMBER, doc CLOB) LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);Which statement is true regarding the above command?A. The LOB values are automatically compressed.B. The LOB values are cached by default in the bu...

（286）The Oracle Database 11g database is running in the ARCHIVELOG mode.The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'LOG_ARCHIVE_DEST_2 = 'SERVICE =...

（285）View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.答案：（A）

（284）Evaluate the following SQL statement used to create the PRODUCTS table:CREATE TABLE products(  product_id NUMBER(3) PRIMARY KEY,  product_desc VARCHAR2(25),  qty NUMBER(8,2),...

（283）You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0MEMORY_TARGET=500MPGA_AGGREGATE_TARGET=90MSGA_TARGET=270MWhich two statements are true regarding these parameters after the database instance is restarted?(Choose two.)A...

（282）You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0.In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.Which two statements are tr...

(281)You are working on a 24 X 7 database. You want to design a backup strategy for your database that uses user managed backups.You want to be able to perform all backups while the database remains online.Which statement about performing user-managed backups in a 24x7 environment is true?...

（280）View the Exhibit to examine the replay settings for replay parameters. What is the implication for setting the values for replay parameters? (Choose all that apply.)A. The COMMIT order in the captured workload is preserved during replay.B. The value 100 in the THINK_TIME...

（279）Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.)A. generating the SQL profileB. testing and accepting the SQL profileC. generating a list of candidate SQLs for tuningD. adding tuned SQL plans into ...