GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

Oracle DBA Interview Questions


Oracle DBA Interview Questions

Questions: 226
Comments: 399
 Oracle DBA Tags
—
Backup, DBMS, Parallel Server, Replication
 Showing Questions 131-140 of 226 Questions
<< Previous 10 11 12 13 [14] 15 16 17 18 19 Next >>
 Sponsored Links

 
 Oracle DBA Interview Questions
Sorting Options :  

Latest Answer: And.. It does not store any data value in it unlike normal index do.Queries will not get benefitted. This can be used only for analysis. ...
Read Answers (2) | Asked by : David
Virtual Indexes are another undocumented feature used by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will not behave the same way that normal indexes behave, and are meant for 
View Question | Asked by : David
Latest Answer: Query Rewrite option advantages we can get with the materialize view option also. ...
Latest Answer: Function-based indexes can use any Function or Object method that is declared as repeatable. Queries using expressions can use the index. Ex:- CREATE INDEX sales_margin_inx  ON sales(revenue - cost);   Sql> SELECT ...
Latest Answer: The explanations are above, read further in the concepts manual.I would advice caution when using these, as they can cause severe conention when used in Update/Insert Intensive / OLTP environs.This is because of the way the bitmap index is organized:Value1:rowid,rowid,rowid........Value2:rowid,rowid,rowid........ ...
Latest Answer: An Extent is a set of contignous data blocks obtain in a single allocation and used to store specific type of information. ...
Latest Answer: 1. set SHARED_SERVERS=(more than 1) in init.ora2. make changes in tnsnames.ora file to get the connection with DISPATHERS rather than dedicated servers ...
Latest Answer: datafile,control file and redo logs ...
Latest Answer: Data objects are used to stored data when needs to grow take chunks of space that is called extents and an data objects multiple extents are stored in segment. ...
Latest Answer: data segmentundo segmenttemperory segmentIndex segments ...
View page << Previous 10 11 12 13 [14] 15 16 17 18 19 Next >>

Ask A Question
Go Top
 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
Sponsored Links

 
Free White Papers & Software


Vulnerability Management
for Dummies eBook
 


 

Request Your Copy
 


Free: 60-Day Trial
Microsoft Office Project
 


 

Request Now
 


The 7 Things that
IT Security Professionals
MUST KNOW!
 


 

Request Your Free eBook

 
 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape