50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.
0/50 answered0 correct
Question 1 of 50
Which of the following statements is true about Oracle database redo logs?
Correct answer: B) Redo logs store both committed and uncommitted transactions.
Explanation: Redo logs store all changes made to the database, both committed and uncommitted, to allow recovery in case of failure.
Question 2 of 50
What is the purpose of Oracle's flashback technology?
Correct answer: A) To recover from user errors by restoring an entire database to a previous point in time.
Explanation: Flashback technology allows recovering from accidental changes or deletions by reverting the database or individual tables to a previous point in time.
Question 3 of 50
Which SQL command is used to create a temporary tablespace in Oracle?
Correct answer: A) CREATE TEMPORARY TABLESPACE;
Explanation: The correct SQL command to create a temporary tablespace is CREATE TEMPORARY TABLESPACE.
Question 4 of 50
Which of the following statements is true about Oracle Automatic Workload Repository (AWR)?
Correct answer: B) AWR stores performance-related statistics.
Explanation: AWR captures and stores performance-related statistics in the database for tuning and diagnostic purposes.
Question 5 of 50
Which Oracle process is responsible for recovering the database after a failure?
Correct answer: C) SMON
Explanation: The SMON process (System Monitor) is responsible for performing instance recovery after a failure.
Question 6 of 50
What happens when a database is opened in read-only mode?
Correct answer: B) Users can view data, but no DML or DDL operations can be performed.
Explanation: When a database is opened in read-only mode, users can view data but cannot perform any updates or schema modifications.
Question 7 of 50
Which SQL statement is used to drop a user in Oracle?
Correct answer: B) DROP USER username;
Explanation: The correct SQL command to drop a user in Oracle is DROP USER.
Question 8 of 50
What does the Oracle background process PMON do?
Correct answer: B) Monitors user sessions and cleans up after terminated sessions
Explanation: PMON (Process Monitor) cleans up after terminated user sessions by releasing locks and freeing resources.
Question 9 of 50
What is the primary purpose of Oracle's Data Guard?
Correct answer: B) To enable disaster recovery and high availability
Explanation: Oracle Data Guard provides disaster recovery and high availability by maintaining standby databases that can take over if the primary database fails.
Question 10 of 50
Which SQL statement is used to remove a column from a table in Oracle?
Correct answer: B) ALTER TABLE DROP column_name;
Explanation: The correct SQL statement to remove a column from a table in Oracle is ALTER TABLE DROP COLUMN.
Question 11 of 50
Which of the following best describes Oracle's undo tablespace?
Correct answer: B) It stores information required to roll back transactions.
Explanation: Undo tablespaces store information needed to roll back uncommitted transactions and provide read consistency.
Question 12 of 50
What is the default port used by Oracle listeners?
Correct answer: A) 1521
Explanation: The default port for Oracle listeners is 1521, which is used for database connection requests.
Question 13 of 50
Which of the following views is used to find information about active sessions in an Oracle database?
Correct answer: A) V$SESSION
Explanation: V$SESSION provides information about current sessions connected to the database.
Question 14 of 50
Which of the following Oracle features allows a database to be recovered up to a specific point in time?
Correct answer: B) Point-in-Time Recovery (PITR)
Explanation: Point-in-Time Recovery (PITR) allows a database to be recovered to a specific point before an error occurred.
Question 15 of 50
Which Oracle background process is responsible for archiving redo logs?
Correct answer: D) ARCn
Explanation: The ARCn (Archiver) background process is responsible for copying redo log files to archive locations when in ARCHIVELOG mode.
Question 16 of 50
Which SQL statement is used to revoke a privilege from a user in Oracle?
Correct answer: A) REVOKE privilege FROM user;
Explanation: The REVOKE statement is used to remove a privilege previously granted to a user.
Question 17 of 50
Which of the following is true about Oracle Database Resource Manager?
Correct answer: B) It is used to manage system resources such as CPU and I/O.
Explanation: Oracle Database Resource Manager is used to allocate and manage system resources such as CPU and I/O among different users and workloads.
Question 18 of 50
Which of the following components is responsible for parsing SQL statements in Oracle?
Correct answer: C) Library Cache
Explanation: The Library Cache is responsible for parsing and storing parsed SQL statements and execution plans.
Question 19 of 50
Which of the following statements is true about Oracle's Enterprise Manager?
Correct answer: B) It is an integrated management tool for monitoring and maintaining Oracle databases.
Explanation: Oracle Enterprise Manager is a web-based tool for managing, monitoring, and maintaining Oracle databases.
Question 20 of 50
What is the purpose of Oracle's Data Pump?
Correct answer: B) To perform high-speed data export and import
Explanation: Oracle Data Pump provides high-speed export and import utilities for transferring large amounts of data between databases.
Question 21 of 50
Which SQL statement creates a sequence in Oracle?
Correct answer: A) CREATE SEQUENCE sequence_name;
Explanation: The correct SQL statement to create a sequence is CREATE SEQUENCE sequence_name.
Question 22 of 50
Which Oracle background process ensures that data blocks in the buffer cache are written to disk?
Correct answer: B) DBWn
Explanation: The DBWn (Database Writer) process ensures that dirty data blocks in the buffer cache are written to disk.
Question 23 of 50
Which of the following is used to control the automatic extension of a data file in Oracle?
Correct answer: B) AUTOEXTEND
Explanation: AUTOEXTEND allows a data file to grow automatically as needed, according to the configured parameters.
Question 24 of 50
Which Oracle tool is used to generate and analyze AWR reports?
Correct answer: C) Enterprise Manager
Explanation: Oracle Enterprise Manager can be used to generate and analyze Automatic Workload Repository (AWR) reports for performance tuning.
Question 25 of 50
What is the purpose of Oracle's SQL*Loader utility?
Correct answer: A) To load data from external files into Oracle tables
Explanation: SQL*Loader is a utility used to load data from external files into Oracle tables.
Question 26 of 50
Which SQL statement is used to alter the size of a data file in Oracle?
Correct answer: B) ALTER DATABASE DATAFILE filename RESIZE;
Explanation: The correct SQL statement to alter the size of a data file is ALTER DATABASE DATAFILE filename RESIZE.
Question 27 of 50
Which of the following is a valid index type in Oracle?
Correct answer: B) Function-based Index
Explanation: A function-based index in Oracle indexes the result of a function applied to a column, enhancing query performance.
Question 28 of 50
What is Oracle's Real Application Clusters (RAc) used for?
Correct answer: B) High availability and scalability
Explanation: Oracle RAC enables multiple instances to access a single database, providing high availability and scalability.
Question 29 of 50
Which of the following is a dynamic performance view in Oracle?
Correct answer: B) V$SESSION
Explanation: V$SESSION is a dynamic performance view that provides information about current database sessions.
Question 30 of 50
What does the Oracle listener process do?
Correct answer: C) Listens for incoming database connection requests
Explanation: The Oracle listener process is responsible for handling incoming requests from clients trying to connect to the database.
Question 31 of 50
Which of the following components is part of Oracle's System Global Area (SGA)?
Correct answer: B) Data Dictionary Cache
Explanation: The Data Dictionary Cache is a component of the SGA that stores information about the database's structure and schema.
Question 32 of 50
Which SQL statement disables a constraint in Oracle?
Correct answer: C) ALTER TABLE table_name DISABLE CONSTRAINT constraint_name;
Explanation: The correct SQL statement to disable a constraint is ALTER TABLE DISABLE CONSTRAINT.
Question 33 of 50
What is the primary function of Oracle's LogMiner utility?
Correct answer: B) To analyze redo logs for changes to the database
Explanation: LogMiner is used to analyze changes in the redo logs, allowing users to track specific modifications made to the database.
Question 34 of 50
Which SQL statement is used to change the default tablespace of a user?
Correct answer: D) ALTER USER username DEFAULT TABLESPACE tablespace_name;
Explanation: The correct SQL statement to change a user's default tablespace is ALTER USER DEFAULT TABLESPACE.
Question 35 of 50
Which Oracle utility is used to create logical backups of tables?
Correct answer: C) Data Pump
Explanation: Oracle Data Pump is used to create logical backups by exporting tables, schemas, or entire databases.
Question 36 of 50
Which Oracle background process is responsible for checkpointing?
Correct answer: B) CKPT
Explanation: The CKPT (Checkpoint) background process is responsible for signaling when a checkpoint occurs, ensuring that all data files and control files are synchronized.
Question 37 of 50
What is Oracle's Materialized View used for?
Correct answer: B) To store the result of a query for faster retrieval
Explanation: A Materialized View stores the result of a query and can be refreshed periodically, providing faster query performance.
Question 38 of 50
Which of the following is true about Oracle's redo log files?
Correct answer: B) They are used to recover changes made to the database after a failure.
Explanation: Redo log files are used to store all changes made to the database and are critical for recovering the database after a failure.
Question 39 of 50
Which of the following options allows a table to automatically generate sequential numbers in Oracle?
Correct answer: C) CREATE SEQUENCE
Explanation: The CREATE SEQUENCE statement allows a table to generate sequential numbers for columns, typically for use as primary keys.
Question 40 of 50
What is the purpose of Oracle's SCN (System Change Number)?
Correct answer: A) It represents the timestamp of a specific change made in the database.
Explanation: The System Change Number (SCN) is a unique identifier assigned to each transaction, representing the point in time when changes were made.
Question 41 of 50
Which SQL statement is used to lock a table in Oracle?
Correct answer: D) LOCK TABLE table_name IN EXCLUSIVE MODE;
Explanation: The correct SQL statement to lock a table in Oracle is LOCK TABLE table_name IN EXCLUSIVE MODE.
Question 42 of 50
Which of the following options provides the ability to rollback a transaction in Oracle?
Correct answer: B) ROLLBACK TO SAVEPOINT
Explanation: ROLLBACK TO SAVEPOINT allows rolling back part of a transaction to a specified savepoint.
Question 43 of 50
Which Oracle process is responsible for generating redo entries?
Correct answer: C) LGWR
Explanation: The LGWR (Log Writer) process generates redo entries that are written to the redo log files to record database changes.
Question 44 of 50
Which of the following views in Oracle provides information about current system performance metrics?
Correct answer: B) V$SYSSTAT
Explanation: The V$SYSSTAT view provides information about current system performance metrics, such as CPU usage and I/O statistics.
Question 45 of 50
Which Oracle utility is used for block-level recovery of database files?
Correct answer: A) RMAN
Explanation: RMAN (Recovery Manager) is used for backup and recovery operations, including block-level recovery of database files.
Question 46 of 50
Which of the following Oracle background processes frees unused memory from the SGA?
Correct answer: D) SMON
Explanation: The SMON (System Monitor) process is responsible for freeing up unused memory and performing instance recovery after a crash.
Question 47 of 50
Which of the following SQL statements enables flashback mode in Oracle?
Correct answer: B) ALTER DATABASE FLASHBACK ON;
Explanation: The correct SQL statement to enable flashback mode in Oracle is ALTER DATABASE FLASHBACK ON.
Question 48 of 50
Which of the following is used to enforce referential integrity between tables in Oracle?
Correct answer: B) Foreign Keys
Explanation: Foreign keys enforce referential integrity by ensuring that a column value in one table corresponds to a valid value in another table.
Question 49 of 50
Which of the following statements is true about Oracle's Automatic Storage Management (ASM)?
Correct answer: B) It simplifies database storage management by automating the storage of database files.
Explanation: ASM automates and simplifies the management of database storage by organizing files into disk groups.
Question 50 of 50
Which of the following SQL statements modifies a table to add a new column?
Correct answer: B) ALTER TABLE table_name ADD column_name;
Explanation: The correct SQL statement to add a new column to a table is ALTER TABLE ADD COLUMN.
Set 5 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).