Hurray .....you reached to
Day-2 preparation. Today we are going to prepare interview questions on CRD
files.
What is control file?
click here
for answer
How would you find out what a particular pfile does?
SQL>sho parameter pfile
SQL>SELECT VALUE FROM V$PARAMETER WHERE NAME='spfile';
SQL>SELECT VALUE FROM V$PARAMETER WHERE NAME='pfile';
How would you find out what a particular pfile does?
SQL>sho parameter pfile
SQL>SELECT VALUE FROM V$PARAMETER WHERE NAME='spfile';
SQL>SELECT VALUE FROM V$PARAMETER WHERE NAME='pfile';
What is the use of control file?
Required to bring up the
database and during recovery scenarios
What does a control file contains?
· Database
name
· Names
and locations of a database's files and redolog files
· Time
stamp of database creation.
What is the significance of MAXLOGFILES,
MAXLOGMEMBERS,MAXINSTANCES and MAXDATAFILES in control file
definition?
What are the characteristics of data files?
A data file can be
associated with only one database.One or more data files form a logical unit of
database storage called a tablespace.
What is the function of redo log?
The primary function of
the redo log is to record all changes made to data.
What is the use of redo log information?
The information in a redo
log file is used only to recover the database from a system or media failure
prevents database data from being written to a database's data files.
What is a datafile?
Every Oracle database has
one or more physical data files. A database's data files contain all the
database data. The data of logical database structures such as tables and
indexes is physically stored in the data files allocated for a database.
What are the characteristics of data files?
A data file can be
associated with only one database.One or more data files form a logical unit of
database storage called a tablespace.
What is the function of redo log?
The primary function of
the redo log is to record all changes made to data.
What is the use of redo log information?
The information in a redo
log file is used only to recover the database from a system or media failure
prevents database data from being written to a database's data files.
How many maximum Redo
Logfiles one can have in a Database?
Maximum number of Redo log
files= MAXLOGFILES in the control file.
Query to check:
select decode(type, 'REDO
LOG', 'MAXLOGFILES'), records_total from v$controlfile_record_section where
type = 'REDO LOG';
What is the difference between an pfile and spfile?
|
Pfile
|
Spfile
|
|
Static text file
|
Binary file
|
|
Changes made to the database needs restart of database
|
Most of the changes made to the database don’t need downtime
|
|
Parameters can't be changed onfly
|
parameters can be changes dynamically
|
|
Not much recommended
|
Recommended especially for RAC environment
|
No comments:
Post a Comment