You have 4 instances running on the same UNIX box. How can
you determine which shared memory and semaphores are
associated with which instance?
I lost one datafile i dont have backup how can you recover that???
how can you initialize log miner?
How to make a replica of existing oracle server to another server?
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What is a correlated sub-query? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility
Give the two types of tables involved in producing a star schema and the type of data theyhold.
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
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?
What is blocking and how would you troubleshoot it?