1. How would you determine the time zone under which a database was operating? 2. Explain the use of setting GLOBAL_NAMES equal to TRUE. 3. What command would you use to encrypt a PL/SQL application? 4. Explain the difference between a FUNCTION, PROCEDURE and PACKAGE. 5. Explain the use of table functions. 6. Name three advisory statistics you can collect. 7. Where in the Oracle directory tree structure are audit traces placed? 8. Explain materialized views and how they are used. 9. When a user process fails, what background process cleans up after it? 10. What background process refreshes materialized views? 11. How would you determine what sessions are connected and what resources they are waiting for? 12. Describe what redo logs are. 13. How would you force a log switch? 14. Give two methods you could use to determine what DDL changes have been made. 15. What does coalescing a tablespace do? 16. What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace? 17. Name a tablespace automatically created when you create a database. 18. When creating a user, what permissions must you grant to allow them to connect to the database? 19. How do you add a data file to a tablespace? 20. How do you resize a data file? 21. What view would you use to look at the size of a data file? 22. What view would you use to determine free space in a tablespace? 23. How would you determine who has added a row to a table? 24. How can you rebuild an index? 25. Explain what partitioning is and what its benefit is. 26. You have just compiled a PL/SQL package but got errors, how would you view the errors? 27. How can you gather statistics on a table? 28. How can you enable a trace for a session? 29. What is the difference between the SQL*Loader and IMPORT utilities? 30. Name two files used for network connection to a database.
1. In a system with an average of 40 concurrent users you get the following from a query on rollback extents:
ROLLBACK CUR EXTENTS
-------------------------- R01 11 R02 8 R03 12 R04 9 SYSTEM 4 2. You have room for each to grow by 20 more extents each. Is there a problem? Should you take any action
No there is not a problem. You have 40 extents showing and an average of 40 concurrent users. Since there is plenty of room to grow no action is needed.
3. You see multiple extents in the temporary tablespace. Is this a problem
As long as they are all the same size this isn?t a problem. In fact, it can even improve performance since Oracle won?t have to create a new extent when a user needs one.
4. Define OFA.
OFA stands for Optimal Flexible Architecture. It is a method of placing directories and files in an Oracle system so that you get the maximum flexibility for future tuning and file placement.
5. How do you set up your tablespace on installation
The answer here should show an understanding of separation of redo and rollback, data and indexes and isolation os SYSTEM tables from other tables. An example would be to specify that at least 7 disks should be used for an Oracle installation so that you can place SYSTEM tablespace on one, redo logs on two (mirrored redo logs) the TEMPORARY tablespace on another, ROLLBACK tablespace on another and still have two for DATA and INDEXES. They should indicate how they will handle archive logs and exports as well. As long as they have a logical plan for combining or further separation more or less disks can be specified.
6. What should be done prior to installing Oracle (for the OS and the disks)
adjust kernel parameters or OS tuning parameters in accordance with installation guide. Be sure enough contiguous disk space is available.
7. You have installed Oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem
Check to make sure that the archiver isn?t stuck. If archive logging is turned on during install a large number of logs will be created. This can fill up your archive log destination causing Oracle to stop to wait for more space.
8. When configuring SQLNET on the server what files must be set up
INITIALIZATION file, TNSNAMES.ORA file, SQLNET.ORA file
9. When configuring SQLNET on the client what files need to be set up
SQLNET.ORA, TNSNAMES.ORA
10. What must be installed with ODBC on the client in order for it to work with Oracle
SQLNET and PROTOCOL (for example: TCPIP adapter) layers of the transport programs.
1. In a system with an average of 40 concurrent users you get the following from a query on rollback extents:
ROLLBACK CUR EXTENTS
-------------------------- R01 11 R02 8 R03 12 R04 9 SYSTEM 4 2. You have room for each to grow by 20 more extents each. Is there a problem? Should you take any action
No there is not a problem. You have 40 extents showing and an average of 40 concurrent users. Since there is plenty of room to grow no action is needed.
3. You see multiple extents in the temporary tablespace. Is this a problem
As long as they are all the same size this isn?t a problem. In fact, it can even improve performance since Oracle won?t have to create a new extent when a user needs one.
4. Define OFA.
OFA stands for Optimal Flexible Architecture. It is a method of placing directories and files in an Oracle system so that you get the maximum flexibility for future tuning and file placement.
5. How do you set up your tablespace on installation
The answer here should show an understanding of separation of redo and rollback, data and indexes and isolation os SYSTEM tables from other tables. An example would be to specify that at least 7 disks should be used for an Oracle installation so that you can place SYSTEM tablespace on one, redo logs on two (mirrored redo logs) the TEMPORARY tablespace on another, ROLLBACK tablespace on another and still have two for DATA and INDEXES. They should indicate how they will handle archive logs and exports as well. As long as they have a logical plan for combining or further separation more or less disks can be specified.
6. What should be done prior to installing Oracle (for the OS and the disks)
adjust kernel parameters or OS tuning parameters in accordance with installation guide. Be sure enough contiguous disk space is available.
7. You have installed Oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem
Check to make sure that the archiver isn?t stuck. If archive logging is turned on during install a large number of logs will be created. This can fill up your archive log destination causing Oracle to stop to wait for more space.
8. When configuring SQLNET on the server what files must be set up
INITIALIZATION file, TNSNAMES.ORA file, SQLNET.ORA file
9. When configuring SQLNET on the client what files need to be set up
SQLNET.ORA, TNSNAMES.ORA
10. What must be installed with ODBC on the client in order for it to work with Oracle
SQLNET and PROTOCOL (for example: TCPIP adapter) layers of the transport programs.
No comments:
Post a Comment