What is hot backup and how it can be taken ?
Answer / chaudhry
Taking backup of archive log files when database is
open. For this the ARCHIVELOG mode should be enabled. The
following files need to be backed up.
All data files. All Archive log, redo log files. All
control files.
| Is This Answer Correct ? | 1 Yes | 1 No |
Define primary and unique key?
Where does the LGWR process writes information?
What is db dialect?
describe middleware applications that ease the connection of databases to web?
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
State three differences between Dbms and Rdbms?
How many types of data are there?
How do queries work in a database?
Why rdbms is not suitable for big data?
What is an artificial (derived) primary key? When should it be used?
Who invented schema theory?
How to retrive a student with height marks,second height and third height from MS access database what wil be the query for this purpuse?
Oracle (3253)
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)