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 ?
514
Why we use trigger in sql server with example?
What is dba in sql? : SQL DBA
What is left inner join in sql?
How would you create a report using the report tool and report wizard?
How to connect html form to mysql database using php?
How does distributed database work?
What do you mean by a replica set in mongodb?
How can you determine if an index needs to be dropped and rebuilt?
Is redis in memory database?
What is open database communication (odbc)?
What is dynamic schema in mongodb?
How to assign data of the deleted row to variables?
explain the advantages and disadvantages of stored procedure? : Sql dba
What are the types of keys?
Which constraints we can use while creating database in sql?