Where would you look for errors from the database engine?
Can we take incremental backups in datapump?
how can you get actual data change values from previous transactions in oracle?
which background process will run @ the time of creation of catalog database
You have just compiled a PL/SQL package but got errors, how would you view the errors?
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?
How do you add a data file to a tablespace?
What are the different types of indexes available in sql server? : sql server DBA
How will u copy the objects of one schema to another schema in datapump & export/import?
What are the operating modes in which database mirroring runs? : sql server DBA
What command would you use to create a backup control file?
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?
WHEN DOWN TIME WHAT CAN U DO?