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 |
What is an artificial (derived) primary key? When should it be used?
What is pdo database?
what is the difference between unique and primary key
what is the difference between DBMS and RDBMS??
76 Answers Aon Hewitt, BlackRock, Infosys, ISB, Jawood, TCS,
What do you mean by Checkbox ?
What is the advantage of the database management approach
What is the 3-tier architecture?
What is indexing in database with example?
Explain primary key and composite key.
Explain 4nf?
What is Distributed database ?
How to use events with zebedee, ssh or stunnel?
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)