1. Data is written to the Data Files before it is written to the Redo Logs. True/False
2. In an offline backup, what files are backed up?
3. In an online backup, what files are backed up?
4. What are the uses of the sapbackup and sapreorg directories?
5. What are the following files used for?
– init<SID>.sap
– init<SID>.dba
– init<SID>.ora
6. How do you verify corrupt data blocks at least once per Backup cycle?
7. What is the use of the OPS$<SID>adm user in an SAP database?
8. What happens during each of the shutdown options?
– shutdown normal
– shutdown immediate
– shutdown force
9. What happens during each of the startup phases?
– startup nomount
– startup mount
– startup open
10. Explain the 2 phase strategy recommended by SAP for maintaining Optimizer statistics?
11. What is the file to troubleshoot Oracle errors and where is it located?
12. Table and Index Reorganization?
13. If an index or a table is unable to allocate another extent, what would be the error code and the cause of it?
14. Provide a solution to resolve 13 above?
15. Which Oracle file is used during recovery and maintains information about LSNs, etc?
16. What is to be done for an index/table for which the MAXEXTENTS limit has been reached?
17. “Checkpoint not Complete” – Can an archiver stuck situation cause this condition? How about Block Corruption?
18. If a Background Process aborts, what kind of recovery do you initiate after starting up the database?
19. During a log file switch, what is the role of the ARCH process?
20. To run Offline Backups, the database has to be running in ARCHIVELOG mode. True/False?
21. How do you adjust the size of the Shared SQL Cache?
22. How do you adjust the DB_BLOCK_SIZE of your database?
23. Know your SAPDBA Restore & Recovery Menu Paths and available options?
24. Information provided in Report for sapdba -check?
25. Identify the best disk layout for the following files w.r.t to security?
a. origlogA, origlogB, mirrorlogA, mirrorlogB.
SAP Learning 