Does truncate need commit?
What is an Integrity Constraint?
what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?
can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?
Can unique keys be null?
What are different sql data types?
1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.
What pl/sql package consists of?
What port does sql server use?
What is the difference between database trigger and stored procedure?
Is trigger a stored procedure?
PL/SQL allocates memory for the variable's at runtime or at compile time
what is a field in a database ? : Sql dba