1Z0-063 Online Practice Questions and Answers

You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR

schema.

After a few days, you want to alter the EMPLOYEES table by executing the command:

SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);

Which statement is true about the execution of the command?

A. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.

B. It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.

C. It executes successfully and continues to store metadata related to the EMPLOYEES table.

D. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.

Which three statements are true about automated maintenance tasks? (Choose three.)

A. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.

B. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.

C. They run at predefined time intervals that are intended to occur during a period of low system loads.

D. An Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a maintenance window.

E. A maintenance window is automatically extended until all the maintenance tasks defined are completed.

Which three statements are true about Flashback Data Archive? (Choose three.)

A. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

B. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.

C. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database.

D. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.

E. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

A. configuration of unified auditing mode

B. execution of SQL statements by users connected with the SYSDBA privilege

C. usage of the AUDIT statement

D. creation of a fine grained audit policy

Which two parameters must be set to configure the fast recovery area? (Choose two.)

A. DB_CREATE_FILE_DEST

B. DB_RECOVERY_FILE_DEST

C. DB_RECOVERY_FILE_DEST_SIZE

D. LOG_ARCHIVE_DEST

E. at least two locations using DB_CREATE _ONLINE_LOG_DEST_n

F. DB_FLASHBACK_RETENTION_TARGET

You plan to upgrade a production database running in NOARCHIVELOG mode that has no Fast Recovery

Area configured.

The upgrade must be reversable within as quickly as possible with the smallest overhead.

Which three steps must you perform before you start the upgrade? (Choose three.)

A. Configure a flashback retention target and the Fast Recovery Area.

B. Configure the Fast Recovery Area.

C. Configure the database in ARCHIVELOG mode.

D. Create a normal restore point.

E. Take a database backup.

F. Create a guaranteed restore point.

You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).

You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.

What is the easiest way to perform capacity planning for consolidation?

A. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system

B. capturing the workload on the production system and replaying the workload for one PDB at a time on the test system

C. capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs

D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system

Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

A. Oracle Data Pump

B. Oracle Recovery Manager (RMAN)

C. Oracle Label Security

D. Oracle Database Vault

E. Oracle Real Application Security

You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema.

Examine the following steps:

1.

Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS (`SH', 'CUSTOMERS') from dual statement.

2.

Execute the dbms_stats.seed_col_usage (null, `SH', 500) procedure.

3.

Execute the required queries on the customers table.

4.

Issue the select dbms_stats.reportwcol_usage (`SH', 'customers') from dual statement.

Identify the correct sequence of steps.

A. 3, 2, 1, 4

B. 2, 3, 4, 1

C. 4, 1, 3, 2

D. 3, 2, 4, 1

Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)? (Choose three.)

A. A PDB opened in restricted mode allows only local users to connect.

B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.

C. When a CDB is in mount state, PDBs are automatically placed in mount state.

D. All PDBs must be shut down before shutting down a CDB instance.

E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.