I-flex  Placement Paper   General - Other   -12 Mar 2005

I-flex  Placement Paper   General - Other   -12 Mar 2005


  • Posted by  FreshersWorld 
    7 Jan, 2012

     I-Flex  Placement Paper on 12th march 2005

    there are 30 questions. 30 min time. No negative marks. Some questions have multiple answers. Among those one question is incomplete. There are questions on Oracle7 also. So go through Oracle7 once before attending the test.

    Q1. What is the size of varchar in Oracle7 ?

    Q2. What is the size of varchar in Oracle8 ?
    A. 4000

    Q3. What is the full form of OFA ?
    A. Optimal Flexible Architecture

    Q4. How can you create a view in oracle7 ?

    Q5. Which of the following is true/false about ADD_MONTHS ?

    Q6. Which of the following is true/false about GROUP BY ?

    Q7. The output of select LENGTH(column) if the column is of CHAR ?
    A. It gives the max. size of the column only

    Q8. The max. no. of columns in a composite key in Oracle8 ?
    A. 16

    Q9. How the procedure can return a value ?
    A. Through OUT parameter

    Q10. How many LONG columns/primary keys columns can be within a single table ?
    A. Only ONE

    Q11. Which of the following is true ? - regarding COMMIT ?
    A. If the DDL statement is succeeded then only the DML work will be committed.

    Q12. Question about Table Partition

    Q13. Question about overloading of functions

    Q14. Question about CURSOR attributes

    Q15. The latest date is
    A. Jan1,4712 BC B. Jan1, 4712 AD C. Dec31, 4712 AD D. None

    Q16. Question on PRE-DEFINED Exception
    A. NO_DATA_FOUND

    & many more....
     

2009-2016 downloadmela.com. All rights reserved.