ORACLE PLACEMENT PAPERS --- Placement Paper 3
- 4 Answers
- 22568 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / guest
Oracle Placement Papers | Oracle Interview Procedure |
Oracle Aptitude Questions | Oracle TechniOraclel Questions
| Oracle Interview Questions
. Three beauty pageant finalists-Cindy, Amy and Linda-The
winner was musician. The one who was not last or first was
a math major. The one who came in third had black hair.
Linda had red hair. Amy had no musical abilities. Who was
first?
(A) Cindy (B)
Amy (C) Linda
(D) None of these
2. Two twins have certain peculiar characteristics. One of
them always lies on Monday, Wednesday, Friday. The other
always lies on Tuesdays, Thursday and Saturdays. On the
other days they tell the truth. You are given a
conversation.
Person A- today is Sunday, my name is
Anil
Person B-today is Tuesday, my name is
Bill What day is today?
(A) Sunday (B)
Tuesday (C) Monday
(D) Thursday
3. The difference of a number and its reciprocal is 1/2.The
sum of their squares is
(A) 9/4 (B)
4/5 (C)
5/3 (D) 7/4
4. The difference of a number and its square is 870.What is
the number?
(A) 42 (B)
29 (C)
30 (D) 32
5. A trader has 100 Kg of wheat, part of which he sells at
5% profit and the rest at 20% profit. He gains 15% on the
whole. Find how much is sold at 5% profit?
(A) 60 (B)
50 (C)
66.66 (D) 33.3
6. Which of the following points are collinear?
(A) (3,5) (4,6)
(2,7) (B) (3,5) (4,7)
(2,3)
(C) (4,5) (4,6)
(2,7) (D) (6,7) (7,8)
(2,7)
7. A man leaves office daily at 7pm.a driver with car comes
from his home to pick him from office and bring back home.
One day he gets free at 5.30 and instead of waiting for
driver he starts walking towards home. In the way he meets
the car and returns home on car. He reaches home 20 minutes
earlier than usual. In how much time does the man reach
home usually?
(A) 1 hr 20 min (B) 1
hr (C) 1 hr 10 min
(D) 55 min
8. If m:n = 2:3,the value of 3m+5n/6m-n is
(A) 7/3 (B)
3/7 (C)
5/3 (D) 3/5
9. A dog taken four leaps for every five leaps of hare but
three leaps of the dog is equal to four leaps of the hare.
Compare speed?
(A) 12:16 (B)
19:20 (C) 16:15
(D) 10:12
10. A watch ticks 90 times in 95 seconds. And another watch
ticks 315 times in 323 secs. If they start together, how
many times will they tick together in first hour?
(A) 100 times (B) 101
times (C) 99 times (D)
102 times
Oracle Placement Papers | Oracle Interview Procedure |
Oracle Aptitude Questions | Oracle TechniOraclel Questions
| Oracle Interview Questions
11. The purpose of defining an index is
(A) Enhance Sorting
Performance (B) Enhance Searching
Performance
(C) Achieve
Normalization (D) All of
the above
12. A transaction does not necessarily need to be
(A) Consistent (B)
Repeatable (C) Atomic (D)
Isolated
13. To group users based on common access permission one
should use
(A) User Groups (B)
Roles (C) Grants (D) None of
the above
14. PL/SQL uses which of the following
(A) No Binding (B) Early
Binding (C) Late Binding (D) Deferred
Binding
15. Which of the constraint can be defined at the table
level as well as at the column level
(A) Unique (B) Not
Null (C) Check (D) All
the above
16. To change the default date format in a SQLPLUS Session
you have to
(A) Set the new format in the DATE_FORMAT key in
the windows Registry.
(B) Alter session to set NLS_DATE-FORMAT.
(C) Change the Config.ora File for the date base.
(D) Change the User Profile USER-DATE-FORMAT.
17. Which of the following is not necessarily an advantages
of using a package rather than independent stored procedure
in data base.
(A) Better
performance.
(B) Optimized memory usage.
(C) Simplified Security
implementation. (D)
Encapsulation.
18. Integrity constrains are not checked at the time of
(A) DCL Statements.
(B) DML Statements.
(C) DDL Statements.
(D) It is checked all the above cases.
19. Roll Back segment is not used in case of a
(A) DCL Statements. (B) DML
Statements. (C) DDL Statements. (D) all of the
above.
20. An Arc relationship is applicable when
(A) One child table has multiple parent
relation, but for anyone instance of a child record only
one of the relations is applicable.
(B) One column of a table is related to another
column of the same table.
(C) A child table is dependent on columns other
than the primary key columns of the parent table.
(D) None of the above.
Oracle Placement Papers | Oracle Interview Procedure |
Oracle Aptitude Questions | Oracle TechniOraclel Questions
| Oracle Interview Questions
21. What is true about the following C functions?
(A) Need not return any
value. (B) Should always return
an integer.
(C) Should always return a
float. (D) Should always return more
than one value.
22. enum number { a=-1, b=4, c,d,e,} what is the value of
e?
(A) 7 (B)
4 (C)
5 (D) 3
23. Which of the following about automatic variables within
a function is correct?
(A) Its type must be declared before using the
variable. (B) They are local.
(C) They are not initialized to
zero. (D)
They are global.
24. Consider the following program segment
int n, sum=5;
switch(n)
{
case 2:sum=sum-2;
case 3:sum*=5;
break;
default:sum=0;
}
if n=2, what is the value of the sum?
(A) 0 (B)
15 (C)
3 (D) None of these.
25. Which of the following is not an infinite
loop?
(A)
x=0;
(B) # define TRUE 0....
do
{
While(TRUE){....}
/*x unaltered within the
loop*/ (C) for(;;) {....}
....}
While
(x==0);
(D) While(1) {....}
26. Output of the following program is
main()
{
int i=0;
for(i=0;i<20;i++)
{
switch(i){
case 0:
i+=5;
case 1:
i+=2;
case 5:
i+=5;
default:
i+=4;
break;
}
}
}
(A) 5,9,13,17 (B)
12,17,22 (C) 16,21 (D)
syntax error.
27. What does the following function print?
func(int i)
{
if(i%2) return 0;
else return 1;
}
main()
{
int i=3;
i=func(i);
i=func(i);
printf("%d",i);
}
(A) 3 (B)
1 (C)
0 (D) 2
28. What will be the result of the following program?
char*g()
{
static char x[1024];
return x;
}
main()
{
char*g1="First String";
strcpy(g(),g1);
g1=g();
strcpy(g1,"Second
String");
printf("Answer is:%s", g
());
}
(A) Answer is: First
String (B) Answer is: Second
String
(C) Run time Error/Core Dump
(D) None of these
29. Consider the following program
main()
{
int a[5]={1,3,6,7,0};
int *b;
b=&a[2];
}
The value of b[-1] is
(A) 1 (B)
3 (C) -
6 (D) none
30. Given a piece of code
int x[10];
int *ab;
ab=x;
To access the 6th element of the array which of the
following is incorrect?
(A) *(x+5) (B) x
[5] (C) ab[5]
(D) *(*ab+5} .
Oracle Placement Papers | Oracle Interview Procedure |
Oracle Aptitude Questions | Oracle TechniOraclel Questions
| Oracle Interview Questions
| Is This Answer Correct ? | 49 Yes | 5 No |
Post New Answer View All Answers
Do we have vacancy for HR RECRUITER ?
Sks Microfinance
what is the use of air in gc
aptitude
HI SIR I WANT PREVIOUS QUESTION PAPER OF HPCL I M CHEMICAL ENGG.
What kind of Issues/bugs arise in ETL projects? I would like to know few issues (critical to somewhat bugs ) normally occur in ETL process especially when testing? Domains can be banking, retail or any.
my question is : reverse a string in COBOL program (please write a code asap) input file: 1234abcdef abc*$#1___ cdef____ghi a_z_k_h___ 4_3_2_1___ ______5678 output file: 8765_____ 1_2_3_4__ h_k_z_a__ ihg____ghi 1#$*cba__ fedcb4321
Recently conducted Apptitude test
my question is : reverse a string in COBOL program (please write a code asap) input file: 1234abcdef output file: 8765_____ abc*$#1___ 1_2_3_4__ cdef____ghi h_k_z_a__ a_z_k_h___ ihg____ghi 4_3_2_1___ 1#$*cba__ ______5678 fedcb4321
What were the occupations of the people who lived within the Mauryan Empire?
A frog wants to climb a pole which is 15 feet in height, frog can jump 3 feet every minute after which he rests for a minute where he slips down 2 feet. How much time will the frog take to reach the top of the pole?
Hi.. Guys Im pranitha, presently im working in a organisation & im look for job at MNC's like DELL, Delloitte, Bank of America, Genpect, etc., I have completed B.com . Pls help me...
what you will do when you struck in traffic ?
email me previous question papers of bob bank for po exams
what is difference between uv and visible spectroscopy and how to differentiate the drug compounds in uv visible region
