chap 2 , queries

Question 1

Show file path of control files

Answer 1

select from v$controlfile

Question 2

Show information section about controlfiles

Answer 2

select * from v$controlfile_record_section

Question 3

Display the name of the database , archive mode , opening mode and creation date

Answer 3

select name , log_mode , created , open_mode from v$database