QUIZ-ORACLE-INTERMEDIATE-LEVEL - DBACCOMPANY

Skip to content

Accueil
A propos
Nos services
Nous contacter

Search for:

QUIZ-ORACLE-INTERMEDIATE-LEVEL

Home -
QUIZ-ORACLE-INTERMEDIATE-LEVEL

Oracle 19c Intermediate Quiz

Welcome to the Oracle 19c Intermediate Quiz!

This quiz is designed to test your intermediate knowledge of Oracle 19c features and modules.

Objectives:

Evaluate your understanding of Oracle 19c concepts.
Explore new features and best practices.

Quiz Format:

15 multiple-choice questions.
Duration: 3 minutes.

Prepare to test your knowledge and deepen your understanding of Oracle 19c!

Good luck to everyone!

Username

User Email *

User Password *

START THE QUIZ

#1. What is the purpose of Oracle's UNDO tablespace?

To store archived log files

To store archived log files

To store redo log files

To store redo log files

To backup tables

To backup tables

To retain uncommitted transaction data

To retain uncommitted transaction data

#2. How does Oracle manage storage in a multitenant architecture?

Storage is managed separately for each tenant

Storage is managed separately for each tenant

Each PDB has its own storage

Each PDB has its own storage

Storage is shared by all PDBs within a CDB

Storage is shared by all PDBs within a CDB

Storage is managed by the root container only

Storage is managed by the root container only

#3. Which view can be used to monitor the usage of tablespaces in Oracle?

DBA_FREE_SPACE

DBA_FREE_SPACE

V$TABLESPACE_USAGE

V$TABLESPACE_USAGE

DBA_DATAFILES

DBA_DATAFILES

DBA_TABLESPACES

DBA_TABLESPACES

#4. Which Oracle feature allows for the encryption of network traffic between a client and the database?

Oracle Net Encryption

Oracle Net Encryption

Oracle Wallet

Oracle Wallet

Data Guard

Data Guard

Oracle RAC

Oracle RAC

#5. Which Oracle utility is typically used to export and import database schemas?

SQL*Loader

SQL*Loader

OEM

OEM

RMAN

RMAN

Data Pump

Data Pump

#6. In Oracle multitenant architecture, what is the role of the Container Database (CDB)?

Holds user data across all tenants

Holds user data across all tenants

Manages the shared SGA of all PDBs

Manages the shared SGA of all PDBs

Stores backups for all PDBs

Stores backups for all PDBs

Contains the system metadata for the entire multitenant environment

Contains the system metadata for the entire multitenant environment

#7. In Oracle ASM, what is a disk group?

A collection of disks

A collection of disks

A single disk used for storage

A single disk used for storage

A backup set

A backup set

A cluster node

A cluster node

#8. What is the purpose of the db_block_size parameter in Oracle?

Determines the size of database blocks

Determines the size of database blocks

Specifies the maximum size of the control file

Specifies the maximum size of the control file

Determines the number of redo logs

Determines the number of redo logs

Sets the size of the undo tablespace

Sets the size of the undo tablespace

#9. Which of the following is a method for managing Oracle user passwords securely?

Store them in plain text

Store them in plain text

Use password encryption

Use password encryption

Store passwords in redo logs

Store passwords in redo logs

Use TNS names for passwords

Use TNS names for passwords

#10. Which Oracle feature is designed to improve security by encrypting data at rest?

Transparent Data Encryption (TDE)

Transparent Data Encryption (TDE)

Oracle ASM

Oracle ASM

Oracle Wallet

Oracle Wallet

RMAN Encryption

RMAN Encryption

#11. How does Oracle manage storage in an ASM environment?

Through logical volume managers

Through logical volume managers

By striping and mirroring disks

By striping and mirroring disks

Through OS-level commands

Through OS-level commands

Through direct file management

Through direct file management

#12. Which of the following Oracle commands is used to change the archive log destination?

ALTER INSTANCE SET ARCHIVELOG_DEST

ALTER INSTANCE SET ARCHIVELOG_DEST

ALTER DATABASE SET LOG_ARCHIVE_DEST

ALTER DATABASE SET LOG_ARCHIVE_DEST

ALTER SYSTEM SET LOG_ARCHIVE_DEST

ALTER SYSTEM SET LOG_ARCHIVE_DEST

ALTER SYSTEM SET ARCHIVELOG_DEST

ALTER SYSTEM SET ARCHIVELOG_DEST

#13. How can you modify a parameter in Oracle without restarting the database?

ALTER DATABASE SET parameter=value SCOPE=BOTH;

ALTER DATABASE SET parameter=value SCOPE=BOTH;

ALTER DATABASE MODIFY parameter=value;

ALTER DATABASE MODIFY parameter=value;

ALTER SYSTEM SET parameter=value SCOPE=SPFILE;

ALTER SYSTEM SET parameter=value SCOPE=SPFILE;

ALTER SYSTEM SET parameter=value SCOPE=BOTH;

ALTER SYSTEM SET parameter=value SCOPE=BOTH;

#14. What happens when the FORCE LOGGING option is enabled in Oracle?

Only full backups will be forced.

Only full backups will be forced.

RMAN will automatically perform backups of redo logs.

RMAN will automatically perform backups of redo logs.

All operations will be logged## even if no-logging operations are performed.

All operations will be logged## even if no-logging operations are performed.

The database will reject any write operations.

The database will reject any write operations.

#15. How can you change the size of an Oracle datafile?

ALTER DATABASE DATAFILE RESIZE

ALTER DATABASE DATAFILE RESIZE

ALTER TABLESPACE RESIZE FILE

ALTER TABLESPACE RESIZE FILE

ALTER FILE RESIZE

ALTER FILE RESIZE

ALTER SYSTEM RESIZE DATAFILE

ALTER SYSTEM RESIZE DATAFILE

Commit

Results

-

Congratulations on passing the quiz! Your hard work and dedication have truly paid off. Keep up the great effort Keep shining! Share the quiz with your friends.

Don't be discouraged! It’s okay to stumble sometimes. Every setback is an opportunity to learn and grow.. Share the quiz with your friends.

Share your score!

Tweet your score!

Other MCQs

Support 24/7

Mail de support contact@dbaccompany.com

Téléphone +33 9 52 87 20 60

Copyright © 2026 DBACCOMPANY

Notre blog
DBA as a service

Notre blog
DBA as a service

Accueil
A propos
Nos services
Nous contacter