logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

Which of the following is a feature of Oracle RAC?

  • Single instance architecture
  • Automatic storage management
  • Shared disk architecture
  • External data management
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

Which of the following is a valid Oracle index type?

  • Bitmap Index
  • Row Index
  • User Index
  • Cluster Index
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 feature does Oracle Data Guard provide?

  • Real-time data backup
  • Network management
  • Automatic storage management
  • High availability
Mark for review

How can an Oracle instance be terminated immediately?

  • SHUTDOWN NORMAL
  • SHUTDOWN IMMEDIATE
  • SHUTDOWN ABORT
  • SHUTDOWN TRANSACTIONAL
Mark for review

Which Oracle view shows information about data files?

  • DBA_DATA_FILES
  • DBA_USERS
  • DBA_SEGMENTS
  • DBA_TABLESPACES
Mark for review

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

  • Permanent
  • Temporary
  • Undo
  • Fixed
Mark for review

What is the function of the Oracle System Global Area (SGA)?

  • Store backup information
  • Manage user sessions
  • Cache data and control information
  • Manage redo logs
Mark for review

Which Oracle component handles database connections?

  • Listener
  • Data Guard
  • RMAN
  • Data Pump
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

What is the purpose of the Oracle Recovery Catalog?

  • Store archived logs
  • Store backup metadata
  • Manage user roles
  • Store redo logs
Mark for review

How can you enable automatic database backup in Oracle?

  • Use Data Pump
  • Use RMAN
  • Use SQL*Loader
  • Use Data Guard
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 a valid Oracle join type?

  • Natural Join
  • Logical Join
  • Physical Join
  • Synthetic Join
Mark for review

Which Oracle component is used to store database backup sets?

  • Data files
  • Control files
  • Flashback logs
  • FRA
Mark for review

What does Oracle Data Pump do?

  • Analyze database performance
  • Encrypt data
  • Export and import data
  • Manage user sessions
Mark for review

Which Oracle process is responsible for cleanup after a user session ends?

  • LGWR
  • PMON
  • SMON
  • DBWn
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

What does the Oracle Flashback feature provide?

  • Data encryption
  • Data recovery
  • Data transport
  • Data security
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

Which of the following is an Oracle database object?

  • User
  • Role
  • Procedure
  • System
Mark for review

What is the main function of Oracle SQL Tuning Advisor?

  • Tune network settings
  • Optimize database schema
  • Tune SQL queries
  • Manage user sessions
Mark for review

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

  • SHUTDOWN
  • RESTRICT
  • MOUNT
  • SLEEP
Mark for review

Which parameter file is used during the startup of an Oracle database?

  • Password file
  • Control file
  • Parameter file (PFILE)
  • Data file
Mark for review

Which Oracle tool can be used to manage database performance?

  • Data Pump
  • RMAN
  • Oracle Enterprise Manager
  • SQL*Loader
Mark for review

What is the main function of the Oracle Database Writer (DBWn) process?

  • Recover transactions
  • Write dirty buffers to disk
  • Manage user connections
  • Execute SQL statements
Mark for review

Which Oracle feature provides automatic optimization of SQL queries?

  • AWR
  • ASH
  • SQL Plan Management
  • Data Pump
Mark for review

How can an Oracle database instance be started?

  • RUN INSTANCE
  • START INSTANCE
  • STARTUP
  • BEGIN INSTANCE
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

blinkerOnline

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • Answered
  • Not Answered
  • Marked for Review

Get a 1:1 Mentorship call with our Career Advisor

Book free session