Oracle 19c OCP-083 题库.docx

豆宇斯

349

150页

23次

2024-03-06

5墨值下载

考试科目：1Z0-083

1、Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?

A)Space is only reclaimed when there is space pressure in the Fast Recovery Area(FRA)

B)Space is always reclaimed automatically when the retention period for Flashback logs is lowered

C)Space might be reclaimed proactively before space pressure occurs

D)Space is always reclaimed proactively before space pressure occurs

E) Space might be reclaimed automatically when the retention period for Flashback logs is lowered

答案: BC

2、Which two are true about server-generated alerts?

A)Stateless alerts can be cleared manually

B)Stateless alerts are automatically cleared after one day.

C)Stateful alerts are purged automatically from the alert history after one day

D)Stateless alerts can be purged manually from the alert history.

E) Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.

答案: AD

3、Which three are true about upgrading Oracle Grid Infrastructure?

A)The newer version is installedin a separate Oracle Grid Infrastructure home on the same server

as the existing version

B)A direct upgrade can be performed only from the immediately precedingOracle Grid

Infrastructure version

C) The upgrade process will automatically install all mandatorypatches for the current versionof

Oracle Grid Infrastructure

D) Only the grid user can perform the upgrade

E) Existing Oracle Databaseinstances must be shutdown before startingthe upgrade

F）An existing Oracle base can be used.

答案: ADE

4 、 Which two are true about the Program Global Area(PGA)and its management in an Oracle database instance?

A)PGA AGGREGATE LIMII is a hard limit on the PGA size for any one session

B)The entire PGA is located in the System Global Area(SGA)when using shared servers

C)The private SQL area(UGA)is located in the System Global Area(SGA)when using shared servers

D)Sorts and Hash Joins use PGA memory.

E) The private SQL area(UGA)is located in the System Global Area(SGA)when using dedicated servers

答案: AC

5、You plan to perform cross-platform PDB transport using XTTS. Which two are true?

A)A backup of the PDB must exist, taken using the BACKUP command with the ro PLATFORM clause

B) The source PDB can be in MOUNT or OPEN state C)The source PDB

must be in MOUNT state.

C) The source PDB must not be an application root.

D) Automatic conversion of endianess occurs.

E) The source and target platforms must have the same endianess

答案: AE

6 、 Which two are true about the automatic execution of operating system scripts when performing silent mode

installation starting from Oracle Database 19c?

A) The installer will prompt for the root or sudo password

B)Silent install always runs operating scripts automatically.

C) The response file can specify the root or sudo password

D)The response file must contain the root or sudo password

E) The response file can specify the path of the sudo program

答案: AE

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

B) creating a database using the CREATE DATABASE SQL statement

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

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

F ) creating a database service using DBMS SERVICE CREATE SERVICE

答案: ABC

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 DAMBASELOCAL 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. createan UNDO tablespace in each PDB,andthen restart the CDB instance.

C) Open the CDB instancein upgrade mode. In CDB&ROOT, executeALTER DATABASE

LOCAL UNDO ON, and then restart the CDB instance

D) Open the CDB in read-only mode. In CDB$ROOT, executeALTER DATABASE LOCAL

UNDO ON and then changethe CDB to read/writemode

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

答案: ABC

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

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

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

C) They can be written only to disk.

D) They must be written to media

答案: AC

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

13 、 A schema owner truncated a table in error and must recover the data Which Oracle

Flashback feature could be used to recover the data?

A)FLASHBACK VERSION QUERY

B) FLASHBACK TABLE

C)FLASHBACK TRANSACTION

D) FLASHBACK DATABASE

E) FLASHBACK DATA ARCHIVE

答案: D

14 、 While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager

(RMAN)incremental level 0 backup is a bottleneck FORCE LOGGING is enabled for the database Which two could

improve read performance?

A) Disable FORCE LOGGING for the database

B) Enable asynchronous disk I/O

C) Increase the size of the database buffer cache.

D) D)Increase the level of RMAN multiplexing

E) Increase the size of tape I/O buffers

答案: BD

15 、 Which two are true about Oracle instance recovery?

A) Recovery begins from the beginning of the CURRENT redo log group.

B) Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no

other group is ACTIVE

C) Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint

process (ckpt)

D) Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance

of 150

5墨值下载

oracle ocp

相关文档

评论