ITPub博客

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...

QUESTION 155Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)A. An SPFILE is a binary fileB. An SPFILE cannot reside on a clientC. An SPFILE cannot contain static parametersD. An SPFILE can store changes persistently across instance restartsE. An SPF...

QUESTION 122Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)A. All AWR tables belong to the SYSTEM schemaB. The AWR contains systemwide tracing and logging informationC. The snapshots collected by the AWR are accessible through data dictionary viewsD. T...

QUESTION 117Which two statements are true about standard database auditing? (Choose two.)A. DDL statements can be audited.B. Statements that refer to standalone procedure can be audited.C. Operations by the users logged on as SYSDBA cannot be audited.D. Only one audit record is ever created for...

QUESTION 95You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE;Which statements describe the effect of the command? (Choose all that apply.)A. The tablespace would require recovery to go back online.B. A checkpoint is taken on all d...

QUESTION 94Examine the following statement that is used to modify the primary key constraint on the SALES table:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;Which three statements are true regarding the above command? (Choose three.)A. The constraint remains valid.B. The index o...

QUESTION 87Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?A. It is the time period after which the undo data becomes obsolete.B. It is the time period after which the committed undo data would be transferred to a temporary tablespace.C. It is t...

QUESTION 53Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100...

QUESTION 15Which two statements are true regarding a tablespace? (Choose two.)A. It can span multiple databasesB. It can consist of multiple data filesC. It can contain blocks of different filesD. It can contains segments of different sizesE. It can contains a part of nonpartitioned segmentCo...

 326.Which of the following does the recover command not do?A. Restore archived redo logs.B. Apply archived redo logs.C. Restore incremental backups.D. Apply incremental backups.E. Restore datafile images.答案：E，但标准答案是A。下面给出测试过程。1...

QUESTION 81Which two statements are true regarding a PL/SQL package body? (Choose two.)A. It cannot be created without a package specification.B. It cannot invoke subprograms defined in other packages.C. It can contain only the subprograms defined in the package specification.D. It can be chang...