logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

How can an Oracle instance be terminated immediately?

  • SHUTDOWN NORMAL
  • SHUTDOWN IMMEDIATE
  • SHUTDOWN ABORT
  • SHUTDOWN TRANSACTIONAL
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 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

Which of the following is a type of segment in Oracle?

  • Temporary Segment
  • Archived Segment
  • Buffer Segment
  • Variable Segment
Mark for review

Which of the following is a valid Oracle index type?

  • Bitmap Index
  • Row Index
  • User Index
  • Cluster Index
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

What does the Oracle LogMiner tool do?

  • Monitor database performance
  • Analyze redo log files
  • Manage users
  • Backup data
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 feature of Oracle RAC?

  • Single instance architecture
  • Automatic storage management
  • Shared disk architecture
  • External data management
Mark for review

Which Oracle component handles database connections?

  • Listener
  • Data Guard
  • RMAN
  • Data Pump
Mark for review

What does Oracle Data Pump do?

  • Analyze database performance
  • Encrypt data
  • Export and import data
  • Manage user sessions
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

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

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

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 NOT a valid Oracle tablespace type?

  • Permanent
  • Temporary
  • Undo
  • Fixed
Mark for review

Which Oracle component is used to store database backup sets?

  • Data files
  • Control files
  • Flashback logs
  • FRA
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 purpose of the Oracle Recovery Catalog?

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

Which Oracle view shows information about data files?

  • DBA_DATA_FILES
  • DBA_USERS
  • DBA_SEGMENTS
  • DBA_TABLESPACES
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 an Oracle database object?

  • User
  • Role
  • Procedure
  • System
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 of the following is a valid Oracle process state?

  • Active
  • Passive
  • Ready
  • Idle
Mark for review

What is the default port number for Oracle SQL*Net?

  • 1521
  • 1526
  • 1600
  • 1433
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 does the Oracle Flashback feature provide?

  • Data encryption
  • Data recovery
  • Data transport
  • Data security
Mark for review

What is the role of the Oracle data dictionary?

  • Store user data
  • Store metadata
  • Manage security
  • Optimize queries
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

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

  • V$SESSIONS
  • V$USERS
  • V$SESSION
  • V$USER_SESSIONS
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