Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common
tables of the SALES_APP application.
Examine these steps:
1. Install the SALES_APP application, including the common tables, in the application root.
2. Install the SALES_APP application in the application root and the common tables in both the CDB root
and the application root.
3. Create an application seed.
4. Install the SALES_APP application in the application seed.
5. Create the SALES_APP1 and SALES_APP2 application PDBs.
6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
8. Sync the application seed with the application root.
Which are the minimum required steps in the correct sequence? 3,4,1,6,8 1,5,6 1,3,5,6,7 1,3,5,7 2,5,6.
Your CDB has two regular PDBs as well as one application container with two application PDBs and an
application seed.
No changes have been made to the standard PDB$SEED.
How many default temporary tablespaces can be assigned in the CDB? three eight seven six five.
Examine this configuration:
1. CDB1 is a container database running in archivelog mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are inactive.
4. Redo log group 3 is the current group.
All members of redo log group 3 are lost before it is archived. Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABASE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABASE OPEN
10. ALTER DATABASE OPEN RESETLOGS
Choose the minimum required steps in the correct order to recover the database. 1, 3, 5, 6 1, 3, 5, 8, 6, 10 1, 3, 5, 6, 9 1, 3, 5, 6, 10 1, 2, 5, 7, 4, 10 1, 3, 5, 7, 10.
How do you configure a CDB for local undo mode? Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO
ON, and then restart the CDB instance. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO
ON, and create an UNDO tablespace in each PDB, then restart the CDB instance. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER
DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance. Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO
ON, and then change the CDB to read/write mode. Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO
ON, create an UNDO tablespace, and then restart the CDB instance.
Which three are true about an application container? (Choose three.) It can contain a single application. It can contain multiple applications. It must have an application seed PDB. It must have an application root PDB. Two application containers can share an application seed PDB An application PDB can belong to multiple application containers.
On the 10th of August, you implement an incremental database backup strategy and configure a recovery
window of five days.
Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups
are taken daily between the level 0 backups.
Today is the 26th of August.
Which backups will be obsolete? all backups prior to 10th of August all backups prior to 22nd of August all backups prior to 24th of August all backups prior to 20th of August all backups prior to 17th of August.
Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases?
(Choose two.) It can be used for both Oracle Database and Oracle Grid Infrastructure installation. It can only install and configure Oracle Database software. The database has to be created separately It does not require the setup wizard It uses a single RPM that automatically extracts and installs the Oracle Database software. It can be used to install and upgrade Oracle Database for single-instance and cluster configurations.
Which two are true about RMAN duplexed backup sets? (Choose two.) They can be written only to disk. They must be written to media. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a
backup. They can be created only by using the COPIES option of a BACKUP command. They can be written to media.
Which should be tuned first when doing a performance tuning exercise for an Oracle Database
environment? SQL statements log writer performance general operating system health database writer performance database instance memory management and sizes.
Which two are true about the automatic execution of operating system scripts when performing silent mode
installation starting from Oracle Database 19c? (Choose two.) The response file can specify the root or sudo password The installer will prompt for the root or sudo password Silent install always runs operating scripts automatically. The response file must contain the root or sudo password The response file can specify the path of the sudo program.
|
