ITPub博客

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

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

QUESTION 16Which two statements are true regarding Oracle Data Pump? (Choose two.)A. EXPDP and IMPDP are the client components of Oracle Data PumpB. DBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clientsC. Oracle Data Pump export and import operations can be performed o...

QUESTION 13Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)A. Failure when no standby database is configuredB. Failure because a data file is renamed accidentallyC. Failure that requires no archive logs to be applied for recoveryD. Fail...

QUESTION 197These are points that describe the contents of different memory components:1: Descriptive information or metadata about schema objects that are queried by using SQL statements2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements3: Resul...

私拉乱接导致网络打印机故障接客户报告，多台网络打印机故障，不能正常打印。首先检查打印机，面板按键没有反应；断开打印机网络，面板按键反应正常。不接网络，通过USB线直连电脑，打印机工作正常。因有多台打印机均出现类似故障现象，初步排除打印机自身故障，怀疑是网络问题导致。接上笔记本，检查电脑上网情...