I-Flex Placement Paper on 12th march 2005
30 questions are given here. 30 minutes time. No negative marks. Some questions have multiple choices / answers. There are questions on Oracle7.
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
See more Oracle 7 and other computer subjects / languages placement paper / employment test questions for multinational companies / MNC exams – test papers and technical hr interview questions.