최신 1Z0-083 무료덤프 - Oracle Database Administration II

A. root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.

B. root.sh can be executed automatically by the Database installer only by using sudo credentials.

C. The sudo password must be specified in a response file.

D. The root password cannot be specified in a response file.

E. orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.

F. The sudo password can be specified in a response file.

A. All archive redo log files are automatically copied to the duplicate database.

B. The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.

C. he duplicate command.

D. The duplicate database is created by using the backups created during the execution of

E. The duplicate database is created without using RMAN backups and prod1 is allowed to remain open during duplication.

F. The duplicate database has the same directory structure as the source database.

A. Database Replay

B. SQL Performance Analyzer

C. Active Session History (ASH) report

D. Automatic Database Diagnostic Monitor (ADDM) Compare Period report

A. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

B. The UNDO TABLESPACE clause is never required.

C. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

D. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.

E. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

A. A backup set may be duplexed with both copies written to sbt.

B. An image copy on sbt can be copied to disk.

C. An image copy on disk can be copied to disk.

D. An image copy on disk can be copied to sbt.

E. A backup set may be duplexed so that one copy is written to sbt and the other to disk.

F. A backup set may be duplexed with both copies written to disk.

A. A common unified audit policy can be created at the CDB level.

B. Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.

C. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.

D. A common unified audit policy can be created at the application root level.

E. All audit records are written to the audit trail in CDB$ROOT

F. An application PDB cannot have a local audit policy.

A. The Statistics Advisor generates actions for all recommendations.

B. The Statistics Advisor can help recommend the best way to gather statistics.

C. Index balanced B*Tree height is considered when evaluating the cost of using an index.

D. Statistics collected using DBMS_STATS always yield the best optimizer result.

E. The number of table rows is considered when evaluating the cost of accessing a table using an index.

A. The active database must be duplicated while in OPEN state.

B. Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.

C. Pre-existing backups of the database to be duplicated are always used if they exist.

D. Backup sets can be used to duplicate the active database.

E. No connection to the recovery catalog is required for active database duplication.

F. Image copies can be used to duplicate the active database.

G. Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.

A. CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4

B. CDB$ROOT, PDB1, PDB2, PDB3, and PDB4

C. CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3

D. CDB$ROOT, PDB2, PDB1, and PDB3

E. CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4

A. It can be used to deploy Oracle Database homes.

B. It cannot be used to provision applications.

C. It is an Oracle Database service.

D. It can be used to deploy Grid Infrastructure homes, including Oracle Restart.

E. It is an Oracle Grid Infrastructure service.

F. It cannot be used to provision middleware.

A. You can use it to create image copies for database files.

B. You can use it to create proxy copies for entire file systems.

C. You can use it to create proxy copies for database files.

D. You can use it to create backup sets for database files.

E. You can use it to create image copies for entire file systems.

A. They can be gathered by the DBMS_STATS package.

B. By default, they are automatically gathered by a maintenance job.

C. They are gathered by the SQL Tuning Advisor.

D. They are ignored by Optimizer if they are stale.

E. They provide real-time data about schema objects.