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 regarding Oracle Database control files is true?
Correct answer: D) A database must have at least one control file.
Explanation: The control file is one of the most critical files in an Oracle database. It contains information required to maintain and recover the database, such as the database name, timestamps of database creation, and the location of data files and redo log files. An Oracle database must have at least one control file to start and run the database.
Question 2 of 50
Which component is configured at database startup and cannot be dynamically managed?
Correct answer: A) Redo log buffer
Explanation: The redo log buffer is set at instance startup and is not dynamically alterable without restarting the instance.
Question 3 of 50
Which component is not part of an Oracle instance?
Correct answer: C) Control file
Explanation: The control file, data file, and redo log files are part of the Oracle database, not the Oracle instance.
Question 4 of 50
Which background process guarantees that committed data is saved even when the changes have not been recorded in data files?
Correct answer: C) LGWR
Explanation: The log writer (LGWR) process writes the redo log buffer information to the online redo log files.
Question 5 of 50
User John has updated several rows in a table and issued a commit. What does the DBWn (database writer) process do at this time in response to the commit event?
Correct answer: D) Does nothing.
Explanation: Database writer takes no action against the commit event. LGWR handles the commit.
Question 6 of 50
Which of the following best describes a RAC configuration?
Correct answer: A) One database, multiple instances
Explanation: With Real Application Clusters, multiple instances (nodes) can mount one database.
Question 7 of 50
Which component of the SGA contains the parsed SQL code?
Correct answer: C) Library cache
Explanation: The shared SQL area is stored in the library cache in a shared pool and is shared between users.
Question 8 of 50
Which tasks are accomplished by the SMON process? (Choose all that apply.)
Correct answer: D) Coalesces contiguous free space in dictionary-managed tablespaces
Explanation: SMON is responsible for performing instance recovery using the online redo log files and for coalescing contiguous free space in tablespaces.
Question 9 of 50
Choose the best statement from the options related to segments.
Correct answer: B) A nonpartitioned table can have only one segment.
Explanation: A table or index has a segment. A segment consists of one or more extents. A segment can belong to only one tablespace.
Question 10 of 50
From the following list, choose two processes that are optional in an Oracle Database 12c database.
Correct answer: D) MMAN
Explanation: The ARCn (Archiver) process is optional and is enabled only when the database is running in ARCHIVELOG mode. MMAN (Memory Manager) is active only when Automatic Memory operations are configured.
Question 11 of 50
Which SGA component will you increase or configure so that RMAN tape backups do not use memory from the shared pool?
Correct answer: D) Large pool
Explanation: The large pool is configured so that RMAN does not use the shared pool.
Question 12 of 50
When a user session is terminated, which processes are responsible for cleaning up and releasing locks? (Choose all that apply.)
Correct answer: D) PMON
Explanation: PMON is responsible for cleaning up failed user processes and releasing locks.
Question 13 of 50
The LRU algorithm is used to manage what part of the Oracle architecture
Correct answer: D) The shared pool and database buffer cache portions of the SGA
Explanation: The LRU mechanism ensures that frequently used objects remain cached in memory.
Question 14 of 50
Two structures make up an Oracle server: an instance and a database. Which of the following best describes the difference between an Oracle instance and a database?
Correct answer: A) An instance consists of memory structures and processes, whereas a database is composed of physical files.
Explanation: The instance consists of the SGA and background processes; the database is made up of physical files.
Question 15 of 50
Which of the following is the proper order of Oracle’s storage hierarchy, from smallest to largest?
Correct answer: B) Operating-system block, database block, extent, segment
Explanation: Multiple operating-system blocks make up database blocks, which make up extents, which make up segments.
Question 16 of 50
The DBA unknowingly terminated the process ID belonging to the PMON process of Oracle Database 12c database using the kill -9 command on Unix. Choose the best answer.
Correct answer: D) The instance crashes and needs to be restarted.
Explanation: PMON is critical; terminating it will crash the database.
Question 17 of 50
When an incremental checkpoint happens in a database, which file(s) are updated with the checkpoint position? Choose all options that are correct.
Correct answer: B) Control files
Explanation: During an incremental checkpoint, the control file is updated with the checkpoint position.
Question 18 of 50
User Isabella updates a table and commits the change after a few seconds. Which of the following actions are happening in the database? Order them in the correct sequence and ignore the actions that are not relevant.
Correct answer: B) Changed blocks from the buffer cache are written to data files.
Explanation: Data blocks are changed in memory, then the redo log buffers are written to redo log files on commit.
Question 19 of 50
Querying the V$LOG file shows the following information. Which redo group files are required for instance crash recovery?
1 NO CURRENT
2 NO INACTIVE
3 NO INACTIVE
4 NO ACTIVE
Correct answer: A) Group 1 and 4
Explanation: Redo log groups with status CURRENT and ACTIVE are required during instance crash recovery.
Question 20 of 50
You noticed that the current value of the UNDO_RETENTION parameter is 900 and is too low for some of your transactions. The database was created using DBCA. You issue the following statement: ALTER SYSTEM SET UNDO_RETENTION=4800; Which option is true?
Correct answer: C) The value is changed in memory, and when the database restarts the next time, the new value will be preserved when using the spfile.
Explanation: When using ALTER SYSTEM to change parameter values, the change is made to the server parameter file (spfile) too, because the default for the SCOPE clause is BOTH.
Question 21 of 50
You need to find the directory where the Oracle alert log is being written. Which initialization parameter can be best used to list the full directory path of the alert log location?
Correct answer: C) DIAGNOSTIC_DEST
Explanation: DIAGNOSTIC_DEST is the initialization parameter that determines where the Automatic Diagnostic Repository home is located. The alert log file would be in the <diagnostic_dest>/diag/rdbms/<dbname>/<instancename>/alert directory.
Question 22 of 50
Which data dictionary view is used to view the current values of parameters?
Correct answer: C) V$PARAMETER
Explanation: V$PARAMETER shows information about the parameters and their current values in the database. V$SPPARAMETER shows the information as read from the spfile.
Question 23 of 50
Which startup options must be used to start the instance when you create a new database?
Correct answer: D) STARTUP NOMOUNT
Explanation: When creating a new database or creating a control file, the database should be in the NOMOUNT state.
Question 24 of 50
The DIAGNOSTIC_DEST parameter is not set up in the initialization parameter file. The value of the ORACLE_HOME environment variable is /u01/app/oracle/product/12.1.0 , and the value of ORACLE_BASE is /u01/app/oracle . The database and instance name is xyz. What is the location of the text-alert log file for the xyz database?
Correct answer: B) /u01/app/oracle/diag/rdbms/xyz/xyz/trace
Explanation: The alert log file in Oracle Database 12c is saved in the $ORACLE_BASE/diag/rdbms/<dbname>/<instancename>/trace directory.
Question 25 of 50
You want to create a database using the DBCA with DB_BLOCK_SIZE as 32KB. Which statement is true?
Correct answer: C) You must choose the Custom template in the DBCA.
Explanation: The Custom template lets you choose the database block size in the DBCA. If the template includes data files, the block size of the template cannot be changed. The predefined templates that come with data files have the block size at 8KB.
Question 26 of 50
All of the following are database-management options within the Database Configuration Assistant except which one?
Correct answer: A) Change Database Initialization Parameters
Explanation: The Database Configuration Assistant lets you create databases, manage templates, add database options, and delete databases. Although you can change initialization parameters when you are defining a database, this is not one of the management options available.
Question 27 of 50
The Oracle Universal Installer is started by executing which program?
Correct answer: B) runInstaller
Explanation: The runInstaller executable performs a preinstall check of the operating system and hardware resources before starting the OUI graphical tool.
Question 28 of 50
You’ve been asked to install Oracle Database 12c on a new Linux server. You’re likely to ask the Unix system administrator to do all but which one of the following for you in order to get the new server ready for Oracle?
Correct answer: D) Determine which directory will be used for $ORACLE_HOME.
Explanation: While the Unix system administrator is responsible for creating volume groups and mount points, the DBA generally decides where the Oracle binaries will be installed—the location derived from $ORACLE_BASE or designated by the $ORACLE_HOME environment variable.
Question 29 of 50
Your database name is OCA12C. The options show the files that are available in the $ORACLE_HOME/dbs directory. Which file is used to start up the database instance when you issue the STARTUP command?
Correct answer: C) spfile.ora
Explanation: When starting the instance, Oracle looks for spfileOCA12C.ora file. If it cannot find that file, it looks for spfile.ora. If that file is not found, Oracle looks for the initOCA12C.ora file.
Question 30 of 50
Which initialization parameter cannot be changed after the database is created?
Correct answer: A) DB_BLOCK_SIZE
Explanation: The block size of the database cannot be changed after database creation. The database name can be changed after the control file is re-created with a new name, and the CONTROL_FILES parameter can be changed after the control files are copied to the new location.
Question 31 of 50
Which script creates the database dictionary?
Correct answer: D) catalog.sql
Explanation: The catalog.sql script creates the data dictionary views, dynamic performance views, and synonyms.
Question 32 of 50
If your database name is PROD and your instance name is PROD1, what would be the name of the text-alert log file?
Correct answer: B) alert_PROD1.log
Explanation: The text-alert log file has the name alert_<instance_name>.log. For most non-RAC databases, the instance name and database name would be the same.
Question 33 of 50
Your database is not responding and is in a hung state. You want to shut down and start the database to release all resources. Which statements would you use?
Correct answer: D) SHUTDOWN ABORT and STARTUP
Explanation: STARTUP FORCE will perform a SHUTDOWN ABORT and STARTUP of the database. SHUTDOWN ABORT will terminate all sessions and processes and will shut down the instance.
Question 34 of 50
Which of the following startup options does not perform a database recovery?
Correct answer: C) STARTUP NOMOUNT
Explanation: The recovery of a database occurs when the database moves from the MOUNT mode to the OPEN mode. All these options attempt to start up and open the database except for option C, which only puts the database in NOMOUNT mode.
Question 35 of 50
Which of the following shutdown statements does not perform a clean shutdown?
Correct answer: A) SHUTDOWN ABORT
Explanation: When you perform a SHUTDOWN ABORT, Oracle never performs a clean shutdown. All other types of shutdowns are considered clean shutdowns because Oracle will not have to perform a recovery on a subsequent database startup.
Question 36 of 50
You would like to perform maintenance on the system and limit access to only the DBA staff during the maintenance window. Which of the following startup options should you use?
Correct answer: B) STARTUP RESTRICT
Explanation: The STARTUP RESTRICT choice opens the database and allows only users with RESTRICTED database access to connect and use it.
Question 37 of 50
You want to start up the database using a binary initialization file. What is another name for this file?
Correct answer: C) Spfile
Explanation: An spfile is another term for a server-side binary file that Oracle reads when a database startup is performed. This binary file contains all the nondefault initialization parameters used at startup.
Question 38 of 50
Under normal circumstances, which of the following actions or events is not found in the Oracle alert log?
Correct answer: D) New columns added to a user table
Explanation: The Oracle alert log contains a chronological history of administrative events and actions and certain types of database errors that occur within the database. Adding a column to a user table is not an administrative action and is not recorded in the alert log. Adding a column will be written to the alert log if the parameter enable_ddl_logging is set to TRUE; the default is FALSE.
Question 39 of 50
Which of the following is true about EM Database Express? (Choose all that apply.)
Correct answer: C) You can modify static initialization parameters.
Explanation: A database cannot be started or stopped using OEM Database Express. The Database Control repository is not created when the CREATE DATABASE statement is executed. DBCA creates the Database Control repository and configures Database Control for you.
Question 40 of 50
Which of the following statements about tablespaces is true?
Correct answer: C) A bigfile tablespace can have only one data file.
Explanation: Bigfile tablespaces can have only a single data file. The traditional or smallfile tablespace can have many data files (the limit is OS-dependent, mostly 1022).
Question 41 of 50
Automatic segment space management on the tablespace causes which of the following table attributes in that tablespace to be ignored?
Correct answer: D) PCTFREE and PCTUSED
Explanation: Segment space management refers to free-space management, with automatic segment space management using bitmaps instead of FREELISTS, PCTFREE, and PCTUSED.
Question 42 of 50
Which is not a type of segment that is stored in a tablespace?
Correct answer: B) Redo
Explanation: Redo information is not stored in a segment; it is stored in the redo logs. Undo segments are stored in the undo tablespace; temporary segments are in the temporary tablespace; and permanent segments go into all the other tablespaces.
Question 43 of 50
Which allocation unit is the smallest?
Correct answer: C) Data block
Explanation: An extent is composed of two or more data blocks; a segment is composed of one or more extents; and a data file houses all these.
Question 44 of 50
You performed the following statement in the database. What actions can you perform on the CUST_INFO table in the CUST_DATA tablespace? (Choose all that apply.)
ALTER TABLESPACE CUST_DATA READ ONLY;
Correct answer: E) RENAME CUST_INFO TO CUSTOMER_INFO
Explanation: When a tablespace is read-only, DML operations and operations that affect data in the table are not allowed. TRUNCATE is not allowed, but the DROP operation is allowed. You can also rename the table using the RENAME statement or the ALTER TABLE statement.
Question 45 of 50
If the tablespace is offline, which statements should be executed to make the USERS tablespace read-only? (Choose all that apply.)
Correct answer: A) ALTER TABLESPACE USERS READ ONLY
Explanation: To make a tablespace read-only, all the data files belonging to the tablespace must be online and available. So bring the tablespace online, and then make it read-only.
Question 46 of 50
How would you add more space to a tablespace? (Choose all that apply.)
Correct answer: B) ALTER DATABASE DATAFILE <FILENAME> RESIZE <N>
Explanation: You can add more space to a tablespace either by adding a data file or by increasing the size of an existing data file.
Question 47 of 50
The database is using automatic memory management. The standard block size for the database is 8KB. You need to create a tablespace with a block size of 16KB. Which initialization parameter should be set?
Correct answer: B) DB_16K_CACHE_SIZE
Explanation: DB_CACHE_SIZE doesn't need to be set for the standard block size because Automatic Memory Management is used. If you set DB_CACHE_SIZE, its value will be used as the minimum. DB_16K_CACHE_SIZE should be set for the nonstandard block size.
Question 48 of 50
Which data dictionary view can be queried to obtain information about the files that belong to locally managed temporary tablespaces?
Correct answer: C) DBA_TEMP_FILES
Explanation: Locally managed temporary tablespaces are created using the CREATE TEMPORARY TABLESPACE command. The data files (temporary files) belonging to these tablespaces are in the DBA_TEMP_FILES view.
Question 49 of 50
How would you drop a tablespace if the tablespace were not empty?
Correct answer: D) Use DROP TABLESPACE <TABLESPACE NAME> INCLUDING CONTENTS.
Explanation: The INCLUDING CONTENTS clause is used to drop a tablespace that is not empty. Oracle does not remove the data files that belong to the tablespace if the files are not Oracle-managed; you need to do it manually using an OS command. Oracle updates only the control fi
Question 50 of 50
Which command is used to enable the autoextensible feature for a file if the file is already part of a tablespace?
Correct answer: A) ALTER DATABASE
Explanation: You can use the ALTER TABLESPACE command to rename a file that belongs to the tablespace, but all other file-management operations are done through the ALTER DATABASE command. To enable autoextension, use ALTER DATABASE DATAFILE <FILENAME> AUTOEXTEND ON .
Set 1 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).