Monday 6 August 2012

CTS

1)TELL ME SOMETHING YOUR SELF?

2)WHAT ARE THE ACTIVITES ARE YOU DOING DAILY IN YOUR   PROJECT?

3)TELL ME RATIO'S OF SQL,PL/SQL&UNIX?

4)DIFF B/W PRIMARY KEY & UNIQUE KEY ?

5)DIFF B/W PRIMARY KEY & UNIQUE KEY + NOT NULL?

6)WHAT IS THE USE OF VIEWS?

7)IF TABLE DROPPED, THEN WHAT HAPPEN VIEW?

8)WHAT IS INDEX?TYPES OF INDEXES?

9)WHICH FUNCTIONS ARE NOT SUPPORTED TO INDEX?

10)WHAT IS SAVEPOINT?

11)WHAT IS ORA-1555?

12)WHAT ARE THE DATATYPES AVILABLE IN PL/SQL, NOT IN SQL?

13)WHAT IS THE MAIN USE OF %TYPE,%ROWTYPE?

14)WHAT IS CURSOR? TYPES OF CURSORS?

15)DIFF B/W EXPLICT CURSOR & FOR LOOP CURSOR?

16)WHAT IS EXCEPTION? TYPES OF EXCEPTIONS?

17)WHAT IS RAISE_APPLICATION_ERROR?

18)WHAT IS PRAGMA_EXCEPTION_INIT?

19)DIFF B/W TRIGGERS&PROCEDURES?

20)CAN YOU CALL PROCEDURE IN SELECT STATEMENT?

21)RESTRICTIONS IN FUNCTIONS?

22)WHAT IS THE USE OF PACKAGES?

23)HOW TO DROP PACKAGE BODY ONLY?

24)CAN USE PRAGMA_AUTONAMOUS_TRANCTIONS IN PACKAGES?

25)WHAT IS BULK COLLECT?

26)WHAT IS NULLIF()?

27)WHAT IS MUTATING ERROR?