Oracle 19c OCP 1Z0-083題庫（7-12）

7 、Which three actions will add a resource to an Oracle Restart configuration? 

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

B)creating a disk group using the CREATE DISKGROUP SQL statement

C)creating a database using the CREATE DATABASE SQL statement

D)creating an Oracle Database service by modifying the SERVICE NAMES parameter

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

F ) creating a database service using DBMS_SERVICE.CREATE_SERVICE

restart對服務的管理使用srvctl。  srvctl -h|grep service 

答案: ABE

8、How do you configure a CDB for local undo mode?

A)Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace  Execute AI TER DAMBASE LOCAL UNDO ON in each PDB. and then restart the CDB instance 

B)Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and then restart the CDB instance.

C）Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance

D）Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON and then change the CDB to read/write mode

E）Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

答案: C

9  、Which three activities are possible for PDBS?

A)converting an application PDB to a regular PDB

B)converting an application PDB to an application seed

C)converting a regular PDB to an application PDB

D)copying an application container into another application container in the same CDB

E)converting an application seed to an application PDB

F)converting an application PDB to an application root

G)copying an application container into another application container in a different CDB

答案: BCE

可以使用應用PDB建立應用種子，也可以反過來。

Example 14-9 Creating an Application Seed From an Application PDB

可以從一個普通的pdb建立應用pdb

Example 14-3 Creating an Application Container by Cloning a Local PDB

10、A user complains about poor database performance

You want to verify if the user's session has waited for certain types of I/O activity 

Which view displays all waits waited on by a session at least once?

A)V$SESSTAT

B)V$SESSION_WAIT

C)V$SESSION_EVENT

D)V$SESSION

E)V$SESSION_WAIT_CLASS

答案: C

V$SESSION_WAIT只顯示當前和最後的等待事件，題目要求所有的事件。

11、  Which two are true about RMAN duplexed backup sets?

A) They can be written to media

B They can be created only by using the copies option of a BACKUP command

C)They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup

D)They can be written only to disk.

E)They must be written to media

答案: AC

可以使用configure和backup兩種方式進行duplex。

12  、Examine this configuration

1.CDB1 is a container database running in ARCHIVELOG mode.

2.Multiple uncommitted transactions are running in CDB1

3.Redo log groups 1 and 2 are INACTIVE

4.Redo log group 3 is the CURRENT group

All members of redo log group 3 are lost before it is archived 

Examine these possible steps

1.SHUTDOWN ABORT

2.STARTUP NOMOUNT

3.STARUP MOUNT

4.ALTER DATABASE MOUNT

5.RESTORE DATABASE

6.RECOVER DATABASE NOREDO

7.RECOVER DATABASE UNTIL AVAILABLE

8.RESTORE ARCHIVELOG ALL

9.ALTER DATABASE OPEN

10.ALTER DATABASE OPEN RESETLOGS

Choose the minimum required steps in the correct order to recover the database 

A)1,3,5,6,9

B)1,3,5,8,6,10

C)1,2,5,7,4,10

D)1,3,5,7,10

E)1,3,5,6,10

F)1,3,5,6,10

答案: D

當前聯機日誌丟失只能用open resetlogs開啟