ORACLE PLACEMENT PAPERS --- Placement Paper 1



ORACLE PLACEMENT PAPERS --- Placement Paper 1..

Answer / guest

Oracle Placement Papers | Oracle Interview Procedure |
Oracle Aptitude Questions | Oracle Technical Questions |
Oracle Interview Questions


1. A certain number of men can finish a piece of work in 10
days. If however there were 10 men less it will take 10
days more for the work to be finished. How many men were
there originally?

(A) 110 men
(B) 130 men
(C) 100 men
(D) none of these


2. In simple interest what sum amounts of Rs.1120/- in 4
years and Rs.1200/- in 5 years ?

(A) Rs. 500
(B) Rs. 600
(C) Rs. 800
(D) Rs. 900


3. If a sum of money compound annually amounts of thrice
itself in 3 years. In how many years will it become 9 times
itself.

(A) 6
(B) 8
(C) 10
(D) 12


4. Two trains move in the same direction at 50 kmph and 32
kmph respectively. A man in the slower train observes the
15 seconds elapse before the faster train completely passes
by him.
What is the length of faster train ?

(A) 100m
(B) 75m
(C) 120m
(D) 50m


5. How many mashes are there in 1 squrare meter of wire
gauge if each mesh is 8mm long and 5mm wide ?

(A) 2500
(B) 25000
(C) 250
(D) 250000

6. x% of y is y% of ?

(A) x/y
(B) 2y
(C) x
(D) can't be determined


7. The price of sugar increases by 20%, by what % should a
housewife reduce the consumption of sugar so that
expenditure on sugar can be same as before ?

(A) 15%
(B) 16.66%
(C) 12%
(D) 9%


8. A man spends half of his salary on household expenses,
1/4th for rent, 1/5th for travel expenses, the man deposits
the rest in a bank. If his monthly deposits in the bank
amount 50, what is his monthly salary ?

(A) Rs.500
(B) Rs.1500
(C) Rs.1000
(D) Rs. 900

Oracle Placement Papers | Oracle Interview Procedure |
Oracle Aptitude Questions | Oracle Technical Questions |
Oracle Interview Questions


9. What is the difference between the two declaration ?

#include <stdio.h>
&
#include ?stdio.h?

(A) No Difference
(B) The 2nd declaration will not compile
(C) First case Compiler looks in all default location and
in 2nd case only in the working directory
(D) Depends on the Compiler


10. How can I print a ?%? character in a in between the
string foo and the value held in the variable foo using
printf format string?

(A) fprintf("foo " "%" "%d\n", foo);
(B) fprintf("foo ?%? %d\n", foo);
(C) fprintf("foo \% %d\n", foo);
(D) fprintf("foo " "%d\n", foo);

11. What is the output of the following program
#include <stdio.h>
#define FIRST_PART 7
#define LAST_PART 5
#define ALL_PARTS FIRST_PART + LAST_PART

int main() {

printf (?The Square root of all parts is %d\n , ALL_PARTS *
ALL_PARTS) ;
return(0);
}

(A) 35
(B) 144
(C) 49
(D) 47


12. What is the use of a make file

(A) Do detect memory leakage
(B) To optimise the code
(C) To link and compile source code to exe
(D) To disassemble the exe to source code


13. What is the difference between calloc and malloc

(A) calloc allocates memory in contiguous bytes, malloc
does not ensure contiguous memory allocation
(B) Memory allocated through calloc need not be freed
explicitly, While memory allocated through malloc needs to
be freed explicitly.
(C) calloc initialises the memory by setting all-bits-zero,
malloc does not does any zero fill.
(D) all of the above


14. What is the output :
void main()
{
int a,b=5,c=10;
a = (b-c) > (c-b) ? b : c;
printf(?%d?,a);
}

(A) 10
(B) 5
(C) 0
(D) Error


15. What is the value of *second_ptr

int *first_ptr;
int *second_ptr;

*second_ptr = 30;
ptr value = 1;
first_ptr = &value
second_ptr = first_ptr;


(A) 30
(B) 1
(C) first_ptr
(D) None of the above


16. How many columns are retrieved from this query:
SELECT address1||','||address2||','||address2 "Adress" FROM
employee;

(A) 1
(B) 2
(C) 3
(D) 0


17. To produce a meaningful result set without any
cartesian products, what is the minimum number of
conditions that should appear in the WHERE clause of a four-
table join?

(A) 8
(B) 3
(C) 4
(D) 5


18. Assuming today is Monday, 10 July 2000, what is
returned by this statement:

SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR')
FROM dual;

(A) 10-JUL-00
(B) 12-JUL-00
(C) 11-JUL-00
(D) 17-JUL-00





19. Which character is used to continue a statement in
SQL*Plus?

(A) *
(B) /
(C) -
(D) @


20. When a user creates an object without a TABLESPACE
clause, where will Oracle store the segment?

(A) System tablespace
(B) Users tablespace
(C) Default tablespace for the user
(D) Oracle will give an error


21. The primary key on table EMP is the EMPNO column. Which
of the following statements will not use the associated
index on EMPNO?

(A) select * from EMP where nvl(EMPNO, '00000') = '59384';
(B) select * from EMP where EMPNO = '59384';
(C) select EMPNO, LASTNAME from EMP where EMPNO = '59384';
(D) select 1 from EMP where EMPNO = '59834';


22. Which character function can be used to return a
specified portion of a character string?

(A) INSTR
(B) SUBSTRING
(C) SUBSTR
(D) POS


23. Which command will delete all data from a table and
will not write to the rollback segment?

(A) DROP
(B) DELETE
(C) CASCADE
(D) TRUNCATE







24. Which of the following can be a valid column name?

(A) Column
(B) 1966_Invoices
(C) Catch_#22
(D) #Invoices


25. Which Oracle access method is the fastest way for
Oracle to retrieve a single row?

(A) Primary key access.
(B) Access via unique index
(C) Table access by ROWID
(D) Full table scan


26. In this PL/SQL statement, which of the following lines
will produce an error?

(A) cursor CAPITALS is select CITY, STATE
(B) into my_city, my_state
(C) from CITIES
(D) where CAPITAL = 'Y';


27. In a PL/SQL block, a variable is declared as NUMBER
without an initial value. What will its value be when it is
used in the executable section of the PL/SQL block?

(A) NULL
(B) 0
(C) Results in a compilation error
(D) An exception will be raised


28. PL/SQL raises an exception, in which TWO of the
following cases:

(A) When a SELECT statement returns one row
(B) When a SELECT statement returns more than one row
(C) When the datatypes of SELECT clause and INTO clause do
not match
(D) When INTO statement is missing in the SELECT statement


29. What is the result if two NULL values are compared to
each other?

(A) TRUE
(B) FALSE
(C) Undefined
(D) NULL

30. Functions for error trapping are contained in which
section of a PL/SQL block?

(A) Header
(B) Declarative
(C) Executable
(D) Exception

Oracle Placement Papers | Oracle Interview Procedure |
Oracle Aptitude Questions | Oracle Technical Questions |
Oracle Interview Questions



ORACLE
======
Oracle at BIT...well i cleared the written but the
interview was
really rigourous...it was in 4 rounds....with streching
upto 8
hrs
per candidate who was selelcted....Oracle took a total of
10
people(9 BEs and 1 MCA)

The oracle paper was difficult to remember...

but i can give brief outline as to what could be
studied...The
Technical consisted of C,Pl/SQL and JAVA....go through Ivan
Bayross for Pl/SQL and Pointers in C by Kanetkar....some of
the
qs
were directly from there.....

u may also do DBMS concepts.....as to what is Data
Modelling,Transactions, Distributed Databases

In my interview.....first we had a short test on C
Programming
where in i
was given C programs to write on PREORDER Tree traversal
and
Conversion of
Infix to Postfix expression...the interview followed where
they
grilled me
on Java and C preprocessors from head to toe...but was
unable to
clear the
second round of interview

TCS
===
TCS at BIT was really great....it took a whopping 63(56 BEs
and
7
MCA) the pattern was no different....since i didn't appear
for TCS
i
cannot give the wordlist.....but it is only the wordlist
that
changed but rest of the pattern was same as JSR and other
RECs..go
through GRE Barrons high frequency word list.....around 16
words
from there...

oracle paper

1. An index is automatically generated with the following
constraints.
a. Check
b. Not null
c. Primary key
d. Foreign key
2. Select mod(16,3) from emp;
a. 1
b. 2
c. 3
d. Error in the stmt
3. The data dictionary view to see the list of constraints
enabled
on a
table is
a. user_tables
b. user_table_constraints
c. user_constraints
d. There is no dictionary view available for the same
4. Identify the pseudocolumns
a. rowid
b. sysdate
c. rowval
d. dual
5. select deptno, count(empno) from emp
where count(empno)>=5
group by deptno;
identify the line no which contains the error
a. 1
b. 2
c. 3
d. 1,3
6. choose the group function that can be used with any data
type
a. sum()
b. min()
c. avg()
d. all
7. which of the following sequence is true
a. WHERE,HAVING,GROUPBY,ORDERBY
b. GROUPBY, WHERE, HAVING, ORDERBY
c. ORDERBY,GROUPBY,WHERE,HAVING
d. NONE OF THE ABOVE
8. which of the proper keyword to deallocate memory
a. free
b. delete
c. clear
d. remove
9. what is the index no of the last element of an array
with 29
elements
a. 29
b. 28
c. 0
d. programmer defined

10. what is the final value of x when the code for(int
x=0;x<10;x++) is
run?
a. 10
b. 9
c. 0
d. 1
11. what is the data type of FILE?
a. integer
b. union
c. pointer
d. structure
12. if "a" is an array of 5*5 dimension, a[2][4] is same as
a. **(a+2+4)
b. *(a+2) + *(a+4)
c. **(a+2)+4
d. *(*a+2)+4)
13. what is the output of ..
#include<stdio.h>
void main()
{
char buffer[10]={"Genesis"};
printf("%d",&buffer[4]-(buffer));
}
a. 3
b. 4
c. 0
d. illegal pointer subtraction
14. what is the output for
#include<stdio.h>
main()
{
static int a[]={5,10,15,20};
int * ptr=a;
int ** ptr_ptr=&ptr;
printf("\n %d",**ptr_ptr++);
}
a. 5
b. 10
c. 15
d. 6
15. what is the value of expr..
1+2/3*4+1
a. 2
b. 3
c. 4
d. 4.666666
e. 5
16. identify the relationship between the many employees
working
in a dept..
a. one to one
b. one to many
c. many to one
d. many to many
17.there was a table given and it was asked which normal
form does
it
follows..
18. the process of including some controlled redundancy for
the
sake of performance
is known as
a. normalization
b. Cartesian product
c. Denormalization
d. None
19. in a doubley linked list
a. the last node contains the address of the first node
b. each node contains the address of previous and next node
c. each node contains the address of previous node
d. none
20. in a queue each node contains
a. the address of previous node
b. address of next node
c. address of both the previous and next node
d. none of the above


Oracle Paper

The test was of 1 hour 30 ques. g apti and 30 of
technical.......some
ques. of g apti were very lengthy so don't end up in
solving
them.....time was less......some 15 ques. from
arithmetic......and
rest
15
logical,statement interpretation,arrangement,tense
correction......and
like
that......
i am enclosing here the 2 C questions :
1. given a square matrix which consists only of 1 and
0......find
which
rows,which cols and which diagonals consist entirely of
1's.
2. given an array of integers find all possible
combinations of
the
numbers whose sum equal to 90.....
ans : knapsack problem (in data structures - aho ullman)
Note : for them solution was not the criteria.......but the
approach
was important......the solution should be generalised and
optimized........optimization was given the top
priority........
here is the techincal paper :
plz try to solve them urself by trying on comp.
1. const int MAX=10;
main()
{enum a {a,b,MAX};
print MAX;
}
2. enum object is a const which can only be assigned a
value at
initialization or a variable which can be assigned any
value in
the
middle of
the program?
3. void *p;
what operation cannot be performed on p?
ans : arithmetic operation unless it is properly typecasted
4. char **p="Hello";
print p,*p,**p
5. main()
{char str[]="Geneius";
print (str);
}
print(char *s)
{if(*s)
print(++s);
printf("%c",*s);
}
6. what does the function fcloseall() does ?
7. main()
{printf("Genius %d",fun(123));
}
fun(int n)
{return (printf("%d",n));
}
8. difference between definition and declaration.
9. find the error?
fun()
{int i=10;
if(i<10)
return 2.0;
else
return 3.0;
}
10. int a=9,b=5,c=3,d;
d=(b-c)<(c-a) ? a : b;
print d
11. 1+2/3*4+1=?
12. In C++, a variable can be defined wherever needed
whereas not
in C
13. main()
{int i=4;
fun(i=i/4);
print i;
}
fun(int i)
{return i/2;
}
14. what is an array ?
15. printf("\" NITK %%SURAHKAL%% !\"");
16. difference between scanf and gets in case of string
input
17. table t1 m rows and x cols
table t2 n rows and y cols
in t1*t2 rows? cols=?
ans. m*n ,x+y
18. symbol of realtionship between 2 entities?
19. which one cannot come in data modelling
a. customer b. student c. office d. speed
20. can a database table exist without a primary key ?
21. whether higher normal forms better than lower forms as
far
redundancy is concerned ?
22. file is at which level
ans. conceptual level
23. what is a foreign key

Oracle Placement Papers | Oracle Interview Procedure |
Oracle Aptitude Questions | Oracle Technical Questions |
Oracle Interview Questions


Is This Answer Correct ?    44 Yes 2 No

Post New Answer

More Placement Papers Interview Questions

Oracle apps Finance

1 Answers   Tecumseh,


TCS

3 Answers   TCS,


TISL PLACEMENT PAPERS -------------- Placement Paper 8

1 Answers   TISL,


icici

1 Answers   HDFC, ICICI,


TechMahindra Pattern & Interview {09/05/2007} {Bangalore}

3 Answers   Tech Mahindra,






BFL PLACEMENT PAPERS --------------- PLACEMENT PAPER

2 Answers   BFL,


CSC Placement Paper - 2006

4 Answers   CSC,


Tcs Technical, Managerial , HR Interview Placement paper ----25 Nov 2006 Hyd

7 Answers   EMC, Syntel, TCS, Wipro,


Sap Labs Written Test Placement Paper on Dec 2006

1 Answers   SAP Labs,


Delhi Infosys Paper & Interview [[4 february 2007 ]

2 Answers   Infosys,


I-GATE PLACEMENT PAPERS ---------placement paper -1

3 Answers   iGate,


placement paper for ece students in amararaja company

1 Answers   Amara Raja, Amara Raja Electronics, Amaron,


Categories