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

PL/SQL Interview Questions


PL/SQL Interview Questions

Questions: 236
Comments: 957
 PL/SQL Tags
 Showing Questions 51-60 of 236 Questions
<< Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>
 Sponsored Links

 
 PL/SQL Interview Questions
Sorting Options :  

Latest Answer: OCI stands for Oracle Call Interface, it is a interface api used to access oracle database from C programs. Data Guard stands for it is multiple DB servers enviornment configured for Physical as well as Logical Standby Databases. And Oracle Advance Queueing ...
Read Answers (1) | Asked by : Kalyan

Latest Answer: We should use Exists or In based on the no of records inner and outer query is expected to return.Using Exists : Here the outer query is executed first and then inner query is excecuted for each value of outer query. So use this when outer query contains ...
Read Answers (9) | Asked by : Sachin Gadakri

How to reduce the the burden/main memory on database if i am using refcursor to hold large data to increase performance.
Read Answers (1) | Asked by : monu

View Question | Asked by : rishamjeet

Latest Answer: SQL (Structures Query Language)PL/SQL (Procedure Language / SQL) is the Oracle's version with lots of additional proprietary functions.T-SQL : Transact-SQL is Microsoft's proprietary version of SQL. ...
Read Answers (1) | Asked by : raafay

When using a count(distinct) is it better to use a self-join or temp table to find redundant data, and provide an example?
View Question | Asked by : hindol_saha

Latest Answer: Application trigger: Fires whenever an event occurs with a particular application  Database trigger: Fires whenever a data event (such as DML) or system event (such as logon or shutdown) occurs on a schema or database ...
Read Answers (2) | Asked by : RAJASEKARAN

Latest Answer: With the Oracle-supplied UTL_FILE package, you can read from and write to operating system files. It Provides security for directories on the server through the init.ora file. UTL_FILE Procedures and Functions:• Function FOPEN• Function IS_OPEN• ...
Read Answers (2) | Asked by : kartheek

Latest Answer: Hi,    Please find the explanation below....CURSOR A cursor is a variable that runs through the tuples of some relation. This relation can be a stored table, or it can be the answer to some query.  A cursor can be used in realtime when ...
Read Answers (1) | Asked by : gouri sankar rath

What is the difference between private packages and public package . what is the difference in declaration of these 2 packages.
Read Answers (2) | Asked by : Chanukya Kumar

View page << Previous 2 3 4 5 [6] 7 8 9 10 11 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
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