What is a control file?
Database’s overall physical architecture is maintained in a file called control file. It will be used to maintain internal consistency and guide recovery operations. Multiple copies of control files are advisable.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
How do you sort in a COBOL program Give sort file definition, sort statement syntax and meaning. ? 27.08.08
Syntax: SORT file-1 ON ASCENDING/DESCENDING KEY key.... USING file-2 GIVING file-3. USING can be substituted by INPUT PROCEDURE IS para-1 THRU para-2 GIVING can...What is File Status in VSAM ? 11.08.08
The FILE STATUS clause of the FILE-CONTROL paragraph allows for each file to be associated with a file status key (i.e., the 2-character data item spec...How do you sort in a COBOL program Give sort file definition, sort statement syntax and meaning ? 31.07.08
Syntax SORT file-1 ON ASCENDINGDESCENDING KEY key.... USING file-2 GIVING file-3. USING can be substituted by INPUT PROCEDURE IS para-1 THRU para-2 GIVING c...How to implement the multiple control files for an existing database? 23.05.08
Shutdown the database Copy one of the existing control file to new location' Edit config.ora file by adding new control file name Restart the database...What command would you use to create a backup control file? 14.05.08
Alter database backup control file to trace....What is Dataware Control? 25.04.07
Any control bound to Data Control. Ex:- Textbox, Check Box, Picture Box, Image Control, Label, List box, Combo Box, DB Combo,...What is the EAR file? 02.10.06
An EAR file is a standard JAR file with an .ear extension, named from Enterprise ARchive file. A J2EE application with all of its modules is delivered in EAR fi...What is the use of Control File ? 04.07.06
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operati...What are user controls and custom controls? 14.03.06
Custom controls: A control authored by a user or a third-party software vendor that does not belong to  the .NET Framework class library. This is a generic...What are database files, control files and log files. How many of these files should a database have at least? Why? 08.03.06
Database Files The database files hold the actual data and are typically the largest in size. Depending on their sizes, the tables (and other objects) for all t...