Vyom World.com . Let's Touch the Sky Together!  

VyomWorld.com Home
Interview Questions
VyomLinks.com Home
JobsAssist.com Home
Vyom Network
Contact Us
Jobs & Careers
Resume Submitter
Placement Papers
IT Companies Directory
Computer Jobs
Interview Questions
Online Exams
Vyom Career eMag.
SMS Jokes
Source Codes Library
Source Codes Home
ASP Source Codes
C Source Codes
C++ Source Codes
COBOL Source Codes
Java Source Codes
Pascal Source Codes
Submit Source Codes
GATE an Overview
GATE Preparation
Study Materal
GRE an Overview
GRE Questions
GRE Preparation
GRE Universities
TOEFL Preparation
TOEFL Resources
GMAT Preparation
GMAT Resources
MBA Preparation
MBA Resources
Networking Concepts
Networking Concepts
Testing Preparation
Testing Resources
Free Traffic Builder
Webmaster Articles
Web Hosting
Hardware Tutorial
1500 Free eBooks New!
Get 30,000 Interview Questions & Answers in an eBook.

Interview Success Kit - Get Success in Job Interviews

Interview Success Kit - Get Success in Job Interviews Interview Success Kit - 30,000 Interview Que. & Ans.

Home » Placement Papers » Oracle Placement Papers » Oracle Placement Paper 3

New Click here to Download 2023 Latest placement papers of this company New

Oracle Placement Paper



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

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

int main() {

printf (�The Square root of all parts is %d\n , ALL_PARTS * ALL_PARTS) ;

(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;

(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?


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


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?

(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?

(C) Undefined 

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

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

Oracle at BIT...well i cleared the written but the interview was 
really rigourous...it was in 4 rounds....with streching upto 8 
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 
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 at BIT was really great....it took a whopping 63(56 BEs and 

MCA) the pattern was no different....since i didn't appear for TCS 

cannot give the wordlist.....but it is only the wordlist that 
changed but rest of the pattern was same as JSR and other 
through GRE Barrons high frequency word list.....around 16 words 
from there... 

oracle paper

1. An index is automatically generated with the following 
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 
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 
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 
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 .. 
void main() 

char buffer[10]={"Genesis"}; 

a. 3 
b. 4 
c. 0 
d. illegal pointer subtraction 
14. what is the output for 

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.. 
a. 2 
b. 3 
c. 4 
d. 4.666666 
e. 5 
16. identify the relationship between the many employees 
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 
18. the process of including some controlled redundancy for 
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 
ques. of g apti were very lengthy so don't end up in solving 
them.....time was less......some 15 ques. from arithmetic......and 
logical,statement interpretation,arrangement,tense 
i am enclosing here the 2 C questions : 
1. given a square matrix which consists only of 1 and 0......find 
rows,which cols and which diagonals consist entirely of 1's. 
2. given an array of integers find all possible combinations of 
numbers whose sum equal to 90..... 
ans : knapsack problem (in data structures - aho ullman) 
Note : for them solution was not the criteria.......but the 
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; 
{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 
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) 

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? 
{int i=10; 
return 2.0; 
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; 
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

New Click here to Download 2023 Latest placement papers of this company New



Recently Updated: New Placement Papers added.
Vyom Network : Web Hosting | Dedicated Server | Free SMS, GRE, GMAT, MBA | Online Exams | Freshers Jobs | Software Downloads | Programming & Source Codes | GRE Preparation | Jobs, Discussions | Software Listing | Free eBooks | Free eBooks | Free Business Info | Interview Questions | Free Tutorials | International Business Information | IAS Preparation | Jokes, Songs, Fun | Free Classifieds | Free Recipes | FAQs | Free Downloads | Bangalore Info | Tech Solutions | Project Outsourcing, Web Hosting | GATE Preparation | MBA Preparation | SAP Info | Excellent Mobiles | Software Testing | Interview Questions | Freshers Jobs | Server Insiders | File Extension Directory

Copyright ©2003-2023 Vyom Technosoft Pvt. Ltd., All Rights Reserved. Read our Privacy Policy