Exam Prep Questions
Use the following command and its output information to answer questions 1 and 2:
SELECT TABLESPACE_NAME, CONTENTS, FROM DBA_TABLESPACES
| TABLESPACE_NAME | CONTENTS |
|---|---|
| SYSTEM | PERMANENT |
| MYDATA | PERMANENT |
| MYINDEXES | PERMANENT |
| UNDOTBS1 | UNDO |
| TEMP | TEMPORARY |
| USERS | PERMANENT |
| 1: | Your database has the TEMP tablespace set as the database default temporary tablespace. If you run the following command, where will the user's temporary segments be built?
CREATE USER amandya IDENTIFIED BY squirrel;
|
| A1: | Answer C is correct. Based on the data returned by the query, the user's temporary segments will be located in the default temporary tablespace. Answer A is incorrect; if there were no temporary tablespace in the database, ... |
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
