| Team Fly | |
Chapter 1 Mastery Check1. The _____ 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?
A. 3
B. 2
C. 4
D. 1
3. Of the following four items of information, which one is not stored in Oracle Database 10g's control files?
A. The name of the database files
B. The creator of the database
C. The location of the database files
D. The sizes of the database files
4. What is the function of a default temporary tablespace in the support of the Oracle Database 10g?
5. Differentiate between an Oracle Database 10g and instance.
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?
7. As a user of the Oracle Database 10g is created, we often specify a default tablespace. In this context, default tablespace means?
A. The system tablespace
B. A tablespace the user can occupy space in without a private or public synonym
C. The tablespace within which objects are created if a location (tablespace) is not explicitly mentioned as a table is created
8. The ________ GUI interface is used to create a new database.
| Team Fly | |