1z1-062試験無料問題集「Oracle Database 12c: Installation and Administration 認定」

A. It will create a CDB with root opened and seed mounted.

B. It will create a multitenant container database (CDB) with only the root opened.

C. It will create a CDB with root and seed opened and one PDB mounted.

D. It will create a CDB with root opened and seed read only.

E. It will create a CDB that must be plugged into an existing CDB.

A. Tables cannot be renamed during an import operation.

B. Existing dump files can be overwritten during an export operation.

C. Only data can be compressed during an export operation.

D. You cannot specify how partitioned tables should be handled during an import operation.

E. Metadata that is exported and imported can be filtered based on objects and object types.

A. cleaning up the database buffer cache and freeing resources that a client process was using

B. restarting a server or a dispatcher process that terminated abnormally

C. performing database services registration with the default listener

D. applying online redo during instance recovery

E. recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline errors

F. cleaning up temporary segments that are no longer needed

A. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

B. Automatic Shared Memory Management is not enabled.

C. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.

D. The keep pool is not configured.

E. Automatic Workarea Management is not configured.

A. Windows work with job classes to control resource allocation

B. Consumer groups are associated with windows

C. The database service name must be provided during windows creation

D. Windows can automatically start job or change resource allocation among jobs for various time periods

E. Only one window can be open at any given time

A. A subset of executed DDL statements is written to the DDL log in ADR home.

B. All data definition language (DDL) commands are logged in to the alert log file.

C. All DDL commands are logged in to a trace file in ADR home.

D. A subset of executed DDL statements is written into an XML file in ADR home.

E. All DDL commands are logged in to a text file in Automatic Diagnostic Repository (ADR) home.

A. To enable flashback database, the CDB must be mounted.

B. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

C. The root container can be flashed back without flashing back the pluggable databases (PDBs).

D. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

E. Individual PDBs can be flashed back without flashing back the entire CDB.

A. 3 and 1

B. 1 and 2

C. Only 3

D. Only 2

E. Only 1

A. It can be used to control the consumption of only physical I/Os where excessive physical I/Os can trigger an automatic session termination but excessive logical I/Os cannot.

B. A resource plan change can be automated by using the Oracle Scheduler.

C. It can be used to control the usage of the undo tablespace by consumer groups.

D. A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.

E. It can be used to control the usage of the temp tablespace by consumer groups.

F. It can be used to enable resumable timeout for user sessions.

A. It writes the checkpoint position to the data file headers.

B. It advances the checkpoint position in the checkpoint queue.

C. It signals CKPT to write the checkpoint position to the data file headers.

D. It writes the checkpoint position to the control file.

A. RMAN

B. The DBMS_PDB package

C. Transportable database

D. Transportable tablespace

E. Data Pump full export/import

A. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

B. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

C. The ASM compatibility attribute controls the format of the disk group metadata.

D. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

E. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

A. SQL Tuning Advisor

B. Memory Advisor for the PGA

C. SQL Access Advisor

D. Memory Advisor for the shared pool

A. Statements that refer to standalone procedure can be audited.

B. DDL statements can be audited.

C. Only one audit record is ever created for a session per audited statement even though it is executed more than once.

D. Operations by the users logged on as SYSDBA cannot be audited.