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

https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/configuring-automatic-restart-of-an-oracle-database.html#GUID-AEB55E5C-48C7-4542-9384-492204F501AE

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 CDBR O O T , d r o p t h e U N D O t a b l e s p a c e E x e c u t e A I T E R D A M B A S E L O C A L U N D O O N i n e a c h P D B . a n d t h e n r e s t a r t t h e C D B i n s t a n c e B ) O p e n t h e C D B i n s t a n c e i n r e s t r i c t e d m o d e . I n C D B 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 CDBROOT,droptheUNDOtablespaceExecuteAITERDAMBASELOCALUNDOONineachPDB.andthenrestarttheCDBinstanceB)OpentheCDBinstanceinrestrictedmode.InCDBROOT, 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 CDBR O O T , e x e c u t e A L T E R D A T A B A S E L O C A L U N D O O N , a n d t h e n r e s t a r t t h e C D B i n s t a n c e D ） O p e n t h e C D B i n r e a d − o n l y m o d e . I n C D B ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance D）Open the CDB in read-only mode. In CDBROOT,executeALTERDATABASELOCALUNDOON,andthenrestarttheCDBinstanceD）OpentheCDBinread−onlymode.InCDBROOT, 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

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/administering-a-cdb-with-sql-plus.html#GUID-1AAB032F-D13A-4E06-A062-59E0487C2FC5

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创建应用种子，也可以反过来。

https://docs.oracle.com/en/database/oracle/oracle-database/21/multi/creating-application-seeds.html#GUID-6C75735A-3612-4D62-8566-DD40C8725F1A

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

可以从一个普通的pdb创建应用pdb

https://docs.oracle.com/en/database/oracle/oracle-database/21/multi/creating-application-containers1.html#GUID-3C6D4200-1FEC-4C0F-B335-EFDC655ADABC

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)VS E S S T A T B ) V SESSTAT B)VSESSTATB)VSESSION_WAIT

C)VS E S S I O N E V E N T D ) V SESSION_EVENT D)VSESSION

E

VENTD)VSESSION

E)VKaTeX parse error: Expected 'EOF', got '#' at position 114: …SION_EVENT.html#̲GUID-5723D404-8…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

https://docs.oracle.com/cd/E18283_01/backup.112/e10642/rcmconfa.htm#i1007486

可以使用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打开

关于作者

姚远：Oracle ACE（Oracle和MySQL数据库方向 http://apex.oracle.com/pls/apex/aces/d/yuan.yao），华为云MVP，曾任IBM公司数据库部门经理。拥有包括Oracle 10g和12c OCM在内的20多项数据库相关技术认证，数据库类畅销书《MySQL 8.0运维与优化》的作者。