Answer Posted / parameswara reddy.challa
logical optimization
physical optimization
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Differentiate pl/sql and sql?
Why do we use view in sql?
What are all the ddl commands?
How do you drop a trigger?
What is the most common sql injection tool?
describe transaction-safe table types in mysql : sql dba
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is the mutating table and constraining table?
Is natural join and inner join same?
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 ?
How do I create an index in word?
Does postgresql run on the cloud?
Explain 3 basic parts of a trigger.
What is data definition language?
How to change the order of columns in Oracle SQL Plus ?
