READ Free Dumps For Oracle- 1z0-023
| Question ID 8819 | Which category of data dictionary views does not have an owner column?
|
| Option A | MY_
|
| Option B | DBA_
|
| Option C | ALL_
|
| Option D | USER_
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. USER_ views do not contain an owner column, because USER_ views show information about connected user objects. Incorrect Answers: A: There is no MY_ views in Oracle. B: DBA_ views show information about all data, it contains an owner column also. C: DBA_ views show information about all data to which user have access , it contains an owner column also. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 314-315 Chapter 7: Managing the Physical Database Structure
| Question ID 8820 | A PL/SQL program unit was created. Where it is stored?
|
| Option A | In the control file
|
| Option B | In the data dictionary.
|
| Option C | In the users default tablespace.
|
| Option D | In the operating system as a file.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. A PL/SQL program unit is stored in the data dictionary. Incorrect Answers: A: A PL/SQL program unit is stored in the data dictionary, not in the control file. Control file is used to mount and open database. C: A PL/SQL program unit is not stored in the users default tablespace. D: A PL/SQL program unit is stored in the data dictionary, not in the operating system as a file. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 317-318 Chapter 7: Managing the Physical Database Structure