logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

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 of the following is a valid Oracle process state?

  • Active
  • Passive
  • Ready
  • Idle
Mark for review

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

  • Permanent
  • Temporary
  • Undo
  • Fixed
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 helps in managing disk space automatically?

  • Oracle Grid
  • Oracle ASM
  • Oracle Data Guard
  • Oracle Data Pump
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

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 role of the Oracle data dictionary?

  • Store user data
  • Store metadata
  • Manage security
  • Optimize queries
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 default port number for Oracle SQL*Net?

  • 1521
  • 1526
  • 1600
  • 1433
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 instance be terminated immediately?

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

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

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

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 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 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 view shows information about data files?

  • DBA_DATA_FILES
  • DBA_USERS
  • DBA_SEGMENTS
  • DBA_TABLESPACES
Mark for review

Which Oracle utility is used for logical backups?

  • RMAN
  • Data Pump
  • DBCA
  • OMF
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 does the Oracle Statspack tool do?

  • Collect database performance data
  • Encrypt data
  • Manage users
  • Backup data
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 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

How is a deadlock detected in Oracle?

  • By the user
  • Automatically by Oracle
  • By the DBA
  • By the operating system
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 feature does Oracle Data Guard provide?

  • Real-time data backup
  • Network management
  • Automatic storage management
  • High availability
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 the primary function of the Oracle Control File?

  • Store redo logs
  • Store backup information
  • Maintain database integrity
  • Store database metadata
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