Oracle Placement Paper V

Oracle Placement Paper Technical 2009 @ Nagpur

1. Identify the relationship between the many employees
working
in a dept..
a. one to one
b. one to many
c. many to one
d. many to many
 

2. The process of including some controlled redundancy for the sake of performance
is known as
a. normalization
b. Cartesian product
c. Denormalization
d. None
 

3. In a doubley linked list
a. the last node contains the address of the first node
b. each node contains the address of previous and next node
c. each node contains the address of previous node
d. none
 

4. In a queue each node contains
a. the address of previous node
b. address of next node
c. address of both the previous and next node
d. none of the above
 

5. can a database table exist without a primary key ?
6. whether higher normal forms better than lower forms as far redundancy is concerned ?
 

7. what is a foreign key?
8. The purpose of defining an index is
(A) Enhance Sorting Performance
(B) Enhance Searching Performance
(C) Achieve Normalization
(D) All of the above
 

9. A transaction does not necessarily need to be
(A) Consistent
(B) Repeatable
(C) Atomic
(D) Isolated
 

10. To group users based on common access permission one should use
(A) User Groups
(B) Roles
(C) Grants
(D) None of the above
 

11. PL/SQL uses which of the following
(A) No Binding
(B) Early Binding
(C) Late Binding
(D) Deferred Binding
 

12. Which of the constraint can be defined at the table level as well as at the column level
(A) Unique
(B) Not Null
(C) Check
(D) All the above
 

13. To change the default date format in a SQLPLUS Session you have to
(A) Set the new format in the DATE_FORMAT key in the windows Registry.
(B) Alter session to set NLS_DATE-FORMAT.
(C) Change the Config.ora File for the date base.
(D) Change the User Profile USER-DATE-FORMAT.
 

14. Which of the following is not necessarily an advantages of using a package rather than independent stored procedure in data base.
(A) Better performance.
(B) Optimized memory usage.
(C) Simplified Security implementation.
(D) Encapsulation.
 

15. Integrity constrains are not checked at the time of
(A) DCL Statements.
(B) DML Statements.
(C) DDL Statements.
(D) It is checked all the above cases.