logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

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

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

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

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 type of segment in Oracle?

  • Temporary Segment
  • Archived Segment
  • Buffer Segment
  • Variable Segment
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 you start an Oracle database in restricted mode?

  • STARTUP RESTRICT
  • STARTUP NOMOUNT
  • STARTUP FORCE
  • STARTUP MOUNT
Mark for review

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

  • LGWR
  • PMON
  • SMON
  • DBWn
Mark for review

What does the Oracle Flashback feature provide?

  • Data encryption
  • Data recovery
  • Data transport
  • Data security
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 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 enable automatic database backup in Oracle?

  • Use Data Pump
  • Use RMAN
  • Use SQL*Loader
  • Use Data Guard
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

What does the Oracle AWR report provide?

  • Detailed performance metrics
  • Backup status
  • User activity logs
  • Security audit logs
Mark for review

How can an Oracle instance be terminated immediately?

  • SHUTDOWN NORMAL
  • SHUTDOWN IMMEDIATE
  • SHUTDOWN ABORT
  • SHUTDOWN TRANSACTIONAL
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 purpose of the Oracle listener?

  • Manage user sessions
  • Control disk storage
  • Provide network connectivity
  • Backup data
Mark for review

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

  • Permanent
  • Temporary
  • Undo
  • Fixed
Mark for review

What does the Oracle Automatic Storage Management (ASM) provide?

  • Backup management
  • Security management
  • Storage management
  • User management
Mark for review

Which background process is responsible for writing redo log buffers to the redo log files?

  • PMON
  • SMON
  • DBWn
  • LGWR
Mark for review

How can an Oracle database instance be started?

  • RUN INSTANCE
  • START INSTANCE
  • STARTUP
  • BEGIN INSTANCE
Mark for review

What is Oracle SQL*Loader used for?

  • Export data
  • Load data
  • Backup data
  • Recover data
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

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 component handles database connections?

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

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

  • SHUTDOWN
  • RESTRICT
  • MOUNT
  • SLEEP
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