READ Free Dumps For Oracle- 1z0-023
| Question ID 8809 | What can a permanent tablespace contain?
|
| Option A | Only temporary segments.
|
| Option B | Only permanent segments.
|
| Option C | Both temporary and ordinary segments.
|
| Option D | Both permanent and temporary segments.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. Users can be assigned to either permanent or temporary tablespaces for creating temporary segments. If the user assigned to a permanent tablespace for creating temporary segments, the temporary segment will be created at the time the disk sort is required. Incorrect Answers: A: A permanent tablespace contains mostly permanent segments, but can be used to keep temporary segments for data sorting. B: A permanent tablespace contains not only permanent segments. C: There is no ordinary segments in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 383-345 Chapter 8: Managing Database Objects I
| Question ID 8810 | You created a password file using the operating system command line. Orapwd file=orapsORCL password=secure entries=5 Which two users with a password of "secure" are included automatically in the password file? (Choose two)
|
| Option A | SYS
|
| Option B | SCOTT
|
| Option C | SYSTEM
|
| Option D | DBADMIN
|
| Option E | INTERNAL
|
| Correct Answer | AE |
Explanation Explanation/Reference: Explanation: Answers A and E are correct. For password, be aware that as you defined the password for your password file, you are also simultaneously assigning the password for logging into Oracle as INTERNAL or SYS. Later, if the DBA connects as INTERNAL or SYS and issues ALTER USER name IDENTIFIED BY PASSWORD command, the password for INTERNAL, SYS, and the password file are all changed. Incorrect Answers: B: Assigning password for password file will not affect user SCOTT. C: Assigning password for password file will not affect user SYSTEM. D: There is no user DBADMIN in Oracle by default. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 277-279 Chapter 6: Basics of the Oracle Database Architecture