Page 1 out of 19. Viewing questions 1-15 out of 282
Question 1
Choose three. Which three actions are mandatory post database upgrade?
A.
Updating client scripts with the new Oracle home.
B.
Resetting passwords to enforce case-sensitivity.
C.
Run OPatch commands from the new Oracle home.
D.
Setting threshold values for tablespace alerts.
E.
Migration to unified auditing.
F.
Upgrading user tables that depend on Oracle-maintained abstract data types.
Answer:
A, C, F
User Votes:
A 2 votes
50%
B 1 votes
50%
C 2 votes
50%
D
50%
E
50%
F 1 votes
50%
Discussions
0/ 1000
Question 2
Choose two. Which two are prerequisites for using FLASHBACK TABLE?
A.
A table's constraints must be disabled before issuing the flashback.
B.
The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.
C.
Row Movement must be enabled on the table being flashed back.
D.
A table's indexes must be set to unusable before issuing the flashback.
E.
The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.
Answer:
B, C
User Votes:
A
50%
B 1 votes
50%
C 1 votes
50%
D
50%
E
50%
Discussions
0/ 1000
Question 3
Choose three. Which three are true about a container database (CDB)?
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.
Answer:
B, E, G
User Votes:
A
50%
B 2 votes
50%
C 2 votes
50%
D
50%
E 2 votes
50%
F
50%
G 1 votes
50%
Discussions
0/ 1000
Question 4
Choose two. Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases?
A.
It does not require the setup wizard.
B.
It can be used to install and upgrade Oracle Database for single-instance and cluster configurations.
C.
It can be used for both Oracle Database and Oracle Grid Infrastructure installation.
D.
It uses a single RPM that automatically extracts and installs the Oracle Database software.
E.
It can only install and configure Oracle Database software. The database has to be created separately.
Answer:
C, E
User Votes:
A
50%
B 2 votes
50%
C 2 votes
50%
D
50%
E 1 votes
50%
Discussions
0/ 1000
Question 5
Choose two. Which two are true about an RPM-based Oracle Database installation?
A.
It includes the Oracle Preinstallation RPM.
B.
From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.
C.
It requires an Unbreakable Linux Network (ULN) subscription.
D.
It performs a software-only Oracle Database installation.
E.
It uses a service configuration script to create a single-instance database as part of the installation.
Answer:
B, D
User Votes:
A
50%
B 2 votes
50%
C
50%
D 2 votes
50%
E
50%
Discussions
0/ 1000
Question 6
Choose two. Your database is in ARCHIVELOG mode and you plan to use Flashback Database. Which two features or parameters manage space availability in the fast recovery area?
A.
the backup retention policy
B.
the backup optimization policy
C.
the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
D.
the archived log deletion policy
E.
the DB_RECOVERY_FILE_DEST parameter setting
F.
using guaranteed UNDO retention
Answer:
A, D
User Votes:
A 2 votes
50%
B
50%
C
50%
D 2 votes
50%
E
50%
F
50%
Discussions
0/ 1000
Question 7
Choose three. Which three are true about Recovery Manager (RMAN) active database duplication?
A.
Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.
B.
Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.
C.
Pre-existing backups of the database to be duplicated are always used if they exist.
D.
Image copies can be used to duplicate the active database.
E.
The active database must be duplicated while in OPEN state.
F.
No connection to the recovery catalog is required for active database duplication.
G.
Backup sets can be used to duplicate the active database.
Answer:
D, F, G
User Votes:
A
50%
B
50%
C
50%
D 2 votes
50%
E 1 votes
50%
F 2 votes
50%
G 3 votes
50%
Discussions
0/ 1000
Question 8
Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle container database from an older release. 2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. A priority list UpgrdList has these entries: 1, pdb2 2, pdb1, pdb3 You execute this command: $ /u01/app/oracle/product/18.1.0/ db_1/rdbms/admin/dbupgrade -L UpgrdList In which order will the upgrade occur?
A.
CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4
B.
CDB$ROOT, PDB2, PDB1, and PDB3
C.
CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3
D.
CDB$ROOT, PDB1, PDB2, PDB3, and PDB4
E.
CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4
Answer:
A
User Votes:
A 3 votes
50%
B
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
Question 9
Choose two. Which two are true about PDB archive files?
A.
DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.
B.
They contain a PDB manifest file and all the data files in uncompressed form for a PDB.
C.
They contain all the data files only in uncompressed form for a PDB.
D.
They must be created using the DBMS_PDB package.
E.
They contain a PDB manifest file and all the data files in compressed form for a PDB.
F.
They contain all the data files only in compressed form for a PDB.
Answer:
A, E
User Votes:
A 3 votes
50%
B
50%
C
50%
D
50%
E 3 votes
50%
F
50%
Discussions
0/ 1000
Question 10
Choose two. Examine this configuration: 1. CDB1 is a container database. 2. APP1_ROOT is an application container contained in CDB1. 3. APP1_ROOT$SEED is the application seed contained in APP1_ROOT and synchronized with APP1_ROOT. 4. APP1_PDB1 and APP1_PDB2 are application PDBs contained in APP1_ROOT. 5. APP1_USER_APP is an application installed in APP1_ROOT at version 1.0. 6. USER1 is a common user in APP1_ROOT and all its application PDBs, created when version 1.0 of APP1_USER_APP was installed. You execute these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> ALTER SESSION SET CONTAINER=app1_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> GRANT CREATE SESSION TO USER1; Grant succeeded. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app END UPGRADE TO '2.0'; Pluggable database altered SQL> ALTER SESSION SET CONTAINER=app1_pdb1; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app SYNC; Pluggable database altered. Which two are true?
A.
USER1 can connect to CDB1.
B.
USER1 can connect to APP1_ROOT and APP1_PDB1.
C.
USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.
D.
USER1 is defined in APP1_PDB2. E) USER1 can connect only to APP1_PDB1.
E.
USER1 can connect only to APP1_ROOT.
Answer:
B, D
User Votes:
A
50%
B 2 votes
50%
C
50%
D 2 votes
50%
E 1 votes
50%
Discussions
0/ 1000
Question 11
Choose two. Which two are true about backup encryption?
A.
The Transparent Data Encryption (TDE) keystore is backed up using RMAN.
B.
Vendor-specific media management software can be used for making encrypted RMAN backups to media.
C.
The BACKUP BACKUPSET command can encrypt and decrypt backup sets.
D.
Image copies can be encrypted.
E.
Keystore-based encryption is the default mode for RMAN backup encryption.
F.
Backup encryption can be enabled selectively for specific tablespaces.
Answer:
C, E
Explanation:
User Votes:
A
50%
B
50%
C 2 votes
50%
D
50%
E 3 votes
50%
F 1 votes
50%
Discussions
0/ 1000
Question 12
Choose three. Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?
A.
Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.
B.
After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.
C.
Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.
D.
The new extended data type capability must be enabled by running the utlrp.sql script
E.
The Oracle Application Express configuration should be updated after upgrading Oracle Database.
Answer:
A, D, E
User Votes:
A 1 votes
50%
B 1 votes
50%
C
50%
D 1 votes
50%
E 1 votes
50%
Discussions
0/ 1000
Question 13
Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. DEFAULT_SHARING is METADAT
A.
SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.
B.
SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.
C.
It will return an error because the SYNC operation is not allowed when constraints are added to common objects.
D.
It will return an error because EMP is not empty in APP_ROOT.
E.
It will return an error because EMP.SAL is empty in APP_ROOT.
Answer:
D
User Votes:
A
50%
B
50%
C
50%
D 1 votes
50%
E
50%
Discussions
0/ 1000
Question 14
Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. You execute these commands: S sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; Which is true?
A.
It will return an error because creation of a local role is not allowed in CDB$ROOT.
B.
ROLE1 will be created only in CDB$ROOT.
C.
It will return an error because common roles must start with C##.
D.
ROLE1 will be created only in CDB$ROOT and APP1_ROOT.
E.
ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.
Answer:
A
User Votes:
A 1 votes
50%
B 1 votes
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
Question 15
Choose three. You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB. Which three methods can you use?