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 Basics Interview Questions


Oracle Basics Interview Questions

Questions: 47
Comments: 230
 Oracle Basics Tags
 Showing Questions 11-20 of 47 Questions
<< Previous 1 [2] 3 4 5 Next >>
 Sponsored Links

 
 Oracle Basics Interview Questions
Sorting Options :  

Latest Answer: Dear All,LIFE OF SQL STATEMENTStep 1: Oracle Create a CursorFor every SQL, first a cursor is created (cursor creation can occur implicitly, or explicitly by declaring a cursor). Step 2: Oracle Parse SQL StatementA SQL statement is parsed only if an identical ...
Read Answers (3) | Asked by : Ritesh Ratna

Latest Answer: Instance is the memory structures and background processes used to interact with Database.Instance = SGA + Background ProcessDatabase is the physical files used to store information. the 3 types of physical files are: Datafiles, Control File and ...
Read Answers (1) | Asked by : Mohammed Abdul Afroze

Latest Answer: Where current of is used for updating the data referenced by cursor which was created as "SELECT FOR UPDATE".DECLARECURSROR MY_CURR IS        SELECT COL1, COL2, COL3,...,COLN        ...
Read Answers (3) | Asked by : ramahesh

Latest Answer: To execute sqlplus via Unix shell scripts the following parameters need to be initialized.(1.) ORACLE_HOME export ORACLE_HOME=Path to (2.) ORACLE_SIDexport ORACLE_SID=Actual ORACLE_SIDAfter these initializations have been done use sqlplus ...
Read Answers (2) | Asked by : ddkdhar

Latest Answer: The only difference between rownum and level pseudocolumn  isRownum is used to order the datas according to their ranks and it is used in inline views..Level pseudocolumn is used in hierarchial retrival of database..... ...
Read Answers (1) | Asked by : ddkdhar

Latest Answer: The varchar2(30) will take 30 bites. Because the size is specified as 30. if you entered a data of only 20 chars the remaining 10 will be transformed to the other field or row. By this the wastage of the disk space can be minimised. ...
Read Answers (2) | Asked by : ferozbm

Latest Answer:  The way the data maintained in the collection of tables can be explained by the data structure. The structure of database will show on which conditions the database will be maintained with out inconsistancy. ...
Read Answers (1) | Asked by : rajender

Latest Answer: And the primary purpose of one time procedure is for one time initialisation of package variables ...
Read Answers (3) | Asked by : hasanvtu

Create a query that will display the total no.of employees and, of that total, the no.of employees hired in 1995,1996,1997, and 1998. create appropriate column headings.

Create a matrix query to display the job, the salary for that job based on department number and the total salary for that job, for departments 20,50,80, and 90,giving each column and appropriate heading.
Read Answers (8) | Asked by : zecar

View page << Previous 1 [2] 3 4 5 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

 




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