Why do you partition data?
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
Explain about various levels of constraint.
Can you have multiple SPs with the same name on a database?
What is the use of time stamp in select statement?
what is the forward decleration in packages?
What steps server process has to take to execute an update statement?
Can you have more than one key in a database?
Explain normalization and what are the advantages of it?
How will you delete a particular row from a Table?
What are analytical functions in sql?
what is a composite primary key ? : Sql dba
How do I run a query in pl sql developer?