logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

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

  • 1521
  • 1526
  • 1600
  • 1433
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 does the Oracle Statspack tool do?

  • Collect database performance data
  • Encrypt data
  • Manage users
  • 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 Flashback feature provide?

  • Data encryption
  • Data recovery
  • Data transport
  • Data security
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 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 of the following is a valid Oracle process state?

  • Active
  • Passive
  • Ready
  • Idle
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 provides automatic optimization of SQL queries?

  • AWR
  • ASH
  • SQL Plan Management
  • Data Pump
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 parameter file is used during the startup of an Oracle database?

  • Password file
  • Control file
  • Parameter file (PFILE)
  • Data file
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 view in Oracle can be used to see current user sessions?

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

Which feature does Oracle Data Guard provide?

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

What is the role of the Oracle data dictionary?

  • Store user data
  • Store metadata
  • Manage security
  • Optimize queries
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 Oracle view shows information about data files?

  • DBA_DATA_FILES
  • DBA_USERS
  • DBA_SEGMENTS
  • DBA_TABLESPACES
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 main function of Oracle SQL Tuning Advisor?

  • Tune network settings
  • Optimize database schema
  • Tune SQL queries
  • Manage user sessions
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 type of segment in Oracle?

  • Temporary Segment
  • Archived Segment
  • Buffer Segment
  • Variable Segment
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 Automatic Storage Management (ASM) provide?

  • Backup management
  • Security management
  • Storage management
  • User management
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

What does the Oracle AWR report provide?

  • Detailed performance metrics
  • Backup status
  • User activity logs
  • Security audit logs
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

How can an Oracle database instance be started?

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