If you're unsure in which script a sys or system-owned
object is created, but you know it's in a script from a
specific directory, what UNIX command from that directory
structure can you run to find your answer?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
How many packages we have in db
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Explain CREATE DATABASE syntax?
How many memory layers are in the shared pool?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
How to make a replica of existing oracle server to another server?
What are statistics, under what circumstances they go out of date, how do you update them?
how does an oracle clusterware manage crs resources?
what is asm?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?