Topic : Control Files and Redolog Files

How many maximum no of control files we can have within a database


  • 3
  • 5
  • 1
  • 8

Answer :

8

Show Answer Discuss

The alert log will never contain information about which database activity?


  • Place tablespace in end backup mode
  • Altering the database to take a data file offline
  • Performing operating system restore of the database files
  • Changing the database mode from NOARCHIVELOG to ARCHIVELOG

Answer :

Performing operating system restore of the database files

Show Answer Discuss

Are uncommitted transactions written to flashback redologs?


  • Yes
  • No

Answer :

Yes

Show Answer Discuss

Is it possible to do flashback after truncate?


  • No
  • Yes

Answer :

No

Show Answer Discuss

What is the correct procedure for multiplexing online redo logs?


  • Issue the ALTER DATABASE. . . ADD LOGFILE GROUP command.
  • Issue the ALTER DATABASE. . . ADD LOGFILE MEMBER command.
  • Shut down the database; copy the online redo-log; and start up the database.
  • Shut down the database; copy the online redo-log; edit the REDO_LOG_FILES parameter; and start up the database

Answer :

Issue the ALTER DATABASE. . . ADD LOGFILE MEMBER command.

Show Answer Discuss