SAP Oracle database placement test question papers - Set 1

SAP Oracle database placement test question papers - Set 1

1)In which log file you can see database events such as starting, stopping of database,error messages, Oracle block error etc.

A) alertSID.log
B) trace.log
C) alert.log
D) error.log
View Answer / Hide Answer


2)In which directory are Oracle trace files available?

A) /usr/sap/
B) /oracle/<SID>/saptrace/usertrace/
C) /oracle/<SID>/background/
D) /oracle/stage/
View Answer / Hide Answer


3) If the oracle user ID password has expired which parameter will you check ?

A) PASSWORD_LIFE_TIME
B) PASSWORD LIFE_TIME
C) PASSWORD_DURATION_TIME
D) PASSWORD_DURATION_LIGETIME
View Answer / Hide Answer


4)If the oracle user is locked, which command would you use to unlock ?

A) ALTER USER <username> ACCOUNT UNLOCK;
B) UPDATE USER <username> ACCOUNT UNLOCK;
C) ALTER USER <username> ACCOUNT RESET;
D) None of the above
View Answer / Hide Answer


5) Update statistics , dbverify jobs can be executed from which transaction code ?

A) DB12
B) DB13
C) DB20
D) DB14
View Answer / Hide Answer


6) If the oracle archive log filesystem is 100 % full, what will happen to SAP?

A) SAP will be down
B) Oracle database will be down
C) SAP and Oracle up and running,users will not able to login
D) none of the above
View Answer / Hide Answer


7) In which “View” you can see if SAP backup is running or not?

A) v$backup
B) v$backuplog
C) v$backupview
D) v$viewbackup
View Answer / Hide Answer


8) Oracle space management logs, backuplogs, redolog backups can be seen from which transaction code ?

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


9) What is purpose of process PMON?

A) Responsible for monitoring other server processes and restarting them if necessary
B) Temporary space cleanup
C) Recovers transactions that are left in a prepared state because of a crash or loss of connection during a two-phase commit
D) commits whenever a user commits a transaction
View Answer / Hide Answer


10) In which package update statistics will run parallely for individual tables?

A) DBMS_STATS
B) RDBMS-STATS
C) DBMS_PACKS
D) Non of the above
View Answer / Hide Answer