Placement papers of Oracle 2015. Learn and practice the placement papers and interview questions answers of Oracle and find out how much you score before you appear for your next interview and written test.
Oracle Placement Papers - Interview Questions:
1. How many times the program will print "India
include
int main()
{
printf("India");
main();
return 0;
}
A.Infinite times B.32767 times C.65535 times D.Till stack doesn't overflow
Answer: D
Explanation:
A call stack or function stack is used for several related purposes, but the main reason for having one is to keep track of the point to which each active subroutine should return control when it finishes executing. A stack overflow occurs when too much memory is used on the call stack. Here function main() is called repeatedly and its return address is stored in the stack. After stack memory is full. It shows stack overflow error.
2. Specify the 2 library functions to dynamically allocate memory?
A.malloc() and memalloc() B.alloc() and memalloc() C.malloc() and calloc() D.memalloc() and faralloc()
Answer: C
3. You need to store elements in a collection that guarantees that no duplicates are stored. Which two interfaces provide that capability?
A.Java.util.Map B.Java.util.List C.Java.util.Collection D.None of the above
Answer: A
Explanation:
Option A is correct. A Map cannot contain duplicate keys. Option B is wrong. Lists typically allow duplicate elements. Option C is wrong. Collection allows duplicate elements.
4. Which three are methods of the Object class? 1. notify(); 2. notifyAll(); 3. isInterrupted(); 4. synchronized(); 5. interrupt(); 6. wait(long msecs); 7. sleep(long msecs); 8. yield();
A.1, 2, 4 B.2, 4, 5 C.1, 2, 6 D.2, 3, 4
Answer: C
Explanation:
(1), (2), and (6) are correct. They are all related to the list of threads waiting on the specified object. (3), (5), (7), and (8) are incorrect answers. The methods isInterrupted() andinterrupt() are instance methods of Thread. The methods sleep () and yield() are static methods of Thread. D is incorrect because synchronized is a keyword and the synchronized()construct is part of the Java language.
5. Which class or interface defines the wait(), notify(),and notifyAll() methods?
A.Object B.Thread C.Runnable D.Class
Answer: A
Explanation:
The Object class defines these thread-specific methods. Option B, C, and D are incorrect because they do not define these methods. And yes, the Java API does define a class called Class, though you do not need to know it for the exam
6. The SQL WHERE clause:
A.limits the column data that are returned. B.limits the row data are returned. C.Both A and B are correct. D.Neither A nor B are correct.
Answer: B
7. To define what columns should be displayed in an SQL SELECT statement:
A.use FROM to name the source table(s) and list the columns to be shown after SELECT.
B.use USING to name the source table(s) and list the columns to be shown after SELECT.
C.use SELECT to name the source table(s) and list the columns to be shown after USING.
D.use USING to name the source table(s) and list the columns to be shown after WHERE.
Answer: A
8. The ODBC core API consists of which of the following functions
A.Commit or rollback transactions only B.Connect to data sources with driver-specific information only C.Connect to data sources only D.Both 1 and 3 above are in the OBDC core API.
Answer: D
9. The memory address of fifth element of an array can be calculated by the formula
A.LOC(Array[5]=Base(Array)+w(5-lower bound), where w is the number of words per memory cell for the array
B.LOC(Array[5])=Base(Array[5])+(5-lower bound), where w is the number of words per memory cell for the array
C.LOC(Array[5])=Base(Array[4])+(5-Upper bound), where w is the number of words per memory cell for the array
D.None of above
Answer: A
10. Which of the following is not a limitation of binary search algorithm?
A.must use a sorted array
B.requirement of sorted array is expensive when a lot of insertion and deletions are needed
C.there must be a mechanism to access middle element directly
D.binary search algorithm is not efficient when the data elements are more than 1000.
Answer: D
You can also see: Syntel Placement Papers
11. SNAPSHOT is used for [DBA]
A.Synonym B.Table space C.System server D.Dynamic data replication
Answer: D
12. What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW regarding moving the window with respect to the application window?
A.Both windows behave the same way as far as moving the window is concerned.
B.A document window can be moved outside the application window while a dialog window cannot be moved
C.A dialog window can be moved outside the application window while a document window cannot be moved
D.None
Answer: C
13. What does DLL stands for?
A.Dynamic Language Library B.Dynamic Link Library C.Dynamic Load Library D.None of the above
Answer: B
14. 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
Answer: A
15. void start()
{
A a = new A();
B b = new B();
a.s(b);
b = null; /* Line 5 */
a = null; /* Line 6 */
System.out.println("start completed"); /* Line 7 */
}
When is the B object, created in line 3, eligible for garbage collection
A.after line 5 B.after line 6 C.after line 7 D.There is no way to be absolutely certain.
Answer: D
Explanation:
Option D is correct. I think there are too many unknowns about the method s and the classes A and B to be able to answer this question with any certainty.
16. int i,j;
for(i=0;i<=10;i++)
{
j+=5;
assert(i<5);
}
A.Runtime error B.5 C.6 D.10
Answer: A
Explanation:
Runtime error: Abnormal program termination. assert failed (i<5), NOTE asserts are used during debugging to make sure that certain conditions are satisfied. If assertion fails, the program will terminate reporting the same. After debugging use, #undef NDEBUG and this will disable all the assertions from the source code. Assertion is a good debugging tool to make use of.
17. main()
{
int c[ ]={2.8,3.4,4,6.7,5};
int j,*p=c,*q=c;
for(j=0;j<5;j++)
{
printf(" %d ",*c);
++q;
}
for(j=0;j<5;j++)
{
printf(" %d ",*p);
++p;
}
}
A.2 2 2 2 2 2 3 4 6 5 B.2.8,3.4,4,6.7,5 C.Compiler error D.None
Answer: A
Explanation:
Initially pointer c is assigned to both p and q. In the first loop, since only q is incremented and not c , the value 2 will be printed 5 times. In second loop p itself is incremented. So the values 2 3 4 6 5 will be printed
18. main(int argc, char **argv)
{
printf("enter the character");
getchar();
sum(argv[1],argv[2]);
}
sum(num1,num2) int num1,num2;
{
return num1+num2;
}
A.2 B.3 C.Compile error D.None
Answer: C
Explanation:
argv[1] & argv[2] are strings. They are passed to the function sum without converting it to integer values.
19. #include
main()
{
char s[]={'a','b','c','\n','c','\0'};
char *p,*str,*str1;
p=&s[3];
str=p;
str1=s;
printf("%d",++*p + ++*str1-32);
}
A.77 B.Compiler error C.32 D.None
Answer: A
Explanation:
p is pointing to character '\n'. str1 is pointing to character 'a' ++*p. "p is pointing to '\n' and that is incremented by one." the ASCII value of '\n' is 10, which is then incremented to 11. The value of ++*p is 11. ++*str1, str1 is pointing to 'a' that is incremented by 1 and it becomes 'b'. ASCII value of 'b' is 98. Now performing (11 + 98 - 32), we get 77("M"); So we get the output 77 :: "M" (Ascii is 77).
20. #include
int main()
{
int j=1;
while(j <= 255)
{
printf("%c %d\n", j, j);
j++;
}
return 0;
}
A.Infinite times B.255 times C.256 times D.254 times
Answer: B
Explanation:
The while(j <= 255) loop will get executed 255 times. The size short int(2 byte wide) does not affect the while() loop.
You can also see: Cisco Placement Papers
21. Which of the following data structure store the homogeneous data elements?
A.Arrays B.Records C.Pointers D.None
Answer: B
22. If you need to duplicate the entire disk, which command will you use?
A.Copy B.Diskcopy C.Chkdsk D.Format
Answer: B
Explanation:
Diskcopy is used to perform track-by-track copy of a disk into another. Copy command copies selected files; chkdsk and format commands are not for copying purpose
23. The SQL command to create a table is:
A.MAKE TABLE. B.ALTER TABLE C.DEFINE TABLE. D.CREATE TABLE.
Answer: D
24. Which SQL trigger does SQL Server NOT support?
A.BEFORE B.INSTEAD OF C.AFTER D.SQL Server supports all three
Answer: A
25. Pre-processors does not do which one of the following
A.macro B.conditional compliclation C.in type checking D.including load file
Answer: C
26. How many buses are connected as part of the 8085 microprocessor?
A.2 B.3 C.5 D.8
Answer: B
27. In a CLIENT/SERVER environment , which of the following would not be done at the client ?
A.User interface part B.Data validation at entry line C.Responding to user events D.None of the above
Answer: D
28. Which command will delete all data from a table and will not write to the rollback segment?
A.DROP B.DELETE C.CASCADE D D.TRUNCATE
Answer: B
29. The system variable that records the select statement that SQL * FORMS most recently used to populate a block is
A.SYSTEM.LAST_RECORD B.SYSTEM.CURSOR_RECORD C.SYSTEM.CURSOR_FIELD D.SYSTEM.LAST_QUERY
Answer: D
30. Which of the following is part of an administrative policy to secure a database?
A.Authentication policies B.Limiting particular areas within a building to only authorized people C.Ensure appropriate responses rates are in external maintenance agreements D.All of the above.
Answer: D
More Placement Papers Click Here
Get Latest Freshers Jobs Alerts For Free
Register Here
For Jobs Updates via Facebook
0 comments:
Post a Comment