Oracle Database Administration II - 1Z1-083 Exam Practice Test

A. They are only released quarterly.

B. They are installed via OPatch or OPatchAuto.

C. They can introduce new features.

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

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

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

A. creating an Oracle Database service by modifying the SERVICE_NAMES parameter

B. creating a database service using DBMS_SERVICE.CREATE_SERVICE

C. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)

D. creating a disk group using the CREATE DISKGROUP SQL statement

E. creating a database using the CREATE DATABASE SQL statement

F. creating a database service using Oracle Database Configuration Assistant (DBCA)

A. It can be launched from both the command line and the Universal Installer (OUI) interfaces.

B. It can only be launched from the command line interface.

C. It can be used to change the character set of an existing database.

D. It can be used to convert a non-container database to a container database.

E. It can be used to create container databases and non-container databases.

A. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

B. BACKUP SPFILE SECTION SIZE 1M;

C. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

D. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE
100M;

E. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

F. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

G. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

A. Image copy backups can be created by using password encryption.

B. A database uses the same encryption key for every encrypted backup.

C. Encrypted backups can only be written to disk.

D. Transparent encryption of backups uses an encryption wallet.

E. A password encryption of backups uses the password while creating and restoring backups.

A. RMAN can recover tables in the SYSAUX tablespace.

B. RMAN can recover tables owed by the SYSTEM user.

C. RMAN always uses an auxiliary instance.

D. RMAN can recover a table after a DDL operation has altered the table structure.

E. RMAN can recover tables in the SYSTEM tablespace.

F. RMAN can recover tables in a standby database.

G. RMAN can recover tables owned by the SYS user.

A. Results are written to the alert log.

B. It runs automatically after each AWR snapshot.

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

D. A DBA can run it manually.

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

A. to store backups that would cause the controlfile to become too large.

B. to allow database duplication without a connection to the auxiliary instance.

C. to report on the database schema at an earlier point in time.

D. to allow database duplication without a connection to the target instance.

E. to store backup metadata that would cause the controlfile to become too large.

A. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

B. Tablespaces never remain in read/write mode during transportable tablespace operations.

C. A transportable data pump import can leave a plugged-in tablespace in read-only mode.

D. Tablespaces always remain in read/write mode during transportable tablespace operations.

E. A transportable data pump import can leave a plugged-in tablespace in read/write mode.

F. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

A. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

B. Unified auditing can be automatically synchronized to all application PDBs in an application container.

C. Application-common TSDP policies are always container specific.

D. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-ENDblock.

E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

F. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-ENDblock.

G. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-ENDblock.

A. Data Pump transportable tablespaces

B. the DBMS_PDB package

C. replication using GoldenGate

D. Data Pump full transportable database

E. cloning the non-CDB as a PDB

F. Data Pump full database export and import

A. OSDBA

B. OSASM

C. OSKMDBA

D. OSRACDBA

E. OSOPER