최신Oracle Database 12c: Installation and Administration - 1z1-062무료샘플문제

A. All current, active, and inactive redo logs are required to complete instance recovery.

B. All current, online, and archived redo logs are required to complete instance recovery.

C. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.

D. All redo log entries in the current log are applied to data files until the checkpoint position is reached.

A. 4, 2, 5, 1, 6

B. 2, 3, 1, 6

C. 2, 5, 1, 6

D. 1, 2, 3, 4, 6

A. 10, 1, 5, 8, 10

B. 10, 1, 2, 5, 4, 9, 8

C. 6, 5, 4, 7

D. 10, 1, 2, 5, 8

A. Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS.

B. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace.

C. The unified audit trail contains audit records only from unified audit policies and AUDIT settings.

D. Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE.

A. The DBMS_PDB package

B. Data Pump full export/import

C. Transportable database

D. Transportable tablespace

E. RMAN

A. segments in tablespaces that have exceeded a critical or warning space threshold

B. segments for tables created using ADVANCED ROW COMPRESSION

C. segments that have the highest growth rate in a database

D. segments that are sparsely populated and have more than 10% of free space below the high water mark.

E. segments that have unusable indexes

A. Create an event-based job.

B. Specify the job as a member of a job class.

C. Use a job array.

D. Create a lightweight job.

A. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

B. IMPDP always use the conventional path insert method to import data.

C. IMPDP can be used to change target data file names, schemas, and tablespaces during import.

D. EXPDP and IMPDP are the client components of Oracle Data Pump.

E. The DBMS_DATAPUMP PL/SQL package can be used independently of Data Pump clients to perform export and import operations.

A. 1, 2, 3, 8, 9 and 10

B. 1, 2, 4, 5, 6 and 7

C. 1, 2, 4, 5, 7, 8, 9 and 10

D. 1, 2, 3, 4, 6, 8, 9 and 10

E. 1, 2, 4, 5, 6, 7 and 8

A. Perform a rolling upgrade.

B. Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.

C. Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database
12c.

D. Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database.

E. Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).

A. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.

B. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.

C. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.

D. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.

E. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.

A. Oracle Database Vault

B. Oracle Recovery Manager (RMAN)

C. Oracle Label Security

D. Oracle Real Application Security

E. Oracle Data Pump

A. They are not terminated but may only issue queries.

B. They are not affected.

C. They are terminated immediately.

D. They are terminated after completing the transaction.

A. One 64G flash cache file will be used.

B. Two 64G flash cache files will be used.

C. It results in an error because these parameter settings are invalid.

D. Two 32G flash cache files will be used.