1Z0-067 · Question #98
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases: $ . oraenv ORACLE-_SID = [oracle] ? cdb1 The oraclebasefor…
The correct answer is C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases. See the full explanation below for the reasoning.
Question
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv ORACLE-_SID = [oracle] ? cdb1 The oraclebasefor ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is /u01/app/oracle $ rman target / Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013 Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved. Connected to target database:CDB1 (DBID=782249327) RMAN>SELECT name FROMv$tablespace; Which statement is true about the execution of the last command?
Options
- AIt succeeds and displays all the tablespaces that belong to the root database.
- BIt fails and returns an error because a connection is not made by using the sysdba privilege.
- CIt succeeds and displays all the tablespaces that belong to the root and pluggable databases.
- DIt fails and returns an error because SQL commands cannot be executed at the RMAN prompt.
How the community answered
(68 responses)- A4% (3)
- B7% (5)
- C71% (48)
- D18% (12)
Community Discussion
No community discussion yet for this question.