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?
4. Can you take Online Backups if the the database is
running in NOARCHIVELOG mode?
Answer Posted / srihari macha
1. Backup are Cold and Hot.
2. Cold Backup
3. No.
4. No.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What the different topologies in which replication can be configured? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What are the different ways you can create databases in sql server? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
how can you process messages in order asynchronously?
What is a system database and what is a user database? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is the use of ocr?
what are the differences of where and if in SAS?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
how can you communicate with operating system files from oracle?
how can you enable flashback feature?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA