SAP Oracle database placement test question papers - Set 7

SAP Oracle database placement test question papers - Set 7

1) Which profile does Brtools read to perform the actions?

A) init<DBSID>.sap
B) default.pfl
C) Instance profile
D) startup profile
View Answer / Hide Answer


2) What is the return code for the description “Canceled by a user or other signal during processing”?

A)return code 0
B)retuen code 2
C)return code 3
D)return code 4
View Answer / Hide Answer


3) Index rebuild can be done from which program?

A) brconnect
B) brrecover
C) brspace
D)brarchive
View Answer / Hide Answer


4)brbackup and brarchive reads which parameter for saving the backup database files ?

A)backup_root_dir
B)backup_root_location
C)backup_location
D)None of the above
View Answer / Hide Answer


5) Select the correct parameter which has the option for “second_copy”

A) archive_function
B) deleted_copied
C) Both A and B
D None of the above
View Answer / Hide Answer


6 ) In the command “brconnect -u / -c -f stats -t MARA”, what does u stand for?

A) using user root
B) force without using password
C) using <sid>adm
D) None of the above
View Answer / Hide Answer


7) What is consistent backup?

A) Files being backed up contain all changes upto same SCN
B) Backup taken when database is shutdown
C) For consistent backup the database can be shutdown with NORAML, IMMEDIATE or TRANSACTIONAL options
D) All of the above
View Answer / Hide Answer


8) If you run a backup with the NOARCHIVELOG mode, will the database be consistent?

A) Yes
B) No
View Answer / Hide Answer


9) Database should be in which state for executing command “ALTER SYSTEM ARCHIVE LOG ALL;”.

A) Mount
B) Open
C) Closed
D) Any of the above state
View Answer / Hide Answer


10) Point-in-time recovery is possible when database is in “ARCHIVELOG” mode.

A) True
B) False
View Answer / Hide Answer