Software job search
.net sql interview questions
  The best place for technical interview questions

 
Home.netSql serverAsp.netC#Vb.netAdo.netAjaxMcpd dumpsWord count tool
Oracle interview questions
 
Question 1   What are the components of physical database structure of oracle database

An oracle database structure contains the below physical components

1) data files
2) archive files
3) redo files
4) control files



Question 2   What are the components of logical database structure of oracle database

Oracle database contains two type of logical database structures.

1) database's schema objects
2) tablespace

database's schema objects – objects like stored procedures, indexes, function, triggers are known as schema objects. they are logical objects stored on a tablespace.

tablespace - logical storage locations in oracle are known as tablespace which are not visible on the file system. there are 3 types of tablespace available in oracle undo, temporary and permanent




Question 3   What is a tablespace

Physical storage locations in oracle are known as datafiles and logical storage locations are known as tablespace. there are 3 types of tablespace available in oracle undo, temporary and permanent. a table space will contain at least one or more datafiles.



Question 4   What is the use of control file

Database’s physical structure information will be stored on a control file. every database has a control file. a control file will have the following informations

1) database name
2) date and time of database creation
3) current log sequence number
4) datafiles name and location
5) redo log file
6) rman catalog
7) database id



 Rate this page
     
 28 votes , average 4 out of 5
1 

Reader's opinions -

No comments
Loading

 
.net interview questions
Asp.net interview questions
C# interview questions
Vb.net interview questions
Ado.net interview questions
Ajax interview questions
Wcf interview questions
Wpf interview questions
.net threading interview questions
.net remoting and webservices interview questions
.net caching interview questions
.net oops interview questions
Sharepoint interview questions
Jquery interview questions
Silverlight interview questions
Linq interview questions
Wwf interview questions
Java interview questions
Sql server interview questions
Ssis interview questions
Ssrs interview questions
Data warehousing interview questions
Data mining interview questions
Oracle interview questions
Php interview questions
Design patterns interview questions
Uml interview questions
Mcpd dumps
Pmp practice tests

This site is best viewed with Internet Explorer 7.0 or higher, Firefox 2.0 or higher, Chrome at a minimum screen resolution of 1024x768.
A complete solution to interview questions
free matrimonial website      
web hosting plans |  compare vps hosting plans |  Compare dedicated hosting plans |  Compare linux hosting plans |  Compare cloud hosting plans |  Compare windows hosting plans | 
Hosting reviews |  GoDaddy reviews | 
Support Wikipedia