2009 Oracle Placement PaperBangalore

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

User Ratings

4 out of 5 based on 1 Ratings.
Here are the details of 2009 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 2009. Here you will find Oracle Placement Paper Pattern and Download questions of Oracle Placement Paper 2009 with Answers & Solutions.

1.void main()
{
struct a
{
char ch[10];
char *str;
};
struct a s1={"Hyderabad","Bangalore"};
printf("\n%c%c",s1.ch[0],*s1.str);
printf("\n%s%s",s1.ch,s1.str);
getch();
}
Ans: HB, HyderabadBangalore

2. main(int argc,int *argv[])
{
int i;
for(i=1;i<argc;i++)
printf("\n%s%s",argv[i],(i<argc-1)?"":"");
return 0;
getch();
}
Ans: I work for oracle

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

Ans: A

4. 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)

5.Which of the following is not true incase of Command line arguments
A. The argc parameter is used to hold the number of arguments in the = command line and is an integer
B. The argv parameter is a pointer to an array of a character = pointer and each one points to command line arguments
C. The argv[1] always point to program name
D. None of above

Ans: C

6. A function without any return type declares return=20
A. Integer
B. Float
C. Void
D. Syntax Error

Ans: A

7.
What will be the output of the fallowing SELECT statement ?
SELECT count(*)
FROM emp
Where exist (select 'X' From dept
Where dept_name ='Stores' and dept.dept_id=emp.dept_id)


A. select total number of employees belonging to department " stores "
B. select all employees belonging to department "X"
C. select all employees belonging to department "stores"
D. select total number of employees belonging to department "X"

8. Denormalisation is done to
A. Check for Data Integrity
B. Reduce Data Redundancy
C. Intoduce Security Check
D. Increase Query performance .

9. When there is a failure in fetching the rows from a cursor…
a. %isopen
b. %notfound
c. %found
d. %rowcount

10. what is the index no of the last element of an array with 29
elements
a. 29
b. 28
c. 0
d. programmer defined

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

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

13. what is the output for
#include
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

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

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

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

16. 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);

17. What is the output of the following program

#include
#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

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

(A) INSTR

(B) SUBSTRING

(C) SUBSTR

(D) POS

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

20.Threading in java a program was given in which it had no exceptions and run function had string as its parameter

a. runtime error
b. compile time error
c. logical error
d. syntax error

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