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 statementC)creating a database using the CREATE DATABASE SQL statementD)creating an Oracle Database service by modifying the SERVICE NAMES parameterE)creating an Oracle Automatic Storage Management(AM)instance with ASM Configuration Assistant(ASMCA)F ) creating a database service using DBMS_SERVICE.CREATE_SERVICEhttps://docs.oracle.com/en/database/oracle/oracle-database/19/admin/configuring-automatic-restart-of-an-oracle-database.html#GUID-AEB55E5C-48C7-4542-9384-492204F501AErestart对服务的管理使用srvctl。  srvctl -h|grep service 答案: ABE8、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 instanceD）Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON and then change the CDB to read/write modeE）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.答案: Chttps://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/administering-a-cdb-with-sql-plus.html#GUID-1AAB032F-D13A-4E06-A062-59E0487C2FC59  、Which three activities are possible for PDBS?A)converting an application PDB to a regular PDBB)converting an application PDB to an application seedC)converting a regular PDB to an application PDBD)copying an application container into another application container in the same CDBE)converting an application seed to an application PDBF)converting an application PDB to an application rootG)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-DD40C8725F1AExample 14-9 Creating an Application Seed From an Application PDB可以从一个普通的pdb创建应用pdbhttps://docs.oracle.com/en/database/oracle/oracle-database/21/multi/creating-application-containers1.html#GUID-3C6D4200-1FEC-4C0F-B335-EFDC655ADABCExample 14-3 Creating an Application Container by Cloning a Local PDB10、A user complains about poor database performanceYou 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$SESSTATB)V$SESSION_WAITC)V$SESSION_EVENTD)V$SESSIONE)V$SESSION_WAIT_CLASS答案: Chttps://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SESSION_EVENT.html#GUID-5723D404-83F7-4C8D-8BF2-031B3FFEAAA8V$SESSION_WAIT只显示当前和最后的等待事件，题目要求所有的事件。11、  Which two are true about RMAN duplexed backup sets?A) They can be written to mediaB They can be created only by using the copies option of a BACKUP commandC)They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backupD)They can be written only to disk.E)They must be written to media答案: AChttps://docs.oracle.com/cd/E18283_01/backup.112/e10642/rcmconfa.htm#i1007486可以使用configure和backup两种方式进行duplex。12  、Examine this configuration1.CDB1 is a container database running in ARCHIVELOG mode.2.Multiple uncommitted transactions are running in CDB13.Redo log groups 1 and 2 are INACTIVE4.Redo log group 3 is the CURRENT groupAll members of redo log group 3 are lost before it is archived Examine these possible steps1.SHUTDOWN ABORT2.STARTUP NOMOUNT3.STARUP MOUNT4.ALTER DATABASE MOUNT5.RESTORE DATABASE6.RECOVER DATABASE NOREDO7.RECOVER DATABASE UNTIL AVAILABLE8.RESTORE ARCHIVELOG ALL9.ALTER DATABASE OPEN10.ALTER DATABASE OPEN RESETLOGSChoose the minimum required steps in the correct order to recover the database A)1,3,5,6,9B)1,3,5,8,6,10C)1,2,5,7,4,10D)1,3,5,7,10E)1,3,5,6,10F)1,3,5,6,10答案: D当前联机日志丢失只能用open resetlogs打开