ORACLE Interview Questions -3

1. Which memory structure records all database changes made to the instance?
2. What are the recommended INITIAL and NEXT values for a temporary tablespace, to reduce fragmentation?
3. Which background process is responsible for writing the dirty buffers to the database files?
4. When a server process is terminated abnormally, which background process is responsible for releasing the locks held by the user?
5. When does Oracle stop adding rows to a block?
6. Which parameter in the ORAPWD utility is optional?
7. Which environment variable or registry entry variable is used to represent the instance name?
8. Which optional component in the database creation process sets up functions and procedures to store, access, and analyze data needed for Geographical Information Systems (GIS)?
9. What clause is in the ALTER TABLE command is used to reorganize a table?
10. What is the minimum number of redo log files required in a database?
11. What is the maximum number of database writer processes allowed in an Oracle instance?
12. How can you fix the MAXEXTENTS reached error for a rollback segment?
13. If you need to have your archive log files named with the log sequence numbers as arch_0000001, arch_0000002, and so on (zero filled, fixed width), what should be the value of the LOG_ARCHIVE_ FORMAT parameter?
14. Which memory structures are shared? Name two.
15. Which component of the SGA contains the parsed SQL code?
16. A table is created with an INITRANS value of 2. Which value would you choose for INITRANS of an index created on this table?
17. What is row migration?
18. When a table is updated, where is the before image information (which can be used for undoing the changes) stored?
19. Which file is used to record all changes made to the database and is used only when performing an instance recovery?
20. Which password parameter in the profile definitions can restrict the user from using the old password for 90 days?
21. When a SELECT statement is issued, which stage checks the user’s privileges?
22. What will happen if ARCn could not write to a mandatory archive destination?
23. If you issue ALTER TABLESPACE USERS OFFLINE IMMEDIATE, which of the following statements is true? A. All data files belonging to the tablespace must be online. B. Does not ensure that the data files are available. C. Need not doe media recovery when bringing the tablespace online. D. Need to do media recovery when bringing the tablespace online.
24. How many codds rule should oracle satisfies
25. What is the recommended configuration for control files?
26. What is the process of upgrading oracle forms /reports from older version to new versions
27. What can cause the Snapshot too old error?
28. What does OFA stand for?