Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)
A.
Tablespace free space can be viewed in V$TABLESPACE
B.
V$TABLESPACE displays information that is contained in the controlfile about tablespaces
C.
V$TABLESPACE displays information about tablespaces contained in the data dictionary
D.
Tablespace free space can be viewed in DBA_TABLESPACES
E.
A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
A - false; v$tablespace is a dynamic performance view and doesn't contain any information referring to space usage
B - true; see Oracle documentation, Release 19, Database Reference, Part III Dynamic Performance Views, 9 Dynamic Performance (V$) Views: V$SCHEDULER_RUNNING_JOBS to V$ZONEMAP_USAGE_STATS, 9.105 V$TABLESPACE, V$TABLESPACE displays tablespace information from the control file.
C - false; dynamic performance views (like e.g. V$TABLESPACE) gets its content from instance, not from a data dictionary; these views are independent of data dictionary
D - false; free space in a tablespace cannot be get from the view DBA_TABLESPACES. It can be get using views DBA_SEGMENTS and DBA_DATA_FILES
E - true; see https://oracle-base.com/articles/misc/renaming-or-moving-oracle-files
Provided answer are corrects:
https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/9i/r2/paa/obe-dbf/html/Move_DF.htm
E is the old way to rename datafile and it's correct as link above.
A is wrong. This view displays basic TS information with no reference to block consumption.
B is correct.
C is wrong. V$-views query the instance and not the dictionary.
D is wrong. You have to query dba_tablespaces, dba_data_files and dba_free_space to obtain this information.
E is correct, but could be wrong also. If we rename the datafile with the SQL command" alter database move datafile" then yes. If we assume that the renaming is done on the OS then the "ALTER DATABASE RENAME FILE" command should be issued when the database is in mount state so that the dictionary can be updated.
B & E are the right answers.
B: v$tablespace gets infromation from control file as per article shared by SimoneF
https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2156.htm#REFRN30277
E: since all DBA_* dictionaries are not accessible until DB is opened
Answer C.
SQL> select * from v$tablespace;
TS# NAME INC BIG FLA ENC CON_ID
---------- ------------------------------ --- --- --- --- ----------
1 SYSAUX YES NO YES 1
0 SYSTEM YES NO YES 1
2 UNDOTBS1 YES NO YES 1
4 USERS YES NO YES 1
3 TEMP NO NO YES 1
0 SYSTEM YES NO YES 2
1 SYSAUX YES NO YES 2
2 UNDOTBS1 YES NO YES 2
3 TEMP NO NO YES 2
0 SYSTEM YES NO YES 3
1 SYSAUX YES NO YES 3
Have some informations about the data files
Answer C doesn't speak about data files thought, but states that v$tablespace view would get data from the data dictionary. That's not true and the view actually gets data from the controlfile, as stated in answer B which is correct:
https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2156.htm#REFRN30277
B and C is correct. TO rename the datafile, database needs is open state.
SQL> alter tablespace teste10
2 rename datafile '/u02/oradata/ORCL/teste10.dbf'
3 to '/u02/oradata/ORCL/teste11.dbf';
alter tablespace teste10
*
ERROR at line 1:
ORA-01109: database not open
Was the database in mount? Because E is true and C is definitely wrong: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2156.htm#REFRN30277
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
nautil2
2 months, 4 weeks agoauwia
6 months agoFranky_T
1 year, 8 months agomaiccrosas
4 months, 2 weeks agocasfdsaf
1 year, 10 months agozorel
2 years, 4 months agosaidov1981
2 years, 9 months agobatavo27
3 years, 2 months agoSimoneF
3 years agobatavo27
3 years, 2 months agoSimoneF
3 years agoEkos
3 years, 1 month agoEkos
3 years, 1 month agoavanand
3 years, 4 months ago