Which data dictionary view would you query to find the name of the default permanent tablespace of the database?
A.
DICTIONARY
B.
DBA_TABLESPACS
C.
DBA_DIRECTORIES
D.
DBA_STORED_SETTINGS
E.
DATABASE_PROPERTIES
F.
DBA_TABLESPAC_GROUPS
Explanation:
SQL*Plus: Release 10.2.0.1.0 – Production onMon Feb6 21:41:04 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> desc DATABASE_PROPERTIESName 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
3 WHERE PROPERTY_NAME = ‘DEFAULT_PERMANENT_TABLESPACE’; PROPERTY_NAME PROPERTY_VALUE
———- —————————-
DEFAULT_PERMANENT_TABLESPACE USERS