Placement Papers - ORACLE

Why ORACLE Placement Papers?

Learn and practice the placement papers of ORACLE and find out how much you score before you appear for your next interview and written test.

Where can I get ORACLE Placement Papers with Answers?

IndiaBIX provides you lots of fully solved ORACLE Placement Papers with answers. You can easily solve all kind of placement test papers by practicing the exercises given below.

How to solve ORACLE Placement Papers?

You can easily solve all kind of questions by practicing the following exercises.

ORACLE PAPER - 21 JUN 2003

Posted By : Abs Rating : +5, -1
Hi Friends

these are the questions of technical paper conducted by oracle this saturday .the code of the paper is qp-9. I have tried to recollect as much as i can.Certain questions are incomplete. the total no. of questions were 30.

1. precedence of PL/SQL

2.in an employee table consisting of empid and supid  to get supervisor id for employee (something like this related to ans. self join) we would use
Intersect
union
join
subquery

 3.The order of execution in corelated queries
Inner query executes first then outer query
Outer query executes first then inner query
each row of inner query is evaluated with outer query
each row of outer query is evaluated with inner query

4.declare
      i  Number
      j  Number
      k Number
begin
      i:=0
      for j = 1..5
                       i:=i+1;
                       j:=j+1;k:=i+j+k;

5.function of ROLLUP and CUBE

 6.Based on Group by clause rule that it should contain column found in select clause

7.Can procedure in a package be overloaded

8.public void static main(String []args)
{
String s1=new String("test");
String s2=new String("test");
if(s1==s2)
System.out.println("Both are equal");
Boolean b1=new Boolean("true");
Boolean b2=new Boolean("false");
if(b1.equals(b2))
System.out.println("some message");
}
output=?

9.
x=7;
y=0;
if(x=y)y=7;
else
y=5;
what is the value of y

10.Threading in java a prg was given in which it had no exceptions and run function had string as its parameter
a.runtime error
b.compile time error
c.
d.

11.what fuction can be repeated instead of comment
..
{
public void aMethod(String S,int i);
//here
..
}
a.public void aMethod(int i ,String S);
b.public void aMethod(String myobj,int j);
c.public int aMethod(String S,int i);
d.public void AMethod(String S,int i);

12.Encapsulation is implemented by
a.private variables and public methods
b.private variables and private methods
c.public variables and public methods
d.protected members

13.Based on scope of a variable

14.Recursive fuction are used to
a.call itself
b.call other functions
c.return integers
d..

15.
int a[]={0,1,2,3,4,5}
int *pa=a;
which of the following is not the correct way to access
a.a[5]
b.*(a+5)
c.*(pa+5)
d.*(*pa+5)

16.
struct{
char emp[12];
int mpno;
}e;
struct e a[2]={{jack,2},{raj,8},{jill,2}}
struct e *p;
*p=a;p+=2
..
17.AVL tree is a balanced binary search tree

18.order of B+tree

19.Disadvantage of indexed sequential file

20.queue can be called as full even if its capacity is'nt.


Like this page? +5 -1




Companies List:

3i Infotech - AAI - ABACUS - ABB - Accel Frontline - Accenture - Aditi - Adobe - ADP - Agreeya - Akamai - Alcatel Lucent - Allfon - Alumnus - Amazon - Amdocs - AMI - Andhra Bank - AppLabs - Apps Associates - Aricent - Ashok Leyland - Aspire - Atos Origin - Axes - Bajaj - Bank of Maharashtra - BEL - BEML - BHEL - BirlaSoft - Blue Dart - Blue Star - BOB - BPCL - BPL - Brakes - BSNL - C-DOT - Cadence - Calsoft - Canara Bank - Canarys - Capgemini - Caritor - Caterpillar - CDAC - CGI - Changepond - Ciena - Cisco - Citicorp - CMC - Consagous - Convergys - CORDYS - Crompton - CSC - CTS - Cummins - Dell - Deloitte - Delphi-TVS - DeShaw - Deutsche - Dotcom - DRDO - EDS - EIL - ELGI - ELICO - ERICSSON - Essar - Fidelity - Flextronics - Freescale - FXLabs - GAIL - GE - Genpact - Geodesic - Geometric - Globaledge - GlobalLogic - Godrej - Google - Grapecity - HAL - HCL - Hexaware - Honeywell - HP - HPCL - HSBC - Huawei - Hughes - IBM - IBS - ICICI - iGate - Impetus - iNautix - Indian Airforce - Indian Airlines - Infosys - Infotech - Intec - Integra - Intergraph - IOCL - iSOFT - ISRO - Ittiam - JSW - Keane - Kenexa - L & T - L & T Infotech - LG Soft - Lifetree - LionBridge - Mahindra Satyam - Mastek - Maveric - McAfee - MECON - Microsoft - MindTree - Miraclesoft - Mistral - Motorola - Mphasis - MTNL - NIC - Nokia Siemens - Novell - NTPC - Nucleus - ORACLE - Patni - Perot - Polaris - Ramco - Robert Bosch - Samsung - SAP - Sapient - Sasken - SBI - Sierra Atlantic - Sonata - Sony India - Sutherland - Syntel - TCS - Tech Mahindra - VeriFone - Virtusa - Wipro - Zensar.