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 ?
688
what is oracle data integrator (odi)?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Is Odi used in oracle products?
What is the primary use of normalization?
What is self contained multi valued query?
What is a system database and what is a user database?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is sql entity?
how to start mysql server? : Sql dba
What is global database name?
What does the key mean in access?
What is orm mongodb?
What is sql azure database?
What is record variable?
Explain index covering? List its merits.