Which data dictionary view would you query to find the name of the default permanent tablespace of the database?

Which data dictionary view would you query to find the name of the default permanent tablespace of the database?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *