Monday, January 28, 2013

Oracle Interview Best and Easy Question


Oracle, Question Paper, Interview, Interview Tips,

Oracle Interview Best and Easy Question  
1. What is the size of Varchar in Oracle 8.0 ?
      a. 2000
      b. 4000
      c. 254
      d. none of the above
      2. What is the size of Varchar in Oracle 7.0 ?
      a. 2000
      b. 4000
      c. 254
      d. none of the above
      3. The default value the lpad function takes is 
      a. a space (¡§ ¡§)
      b. an asterisk
      c. The default value is not optional
      d. None of the above
      4. The no. of columns that may be used as composite primary key in oracle 

      a. 8
      b. 16
      c. 32
      d. none of the above
      5. which of the following is true about add_months
      a. we can pass a numerical value in first parameter
      b. we can pass a negative value in second parameter
      c. Both a & b
      d. None of the above
      6. The latest date that can be stored in oracle 8
      a. 31st Dec 4012 A.D
      b. 31st Dec 4011 A.D
      c. Dec 31st ,9999
      d. None of the above.
      7. What happens when the first date is greater than the second date that 
      is passed to the months_between function in oracle 8.
      a. It gives an error
      b. It gives a negative value
      c. None of the above
      8. Regarding the Summary query which of the following is true
      a. The order of the base column list in the select statement should be
      same in the Group by clause.
      b. The order of the base column list in the select statement need not be
      same in the Group by clause.
      c. None of the above
      9. Regarding the Summary query which of the following is true
      a. All the base table columns selected in the select list should be
      specified in the Group by clause.
      b. All the base table columns selected in the select list need not be
      specified in the Group by clause.
      c. None of the above.
      10. How do u mask the user from entering irrelevant data ?
      a. Synonym
      b. View
      c. Index
      d. sequence
      11. What does the length function returns when applied to column of char 
      datatype ?
      12. Which of the following is true about the packages ?
      a. Package specification should contain return type of a function
      b. Package specification need not contain return type of a function
      c. Both a & b
      d. None of the above
      13. If the first parameter is negative, then second parameter
      a. need not be negative
      b. there is no such restrictions
      c. should be positive
      d. None of the above.
      14. Which of the following is true about procedures
      a. The size of the parameter should be mentioned in a procedure.
      b. The size of the parameter should not be mentioned in a procedure
      c. Both a & b
      d. None of the above.
      15. ¡§REFERENCING¡¨ in oracle 8 
      a. used to mention referential integrity
      b. used for creating views
      c. there is no such word in oracle 8
      d. none of the above
      16. If you want to restrict the user, to enter the same values that has 
      been stored in other table then what constraint do u use?
      a. Entity integrity
      b. Referential Integrity
      c. Both a & b
      d. None of the above
      17. Which of the following is true about NULL?
      a. when an arithmetic operation is performed on NULL, u will get the
      result as NULL
      b. NULL is same as 0.
      c. NULL is same as blank date.
      d. None of the above
      18. For a DDL statement, which of the following is true
      a. A DDL statement is preceded and followed by commit.
      b. All the DML statements gets committed even when u get an error after
      writing DDL statement.
      c. Both a & b
      d. None of the above.
      19. Which of the following is true for update clause?
      a. We can update two base tables simultaneously
      b. U can use a subquery in SET clause of the UPDATE statement.
      c. Both a & b
      d. None of the above
      20. Which of the following is true for delete?
      a. Delete statement can be given without writing where clause.
      b. We can delete two tables simultaneously
      c. Both a & b
      d. None of the above
      21. How do u rename a table ?
      a. Using alter command
      b. Using RENAME
      c. Dropping the table and creating once again
      d. None of the above.
      22. In oracle 7 which of the following is true about manipulating the view 

      a. View based on two base tables can be manipulated
      b. View having a column which contain operation can be manipulated
      c. Both a & b
      d. None of the above
      23. In oracle 8 which of the following is true about manipulating the view
      a. View based on two base tables can be manipulated
      b. View having a column which contain operation can be manipulated
      c. Both a & b
      d. None of the above
      24. Which of the following is true about packages
      a. We can write a procedure in package body which has not been specified
      in package specification.
      b. We cannot write a procedure in package body which has not been
      specified in package specification.
      c. Both a & b
      d. None of the above.
      25. Which of the following is true about outer joins
      a. The outer join symbol should be present on any one side of the join.
      b. The outer join symbol may be present on both the sides of the join
      c. The outer join return the rows from the two tables that donot have
      matching records in other table.
      d. None of the above
      26. Which of the following is true about procedure and a function
      a. Procedure should return a value and a function may not return a value
      b. A function has to return a value and a procedure don¡¦t have to
      c. Both a & b
      d. None of the above.
      27. What does OFA stands for ?
      a. Oracle Flexible Architecture
      b. Oracle Financials Applications
      c. Optimal Flexible Architecture
      d. None of the above

  

0 comments:

Post a Comment