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

Real time Oracle Interview Questions


Real time Oracle Interview Questions

Questions: 25
Comments: 71
 Showing Questions 11-20 of 25 Questions
<< Previous 1 [2] 3 Next >>
 Sponsored Links

 
 Real time Oracle Interview Questions
Sorting Options :  

What is mutated trigger, is it the problem of locks. In single user mode we got mutated error, as a DBA how you will resolve it
Schema A has some objects and created one procedure and granted to Schema B. Schema B has the same objects like schema A. Schema B executed the procedure like inserting some records. In this case where the data will be stored whether in Schema A or Schema B
Latest Answer: SELECT TEXT FROM USER_SOURCE/ALL_SOURCE/DBA_SOURCEWHERE NAME= AND TYPE='PACKAGE';HERE THE TYPE MAY BE PACKAGE,PROCEDURE,.... ...
If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan
Latest Answer: when we try access a  table which is locked or manipulated by another user ...
Latest Answer: The wildcard char % can be placed in one of three ways:  %searchwordhere%  searchwordhere%  %searchwordhere  The searchwordhere% is the fastest because it can use an index if one is specified on that column. The other two ...
You are regularly changing the package body part. How will you create or what will you do before creating that package
All the users are complaining that their application is hanging. How you will resolve this situation in OLTP
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why
Latest Answer: The two available options are1. CRONTAB2. AT (One time scheduling) ...
View page << Previous 1 [2] 3 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 (?)

 
Expert Members
—
# User Name Count
1pandish 3
2agarwalk_2000 2
3Beena 1
4simakas 1
5kishoredba 1
6askvenki 1
7singh.neerajin 1
8leojames22 1
9kkalluri 1
10krish 1
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