You execute this command in MOUNT mode: ALTER DATABASE ARCHIVELOG; Where is the information that the database is now in ARCHIVELOG mode stored?()
A.SPFILE B.archive log C.control file D.system tablespace
You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands: STARTUP MOUNT; BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2; Which components are included in the backup?()
A.Only the data files. B.Only the data files and the online logs. C.The data files, control files, and the online logs. D.The data files and control files, but not the online logs.
You want to create a copy of the DEPARTMENTS table. When that is complete, you want to truncate the new DEPARTMENTS table, then restore the data with a direct-load insert from the old DEPARTMENTS table. Which CREATE statement should you use?()
A.A B.B C.C D.D