Bandas_test

Which three are true about a whole database backup?. lt always includes all data files, the current control file, the server parameter file and archived redo logs. lt can be inconsistent. lt can be created only by using RMAN. lt is the only possible backup type for a database in NOARCHIVELOG mode. lt can be consistent. lt can consist of either backup sets or image copies.

Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output?. Media Management errors appear as a line with "sbtio" and a number. lf an RMAN command fails, the output will identify the channel ID where the failure occurred. Some messages in the error stack are not errors. Media Management errors appear as a line with "Additional information and a number". Media Management errors appear as a line with "sbtio". lf an RMAN command fails, the output will only identify the command that failed.

Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?. SQL statements. database instance memory management and sizes. general operating system health. database writer performance. Log writer performance.

- A database is configured in ARCHIVELOG mode. - Full RMAN backups are taken daily and no backup to trace has been taken of the control file. - A media failure has occurred. In which two scenarios is complete recovery possible?. after losing the SYSTEM tablespace. after losing an archived log from after the most recent backup. after losing all copies of the control file. after losing an archived log from before the most recent backup. when any archived log from, before, or after the most recent backup is corrupt.

Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?. The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog. The target PDB must be registered in a Virtual Private Catalog. The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs. The target PDB must be registered in both the base catalog and the Virtual Private Catalog. The base catalog must be enabled for Virtual Private Catalog use. The target PDB must be registered in a base catalog.

Examine this configuration: 1. CDB 1 is an Oracle Data base 12c Release 2 container database (CDB). 2. PDB 1 and PDB2 are two pluggable data bases (PDBs) in CDB 1. After successfully performing all the pre­-upgrade tasks, you execute these commands from the Oracle Database 18c environment: What is the outcome?. CDB$ROOT, PDBS$SEED, PDB1, and PDB2 are upgraded. lt fails because PDB$SEED is in MIGRATE state. Only CDB$ROOT and PDB$SEED are upgraded. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded. lt fails because PDB2 is not in UPGRADE state. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.

Which two are true about server-generated alerts?. Stateless alerts are automatically cleared after one day. Stateless alerts can be purged manually from the alert history. Stateful alerts are purged automatically from the alert history after one day. Stateless alerts can be cleared manually. Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.

Which two are true about Optimizer Statistics?. They are gathered by the SQL Tuning Advisor. They are ignored by Optimizer if they are stale. They can be gathered by the DBMS_STATS package. They provide real-time data about schema objects. By default, they are automatically gathered by a maintenance job.

A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB. A transportable data pump import can leave a plugged-in tablespace in read/write mode. Tablespaces never remain in read/write mode during transportable tablespace operations. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported. A transportable data pump import can leave a plugged-in tablespace in read-only mode. Tablespaces always remain in read/write mode during transportable tablespace operation. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

Which three are true about RMAN archival backups with the RESTORE POINT clause?. AII archive logs are retained after an archival! backup is taken, until the next archival! backup is taken of the same database. Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored. They can optionally be written to a fast recovery area (FRA). Use of a recovery catalog is always required to support the creation and use of archival backups. The SPFILE is included in the archival backup. The ARCHIVAL attribute for a backup overrides the RMAN retention policy. They are never considered obsolete by RMAN.

Which three actions will add a resource to an Oracle Restart configuration?. creating a database service using Oracle Database Configuration Assistant (DBCA). creating a database service using DBMS SERVICE.CREATE SERVICE. creating a disk group using the CREATE DISKGROUP SQL statement. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA). creating an Oracle Database service by modifying the SERVICE NAMES parameter. creating a database using the CREATE DATABASE SQL statement.

PDB 1 and PBD2 are pluggable data bases in CDB1. Examine these commands: CDB1 is then restarted. Which three are true? (Choose three.). PDB2 will be MOUNTED. PDB 1 will be opened READ WRITE. PDB$SEED will be opened READ ONLY. PDB1 will be MOUNTED. PDB$SEED will be MOUNTED. PDB2 will be opened READ WRITE.

Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?. lt cannot be used to provision applications. lt can be used to deploy Grid infrastructure homes, including Oracle Restart. lt can be used to deploy Oracle Database homes. lt is an Oracle Database service. lt cannot be used to provision middleware. lt is an Oracle Grid infrastructure service.

You plan to perform cross-platform PDB transport using XTTS. Which two are true?. The source PDB can be in MOUNT or OPEN state. Automatic conversion of endianness occurs. The source PDB must be in MOUNT state. A backup of the PDB must exist, taken using the BACKUP command with the TO PLATFORM clause. The source and target platforms must have the same endianness. The source PDB must not be an application root.

Which three are true about patchsets?. lnstalling a patchset is considered an "upgrade". A base release is not needed to install patchsets. They can be applied in a rolling fashion for Clusterware and the data bases. They are installed via OPatch or OPatchAuto. They are only released quarterly. They can introduce new features.

Which three are true about Rapid Home Provisioning of Oracle software?. lt can be used to patch existing Oracle software installations. lt can be used to create templates of Oracle homes as gold images of only Oracle databases. lt can be used to deploy new homes without disrupting active databases. lt can be used to create a single-instance Oracle Database in an already ­installed Oracle home. lt can be used to upgrade only single-instance databases running on Oracle Restart. lt can be used only on nodes with Oracle Grid infrastructure installed.

Which three are true about performing an Oracle Database install on Linux?. lt can be done after installing Grid infrastructure for a Standalone Server. lt can be done before installing Grid infrastructure for a Standalone server. lt allows you to select the languages supported by the Oracle database server. The Oracle database administrator must be granted access to the root operating system account to run root privileged scripts. The runfixup.sh script can install missing RPMs. The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle lnventory group and an Oracle administrative privileges group. The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle lnventory group, and an Oracle administrative privileges group.

How do you configure a CDB for local undo mode?. Open the CDB 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. 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, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON. Create an UNDO tablespace in each PDB, and then restart the CDB instance.

Which two are true about creating RMAN backups for an Oracle container data base?. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces. SPFILE backups can be created while connected to an application root PDB. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB. The BACKUP DATABASE PLUS ARCHIVELOG Command will back up archive logs when RMAN is connected to a PDB.

Which two are true about various Oracle security and auditing capabilities?. Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed. Application-common OLS policies can be created only if all the PDBS in the application container are closed. Application-common TSDP policies are always container specific. Unified auditing can be automatically synchronized to all application PDBS in an application container. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBS contained in the application container when they are updated.

Which two are true about RMAN backups when using a media manager?. A media manager is required to create RMAN image copies. A media manager is required to create RMAN proxy copies. By default, a request for a proxy copy may result in a backup set being created. The media manager layer (MML) routines provided by Oracle support any vendors' media management products. A media manager always writes RMAN requested backups to tape.

Which three are true about the tools for diagnosing Oracle Database failure situations?. The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support. The Data Recovery Advisor uses the ADR. RMAN can always repair corrupt blocks. The ADR can store metadata in an Oracle Database repository. The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it. Flashback commands help with repairing physical errors.

- You want to transport the UNIVERSITY tablespace from one database to another. - The UNIVERSITY tablespace is currently open read/write. - The source and destination platforms have the same endian format. Examine this list of steps: 1. Make the UNIVERSITY tablespace read-only on the source system. 2. Export the UNIVERSITY tablespace metadata using EXPDP. 3. Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an RMAN command that includes the DATAPUMP clause. 4. Copy the cross-platform backup sets to the destination system. 5. Copy the Data Pump dump set from the source to the destination system. 6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause. 7. lmport the UNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITY tablespace read/write on the destination system. Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?. 3,4,6. 2, 3, 4, 5, 6, 7. 1, 3, 4, 6, 8. 1, 2, 3, 4, 5, 6, 7, 8.

Pregunta no disponible en el PDF, solo respuestas. A lost TEMPFILE must always be re-created manually. A lost index tablespace can be re-created without performing any recovery. A lost password file can be manually re-created with the orapwd utility. A lost password file can be re-created with SQL*PLUS. A lost SPFI LE can be recovered from memory using SQL *PLUS. A lost PFILE can be re-created from alert.log using SQL *PLUS.

Which four are true about duplicating a database using Recovery Manager (RMAN)?. A connection to an auxiliary instance is always required. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance. A new DBID is always created far the duplicated database. A connection to the target database instance is always required. A backup of the target database is always required. Duplication can be done by having the target database instance push copies to the auxiliary database instance. A subset of the target database can be duplicated. A connection to the recovery catalog instance is always required.

Which two are true about Oracle Grid lnfrastructure far a Standalone Server?. The CSS daemon runs from the Grid infrastructure home. lt must be installed before the Oracle database software is installed. lt can manage database resources on the server where it is installed or on a different server. lt supports volume management, file system, and automatic restart capabilities. lt requires Oracle Automatic Storage Management (ASM) components to be installed separately.

Which two are true about the character sets used in an Oracle database?. Single-byte character sets always use 7-bit encoding schemes. Unicode enables information from any language to be stored using a single character set. Multibyte character sets allow more efficient space utilization than single byte character sets. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA). Single-byte character sets provide better performance than multibyte character sets. Single-byte character sets always use 8-bit encoding schemes.

Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?. They can create any table. They cannot create restore points. They can view data from any user-defined tables. They can drop any tablespace. They cannot drop tablespaces. They can view_ data from any data dictionary view or dynamic performance view.

Which two are true about Oracle instance recovery?. Recovery begins from the last checkpoint position that was recorded in l:!..I the control file by the checkpoint process (CKPT). Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions. Recovery begins from the beginning of the CURRENT redo log group. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the database is opened.

Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?. lt is a set of recommendations by the optimizer to create new indexes. lt is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders. lt is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans. lt is a set of recommendations by the optimizer to change the access methods used. lt is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.

Which two are true about RMAN Multisection backups when a very large data file is divided into four sections?. Each of the file sections must be processed serially. The four sections can be created serially. The four sections must be image copies. The four sections can be created in parallel. The four sections must be contained in backup sets.

Which three are true about block media recovery?. The data file containing the block being recovered remains online. lt cannot repair logical corruption. lt can be performed on noncorrupt blocks. A block being recovered is not accessible. The target database for which one or more blocks are to be recovered must be in the OPEN state. To use it, Flashback Database must be enabled.

Which two are true about duplicating pluggable databases (PDBs) with RMAN?. Two or more PDBS can be duplicated with the same RMAN DUPLICATE command. The auxiliary instance is automatically created with ENABLE PLUGGABLE DATABASE = TRUE. A user with SYSDBA or SYSBKUP must use RMAN logged in to a PDB in order to duplicate it. AII tablespaces belonging to a PDB must be duplicated when duplicating the PDB. CDB$ROOT and PDB$SEED are automatically duplicated if a PDB is duplicated.

- Your container database, CDB 1, is in local undo mode. - You successfully execute this command while connected to CDB 1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1'; Which three are true about PDB1? (Choose three.). lt has only local roles. lt has the same common users defined as does CDB1. Service PDB1 is created for remote logins to CDB1. lt is in mount state after creation. lt has no local users. lt has the same number of roles as CDB1.

Which three are true about upgrading Oracle Grid lnfrastructure?. The newer version is installed in a separate Oracle Grid lnfrastructure home on the same server as the existing version. Existing Oracle Database instances must be shut down before starting the upgrade. An existing Oracle base can be used. A direct upgrade can be performed only from the immediately preceding Oracle Grid lnfrastructure version. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid lnfrastructure. Only the grid user can perform the upgrade.

Examine this configuration: 1. CDB 1 and CDB2 are two container data bases. 2. PDB 1 is a pluggable database in CDB 1. 3. PDB1 C1 SRV is a service far PDB1. 4. CDB1 LINK is a database link in CDB2 referring to PDB1. 5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service. You execute these commands successfully: $ sqlplus sys/oracle_ 4U@cdb2 as sysdba SQL> CREATE PLUGGABLE DATABASE PDB1 FROM PDB1@CDB1_LINK SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV'); Which two are true?. PDB1_C2_SRV will be created and started automatically. PDB1 will be created in CDB2 and automatically opened. PDB1 will be created in CDB2 and left in MOUNT state. PDB1_C2_SRV will be created but not started. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.

Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?. Space is only reclaimed when there is space pressure in the Fast Recovery Area (FRA). Space is always reclaimed automatically when the retention period for Flashback logs is lowered. Space might be reclaimed proactively before space pressure occurs. Space might be reclaimed automatically when the retention period for Flashback logs is lowered. Space is always reclaimed proactively before space pressure occurs.

Examine this configuration: 1. CDB 1 is a container data base. 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. USER1 can connect to CDB1. USER1 is defined in APP1_PDB2. USER1 can connect only to APP1_PDB1. USER1 can connect to APP1 ROOT, APP1_ROOT$SEED, and PP1 PDB1. USER1 can connect to APP1_ROOT and APP1_PDB1. USER1 can connect only to APP1_ROOT.

Which three are true about cloning databases into an existing CDB with RMAN?. Only one PDB can be cloned at a time. A non-CDB can be cloned into a PDB. A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB. The target and auxiliary instance passwords must be the same. Two or more PDBS can be cloned with the same command. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.

Examine this configuration: 1. CDB1 is a container database. 2. There are several pluggable databases (PDBs) in CDB1. 5. Each PDB has several tables with referential integrity constraints. 6. FLASHBACK DATABASE is ON. 7. UNDO RETENTION GUARANTEE is enabled. Multiple undesired multi table changes were made in all the PDBs. Which method can be used to undo the changes using a single command?. restore and recover database. flashback table and transaction. flashback transaction. flashback table. flashback database.

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?. CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4. CDB$ROOT, PDB2, PDB1, and PDB3. CDB$ROOT, PDB1, PDB2, PDB3, and PDB4. CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4. CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3.

Far which two tasks can you use the DBMS_PDB.DESCRIBE procedure?. To generate an XML metadata file that describes the current plugged-in PDB. To generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB. To generate an XML metadata file from any unplugged PDB. To determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure. To generate a .pdb archive file for any PDB in the current CDB.

Examine this configuration: 1. CDB1 is a container data base. 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: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; What is true?. ROLE1 will be created only in CDB$ROOT. ROLE1 will be created only in CDB$ROOT and APP1_ROOT. ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1 PDB1. lt will return an error because common roles must start with C#. It will return an error because creation of a local role is not allowed in CDB$ROOT.

Which three activities are possible for PDBs?. converting an application PDB to an application root. copying an application container into another application container in a different CDB. converting an application PDB to a regular PDB. converting an application PDB to an application seed. copying an application container into another application container in the same CDB. converting an application seed to an application PDB. converting a regular PDB to an application PDB.

A schema owner truncated a table in error and must recover the data. Which Oracle Flashback feature could be used to recover the data?. FLASHBACK TRANSACTION. FLASHBACK TABLE. FLASHBACK DATA ARCHIVE. FLASHBACK DATABASE. FLASHBACK VERSION QUERY.

Which two are true about RMAN duplexed backup sets?. 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 must be written to media. They can be written to media. They can be written only to disk.

Which three are true about the Oracle Optimizer?. lt obeys all hints. lt can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated. lt considers the filters in WHERE clauses when generating execution plans for SQL statements. lt can re-optimize execution plans after previous executions detect suboptimal plans. lt considers object statistics when generating execution plans far SQL statements. lt updates stale object statistics in the Data Dictionary.

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?. AWR snapshots can be created in a PDB. AWR reports can be generated while connected to any container. AII AWR data is stored in the CDB$ROOT SYSAUX tablespace. AWR snapshots can be created in CDB$ROOT. ADDM can run in a non-root container. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Which three are true about an application container?. lt can contain multiple applications. lt can contain a single application. Two application containers can share an application seed PDB. lt must have an application seed PDB. An application PDB can belong to multiple application containers. lt must have an application root PDB.

Which are two of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?. backing up the cloned PDB. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned. opening the cloned PDB. leaving the cloned PDB in mount state.

The HR ROOT application container must support the execution of a query on a table shared by application local PDBS PDB1 and PDB2, and remote PDB PDB3. Which three are true?. A proxy PDB must exist in the application root in the local CDB. A proxy PDB must exist in the application root in the remote CDB. The HR ROOT replica must exist in the remote CDB. A database link must exist in the local CDB root referring to the remote CDB. A database link must exist in the remote CDB referring to the local CDB. PDB3's application root replica must exist in the local CDB.

Which two are true about backup set compression using RMAN default compression?. Compressed backups cannot have a section size defined. Compression can be done only for locally managed tablespaces. Compressed backups can be written only to media. Binary compression adds CPU overhead to backup operations. Unused blocks below the high water mark are backed up.

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level O backup is a bottleneck. FORCE LOGGING is enabled for the database. Which two could improve read performance?. lncrease the level of RMAN multiplexing. Disable FORCE LOGGING far the database. lncrease the size of tape 1/0 buffers. Enable asynchronous disk 1/0. Increase the size of the data base buffer cache.

Which two are true about creating pluggable databases (PDBS) in Oracle 19c and later releases?. A PDB snapshot depends on an existing storage snapshot of the source PDB. A snapshot copy PDB can be a full copy of a source PDB. A PDB snapshot can be a full copy of a source PDB. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB. A PDB snapshot can be a sparse copy of a source PDB.

- HR_ROOT is an application container with the HR_APP application installed. - No application PDBs and no application seed have yet been created in HR ROOT. - An application PDB, PDB1, must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?. Create the PDB1 application PDB and synchronize it with PDB$SEED. Create an application seed and install HR APP in it. Create the PDB1 application PDB and synchronize it with HR_ROOT. Create an application seed, synchronize it with HR_ROOT and then create the PDB1 application PDB. Create the PDB1 application PDB and install HR APP in it.

A container database (CDB) contains two pluggable databases PDB1 and PDB2. The LOCAL UNDO ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it. The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT. Which three are true?. Data file 24 can be recovered only while connected to PDB2. Data file 24 can be restored only while connected to PDB2. Data file 24 can be recovered while connected to PDB2. Data file 24 can be restored and recovered while connected to CDB$ROOT. Data file 24 can be recovered while connected to CDB$ROOT. Data file 24 can be restored only while connected to CDB$ROOT.

Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database?. AII pluggable databases are automatically upgraded as part of a container database upgrade. The database must be opened in read-only mode. Multiple databases with the same ORACLE HOME can be upgraded simultaneously. A whole database backup must exist before upgrade. DBUA must be launched from the target Oracle Home. The Pre-Upgrade lnformation Tool script is executed by DBUA.

Which two are true about the execution of operating system scripts starting from Oracle Database 19c?. root.sh can be executed automatically by the Database installer only by using sudo credentials. The sudo password must be specified in a response file. orainstRoot.sh can be executed automatically by the Database installer by using sudo of root credentials. root.sh can be executed automatically by the Database installer only if is provided with root credentials. The root password cannot be specified in a response file.

Which three capabilities require the use of the RMAN recovery catalog?. using the REPORT SCHEMA Command to list a database's current data files and tablespaces. creating encrypted backups. using the KEEP FOREVER clause with the BACKUP command. creating customized reports about a single database's backups. using the REPORT SCHEMA Command to list a database's data files and tablespaces at times in the past. using RMAN stored scripts.

Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?. the data dictionary in CDB$ROOT. undo tablespaces. the log writer process (LGWR). temporary tablespaces. the Process Monitor Process (PMON). SYSAUX tablespaces.

Which two are true about the Automatic Database Diagnostic Monitor (ADDM)?. lt runs automatically after each AWR snapshot. Results are written to the alert log. When ADDM reports multiple findings, summing all their impacts can yield to more than 100% of DB time. By default, it analyzes a period of time corresponding to the last 24 hours of activity. By default, it analyzes a period of time corresponding to the last 4 hours of activity.

Which three are true about using Database Resource Manager in an Oracle multitenant environment?. A CDB-level resource plan is mandatory when using PDB-level resource plans. PDB-level resource plans can limit uncommitted UNDO per consumer group. A CDB-level resource plan can limit PDB UNDO use. A CDB-level resource plan can limit session CPU utilization. A CDB-level resource plan can limit PDB CPU utilization. A PDB-level resource plan can limit session PGA memory.

Examine this configuration: 1. CDB1 is a container database running in ARCHIVELOG mode. 2. Multiple uncommitted transactions are running in CDB1. 3. Redo lag groups 1 and 2 are INACTIVE. 4. Redo lag group 3 is the CURRENT group. AII members of redo lag 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 UNTILAVAILABLE 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,10. 1, 3, 5, 8, 6, 10. 1,2,5,7,4,10. 1, 3, 5, 6, 9. 1,3,5,6,10. 1,3,5, 7, 10.

You issued this command: RMAN> BACKUP RECOVERY AREA FORCE; Which three are true?. AII files in the current fast recovery area (FRA) that have not yet been backed up, are backed up. AII files in the current FRA that have been backed up already, are backed up. AII Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up. AII Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up. AII files in any previous FRA that have been backed up already, are backed up. AII Oracle recovery files normally written to the FRA and which have not yet been backed, are backed up. AII files in any previous FRA that have not yet been backed up, are backed up.

Which three are true about Automatic Workload Repository (AWR) snapshots?. They are always created automatically. They are generated if STATISTICS_LEVEL is set to ALL. They can be retained forever. They are always created manually. They are generated if STATISTICS_LEVEL is set to BASIC. They are generated if STATISTICS_LEVEL is set to TYPICAL.

In which two situations can you use Database Upgrade Assistant?. when multiple pluggable databases in a container database have to be upgraded in a specific sequence. when the target and source database are on the same platform. when the operating system (OS) needs to be changed as part of the upgrade. when the hardware platform needs to be changed as part of the upgrade. when a character set conversion is required during the upgrade.

Which two are true about memory advisors?. AII memory advisors use data from Automatic Workload Repository. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available. If Automatic Memory Management is enabled, no memory advisors are available. lf Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer. Cache Advisor are available. lf Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

Which three are true about the FLASHBACK DATABASE feature?. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database. A database can be flashed back using SQL *PLUS. lt requires that the target database be in ARCHIVELOG mode. FLASHBACK LOGS are archived after a log switch. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time. lt always generates REDO and UNDO.