Oracle Interview Questions and Answers Pdf Free Download - 2

Question: 6

What are the components of an Oracle instance?

Background process and memory structure are the two components of an Oracle instance.

Question: 7

What is the difference between SPFILE and PFILE?

Oracle can use both SPFILE and PFILE as initialization parameter files.

SPFILE is a binary file while PFILE is a text file.

You can change the values in PFILE by directly editing it but those changes would not take effect until the restart of the database.

Whereas, you have to use Oracle statements to change the values in SPFILE and these changes can be incorporated dynamically in a running database.

Question: 8

Name a tablespace, which is automatically created when you create a database?

The SYSTEM tablespace is created automatically during database creation. It contains data dictionary objects.

All data stored on behalf of stored PL/SQL program units (procedures, functions, packages and triggers) resides in the SYSTEM tablespace, which is always online when the database is open.

Question: 9

Which file is accessed when you start an Oracle database?

Initialization parameter file or SPFILE is always accessed first when an Oracle database is started.

This file is used to determine database level setting because those values are stored as parameters in this file.

Question: 10

How do you view parameter values when you are using PFILE or SPFILE?

You can use the SHOW PARAMETER command from SQL*Plus or query v$PARAMETER view to see the value of the parameters.

Related Questions