SAP Basis/Netweaver Certification Question Set 6

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!

Oracle Database related questions from SAP Basis/Netweaver Certification point of view

1. When is data is written to the Oracle transaction logs (redo logs)?

Please click on the button next to the correct answer.

A.     Sometimes before, sometimes after being written to the database files.

B.     After being written to the database files.

C.     At the same time as being written to the database files.

D.     As specified by the parameter "dblg_after" in the ORACLE initialization file.

E.     Before being written to the database files.

2. During an offline backup, which customer files does sapdba save to ensure that the Oracle database can be restored to an internally consistent state?

Please click on the button next to the correct answer.

A.     Oracle executable files.

B.     Oracle database transaction log files and offline redo log files.

C.     Offline redo log files and the R/3 SYSLOG file.

D.     Tablespace data files, database transaction log files, and the database control file.

E.     Database transaction log files and R/3 transport structures.

3. During an online database backup, which customer files must be saved to ensure that the Oracle database can be restored to an internally consistent state?

Please click on the button next to the correct answer.

A.     Tablespace data files, the database control file, and all database redo logs written during the online backup.

B.     Oracle online redo log files and the database control file.

C.     Offline redo log files, the database control file, and the Oracle executables.

D.     The Oracle executables, the database parameter file, and the tablespace data files.

E.     The tablespace data files, the database control file, and the database parameter file.

4. What is the primary function of the directory $ORACLE_HOME/sapbackup?

Please click on the button next to the correct answer.

A.     Storing database transaction logs (redo logs) temporarily before they are automatically written to tape.

B.     Providing a work area for R/3 Instance tasks.

C.     Storing database backups which are written to disk.

D.     Storing the offline redo log files.

E.     Providing a work area for R/3 database utilities during database reorganizations.

5. When an Oracle database is used by an R/3 System with SAP System ID C11, what is the name of the file for brbackup and brarchive parameters?

Please click on the button next to the correct answer.

A.     initC11.ini

B.     initC11.sap

C.     initC11.ora

D.     sapdba.ini

E.     initC11.dba

6. Which of the following statements is correct in regard to using the brbackup command  to backup database and non-database files?

Please click on the button next to the correct answer.

A.     Brbackup is an improvement over all operating system level backup methods and is recommended for regular backups.

B.     Brbackup must be called from sapdba.

C.     Non-SAP and non-Oracle subdirectories are backed-up through recursive calls.

D.     Non-database files must be specified with their complete, absolute file names.

E.     Brbackup's "all" option is used to backup the complete operating system, R/3 instance, and the Oracle database.

7. What is the probable cause of the sapdba error indicated in this screen?

Please click on the button next to the correct answer.

A.     An offline backup has been started but tablespaces are missing.

B.     Users are still logged on to the R/3 instance.

C.     The backup has aborted because there is no tape in the tape device.

D.     The tape has not been initialized.

E.     The backup has been terminated because brarchive is already running.

8. Which of the following statements are correct in regard to using a single run of BRBACKUP to save both the database files and the offline redo log files?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     BRARCHIVE is started immediately after the database backup is complete: no further intervention by the database administrator is necessary.

B.     This technique can only be used for offline database backups, not online backups.

C.     The database backup and the backup of the offline redo log files must fit on one tape because changing tapes is not supported.

D.     You can backup the database using multiple tape devices in parallel.

E.     The tapes used must have been initialized by BRBACKUP.

9. SAP recommends checking the database for corrupt data blocks at least once per backup cycle.

How can this be done?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     You can run the ABAP report RSORABLK at times of low system load.

B.     You can export the complete database using the Oracle export utility.

C.     You can run the command "sapdba -analyze PSAP%".

D.     You can run the command "brbackup -t offline -m all -verify".

E.     You can run the command "brrestore -w use_dbv" on a previously performed full database backup.

10. Which of the following strategies are supported by SAPDBA?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     Standby database

B.     Split mirror backup

C.     Recovery of a lost table based on an export.

D.     Two-level backup: first to disk, then to tape

E.     Replication database

11. What is the primary purpose of the directory $ORACLE_HOME/sapreorg (Windows NT: $ORACLE_HOME\sapreorg)?

Please click on the button next to the correct answer.

A.     Storing the offline redo log files.

B.     Providing a work area for R/3 dialog instance tasks.

C.     Storing online database backups instead of writing them to tape.

D.     Storing transaction log files.

E.     Providing a work area for R/3 database utilities.

12. Which of the following statements is correct in regard to OPS$connect?

Please click on the button next to the correct answer.

A.     OPS$connect authorization allows an operating system user to connect to the database without being prompted for a password.

B.     OPS$connect is an Oracle command enabling whoever executes it to administer the database without using svrmgrl.

C.     OPS$connect is used in Oracle Parallel Server installations to enable remote database connections over a LAN.

D.     OPS$connect authorization is required for all users connecting to the Oracle database.

E.     OPS$connect enables the R/3 saposcol process to communicate and exchange data with the Oracle database.

13. What happens during the startup of an Oracle database?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     The SGA is created in shared memory according to the parameter settings in the configuration file init<SID>.ora.

B.     The Oracle background and shadow processes are created.

C.     In the mount phase, all copies of the control file are opened.

D.     If necessary, Oracle automatically performs an instance recovery.

E.     As the last step, the online redo log files are cleared and the data files are opened.

14. What happens during the shutdown of an Oracle database?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     When you shutdown the database with the NORMAL option, the database system disconnects all users before shutting down the database.

B.     When you shutdown the database with the NORMAL or IMMEDIATE option, the database system writes a checkpoint before shutting down the database.

C.     When you shutdown the database with the ABORT or IMMEDIATE option, open transactions are rolled back before the database is shut down.

D.     When you shut down the database with the ABORT option, the R/3 system is shut down, too.

E.     Shutting down the database with the ABORT option always requires an instance recovery at the next database startup.

15. Which of the following commands does SAP recommend running on a weekly basis to update table statistics used by the Oracle cost-based optimizer?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     sapdba -analyze PSAP%

B.     analyze table <table name> estimate statistics sample 10 percent

C.     sapdba -checkopt PSAP%

D.     sapdba -analyze DBSTATCO

E.     update statistics medium

16. Which of the following statements express part of the SAP-recommended strategy for creating and updating the table statistics used by the cost-based optimizer?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     No statistics are created for R/3 pool and cluster tables.

B.     Statistics are created for all transparent tables that have no statistics.

C.     The table DBSTATC can be used to trigger an exact computation of the statistics of specific tables.

D.     The update for table statistics refreshes all transparent tables.

E.     The table DBSTATC can be used to detect which table statistics need to be refreshed.

17. Which of the following statements are correct in regard to index reorganization using SAPDBA?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     The reorganization can be done online using the "ALTER INDEX REBUILD" function without danger to data security and consistency.

B.     The reorganization can be done by calling the Oracle export/import utilities through the SAPDBA reorganization menu.

C.     The reorganization can be accelerated with the help of the Oracle PARALLEL QUERY functionality.

D.     SAPDBA prompts you to perform a backup before reorganizing indexes.

E.     You can do a test import before the old index is dropped.

18. Which of the following statements are correct in regard to table reorganization using SAPDBA?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     The reorganization can be done using the 'CREATE TABLE AS SELECT' function.

B.     SAPDBA offers using the Oracle SQL*Loader for the data import.

C.     Reorganization of a table always includes the reorganization of all its indexes.

D.     Reorganization of one large table can be performed by parallel processing using the  tool R/3chop and specifying multiple dump destinations for the data export.

E.     After a reorganization with SAPDBA you should immediately update the table statistics needed by the cost-based optimizer.

19. What is the name of the alert log file for an Oracle database used by an

R/3 System with SAP system ID "C11"?

Please click on the button next to the correct answer.

A.     ora_log_C11.log

B.     ora_log_C11.trc

C.     orasrv.log

D.     alert_C11.trc

E.     alert_C11.log

20. What happens if a table wants to allocate another extent but there is not enough contiguous free space in the tablespace?

A.     Please click on the button next to the correct answer.

B.     The extent is allocated in another tablespace.

C.     The extent is distributed across the free space that is available.

D.     The Oracle error message ORA 1653 is sent to the file SYSLOG and to the ABAP short dump.

E.     Oracle dynamically reorganizes the tablespace to make all available space contiguous.

F.     The database switches into maintenance mode and sends a system message to the database administrator.

21. Based upon the archive status display shown, what may be concluded?

Please click on the button next to the correct answer.

A.     The directory for the offline redo log files is almost out of space.

B.     The R/3 central instance is not installed on the same computer as the database.

C.     There are 206 database transaction logs and 19 offline redo log files.

D.     The directory SAPARCH is approximately 20 MB in size.

E.     There are no obvious problems.

22. Which Oracle component dynamically maintains information about the status of the database redo logs, the database mode, and the names and paths of database files, and is essential during a database recovery?

Please click on the button next to the correct answer.

A.     The Oracle parameter file, init<SID>.ora.

B.     Each tablespace data file contains this data for the whole database.

C.     The SGA definition file, sgadef<SID>.def.

D.     The Oracle control file, cntrl<SID>.dbf.

E.     The sapdba parameter file, init<SID>.dba.

23. When the R/3 update task aborts with an Oracle error ORA1653 - failure to allocate an extent for a table in a specific tablespace - what action needs to be taken?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     The tablespace should be reorganized.

B.     The tablespace size should be increased by adding a new data file.

C.     The table should be reorganized.

D.     The storage parameter MAXEXTENTS must be increased.

E.     After the cause of the error has been removed, the R/3 update task must be reactivated.

24. What action needs to be taken when a table tries to extend beyond the number of defined MAXEXTENTS?

Please click on the button next to the correct answer.

A.     You should run the command "sapdba -next".

B.     The value of MAXEXTENTS must be increased manually by the database administrator.

C.     If the table has already allocated 505 extents, the table must be reorganized.

D.     With Oracle8 the value of MAXEXTENTS is automatically increased. No user action is required.

E.     With Oracle8 no error occurs, because tables are allowed to have an unlimited number of extents. No user action is required.

25. What is indicated by the Oracle database message "Checkpoint not complete" displayed in this screen?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     The database was corrupted because a checkpoint could not complete.

B.     A log switch had to wait for a checkpoint to complete.

C.     There was a temporary database standstill while waiting for a checkpoint to complete.

D.     An archiver stuck situation occurred that prevented the ongoing checkpoint from completing.

E.     The database system tried to reuse an online redo log that had not yet been copied to the archive directory by the ARCH process.

26. Which of the following checks are useful for database performance monitoring?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     Checking that the CBO statistics are refreshed once a week according to the strategy recommended by SAP.

B.     Checking that the archive directory contains enough free space.

C.     Checking the data buffer quality.

D.     Checking the shared cursor cache for expensive SQL statements.

E.     Checking for tables with more than 100 extents.

27. An instance error occurs when one or more Oracle background processes become corrupted.

As the database administrator, what action should you take?

Please click on the button next to the correct answer.

A.     Shutdown abort and startup open. The SMON process will use the current redo log files and checkpoint information from the control files to execute an automatic instance recovery upon database startup.

B.     Shutdown the operating system and reinstall the Oracle software.

C.     Call the Oracle hotline, as this is a serious error.

D.     Shutdown the operating system and turn all hardware off. After the hardware cools off, start everything up again and execute Orainst using the repair option.

E.     Restore all missing files, apply the offline redo logs, update the control files, and execute the startup open command.

28. The R/3 System Oracle database has four online redo logs, also known as database transaction logs. Each online redo log has a mirrored copy. What is the effect of a log file switch?

Please click on the button next to the correct answer.

A.     The current online redo log is copied to its mirrored copy, then the next online redo log becomes open for writing.

B.     The database alternates between writing to the online and offline redo log files.

C.     The database switches between writing to the original redo log files and the mirrored redo log files.

D.     The current online redo log is closed and the next online redo log becomes open for writing. The ARCH process is triggered to begin backing up the recently closed redo log.

E.     The current R/3 SYSLOG file is copied to the saparch directory and a new SYSLOG file is created.

29. Which of the following statements is correct in regard to online Oracle database backups?

Please click on the button next to the correct answer.

A.     Users may only read data and may not enter data until after the backup is done.

B.     The database must be running in archivelog mode.

C.     The tablespace data files and control file comprise the complete online backup and are all that is necessary for restoring the database to a consistent status.

D.     Database transaction logs (online redo logs) are not written during online backups.

E.     Online database backups are not supported by Oracle.

30. In an Oracle database with system ID C11, if tablespace PSAPBTABD is extended by 200 MB by adding another data file, which of the following statements is correct?

Please click on the button next to the correct answer.

A.     To maintain database recoverability, all data files for PSAPBTABD and the database control file should be backed up.

B.     If a full database restore is performed, the new tablespace data file is automatically created based on information in the file initC11.ora.

C.     To register the existence of the new file in the Oracle internal system tables, the database must be restarted.

D.     To maintain database recoverability, the data files for PSAPBTABD, the control file, and the redo logs must be backed up.

E.     To create a clean copy of the complete database, an R3SETUP database copy should be run.

31. Which of the following statements are correct in regard to the options in the SAPDBA restore/recovery menu?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     Option "c - Reset database" does not allow database recovery after restoring the backup.

B.     For option "c - Reset database", only offline backups can be used, not online backups.

C.     For option "a- Partial restore and complete recovery", SAPDBA detects and restores only the damaged data files.

D.     After using the option "d - Restore one tablespace", only complete database recovery is possible, no point-in-time recovery.

E.     For option "b - Full restore and recovery", only full online or full offline backups can be used, no partial backups.

32. When planning the distribution of the database transaction logs, mirrored transaction logs, archived transaction logs, and tablespace data files over multiple logical device groups, what is the highest priority?

Please click on the button next to the correct answer.

A.     Better performance through more hardware.

B.     More flexibility in case of hardware failure.

C.     Easier database backups and quicker restores.

D.     To make the system physically more modular for transport reasons.

E.     Higher data security and easier administration.

33. Which of the following oracle parameters should never be modified in the file init<SID>.ora?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     db_name

B.     control_files

C.     shared_pool_size

D.     db_block_size

E.     db_block_buffers

34. Which one of the following configurations has the least impact on data security and performance?

Please click on the button next to the correct answer.

A.     Operating system swap and Oracle tablespace data files installed on the same physical disk(s).

B.     Operating system swap and Oracle database transaction logs (redo logs) installed on the same disk(s).

C.     Operating system swap and SAP kernel (executable files) installed on the same physical disk(s).

D.     Operating system swap and the /usr/sap directory installed on the same physical disk(s).

E.     Oracle offline redo log files accessed over a shared or Network File System directory connection.

35. To enlarge the shared memory for the Oracle database instance, which of the following Oracle parameters should be modified in the file init<SID>.ora?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     db_block_buffers

B.     log_archive_dest

C.     shared_pool_size

D.     rollback_segments

E.     db_block_size

36. Which of the following statements is correct in regard to the directory SAPARCH?

Please click on the button next to the correct answer.

A.     A SAPARCH of approximately 300 MB is large enough to satisfy all R/3 customer requirements.

B.     The size of SAPARCH is not critical; it does not matter, for example, if it is created relatively small to save money on hardware.

C.     SAPARCH must be at least as large as the largest database table.

D.     SAPARCH must be at least as large as the largest tablespace.

E.     SAPARCH should have several hundred MB for a demonstration or test system, and be considerably larger (at least 1 GB) for a production system.

37. Based on SAP configuration guidelines for data security and performance, which of the following statements is correct in regard to the configuration revealed by this screen?

(For Windows NT, the directory delimiters appear as " \ ".)

Please click on the button next to the correct answer.

A.     This represents a secure configuration. Nothing could be done to improve the distribution of components.

B.     Mirror logs A and B represent a potential data security problem. The database is not capable of being recovered.

C.     The database redo logs on device 3 are in danger of accidentally being overwritten by the operating system swap installed there. This represents a potential data security problem.

D.     Disk I/O on device 4 may be unreasonably slow due to the mirror logs A and B being on the same device as the database data disks.

E.     The fact that SAPARCH is installed with the R/3 Transport structures on device 2 represents a potential data security problem.

38. Based on SAP configuration guidelines for data security and performance, which of the following statements is correct in regard to the configuration revealed by this screen?

(For Windows NT, the directory delimiters appear as " \ ".)

Please click on the button next to the correct answer.

A.     This configuration represents a potential data security problem because having disks configured for RAID 1 and disks configured for RAID 5 on one computer may lead to hardware failure.

B.     The database data files are installed in an non-recommended RAID 5 configuration, potentially causing data security problems.

C.     Installing the SAPARCH directory and the R/3 transport directory on the same device represents a potential data security problem.

D.     Installing the Oracle database transaction logs, origlogA and origlogB, on the same device represents a critical data security problem.

E.     This represents a secure configuration. The distribution of system components is reasonable in regard to performance.

39. Based on SAP configuration guidelines for data security and performance, which of the following statements is correct in regard to the configuration revealed by this screen?

(For Windows NT, the directory delimiters appear as " \ ".)

Please click on the button next to the correct answer.

A.     This configuration meets SAP data-security standards. The distribution of system components is reasonable in regard to performance.

B.     A significant performance improvement could be achieved by relocating origlogA and mirrlogB together on one disk, and origlogB and mirrlogA together on another disk.

C.     The installation of the directory SAPREORG on the same disk as mirrlogA and mirrlogB represents a potential data security problem.

D.     OriglogA and origlogB may increase in size exponentially, and should not be installed on the same disk as the $ORACLE_HOME directory.

E.     Installing the components sapdata1 to sapdata6 on disks of 4 GB is a waste of hardware because these components never increase in size.

40. Which of the following kinds of information are provided by the command "sapdba -check"?

Note! More than one answer is correct. Please click on the buttons next to the correct answers.

A.     Information about the last successful or failed backups.

B.     Complete path names and file sizes for all data files.

C.     Space-critical objects.

D.     The tables and indexes with the most free space.

E.     Values of all active database configuration parameters.