Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-083 - Oracle Database Administration II

Oracle 1z0-083 Premium Access     Download Demo    
Page: 2 / 9
Total 286 questions

Choose three. Which three are performed by Oracle Automatic Storage Management (ASM) instances?

A.

mounting disk groups

B.

acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes

C.

managing extent allocation for Oracle database segments

D.

managing Allocation Units (AUs) for disk group content

E.

managing space allocation for Oracle ASM files

F.

acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. DEFAULT_SHARING is METADATA. 3. APP_ROOT is an application root contained in CDB1. 4. APP_PDB1 is an application PDB contained in APP_ROOT. 5. COMPANYAPP is an application contained in APP_ROOT. 6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed. You execute these commands: $ sqlplus sys/ orac1e@localhost:1521/cdb1 as sysdba SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL) ; Table altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> DESC emp; Name Null? Type --------------------------------------------------------------ENO NUMBER ENAME VARCHAR2 (20) SQL> SELECT * FROM emp; ENO ENAME ---------------------------------100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?

A.

SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.

B.

SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.

C.

It will return an error because the SYNC operation is not allowed when constraints are added to common objects.

D.

It will return an error because EMP is not empty in APP_ROOT.

E.

It will return an error because EMP.SAL is empty in APP_ROOT.

choose two You take your database backups by using the RMAN media management interface (MMI). Which two are true about the use of the RMAN MMI?

A.

You can

B.

You can

C.

You can

D.

You can

E.

You can

Choose three. Which three actions will add a resource to an Oracle Restart configuration?

A.

creating a disk group using the CREATE DISKGROUP SQL statement

B.

creating a database service using DBMS_SERVICE.CREATE_SERVICE

C.

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

D.

creating a database using the CREATE DATABASE SQL statement

E.

creating an Oracle Database service by modifying the SERVICE_NAMES parameter

F.

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

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

A.

cloning a remote container database in interactive mode

B.

cloning a remote pluggable database in silent mode

C.

relocating a remote pluggable database in interactive mode

D.

relocating a remote container database in silent mode

E.

cloning a remote container database in silent mode

F.

relocating a remote pluggable database in silent mode

G.

relocating a remote container database in interactive mode.

Choose two You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs). Examine the query and its output: SQL> SELECT * FROM v $PWFILE_users; USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID ------------------------------------------------------------------------SYS TRUE TRUE FALSE FALSE FALSE FALSE 0 Which two tasks must you perform to add users with the SYSBACKUP, SYSDG, and SYSKM prileges to the password file?

A.

Re-create or migrate the password file to the Oracle Database 12c format

B.

Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C.

Copy the password file from a sample file in the DBS dierectory

D.

Assign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

A.

Tablespaces are automatically created as need while importing full exports in either a non-CDB or a PDB.

B.

Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.

C.

A new PDB is automatically created when importing a non-CDB into a CDB.

D.

Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

E.

Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.

F.

Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

Choose three. Which three are true about OPatch ?

A.

It requires installation of Oracle Universal Installer.

B.

It supports Rolling Patching.

C.

It must be invoked as the user that owns the software being patched.

D.

It is a Java-based utility for applying patchsets.

E.

It is platform independent.

F.

It can be used to apply interim patches to the Grid Infrastructure and Database Home combination.

Choose two. Which two are true about unplugging an application container from a container database and plugging it into a different container database?

A.

Plugging the application root into a different CDB plugs in all its application PDBs.

B.

The application root of an application container should be plugged into the other CDB before its application PDBs are plugged in.

C.

Application PDBs in the application container must be unplugged before the application root is unplugged.

D.

Unplugging the application root from a CDB unplugs all its application PDBs.

E.

It requires only local UNDO mode in the database where the application container will be unplugged.

F.

It requires local UNDO mode in both container databases.

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

A.

Tables or table partitions can be recovered by using an auxiliary instance only.

B.

Tables or table partitions with a foreign key cannot be recovered.

C.

Tables or table partitions can be recovered only when the database is in mount state.

D.

Tables or table partitions from the system and sysaux tablespaces cannot be recovered.

E.

Tables with not null constraints cannot be recovered.