问题:单选题As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?()A CKPTB SMONC MMOND DBWR...
查看答案
问题:多选题Which two statements are true regarding the USING and ON clauses in table joins?()ABoth USING and ON clauses can be used for equijoins and nonequijoinsBAmaximum of one pair of columns can be joined between two tables using the ON clauseCThe ON clause c...
问题:多选题You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?()AYou are backing up to tape and your tape device performs its own compression.BYou are making image copies, and you have not ena...
问题:单选题Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?()A PLSQL_BLOCKB JAVA_STORED_PROCEDUREC STORED_PROCEDURED EXECUTABLEE None of the above are invalid settings....
问题:多选题What are the advantages of variable extent size support for large ASM files?()AIt improves resync operations when the disk comes online after being taken offline for maintenance purposes.BIt improves performance in the extended cluster configuration by...
问题:单选题During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?()A The installation te...
问题:Which tuning tool recommends how to optimize materialized vi...
问题:多选题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 ...
问题:多选题Which three elements can a job chain process involve?()Aan eventBa scheduleCa programDanother chainEa lightweight job...
问题:多选题Which three statements are true regarding the data types in Oracle Database 10g/11g?()AOnly one LONG column can be used per tableBA TIMESTAMP data type column stores only time values with fractional secondsCThe BLOB data type column is used to store bi...
问题:多选题The NLS_SORT parameter sets the default sort method for which of the following operations?()AWHERE clause WHEREBORDER BY clauseCBETWEEN clauseDNLSSORT functionENLS_SORT function...
问题:单选题You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?()A Mount the databaseB Open the database in NORMAL ...
问题:多选题Which two activities are NOT supported by the Data Recovery Advisor?()ADiagnose and repair a data file corruption offline.BDiagnose and repair a data file corruption online.CDiagnose and repair failures on a standby database.DRecover from failures in t...
问题:Examine the following command: ALTER DISKGROUP data MOUNT FO...
问题:多选题The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario?()AThe optimi...
问题:单选题Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?()A only encryption and compression settings for all SecureFile LOBsB only encryption and deduplication settings for only SecureFile CLOBsC deduplication, encryption, and compress...
问题:多选题Which three are the valid statements in relation to SQL plan baselines?()AThe plans can be manually loaded to the SQL plan baseline.BThe plans in the SQL plan baseline are verified and accepted plans.CThe plans generated for every SQL statement are sto...
问题:单选题Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance ta...
问题:多选题You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()AAll the objects of scott are moved to the Recycle Bin.BAny objects in the Recycle Bin belonging to scott are pur...
问题:单选题Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? ()A SQL statements that are part of the AWR baseline only B SQL statements based on the AWR top SQL identificationC SQL statements that are part of the availa...