What is Library Cache in Oracle?
What is where clause in oracle?
is there a tool to trace queries, like profiler for sql server?
What is the diff between Oracle and SQL Server
How a database is related to tablespaces?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
Explain a synonym?
Is primary key indexed by default in oracle?
What are the uses of synonyms?
Is primary key = unique key,not null? If yes,please explain IF No,please explain
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
Give the constructs of a package, function or a procedure.
State all possible different index configurations a table can possibly have?