| Team Fly | |
1. The __________ background process is primarily responsible for writing information to the Oracle Database 10g files.
The database writer, or dbwr, background process is primarily responsible for writing information to the Oracle Database 10g files.
2. How many online redo log groups are required to start an Oracle Database 10g?
B.
Explanation The minimum number of redo log groups required to start an Oracle Database 10g is two though many DBAs add more groups. This increases the fault tolerance of the database.
3. Of the following four items of information, which one is not stored in Oracle Database 10g's control files?
B.
Explanation The creator of the database is not stored anywhere in the assortment of the Oracle Database 10g support files.
4. What is the function of a default temporary tablespace in the support of the Oracle Database 10g?
The default temporary tablespace is the location where sessions build intermediary objects to satisfy queries and perform sort operations.
5. Differentiate between an Oracle Database 10g and instance.
The database is a collection of files, whereas an instance is a handful of processes working in conjunction with a computer's memory to support access to those files.
6. Activities such as allocating space in the database and user management are commonly performed by the DBA. What feature in the Oracle Database 10g allows some of these secure operations to be carried out by non-DBA users? How are these rights given out?
System privileges allow the DBA to give out rights to perform selected secure operations to other Oracle Database 10g users. These privileges are given out with a grant statement.
| Team Fly | |