What is a correlated sub-query? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
who owns the operating system files created by the utl_file package?
When a user process fails, what background process cleans up after it?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
Datapump backup steps?