i have some prob
lem to tell me about my self in interview first round ...
No Answer is Posted For this Question
Be the First to Post Answer
What is a unique key?
What is sql and how does it work?
What are different types of triggers?
Why do we use cursors?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
Is primary key clustered or nonclustered?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Differentiate between % rowtype and type record.
Which are sql * plus commands?
how to use regular expression in pattern match conditions? : Sql dba
define sql
What is mutating error?