OCP Multiple Select — 10 Questions

Question 1

Which THREE operations are permitted on Blockchain tables?

Accepted Answer

VERIFY. You can insert, select, and verify rows in a Blockchain table.

Answer

DELETE

Answer

UPDATE

Question 2

Which THREE of the following are benefits of the JSON Duality feature?

Accepted Answer

Simplified application development. Duality simplifies coding, maintains consistency, and supports native SQL access.

Answer

Automatic data encryption

Answer

No indexing required

Question 3

Which TWO of the following are benefits of using an RMAN recovery catalog?

Accepted Answer

Stores backup metadata for multiple databases.. Centralization and extended retention are key benefits.

Answer

Automatically encrypts all backups.

Answer

Eliminates the need for archivelogs.

Answer

Provides faster database performance.

Question 4

Which THREE actions are performed during the 'RESTORE DATABASE' command?

Accepted Answer

Restoring datafiles to the disk.. Restoring files, updating the control file, and verifying existence are key.

Answer

Opening the database with RESETLOGS.

Answer

Performing media recovery.

Question 5

Which THREE features are enabled in 23ai to simplify database management?

Accepted Answer

AI Vector Search. JSON Duality, Lock-Free Reservations, and Vector Search are key 23ai management/performance features.

Answer

Flashback Data Archive

Answer

Tablespace encryption

Question 6

Which TWO RMAN settings significantly improve performance during backup operations on an Exadata system?

Accepted Answer

CONFIGURE BACKUP OPTIMIZATION ON;. Backup optimization and parallelism settings directly impact throughput on high-performance storage.

Answer

CONFIGURE CHANNEL ... RATE 10M;

Answer

CONFIGURE MAXSETSIZE UNLIMITED;

Answer

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

Question 7

Which THREE conditions must be met to perform a successful RMAN cross-platform transportable tablespace migration?

Accepted Answer

The RMAN CONVERT command must be used if endianness differs.. The databases must be at compatible levels, endian formats must be checked, and the tablespace must be read-only.

Answer

The source platform must be the same endian as the target.

Answer

The source and destination databases must have the same DBID.

Question 8

Which TWO features of 23ai help improve performance of high-concurrency workloads?

Accepted Answer

Lock-Free Reservations. Lock-Free Reservations and Memoptimized Write are specifically for high-concurrency improvements.

Answer

Wide tables

Answer

Blockchain tables

Answer

JSON Duality

Question 9

Which TWO of the following are valid RMAN backup types?

Accepted Answer

Cumulative. Full and incremental are the standard types.

Answer

Sequential

Answer

Transactional

Question 10

Which THREE operations are automatically performed by RMAN when executing the 'RECOVER TABLE' command?

Accepted Answer

Exporting the recovered table to the target database using Data Pump. The RECOVER TABLE command creates an auxiliary instance, performs a partial restore and recovery of the tablespace containing the table, and then exports the table metadata to the target database.

Answer

Automatic deletion of all backups older than the restore point

Answer

Automatic conversion of the database to NOARCHIVELOG mode