Oracle Placement Papers 2016-2017 - Interview Questions

Advertisements

Oracle Placement Papers
Placement papers of Oracle 2016-2017. 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: Sasken 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



Oracle Placement Papers Syllabus:


Quantitative Aptitude Syllabus:

  • Probability
  • Permutations & Combinations
  • Algebra
  • Averages
  • Time Speed & Distance
  • Time & Work
  • Profit & Loss
  • Ratio & Proportion
  • Simple & Compound Interest
  • Percentage
  • Number Series
  • Mixtures & Alligations
  • Simplification
  • Number System
  • Heights and Distances
  • Geometry & Mensuration
  • Data Sufficiency
  • Logarithms
  • Progressions
  • LCM and HCL
  • Pipes and Cisterns
  • Partnership
  • Boats and Streams
  • Areas, Volumes

Reasoning Syllabus:

  • Number Series
  • Letter Series
  • Anologies
  • Puzzles
  • Syllogisms
  • Binary Logic
  • Clocks & Calendars
  • Cubes & Dice
  • Classification 
  • Blood Relations
  • Coding-Decoding
  • Data Sufficiency
  • Seating Arrangement
  • Venn Diagrams
  • Problem Solving
  • Coded Inequalities
  • Double Lineup
  • Logical Deductions
  • Routes & Networks
  • Grouping & Selections
  • Evaluating Course of Action
  • Statements and Conclusions
  • Mathematical and Computer Operations
  • Critical Reasoning
  • Inferences
  • Situation Reaction Test
  • Decision Making
  • Symbols and Notations
  • Direction Sense Test
  • Logical Sequence Of Words
  • Assertion and Reason
  • Verification of Truth of the Statement
  • Statements and Assumptions
  • Data Interpretation

Verbal Ability Syllabus:

  • Synonyms
  • Antonyms
  • Sentence Completion
  • Spelling Test
  • Passage Completion
  • Sentence Arrangement
  • Idioms and Phrases
  • Para Completion
  • Error Correction (Underlined Part)
  • Fill in the blanks
  • Synonyms
  • Prepositions
  • Active and Passive Voice
  • Spotting Errors
  • Substitution
  • Transformation
  • Sentence Improvement
  • Joining Sentences
  • Error Correction (Phrase in Bold)
  • Articles
  • Gerunds
  • Identify the Errors
  • Plural Forms
  • Odd Words
  • Prepositions
  • Suffix
  • Tense
  • Adjectives
  • Homophones
  • Identify the Sentences
  • Nouns
  • Prefix
  • Sentence Pattern
Dear readers, the syllabus and Oracle placement papers provided here are just for information purpose only. Sometimes companies may change their syllabus and exam pattern. So Please check official company website for latest syllabus.



Share This Job Opening...!!





About www.allindiajobs.in

All India Jobs is one of the top fresher job sites in India with over 1000 companies listing jobs online. If you are looking for best careers in India then you are at right place. You can find IT software jobs, bank jobs, bpo jobs, mba jobs, govt jobs, walkin for fresher, engineering jobs, railway jobs, medical or pharma jobs, internship jobs etc. Also we provide latest placement papers for freshers to practice for mnc company written online exams. www.allindiajobs.in is one of the the best recruitment websites in india.