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 |
What are the advantages of database software?
How to improve query performance using index hunting?
Define stored procedures.
Explain what are the types of transparencies?
WHAT IS INDEXING?
Define scalar functions.
What are the properties of a database?
What are the types of database management system?
How to deactivate triggers?
What are the different Sequence of events takes place while starting a Database ?
1 Answers KPSC Karnataka Public Service Corporation,
Explain concurrency transparency.
Define identity and uniqueidentifier property of column?
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)