What is the use of NOARCHIEVELOG parameter in Database?
Answer / guest
NOARCHIEVELOG parameter is used to enable the database in
Achive mode as True or false.
If you need to check database is in which mode use this
command:
1.select log_mode from v$database.
IF database needs to be set in Archivelog Mode
2. Shutdown immediate
3. Startup mount
4. alter database archivelog
5. alter database open
| Is This Answer Correct ? | 4 Yes | 0 No |
Which is the most used database?
Can the SNAPSHOTS be refreshed automatically ?
How do queries work in a database?
What is 1nf 2nf 3nf in dbms?
What is ddl in dbms?
What are the different kind of export backups ?
What are different type of normalization?
Enlist various transaction phases.
What are the different Sequence of events takes place while starting a Database ?
1 Answers KPSC Karnataka Public Service Corporation,
What are the different types of database?
Is there an example how to configure externalfileaccess setting in firebird.conf?
What is ordbms with example?
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)