Which statement is true about the execution of the last command?

You execute the commands on a multitenant container database CDB1 that has multiple
pluggable databases: Exhibit: Which statement is true about the execution of the last
command?

You execute the commands on a multitenant container database CDB1 that has multiple
pluggable databases: Exhibit: Which statement is true about the execution of the last
command?

A.
It fails and returns an error because SQL commands cannot be executed at the RMAN
prompt.

B.
It succeeds and displays all the tablespaces that belong to the root database.

C.
It fails and returns an error because a connection is not made by using the sysdba
privilege.

D.
It succeeds and displays all the tablespaces that belong to the root and pluggable
databases.

Explanation:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Shakeeb

Shakeeb

D is correct

C:\Users\Administrator>rman target /

Recovery Manager: Release 12.1.0.1.0 – Production on Mon Mar 21 15:45:17 2016

Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.

connected to target database: CDB1 (DBID=870415899)

RMAN> select name from v$tablespace;

NAME
——————————
SYSTEM
SYSAUX
UNDOTBS_12C
USERS
TEMP
SYSTEM
SYSAUX
TEMP
SYSTEM
SYSAUX
TEMP
USERS
EXAMPLE
SYSTEM
SYSAUX
TEMP
USERS
EXAMPLE
TEST_CDB
TEST_CDB
SYSTEM
SYSAUX
TEMP
SALESTBS

24 rows selected