nerdexam
Oracle

1Z0-074 · Question #69

The TESTDB container database (CDB) contains two pluggable databases (PDBs), PDB1 and PDB2. USER1 is a local user in PDB1 and has the SYSBACKUP privilege. Connect descriptors for PDB1 and PDB2 are…

The correct answer is B. The current date is displayed. Explanation/Reference:

Administering a Multitenant Container Database

Question

The TESTDB container database (CDB) contains two pluggable databases (PDBs), PDB1 and PDB2. USER1 is a local user in PDB1 and has the SYSBACKUP privilege. Connect descriptors for PDB1 and PDB2 are mapped to TNS aliases pdb1 and PDB2 in tnsnames.ora. Examine these commands executed by USER1 when all PDBs are open:

What is the outcome and why?

Options

  • AAn error is returned because the user is connected to a pluggable database.
  • BThe current date is displayed.
  • CAn error is returned because SQL commands cannot be executed from RMAN without using the SQL
  • DAn error is returned because the user is not SYS.
  • EAn error is returned because the user is not a common user.

How the community answered

(52 responses)
  • A
    2% (1)
  • B
    71% (37)
  • C
    8% (4)
  • D
    15% (8)
  • E
    4% (2)

Explanation

Explanation/Reference:

Topics

#RMAN#SYSBACKUP privilege#local user#PDB connection

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice