Please note most of these questions are gathered by me from students who have already taken certification exam and from google.
Hope you will find these useful !! All the best!
Please find below important Oracle database related questions from SAP certification point of view
1. Which of the following are Oracle start-up phases:
a. Nomount
b. Mount
c. Open
d. Abort
e. Immediate
2. Which of the following are Oracle shut-down phases:
a. Shutdown open
b. Shutdown abort
c. Shutdown immediate
d. Shutdown normal
e. Shutdown mount
3. Oracle database data is stored in
a. 80 k blocks
b. 16 k blocks
c. 8 k blocks
d. 10 k blocks
e. 2 k blocks
4. The Oracle database parameter file is:
a. Init<SID>.sap
b. Init<SID>.dba
c. Init<SID>.ora
d. ORA<SID>.ora
e. SYS<SID>.ora
5. There is an ORACLE shadow process for:
a. Each R/3 dispatcher only
b. Each R/3 enqueue process only
c. Each R/3 workprocess
d. Each R/3 message server only
e. None of the above. Oracle does not use shadow processes.
6. Each R/3 workprocess:
a. Connects to the database as one database user, SAPR3
b. Handles database requests for the different R/3 system users
c. Can reconnect to the database
d. Connects to the database as one database user, R3USER
7. SAPDBA :
a. Is an R/3 database maintenance tool
b. Is an Oracle process
d. Is an R/3 tablespace
e. Requires that R/3 be up and active in order to function.
8. Which of the following are true?
a. An R/3 system <SID> has one database
b. An R/3 system must have more than one R/3 instance.
c. R/3 workprocesses may connect to the database over the network using the OPS$ mechanism
d. OPS$<SID>adm is a valid UNIX user.
e. User <SID>adm permits full privileges.
9. SAPDBA -check, creates a log in the following directory:
a. \oracle\<SID>\saparch
b. \oracle\<SID>\sapcheck
c. \oracle\<SID>\bin
d. \oracle\<SID>\sapbackup
10. Which of the following are Oracle processes?
a. LGWR
b. DMON
c. PMON
d. SAPDBA
11. Three OS files used in NET8 are:
a. Listner.ora
b. Netsql.ora
c. SQLnet.ora
d. Ora.Lst
e. Tnsnames.ora
12. The Oracle SGA contains the following :
a. The SQL Request area which holds parsed SQL statements.
b. The Database buffer cache
c. The oracle control files
d. The REDO log buffer
e. The REDO log files
13. Backup tapes may be initialized:
a. Using the SAPDBA tool
b. Using the command BRBACKUP – t v <tape name>
c. Using the command BRBACKUP -i -v <tape name>
d. Using the command SAPDBA - check
e. None of the above, tapes must be initialized outside of R/3.
14. The tape label contains:
a. The database name
b. The timestamp of the last backup recorded on the tape
c. The number of backups performed with the tape
d. The tape name
15. The OS file which contains the BRBACKUP/BRARCHIVE configurations is
a. init<SID>.dba
b. init<SID>.ora
c. init<SID>.sap
d. ORA<SID>.sap
e. None of the above
16. The OneRun Strategy-
a. Allows backuping up of all the database on one tape with the exception of any archived files.
b. Permits the reusing of one tape for the entire backup cycle.
c. Can backup the database and offline redo logs with the same tape.
d. Ensures less tapes are required and less administrative tasks need to be performed
e. May do BRBACKUP and BRARCHIVE in only one backup run.
17. The Oracle block size is determined
a. By a parameter setting in init<SID>.dba
b. By an R/3 instance profile parameter
c. By a parameter setting in init<SID>.ora
d. By a parameter setting in the DEFAULT.PFL
e. None of the above
18. While running an offline backup, the following R/3 instance parameters may preserve the R/3 buffers:
a. rdisp/reco_trials and rdisp/reco_sleep_time.
b. rsdb/reco_trials and rsdb/reco_sleep_time
c. rsdb/reco_buffers and rdisp/reco_backup
d. None of the above, the R/3 buffers can never be preserved running an offline backup.
19. Which of the following are true regarding RMAN?
a. Only Incremental backups are possible with RMAN.
b. RMAN backups cannot be started using the DBA calendar.
c. The init<SID>.sap parameter setting backup_mode = FULL is the parameter needed create a full RMAN database backup which will be cataloged as level 0.
d. The init<SID>.sap parameter setting backup_mode = INCR is the parameter needed create a incremental RMAN database backup which will be cataloged as level 0.
e. Database backups created with the init<SID>.sap parameter setting backup_mode = ALL can be used as a base level backup for subsequent incremental backups
20. Which of the following are true regarding tablespace administration?
a. The database must not be active when tablespaces are extended.
b. Tablespaces cannot be extended.
c. Tablespaces can be extended by adding a datafile.
d. Tablespaces can be extended by increasing the size of a datafile.
e. Only completely fragmented tablespaces should be extended.
0 comments:
Post a Comment