-
web.groovymark@gmail.com
- December 5, 2024
Question 01
Which of the following statements is true about Oracle database redo logs?
A) Redo logs store only committed transactions.
B) Redo logs store both committed and uncommitted transactions.
C) Redo logs are only written when a checkpoint occurs.
D) Redo logs store a backup of the data files.
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 02
What is the purpose of Oracle’s flashback technology?
A) To recover from user errors by restoring an entire database to a previous point in time.
B) To roll forward changes from redo logs.
C) To generate reports of past data changes.
D) To provide automated backups.
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 03
Which SQL command is used to create a temporary tablespace in Oracle?
A) CREATE TEMPORARY TABLESPACE;
B) CREATE TEMP TABLESPACE;
C) CREATE TEMPORARY SPACE;
D) CREATE TEMPORARY STORAGE;
Correct Answer: A) CREATE TEMPORARY TABLESPACE;
Explanation: The correct SQL command to create a temporary tablespace is CREATE TEMPORARY TABLESPACE.
Question 04
Which of the following statements is true about Oracle Automatic Workload Repository (AWR)?
A) AWR snapshots are automatically generated by Oracle every 10 minutes.
B) AWR stores performance-related statistics.
C) AWR reports are stored in the redo logs.
D) AWR reports can be generated only manually.
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 05
Which Oracle process is responsible for recovering the database after a failure?
A) LGWR
B) CKPT
C) SMON
D) DBWn
Correct Answer: C) SMON
Explanation: The SMON process (System Monitor) is responsible for performing instance recovery after a failure.
Question 06
What happens when a database is opened in read-only mode?
A) Users cannot connect to the database.
B) Users can view data, but no DML or DDL operations can be performed.
C) The database prevents all access to the data.
D) Users can update data but cannot modify the schema.
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 07
Which SQL statement is used to drop a user in Oracle?
A) REMOVE USER username;
B) DROP USER username;
C) DELETE USER username;
D) REVOKE USER username;
Correct Answer: B) DROP USER username;
Explanation: The correct SQL command to drop a user in Oracle is DROP USER.
Question 08
What does the Oracle background process PMON do?
A) Performs instance recovery
B) Monitors user sessions and cleans up after terminated sessions
C) Writes data to data files
D) Checks data block integrity
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 09
What is the primary purpose of Oracle’s Data Guard?
A) To provide a backup solution
B) To enable disaster recovery and high availability
C) To automate database tuning
D) To facilitate data replication between databases
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
Which SQL statement is used to remove a column from a table in Oracle?
A) DELETE COLUMN column_name;
B) ALTER TABLE DROP column_name;
C) DROP COLUMN column_name;
D) ALTER TABLE REMOVE column_name;
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
Which of the following best describes Oracle’s undo tablespace?
A) It stores backup copies of data files.
B) It stores information required to roll back transactions.
C) It logs changes made to the data for recovery purposes.
D) It stores archived redo logs.
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
What is the default port used by Oracle listeners?
A) 1521
B) 8080
C) 1433
D) 1522
Correct Answer: A) 1521
Explanation: The default port for Oracle listeners is 1521, which is used for database connection requests.
Question 13
Which of the following views is used to find information about active sessions in an Oracle database?
A) V$SESSION
B) DBA_USERS
C) V$LOG
D) V$DATAFILE
Correct Answer: A) V$SESSION
Explanation: V$SESSION provides information about current sessions connected to the database.
Question 14
Which of the following Oracle features allows a database to be recovered up to a specific point in time?
A) Flashback Query
B) Point-in-Time Recovery (PITR)
C) Redo Log Archiving
D) Data Pump
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
Which Oracle background process is responsible for archiving redo logs?
A) DBWn
B) SMON
C) CKPT
D) ARCn
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
Which SQL statement is used to revoke a privilege from a user in Oracle?
A) REVOKE privilege FROM user;
B) REMOVE privilege FROM user;
C) DELETE privilege FROM user;
D) DROP privilege FROM user;
Correct Answer: A) REVOKE privilege FROM user;
Explanation: The REVOKE statement is used to remove a privilege previously granted to a user.
Question 17
Which of the following is true about Oracle Database Resource Manager?
A) It is used to monitor database memory usage.
B) It is used to manage system resources such as CPU and I/O.
C) It is used to optimize SQL query performance.
D) It is used to manage undo space.
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
Which of the following components is responsible for parsing SQL statements in Oracle?
A) Buffer Cache
B) Redo Log Buffer
C) Library Cache
D) Data Dictionary
Correct Answer: C) Library Cache
Explanation: The Library Cache is responsible for parsing and storing parsed SQL statements and execution plans.
Question 19
Which of the following statements is true about Oracle’s Enterprise Manager?
A) It is used to schedule backups only.
B) It is an integrated management tool for monitoring and maintaining Oracle databases.
C) It is used only for monitoring memory usage.
D) It is primarily used for SQL query optimization.
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
What is the purpose of Oracle’s Data Pump?
A) To recover a database to a previous point in time
B) To perform high-speed data export and import
C) To archive redo logs
D) To manage memory allocation
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.
