ITPub博客

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

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

QUESTION 111Which two statements are true about checkpointing? (Choose two.)A. The checkpoint frequency decreases with the smaller redo log file size.B. It ensures that all committed data is written to the data files during normal shutdown.C. The frequent full checkpoint in a database can cause ...

QUESTION 195Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)A. Avoid coding unnecessary longrunning transactions.B. Allow the database to handle locks in default locking mode.C. Always explicitly code the lock...

QUESTION 193In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)A. if a table is not in a clusterB. if a table has an active triggerC. if a table has an encrypted columnD. if a table has a column of data...

QUESTION 21View the Exhibit and examine the privileges granted to the SL_REP user.The EMP table is owned by the SCOTT user. The SL_REP user executes the following command:SQL> GRANT SELECT ON scott.emp TO hr;Which statement describes the outcome of the command?A. The command executes successf...

QUESTION 18Which two statements are true about alerts? (Choose two.)A. Clearing an alert sends the alert to the alert historyB. Response actions cannot be specified with server-generated alertsC. The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS viewD. Server-generated alerts notify ...

QUESTION 141Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)A. Undo tablespaceB. USERS tablespaceC. SYSAUX tablespaceD. SYSTEM tablespaceE. Temporary tablespaceCorrect Answer: CD参考：http://blog.csdn.net/rlhua/article/details/122331...