What is an artificial (derived) primary key?
No Answer is Posted For this Question
Be the First to Post Answer
Which is the best option used to move database from one server to another serve on same network and why?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
What is the dba role in oracle?
What do you understand by the oracle?
How does one create a new database?
How can you tell if a tablespace has excessive fragmentation?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
What is the difference between truncate and delete? Why is one faster?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
Do you need a commit after ddl statements?
What file will give you oracle instance status information? Where is it located?
What is main function of database administrator?