KyaPoocha.com

Related Interview Questions

• What is a control file?  23.05.08

  Database's overall physical architecture is maintained in a file called control file. It will be used to maintain internal consistency and guide recovery operat...

• What is a datafile ?  05.05.08

  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 a...

• What are the components of physical database structure of Oracle database ?  02.05.08

  Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files....

• How can we create custom controls in ASP.NET?  29.04.07

  Custom Controls can be created in either of the following 3 methods. 1. Creating as a composite control : This method uses and combines the existing controls...

• How would you implement inheritance using VB.NET/C#?  16.01.07

  When we set out to implement a class using inheritance, we must first start with an existing class from which we will derive our new subclass. This existing cla...

• 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...

• Name the three major set of files on disk that compose a database in Oracle  11.03.06

  There are three major sets of files on disk that compose a database. All the files are binary. these are:- Database files Control files Redo logs The mos...

• What is cold backup and hot backup (in case of Oracle)?  08.03.06

  Cold Backup: It is copying the three sets of files (database files, redo logs, and control file) when the instance is shut down. This is a straight file copy, u...

• What is Oracle Block? Can two Oracle Blocks have the same address?  08.03.06

  Oracle "formats" the database files into a number of Oracle blocks when they are first created—making it easier for the RDBMS software to manage the files and...

• 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...