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 |
Why is the use of dbms recommended?
What is Two-Phase Commit ?
Define database lock and its types.
what do u mean by implementation?
What do you understand by cursor? Mention the different types of cursor?
What is db context?
What is third normal form?
How many types of database languages are?
I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
What is the use of INDEXES option in IMP command ?
Where the data file for system Tablespace is located? What is its name, initial size and maxsize?
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)