You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs).
Examine the query and its output:
SQL> SELECT * FROM v $PWFILE_users; USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID -----------------------------------------------------------------------SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
Which two tasks must you perform to add users with the SYSBACKUP, SYSDG, and SYSKM prileges to the password file? Choose two
A. Re-create or migrate the password file to the Oracle Database 12c format
B. Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
C. Copy the password file from a sample file in the DBS dierectory
D. Assign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.
Which three are true about a container database (CDB)? Choose three.
A. It can be created from a non-CDB.
B. It can contain only one PDB$SEED, which is created when the CDB is created.
C. It can have local users with the same name in different PDBs.
D. It can contain only one Application Container seed, which is created when the Application Container is created.
E. It can be created by cloning an existing CDB.
F. It can have any number of pluggable databases (PDBs) limited only by space availability.
G. It contains predefined common roles in both the root and the seed.
Which two are prerequisites for performing Flashback Transaction?
A. Fast Recovery Area must be enabled for the database
B. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
C. Undo retention guarantee must be configured for the database.
D. A supplemental log must be enabled for the primary key.
E. A supplemental log must be enabled for the primary key.
Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege? (Choose three.)
A. They can view data from any data dictionary view or dynamic performance view.
B. They cannot create restore points.
C. They cannot drop tablespaces.
D. They can create any table.
E. They can drop any tablespace.
F. They can view data from any user-defined tables.
Which three activities are possible for PDBs? (Choose three.)
A. converting an application PDB to a regular PDB
B. converting an application PDB to an application root
C. converting an application seed to an application PDB
D. converting an application PDB to an application seed
E. converting a regular PDB to an application PDB
F. converting an application container into another application container in a different CDB
G. converting an application container into another application container in the same CDB
Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)
A. A PDB snapshot can be a sparse copy of a source PDB.
B. A PDB snapshot depends on an existing storage snapshot of the source PDB.
C. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
D. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
E. A PDB snapshot can be a full copy of a source PDB.
F. A snapshot copy PDB can be a full copy of a source PDB.
G. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)
A. It supports volume management, file system, and automatic restart capabilities.
B. It must be installed before the Oracle database software is installed.
C. The CSS daemon runs from the Grid Infrastructure home.
D. It can manage database resources on the server where it is installed or on a different server.
E. It requires Oracle Automatic Storage Management (ASM) components to be installed separately.
In which two situations can you use Database Upgrade Assistant? (Choose two.)
A. when the operating system (OS) needs to be changed as part of the upgrade
B. when a character set conversion is required during the upgrade
C. when multiple pluggable databases in a container database have to be upgraded in a specific sequence
D. when the target and source database are on the same platform
E. when the hardware platform needs to be changed as part of the upgrade
Which three are true about block media recovery? (Choose three.)
A. The data file containing the block being recovered remains online.
B. To use it, Flashback Database must be enabled.
C. A block being recovered is not accessible.
D. It can be performed on noncorrupt blocks.
E. The target database for which one or more blocks are to be recovered must be in the OPEN state.
F. It cannot repair logical corruption.
Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output? (Choose three.)
A. Some messages in the error stack are not errors.
B. If an RMAN command fails, the output will only identify the command that failed.
C. If an RMAN command fails, the output will identify the channel ID where the failure occurred.
D. Media Management errors appear as a line with "sbtio" and a number.
E. Media Management errors appear as a line with "sbtio".
F. Media Management errors appear as a line with "Additional information" and a number.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-083 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.