SAP Oracle database placement test question papers - Set 5
1) The source and target systems must run on different hosts for security reasons.A) True
B) False
View Answer / Hide Answer2) How do you find the character set of the source system?A) SELECT * FROM V$NLS_PARAMETERS;
B) SELECT * FROM C$NLS_PARAMETERS;
C) SELECT * FROM S$NLS_PARAMETERS;
D) SELECT * FROM K$NLS_PARAMETERS;
View Answer / Hide AnswerANSWER: A) SELECT * FROM V$NLS_PARAMETERS;
3) Which file is not required while copying from source system to target system ?A) ORIGLOGA
B) SAPDATA files
C) control file from source system
D) None of the above
View Answer / Hide Answer4) While performing system copy if you change <DBSID > which parameter you need to adapt ?A) global_name
B) Oracle_name
C) SAP_NAMES
D) None of the above
View Answer / Hide Answer5) What will happen when you execute command “ALTER DATABASE OPEN RESET LOGS”?A) It will update all data files,redo log files with new SCN number
B) Database will be in mount state
C) Database will be in Nomount State
D) None of the above
View Answer / Hide AnswerANSWER: A) It will update all data files,redo log files with new SCN number
6) Can we take oracle backup with Brtools?A) Yes
B) No
View Answer / Hide Answer7) Oracle backup can be taken from which user ID using Brtools?A) ora<sid>
B) <sid>adm
C) root
D) None of the above
View Answer / Hide Answer8) When you execute offline backup from Brtools, what will happen?A) Oracle will be down automatically, once backup is completed oracle will be up automatically
B) backup will be cancelled as we executed command when system is up and running
C) backup will be completed, we need to start oracle manually
D) None of the above
View Answer / Hide AnswerANSWER: A) Oracle will be down automatically, once backup is completed oracle will be up automatically
9) Where will the online and offline database backup log file will be saved?A) /oracle/<sid>adm/saparch
B) /oracle/<sid>adm/sapbackup
C) /oracle/<sid>adm/saptrace
D) None of the above
View Answer / Hide AnswerANSWER: B) /oracle/<sid>adm/sapbackup
10) At which location are Brtools executables located?A) /usr/sap/<SID>/exe/run
B) /sapmnt/<SID>/exe
C) /sapmnt/<SID>/SYS/exe/run
D) Both A and B
View Answer / Hide Answer