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_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_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
3 WHERE 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 *