nerdexam
Oracle

1Z0-063 · Question #123

You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases: $ . oraenv ORACLE-_SID = [oracle] ? cdb1 The oracle base for…

The correct answer is A. It succeeds and displays all the tablespaces that belong to the root database. 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 oracle base for 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 Copy right (c) 1982, 2013, oracle and/or its affiliates. All rights reserved. Connected to target database:CDB1 (DBID=782249327) RMAN>SELECT name FROM v$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

(30 responses)
  • A
    83% (25)
  • B
    3% (1)
  • C
    3% (1)
  • D
    10% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice