| 1. | Which memory area is used to cache the data dictionary information? |
| a. | | Database Buffer Cache |
| b. | | PGA |
| c. | | Redo Log Buffer |
| d. | | Shared Pool
|
|
|
|
|
|
|
| 2. | What represents the value of the ORACLE_HOME environment variable in Oracle 9i? |
| a. | | @ |
| b. | | ! |
| c. | | # |
| d. | | &
|
|
|
|
|
|
|
| 3. | Which statement represents a default characteristic of the database if a database is created using the database creation assistant? |
| a. | | To access the HR user account, the account should be unlocked first |
| b. | | All accounts created by the Database Creation Assistant are locked |
| c. | | All accounts created by the Database Creation Assistant initially have expired passwords |
| d. | | The SYS and SYSTEM accounts use the same default password as in previous Oracle versions
|
|
|
|
|
|
|
| 4. | When creating a new database by issuing CREATE DATABASE, what should be done to prevent users from using the SYSTEM tablespace for sorting operations? |
| a. | | Create an undo tablespace |
| b. | | Create a default temporary tablespace |
| c. | | Create a tablespace with the UNDO keyword |
| d. | | Create a tablespace with the TEMPORARY keyword
|
|
|
|
|
|
|
| 5. | The information for a dynamic performance view is gathered from the control file. |
| a. | | True |
| b. | | False
|
|
|
|
|
|
|
| 6. | What determines the initial size of a tablespace? |
| a. | | The INITIAL clause of the CREATE TABLESPACE statement |
| b. | | The MINEXTENTS clause of the CREATE TABLESPACE statement |
| c. | | The MINIMUM EXTENT clause of the CREATE TABLESPACE statement |
| d. | | The sum of the sizes of all data files specified in the CREATE TABLESPACE statement
|
|
|
|
|
|
|
| 7. | The database needs to be shut down for hardware maintenance. All users sessions except one have either voluntarily logged off or have been forcibly killed. The one remaining user session is running a business critical DML statement and it must complete prior to shutting down the database.
Which shutdown statement prevents new user connections, logs off the remaining user, and shuts down the database after the DML statement completes? |
| a. | | SHUTDOWN |
| b. | | SHUTDOWN ABORT |
| c. | | SHUTDOWN NORMAL |
| d. | | SHUTDOWN IMMEDIATE |
| e. | | SHUTDOWN TRANSACTIONAL
|
|
|
|
|
|
|
| 8. | Examine the syntax for creating a DEPARTMENT table:
CREATE TABLE department(
Deptno NUMBER(4),
Dname VARCNAR2(30),
mgr NUMBER(6),
Loc NUMBER(4))
STORAGE(INITIAL 200K NEXT 200K
PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 5)
TABLESPACE userdata;
What is the size defined for the fifth extent? |
| a. | | 200 K |
| b. | | 300 K |
| c. | | 450 K |
| d. | | 675 K
|
|
|
|
|
|
|
| 9. | To re-create a database, all existing database files should be reused. The following SQL statement is issued:
CREATE DATABASE Sales
DATAFILE
'/u01/oradata/Sales/system0l.dbf'
SIZE 100M REUSE
LOGFILE
GROUP 1 ('/u01/oradata/Sales/logla.rdo',
'/u02/oradata/Sales/loglb.rdo')
SIZE 50K REUSE,
GROUP 2 ('/u01/oradata/Sales/log2a.rdo',
'/u02/oradata/Sales/log2b.rdo')
SIZE 50K REUSE
MAXLOGFILES 5
MAXLOGHISTORY 100
MAXDATAFILES 10;
Why does the CREATE DATABASE statement fail? |
| a. | | The MAXLOGFILES are set too low |
| b. | | The CONTROLFILE REUSE clause is omitted |
| c. | | The online redo log files cannot be reused |
| d. | | The data file belonging to the SYSTEM tablespace cannot be reused
|
|
|
|
|
|
|
| 10. | Which of the following actions cause a log switch? |
| a. | | A transaction completes |
| b. | | The instance is started |
| c. | | The current online redo log group is filled |
| d. | | The ALTER SYSTEM SWITCH LOGFILE command is issued
|
|
|
|
|
|
|
| 11. | Which statement is true with regard to the shared pool? |
| a. | | The shared pool CANNOT be dynamically resized |
| b. | | The shared pool contains only fixed structures |
| c. | | The shared pool consists of the library cache and buffer cache |
| d. | | The shared pool stores the most recently executed SQL statements and the most recently accessed data definitions
|
|
|
|
|
|
|
| 12. | The control file defines the current state of the physical database.
Which dynamic performance views obtain information from the control file? |
| a. | | V$LOG |
| b. | | V$SGA |
| c. | | V$THREAD |
| d. | | V$VERSION |
| e. | | V$DATAFILE |
| f. | | V$PARAMETER
|
|
|
|
|
|
|
