Which data dictionary view would you query to find the name of the default permanent tablespace
of the database?
A.
DICTIONARY
B.
DBA_TABLESPACES
C.
DBA_DIRECTORIES
D.
DBA_STORED_SETTINGS
E.
DATABASE_PROPERTIES
F. DBA_TABLESPACE_GROUPS
Explanation:
SQL*Plus: Release 10.2.0.1.0 – Production on Sat Feb 4 20:31:26 2006 Copyright
(c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL>desc DATABASE_PROPERTIES
Name Null? Type
—————————————– ——– ——————– PROPERTY_NAME NOT NULL
VARCHAR2(30)
PROPERTY_VALUE VARCHAR2(4000)
DESCRIPTION VARCHAR2(4000)
SQL> SELECT PROPERTY_NAME, PROPERTY_VALUE
2 FROM DATABASE_PROPERTIES
3WHERE PROPERTY_NAME=’DEFAULT_PERMANENT_TABLESPACE;
PROPERTY_NAME PROPERTY_VALUE
———- —————————-
DEFAULT_PERMANENT_TABLESPACE USERS