1Z0-083試験無料問題集「Oracle Database Administration II 認定」

A. The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the column select list of a query

B. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.

C. The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity tracking.

D. The ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set.

E. The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set.

A. It must have an application seed PDB.

B. It can contain a single application.

C. It must have an application root PDB.

D. Two application containers can share an application seed PDB.

E. It can contain multiple applications.

F. An application PDB can belong to multiple application containers.

A. a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled

B. a Data Warehouse database template, with t he dedicated server mode option and AMM enabled

C. a General Purpose database template with default memory allocation

D. a default database configuration

A. The database instance memory should always be tuned before tuning any file systems.

B. Tuning activities should stop once the user is satisfied with performance.

C. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.

D. Tuning activities should stop once agreed service levels for performance have been met.

E. The alert log should be used to find the database and instance areas most in need of tuning.

F. SQL statements should always be tuned before tuning any file systems.

A. PDB$SEED will be MOUNTED.

B. PDB1 will be opened READ WRITE.

C. PDB1 will be MOUNTED.

D. PDB2 will be opened READ WRITE.

E. PDB$SEED will be opened READ ONLY.

F. PDB2 will be MOUNTED.

A. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.

B. It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.

C. It can be used for applications and middleware.

D. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.

E. It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.

A. A sequence can provide numeric values for more than one column or table.

B. Sequence numbers that are allocated require a COMMIT statement to make the allocation permanent.

C. The data dictionary is always updated each time a sequence number is allocated.

D. A sequence can issue the same number more than once.

E. Sequences that start with 1 and increment by 1 can never have gaps.

A. Unified Auditing can be configured to audit only events that are issued indirectly by all users

B. Schema Only accounts can be granted administrator privileges.

C. Unified Auditing can be configured to audit only events that are issued directly by an audited user.

D. All the Oracle-supplied accounts are Schema Only accounts.

E. If the password file location changes, then the instance must be restarted.

A. A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.

B. Two or more PDBs can be cloned with the same command.

C. A non-CDB can be cloned into a PDB.

D. The target and auxiliary instance passwords must be the same.

E. Only one PDB can be cloned at a time.

F. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.

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

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

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

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

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

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

A. Database Replay always uses one replay client for all the original database sessions.

B. SQL Performance Analyzer can identify regressed SQL statements.

C. Database Replay always uses one replay client for each original database session.

D. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two non-consecutive periods.

E. The Active Session History (ASH) report is based on wait event samples.

F. SQL Performance Analyzer can suggest schema changes.

G. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two consecutive periods.

A. It can be used to upgrade only single-instance databases running on Oracle Restart.

B. It can be used only on nodes with Oracle Grid Infrastructure installed.

C. It can be used to create a single-instance Oracle Database in an already-installed Oracle home.

D. It can be used to deploy new homes without disrupting active databases.

E. It can be used to patch existing Oracle software installations.

F. It can be used to create templates of Oracle homes as gold images of only Oracle databases.

A. It analyzes a period of time corresponding to the last day of activity.

B. It runs automatically after each AWR snapshot.

C. It analyzes a period of time corresponding to the 12 hours of activity.

D. Results are written to the alert log.

E. A DBA can run it manually.

A. Backups can be done incrementally.

B. Backups must be done incrementally.

C. Only consistent backups can be created.

D. The database must be registered in an RMAN catalog.

E. Backups can be taken only if the database is in ARCHIVELOG mode.

F. Backups must be contained in backup sets.