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?
Answers were Sorted based on User's Feedback
Answer / girish k
1. HOT and COLD Backups
2. COLD Backup
3. NO
4. NO
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain what partitioning is and what its benefit is.
What happens on checkpoint? : sql server DBA
why do we give pctfree and pctused in create table statement?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What is the recommended interval at which to run statspack snapshots, and why?
Name three advisory statistics you can collect.
Where in the Oracle directory tree structure are audit traces placed?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How will u copy the objects of one schema to another schema in datapump & export/import?
Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???
what is the last version,the release date of that version and fix pack of ibm db2 udb?
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.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)