Which view shows the Name and number of all tablespaces from the contr – McqOptions

MCQOPTIONS

1.	Which view shows the Name and number of all tablespaces from the control file in Viewing Tablespace Information?
A.	DBA_TABLESPACE_GROUPS
B.	V$TABLESPACE
C.	V$DATAFILE
D.	DBA_EXTENDS,USER_EXTENDS
Answer» C. V$DATAFILE

Discussion

No Comment Found

Related MCQs

Data files of which tablespaces can be recovered by performing an open recovery?
Which utility ensure that the CONSTRAINTS and TRIGGERS parameters are set to Y the default?
Which of the following is the default permanent tablespace?
Identify the common Dynamic Performance views which are accessible in NOMOUNT stage?
Which view is useful for monitoring the effects of transaction execution on undo space in the current instance in viewing information about undo?
Which parameter when not specified then all the database objects are created in the same user schema as in the source database, and those users must already exist in the target database?
Which view shows the Name and number of all tablespaces from the control file in Viewing Tablespace Information?
A transportable tablespace set consists of datafiles for the set of tablespaces being transported and an export file containing structural information (metadata) for the set of tablespaces we use ______
What migrates a locally managed tablespace to dictionary-managed in Diagnosing and Repairing Locally Managed Tablespace Problems?
Which SQL statement from the following is used to create a new tablespace?