What are the valid status codes in the V$LOGFILE view? - Valid status codes V$LOGFILE views include STALE, INVALID, DELETED, or the status can be blank. STALE means the file contents are incomplete; INVALID means the file is not accessible; DELETED means the file is no longer used; and blank status means the file is in use.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

DETAILS

Question: What are the valid status codes in the V$LOGFILE view?

Answer: Valid status codes V$LOGFILE views include STALE, INVALID, DELETED, or the status can be blank. STALE means the file contents are incomplete; INVALID means the file is not accessible; DELETED means the file is no longer used; and blank status means the file is in use.

Category	Oracle Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 6708 users
Added on	7/7/2010
Views	68724
Rate it!

Question: What are the valid status codes in the V$LOGFILE view?

Answer:

Valid status codes V$LOGFILE views include STALE, INVALID, DELETED, or the status can be blank. STALE means the file contents are incomplete; INVALID means the file is not accessible; DELETED means the file is no longer used; and blank status means the file is in use. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	How many ARCn processes can be associated with an instance?	View Answer
	What will happen if ARCn could not write to a mandatory archive destination?	View Answer
	Which file is used to record all changes made to the database and is used only when performing an instance recovery?	View Answer
	What is the biggest advantage of having the control files on different disks?	View Answer
	Which data dictionary view shows that the database is in ARCHIVELOG mode?	View Answer
	The initialization parameter file has LOG_CHECKPOINT_INTERVAL = 60; What does this mean?	View Answer
	Which data dictionary view provides the names of the control files?	View Answer
	When you create a control file, the database has to be:	View Answer
	What piece of information is not available in the control file?	View Answer
	What is the best method to rename a control file?	View Answer
	Which optional component in the database creation process sets up functions and procedures to store, access, and analyze data needed for Geographical Information Systems (GIS)?	View Answer
	Which clauses in the CREATE DATABASE command specify limits for the database?	View Answer
	Which clauses in the CREATE DATABASE command specify limits for the database?	View Answer
	What is the prefix for dynamic performance views?	View Answer
	Which data dictionary view provides information on the version of the database and installed components?	View Answer
	What is the default password for the SYS user?	View Answer
	Who owns the data dictionary?	View Answer
	How many data files can be specified in the DATAFILE clause when creating a database?	View Answer
	Which event trigger from the following cannot be created at the database level?	View Answer
	How do you correct a procedure that has become invalid when one of the tables it is referring to was altered to drop a constraint?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Oracle Interview Questions & Answers - Exam Mode / Learning Mode