SAP Oracle database placement test question papers - Set 3

SAP Oracle database placement test question papers - Set 3

1) You must check the prerequisites for the Oracle Universal Installer (OUI> by executing which command?

A) ./runInstaller –executeSysPrereqs
B) ./ runInstaller –execute
C) runInstaller –executeSysPrereqs
D)./RUNINSTALLER –executesysPrereqs
View Answer / Hide Answer


2) DBUA stand for ?

A) database upgrade assistant
B) database universal assistant
C) database universal upgrade assistant
D) None of the above
View Answer / Hide Answer


3)what is the purpose of utlrp.sql?

A) Checks invalid objects in the schema
B) Checks failed jobs in the system
C) Checks valid objects in the system
D) A and B are correct
View Answer / Hide Answer


4)Can we change NOARCHIVELOG mode to ARCHIVELOG mode without shutdown of oracle database?

A)Yes
B)No
View Answer / Hide Answer


5)Which script is used to upgrade all data dictionary objects and all components in the database?

A) catupgrd.sql
B) utl102i.sql
C) upgrade.sql
D) None of the above
View Answer / Hide Answer


6)Select the correct statement.

A) Both OS and Database should be same in source and target system for homogeneous system copy
B) Both OS and Database should not be the same in source and target system for the homogeneous systemcopy
C) OS remains same in both source and target system only DB changes.
D) None of the above
View Answer / Hide Answer


7) Select the correct pre-requisite for performing homogeneous systemcopy?

A) source system and target system should be in same network
B) control.sql is generated in the target system for recovery
C) SAP support pack version and oracle version should be same in source and target system
D) All of the above
View Answer / Hide Answer


8) Select the wrong statement related to system copy ?

A) OriglogA,OriglogB,MirrlogA ,MirrlogB required for restoring
B) sapdata1 to sapdataN..data files required for system copy
C) control.sql file from source system required for systemcopy
D) target system OriglogA ,OriglogB,MirrlogA,MirrloB should be deleted
View Answer / Hide Answer


9)For point-in-time systemcopy oracle files are required for recovery ?

A)True
B)False
View Answer / Hide Answer


10) What is the recommended permission that can be set to file name sapcon role?

A) 755
B) 7778
C) 7775
D) 5555
View Answer / Hide Answer