ITPub博客

617.A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCYFAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2'FAILGROUP controller2 DISK '/devices/diskb1', '/device...

99.View the Exhibit and examine the steps that you executed to create a database resource plan.Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?Exhibit:A. The pending area is auto...

675.Which two client requests are captured during database replay Capture? (Choose two)A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL *loaderE. Data definition language (DDL) a...

666.You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the tab...

212.Note the following parameters settings in your database:SGA_MAX_SIZE = 1024MSGA_TARGET = 700MDB_8K_CACHE_SIZE = 124MLOG_BUFFER = 200MYou issued the following command to increase the value of DB_8K_CACHE_SIZE:SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;What would happen?A. It will fail be...

205.You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?A. The database instance starts, and Oracle sets the default value of SG...

156.What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?A. The number of DBWR processes increasesB. The number of ASMB processes increasesC. The number of DBWR_TO_SLAVES increasesD. The rebalancing operation in an ASM instance completes more quickly, but can result in hig...

128.You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To ...

663.Which options would you consider while configuring a flash recovery area (fast recovery area in 11gRelease 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)A. Setting the FAST_START_MTTR_TARGET to set the mean time to recoverB. Setting the RECOVERY_PA...

602.On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am.Which option must you use to check whether a flashback operation can recover the database to the specified time?A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC...

605.What two are the prerequisites for enabling Flashback Database? (Choose two)A. The database must be in ARCHIVELOG modeB. The database must be in MOUNT EXCLUSIVE modeC. The database must be opened in RESTRICTED modeD. The database instance must be started in the NOMOUNT stateE. The database ...

678.Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)A.Flash recovery area must be definedB.Undo retention guarantee must be enabled.C.Database must be running in archivelog mode.D.Automatic undo management must be enabled.E.The tablespace in which the Flas...

677.What are the prerequisites for performing flashback transactions? (Choose all that apply)A.Supplemental log must be enabledB.Supplemental log must be enabled for the primary keyC.Undo retention guarantee for the database must be configuredD.EXECUTE permission on the DBMS_FLASHBACK package mu...

669.User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA,which commands must you execute to enable SCOTT to flash back the transactions? (Choose four.)A. ALTER DATABASE FLASHBACK ON;B. GRANT SELECT any transaction TO scott;C. GRANT EXECUTE ON dbms_flashback T...

667.What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?什么是db_flashback_retention_target参数配置？A. An upper limit on how far you can flash back the database, depending on the information in the redologsA. 根据在redologs中的信息，你可以闪回数据库多长时间的一个上限 B. An u...

QUESTION 128Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choose three.)A. The corresponding indexes for the table are also truncated.B. Delete triggers on the table are fired during the execution of the TRUNCATE command.C. The child table is truncat...

QUESTION 112Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)A. You cannot export data from a remote database.B. You can rename tables during an import operation.C. You can overwrite existing dump files during an export operation.D. You can...

QUESTION 80The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transaction in the system. Each row has cumulative transaction details of a single product and every product is identified by a product code, which is the primary key. As part of the archival pr...

View the Exhibit to examine the error that occurred during the database startup. You opened an RMANsession for the database. To repair the failure, you executed the following command as the first RMANcommand:RMAN> REPAIR FAILURE;Which statement describes the consequence of this command?A. Th...

QUESTION 177Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)A. It can be increased up to the value of the SGA_MAX_SIZE parameter.B. Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.C...