GeekInterview.com
  I am new, Sign me up!
 

Oracle Architecture Interview Questions


Oracle Architecture Interview Questions

Questions: 73
Comments: 150
 Showing Questions 41-50 of 74 Questions
<< Previous 1 2 3 4 [5] 6 7 8 Next >>
 Sponsored Links

 
 Oracle Architecture Interview Questions
Sorting Options :  

Yes. 

Yes. 

A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns. 
Latest Answer: Table is data base object which stores the data in the logical representatiom in form of rows n coluns which is existing in two dimension form... and is stored in the databse. ...

A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.) 
Latest Answer: View is a Virtual Table. It likes like a table. View provide additional level tabel security and providing selected columns only and it accessing different tables no need to joins of different tables. Views also stores data like (Materialized Views) ...

Views do not contain or store data. 
Latest Answer:  Hi,   It  depends on the type of view it is.  if it is a normal view than it does not contains the data. and if it is materialsed view than it contains the data. Thanks sanjay pramanik ...

Yes. 

Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.Hide data complexity.Simplify commands for the user.Present the data in a different 

A sequence generates a serial list of unique numbers for numerical columns of a database's tables. 
Latest Answer: nice answer soumyanag thumati_nagaraju@yahoo.co.in ...

A synonym is an alias for a table, view, sequence or program unit. 
Latest Answer: ya synonym is used to rename or to create alias for the data base object .. ...

There are two types of Synonyms Private and Public. 

View page << Previous 1 2 3 4 [5] 6 7 8 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape