SAP Oracle database placement test question papers - Set 8

SAP Oracle database placement test question papers - Set 8

1) Can we make make datafile offline when oracle is up and running?

A) Yes
B) No
View Answer / Hide Answer


2) What is time based recovery?

A) Recovers the data up to a specified point in time
B) Recovers until you issue the CANCEL statement
C) Recovers until the specified log sequence number
D) None of the above
View Answer / Hide Answer


3) Which backup tool is used for connecting to oracle for taking backups?

A) Backint
B) TSM
C) ADSM
D) Networker
View Answer / Hide Answer


4) What is archive log destination parameter?

A) LOG_ARCHIVE_DEST_1
B) LOG_ARCHIVE_LOCATION
C) LOG_DEST_ARCHIVE
D) Both A and B will work
View Answer / Hide Answer


5) What is full database backup?

A) A full database backup contains all used data pages and the log files written during the backup
B) The size of a full database backup is much smaller than the size of a full differential backup
C) A full Windows backup backs up the entire system including the database, SQL Server and Windows files
D) None of the above
View Answer / Hide Answer


6) What is Transaction log backup?

A) The transaction log of the SAP database records all changes made to the database. It may never be deleted and must be backed up separately
B) Transaction log backups save the log files
C) Transaction log backups have almost no impact on performance and can therefore be performed when the workload is high
D) All of the above
View Answer / Hide Answer


7)Which contents does brbackup back up?

A)Datafiles
B)Control files
C)Online redo log files
D)All of the above
View Answer / Hide Answer


8) Offline redo log files are backed up by the tool brarchive.

A) True
B) False
View Answer / Hide Answer


9) What does brrecover tool perform?

A) database backup (parallel, restartable, database status is monitored
B) archiving of offline redo log files
C) Complete database recovery, point-in-time recovery, and disaster recovery
D) Restore of database and offline redo log files (parallel, restartable)
View Answer / Hide Answer


10) From which transaction code you can perform “whole database offline + redo log backup”

A) DB10
B) DB12
C) DB13
D) DB02
View Answer / Hide Answer