多选题

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(ASM)instance with ASM Configuration Assistant(ASMCA)

F、

creating a database service using DBMS SERVICE CREATE SERVICE

下载APP答题
由4l***2q提供 分享 举报 纠错

相关试题

单选题 Examine this configuration
1)CDBL is a container database running in ARCHIVELOG mode.
2)Multiple uncommitted transactions are running in CDBL
3)Redo log groups l 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 MOUN
4) ALTER DAABASE MOUNT
5) RESTORE DATABASE
6) RECOVER DATABASE NOREDO
7)RECOVER DATABASE UNTIL AVAILABLE
8)RESTORE ARCHIVELOG ALL
9)ALTER DAVABASE OPEN
10)ALTER DATABASE OPEN RESEMLOGS
Choose the minimum required steps in the correct order to recover the
Database

A、1,3,5,69
B、1,3.5,86,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

多选题 Which three are true about upgrading Oracle Grid Infrastructure?

A、

The newer version is installed in 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 preceding Oracle Grid Infrastructure version

C、

The upgrade process will automatically install all mandatory patches for The current version of Oracle Grid Infrastructure

D、

Only the grid user can perform the upgrade

E、

Existing Oracle Database instances must be shut down before starting The upgrade

F、An existing Oracle base can be used.

多选题 Which two are true about the Program Global Area(PGA)and its

Management in an Oracle database instance?

A、

PGA AGGREGATE_LIMIIT 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

多选题 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

多选题 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、Increase the level of RMAN multiplexing
E、 Increase the size of tape I/O buffers

多选题 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.

D、

The source PDB must not be an application root.

E、Automatic conversion of endianess occurs.
F、The source and target platforms must have the same endianess

多选题 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

多选题 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