Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sudarsan
check point is a background process(chk process name),when
ever any transaction takes place oracle create an check
point for that particular transaction and that is saved
into the controlfile header as well as datafile header.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Where would you look for errors from the database engine?
how can you record information about current session?
What authentication modes does sql server support? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the default port no on which sql server listens? : sql server DBA
Explain materialized views and how they are used.
Query processing is slow(eg select query)how will u solve that
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Where do you find the default index fill factor and how to change it? : sql server DBA
What are the recovery models for a database? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
