Quiz | Croma Campus

Which Oracle view shows information about data files?

DBA_DATA_FILES
DBA_USERS
DBA_SEGMENTS
DBA_TABLESPACES

Mark for review

How can you start an Oracle database in restricted mode?

STARTUP RESTRICT
STARTUP NOMOUNT
STARTUP FORCE
STARTUP MOUNT

Mark for review

What is an Oracle Extent?

The largest unit of data storage
The smallest unit of data storage
A contiguous set of data blocks
A single data block

Mark for review

Which of the following is a valid Oracle join type?

Natural Join
Logical Join
Physical Join
Synthetic Join

Mark for review

What is the primary function of the Oracle Control File?

Store redo logs
Store backup information
Maintain database integrity
Store database metadata

Mark for review

How can you view the alert log in Oracle?

Querying DBA_ALERT_LOG view
Checking the alert.log file on disk
Using RMAN
Using Data Pump

Mark for review

Which of the following can be used to create a new Oracle database?

DBCA
RMAN
SQL*Loader
Data Pump

Mark for review

How can an Oracle database instance be started?

RUN INSTANCE
START INSTANCE
STARTUP
BEGIN INSTANCE

Mark for review

Which of the following is a valid Oracle process state?

Active
Passive
Ready
Idle

Mark for review

Which command is used to change the password for a user in Oracle?

ALTER USER
MODIFY USER
UPDATE USER
CHANGE USER

Mark for review

How can you add a data file to an existing tablespace in Oracle?

ALTER TABLESPACE
CREATE DATAFILE
ADD DATAFILE
MODIFY TABLESPACE

Mark for review

Which Oracle feature helps in managing disk space automatically?

Oracle Grid
Oracle ASM
Oracle Data Guard
Oracle Data Pump

Mark for review

What is the maximum number of data files that can be open in an Oracle database?

100
200
500
65534

Mark for review

What is Oracle SQL*Loader used for?

Export data
Load data
Backup data
Recover data

Mark for review

Which of the following is a valid Oracle database startup mode?

SHUTDOWN
RESTRICT
MOUNT
SLEEP

Mark for review

Which tool can be used to migrate an Oracle database to a different platform?

DBCA
Data Pump
RMAN
SQL*Loader

Mark for review

Which of the following is NOT a valid Oracle tablespace type?

Permanent
Temporary
Undo
Fixed

Mark for review

Which view in Oracle can be used to see current user sessions?

V$SESSIONS
V$USERS
V$SESSION
V$USER_SESSIONS

Mark for review

How can an Oracle database be recovered from a media failure?

Using SQL*Loader
Using Data Pump
Using RMAN
Using DBCA

Mark for review

Which Oracle feature provides automatic optimization of SQL queries?

AWR
ASH
SQL Plan Management
Data Pump

Mark for review

Which Oracle component is used to store database backup sets?

Data files
Control files
Flashback logs
FRA

Mark for review

What is the role of the Oracle SMON process?

Perform instance recovery
Manage user connections
Write to redo logs
Load data into tables

Mark for review

What does the Oracle AWR report provide?

Detailed performance metrics
Backup status
User activity logs
Security audit logs

Mark for review

What does the Oracle LogMiner tool do?

Monitor database performance
Analyze redo log files
Manage users
Backup data

Mark for review

Which Oracle tool can be used to manage database performance?

Data Pump
RMAN
Oracle Enterprise Manager
SQL*Loader

Mark for review

How is a deadlock detected in Oracle?

By the user
Automatically by Oracle
By the DBA
By the operating system

Mark for review

What is the main purpose of Oracle Redo Log files?

Store user data
Store undo information
Record all changes made to the database
Manage disk storage

Mark for review

Which Oracle utility is used for logical backups?

RMAN
Data Pump
DBCA
OMF

Mark for review

Which feature does Oracle Data Guard provide?

Real-time data backup
Network management
Automatic storage management
High availability

Mark for review

What does the Oracle Statspack tool do?

Collect database performance data
Encrypt data
Manage users
Backup data

Mark for review

Online Exam Quiz

Online

Did you like this Question

Get a 1:1 Mentorship call with our Career Advisor