2010 Oracle Placement PaperBangalore

  • CategoryIT
  • Sub CategoryPlacement Papers
  • LocationBangalore
  • CompanyOracle
  • Posted date on our Website28 January 2011

User Ratings

3 out of 5 based on 2 Ratings.
Here are the details of 2010 Oracle Placement Paper job in Oracle. This job or placement paper has been sourced from either company website or newspaper or other media and from students who appeared for this job. User is requested to verify the data before applying for the job.

Welcome to Oracle Placement Paper 2010. Here you will find Oracle Placement Paper Pattern and Download questions of Oracle Placement Paper 2010 with Answers & Solutions.

1..void main()
{
int i;
clrscr();
for(i=1;i<6;++i)
switch(i)
{
case 1:
case 2: printf("%d,",i++);break;
case 3: continue;
case 4: printf("%d,",i);
}
printf("%d",i);
getch();
}

Ans: 1,4,6

2.Which of the storage class(es) becomes the global variables for the entire Program
(A) Extern
(B) Static
(C) Auto
(D) Register

Ans: A

3. What is the output of the program
void main()
{
char s[]="oracle is the best";
char t[40];
char *ss,*tt;
while(*tt++=*ss++);
printf("%s",t);
getch();
}
// A. oracle is the best
// B. Core dump
// c. Error Message
// D. Goes into infinite loop

Ans: B. core dump (Garbage value)


4. What is the output of the program
void main()
{
int j[10]={9,7,5,3,1,2,4,6,9};
int i=1;
clrscr();
for(;i<9;i++)
printf("%d ",--j[i++]);
getch();
}
// A. 6,2,1,5
// B. 6,2,1,5,7
// c. Error Message
// D. core dump

Ans: A. 6,2,1,5

5. Which clause u use to exclude the rows before grouping them?

A. Group By
B. Having
C. Where
D. Minus

6. Which of the following statements is not true about views?

A. you can create a index on views
B. Views do not have permanent data
C. Views can be based on one or more tables
D. Views can be dropped without dropping
tables


7. What should be the value of a, in the polynomials x2 – 11x + a and x2 – 14x + 2a, so that these two polynomials have common factors.

a) 24 b)1 c)-1 d)1/2

8. a right angled triangle, the square of the hypotenuse is twice the product of the other two sides. Then one of the acute angles of the triangle is…

a) 450 b) 300 c) 600 d) 150

9.. In class of 10 students, the teacher writes a number on the board. The first student tells that the number is divisible by 1, the second student tells that the number is divisible by 2, the third by 3, the forth by 4 and so on till 10. If the statement of one of the students in wrong then what is the least number possible.

10. 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

11. Identify the pseudocolumns

a. rowid
b. sysdate
c. rowval
d. dual

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
void main()
{
char buffer[10]={"Genesis"};
printf("%d",&buffer[4]-(buffer));
}
a. 3
b. 4
c. 0
d. illegal pointer subtraction

14. 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

15.there was a table given and it was asked which normal form does it follows..

16. the process of including some controlled redundancy for the sake of performance is known as

a. normalization
b. Cartesian product
c. Denormalization
d. None

17. 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

18. 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

19. 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

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

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

About Oracle:-

Oracle provides the world’s most complete, open, and integrated business software and hardware systems, with more than 370,000 customers—including 100 of the Fortune 100—representing a variety of sizes and industries in more than 145 countries around the globe. Oracle's product strategy provides flexibility and choice to our customers across their IT infrastructure. Now, with Sun server, storage, operating-system, and virtualization technology, Oracle is the only vendor able to offer a complete technology stack in which every layer is integrated to work together as a single system. In addition, Oracle's open architecture and multiple operating-system options gives our customers unmatched benefits from industry-leading products, including excellent system availability, scalability, energy efficiency, powerful performance, and low total cost of ownership.

Why Oracle- Why Should i join Oracle::-


Oracle recruiters are always searching for brilliant employees with an entrepreneurial spirit, looking for a work culture where innovation is the goal, hard work is expected, and creativity is rewarded. Oracle employees enjoy competitive salaries, excellent health benefits, and a network of like-minded co-workers that drive innovation across the entire technology industry.
 

Contact Details:

Address of Oracle-

Oracle India Private Limited
DLF Building No 8, Tower C
Ground & 7th Floor
DLF Cyber City, DLF Phase - II
Gurgaon - 122002, Haryana
Phone: +91 124 4328000
Fax: +91 124 4328101

Oracle India Private Limited
Bangalore Oracle Technology Park
India Development Centre
No. 3, Banerghatta Road
Bangalore 560 029
Tel: 91 80 41070000
Fax: 91 80 25526124

Oracle India Private Limited
India Development Centre
4th Floor, Cyber Towers
Hitec City, Madhapur
Hyderabad 500 033
Phone: +91 40 23110222/3/4
Fax: +91 40 23110225

Oracle India Private Limited
Acropolis Level 8 #148,
Dr.R.K.Salai
Mylapore
Chennai 600 004
Phone: +91 44 66346000
Fax: +91 44 66143951

Oracle India Private Limited
The IL&FS Financial Centre
2nd Floor, South Quadrant
Bandra-Kurla Complex
Bandra (East)
Mumbai 400 051
Phone: +91 22 66796200
Fax: +91 22 66796403

(Disclaimer : This Job or placement paper has been sourced from various sources like print media, Job consultants, past candidates, our users and/ or Company website. The posted date above means the date on which the Job was posted on our site and not on the company site. Users are advised to check with the company for latest requirements before applying for the job. Our website will not be responsible for any loss to the company or the candidate. We have no relation with the company and are not responsible for the validity of this Job. We donot charge the company or candidate or any student anything. If the respective company has any issue with the data provided or they want this particular job or placement paper to be removed they can write into us at infinitecourses@gmail.com)

Comments / Reviews / Queries On

Click to See more Comments