| 1. |
How many tests does the Oracle9i OCA Certification consist of?
A. 1
B. 2
C. 3
D. 4 |
| |
| 2. |
A table is the basic structure of data storage in Oracle9i.
A. True
B. False |
|
| 3. |
DML is used to define, alter, or drop database objects and their privileges.
A. True
B. False |
|
| 4. |
What are the special characters allowed in a table name?
(Choose
two answers.)
A. &
B. #
C. @
D. $
| |
| 5. |
How many control files are required to create a database?
A.
One
B. Two
C. Three
D. None
|
|
| 6. |
Which SHUTDOWN option will wait for the users to complete
their
uncommitted transaction?
A. SHUTDOWN IMMEDIATE
B. SHUTDOWN
TRANSACTIONAL
C. SHUTDOWN NORMAL
D. SHUTDOWN ABORT |
|
| 7. |
What physical file(s) does Oracle's physical database structure consist of?
A.
Data files
B. Redo log files
C. Control files
D. All of the above
|
|
| 8. |
Choose the maximum number of tables into which rows can be inserted
via a single INSERT statement.
A. 1
B. 2
C. No more that 16
D.
Unlimited |
|
| 9. |
What is the most important part of the Oracle Database?
A. Data Dictionary
B. Table
C. CONTROL_FILES
D.
View
as and when
required. |
|
| 10. |
Which command is used to assign a profile to an existing user?
A.
ALTER PROFILE
B. ALTER USER
C. SET PROFILE
D. The profile should be specified when creating the user; it cannot be changed. |
|