先試後買

A. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

B. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

C. In a PDB plan, subplans may be used with up to eight consumer groups.

D. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

E. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

A. when you perform active database duplication on a database that has readonly tablespaces

B. when the duplicate ... from active database command contains the section size clause

C. when the number of auxiliary channels allocated is equal to or greater than the number of target channels

D. when you perform active database duplication on a database with flashback disabled

E. when you specify set encryption before the duplicate ... from active database command

A. Uncommitted transactions are allowed to continue to the next COMMIT.

B. New connection requests made to the database instance are refused.

C. All existing connections to the database instance remain connected until all transactions either roll back or commit.

D. All existing transactions are aborted immediately.

E. Uncommitted transactions are rolled back automatically.

A. The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

B. The runfixup.sh script can install missing RPMs.

C. It can be done after installing Grid Infrastructure for a Standalone Server.

D. The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

E. It allows you to select the languages supported by the Oracle database server.

F. The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.

G. It can be done before installing Grid Infrastructure for a Standalone Server.

A. Tracking the most recent write time for a table block

B. Tracking insert time by row for table rows

C. Tracking the most recent read time for a table segment in a user tablespace

D. Tracking the most recent read time for a table segment in the SYSTEM tablespace

E. Tracking the most recent write time for a table segment in a user tablespace

F. Tracking the most recent write time for a table segment in the SYSAUX tablespace Correct

A. 1, 3, 5, 6, 10

B. 1, 3, 5, 7, 10

C. 1, 2, 5, 7, 4, 10

D. 1, 3, 5, 8, 6, 10

E. 1, 3, 5, 6, 9

A. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.

B. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

C. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB.

D. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

E. SPFILE backups can be created while connected to an application root PDB.

A. using the CREATE TABLE AS SELECT SQL statement

B. using Database Replay

C. using Oracle Data Pump

D. using SQL Developer

E. using operating system file copy utilities

F. using Database Upgrade Assistant

A. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

B. The valid time columns employee_time_start and employee_time_end are automatically created.

C. Thesamestatementmayfilteronbothtransactiontimeandvalidtemporaltimebyusingthe AS OF TIMESTAMP and PERIOD FOR clauses.

D. The valid time columns are not populated by the Oracle Server automatically.

E. The valid time columns are visible by default when the table is described.

A. V$SESSION_WAIT and V$SESSION both contain details of the event on which a waiting session is currently waiting.

B. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

C. V$SERVICE_EVENT displays wait counts for every wait event for each service even including counts of zero for waits that never occurred.

D. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for terminated sessions.

E. V$SESSION_EVENT displays all waits events for those events that have occurred at least once for sessions that have now terminated.

A. OSRACDBA

B. OSOPER

C. OSDBA

D. OSKMDBA

E. OSASM

A. It succeeds.

B. Itsucceeds only if the target database is greater than 400M.

C. No catalogued backup of the TARGET is used to duplicate the database.

D. It fails because no parallel channels are allocated for the auxiliary database.

E. It fails because connection to the AUXILIARY instance must be as SYSDBA.

A. They are only released quarterly.

B. A base release is not needed to install patchsets.

C. They can be applied in a rolling fashion for Clusterware and the databases.

D. They can introduce new features.

E. Installing a patchset is considered an "upgrade".

F. They are installed via OPatch or OPatchAuto.

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

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

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

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

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

A. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

B. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

C. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

D. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

E. Automatic Memory Management must be used together with locking the System Global Area into physical memory.

F. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.