What is the use of NOARCHIEVELOG parameter in Database?
Answer Posted / 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 |
Post New Answer View All Answers
Define RDBMS.
What is 1nf?
Segregate database technology's development.
What is the main purpose of database?
Explain the role of metadata for the three-layer architecture.
How is foreign key commands related to primary key?
How to select a random record from a table?
What is maintaining database?
Where is the data stored in a database?
What is considered a database?
Explain data dictionary.
How view is related to data independence?
what are the two integrity rules used in DBMS?
What are the 5 major parts of a database system?
What is 1nf 2nf 3nf in dbms?