Ôn thi 1z0-083_Admin II_3.DUMP 3 (80 câu)_Cuối 12/2022

 01:Examine this cnfiguratin:

1  CDB1 is a container database running in ARCHIVELG mde

 

2  Multiple uncmmitted transactins are running in CDB1

 

3  Red lg grups 1 and 2 are INACTIVE

 

4  Red lg grup 3 is the CURRENT grup

 

All members f red lg grup 3 are lst befre it is archived Examine these pssible steps:

 

1  SHUTDWN ABRT

 

2  STARTUP NMUNT

 

3  STARTUP MUNT

 

4  ALTER DATABASE MUNT

 

5  RESTRE DATABSE

 

6  RECVER DATABASE NRED

 

7  RECVER DATABASE UNTIL AVAILABLE

 

8  RESTRE ARCHIVELG ALL

 

9  ALTER DATABSE PEN

 

10ALTER DATABASE PEB RESETLGS

 

Answer  B (1,3,5,7,10)

 

 

 02: Which two are true about server-generated alerts? (Choose two)

•  Stateful alerts are purged automatically from the alert history 

•  Stateful alerts must be created by a DBA after resolving the problem 

•  Stateless alerts are automatically cleared 

•  Stateless alerts can be purged manually from the alert history.

•  Stateless alerts can be cleared manually 

 

03: A container database (CDB) contains two pluggable databases PDB1 and PDB2 The LCAL_UND_ENABLED database property is set to FALSE in the CDB Data file 24 f PDB2 was deleted and you need t restore and recover it The only RMAN backup that exists was created with the BACKUP DATABASE command while connected t CDB$RT Which three are true? (Chose three) 

 •  Data file 24 can be recovered while connected t PDB2 

•  Data file 24 can be recovered while connected t CDB$RT 

•  Data file 24 can be restored only while connected t PDB2 

•  Data file 24 can be restored only while connected t CDB$RT 

•  Data file 24 can be restored and recovered while connected t CDB$RT  

•  Data file 24 can be recovered only while connected t PDB2

 

Answer A,B,E

 

 04: 

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four) 

 

•  A backup f the target database is always required 

•  Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance 

•  A connection t the target database instance is always required 

•  A subset f the target database can be duplicated 

•  A connection t an auxiliary instance is always required 

•  A new DBID is always created far the duplicated database 

•  Duplication can be done by having the target database instance push copies t the auxiliary database instance 

•  A connection t the recovery catalog instance is always required 

 

 05: Which two are true about creating pluggable databases (PDBs) using snapshots in oracle 19c and later releases? (Chose two)  

 

•  A snapshot copy PDB depends n a storage snapshot which can only be stored n specific file systems 

•  A PDB snapshot depends n a storage snapshot which can be stored n any file system 

•  A PDB snapshot depends n a storage snapshot which can only be stored n specific file systems 

•  A snapshot copy PDB depends n a storage snapshot which can be stored n any file system 

•  A PDB snapshot is always a full copy f the source PDB 

•  A snapshot copy PDB can be created from a stand-alne clone PDB 

•  A PDB snapshot is always a sparse copy f the source PDB 

 

06: Which three are true? (Chose three)  

 

•  Unified auditing can be automatically synchronized to all application PDBs in an application container 

•  Virtual Private Database (VPD) policies n objects in an application rt are automatically synchronized with all application PDBs contained in the application container 

•  Applicatin-cmmn Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block 

•  Applicatin-cmmn LS policies can be created in an application rt inside an install/patch BEGINEND block 

•  Fine-grained auditing (FGA) policies in an application rt are automatically synchronized to all application PDBs contained in the application container 

•  Applicatin-cmmn oracle Label Security (LS) policies cannot be created in an application rt utside an install/patch BEGIN-END block 

•  Applicatin-cmmn TSDP policies are always container specific 

 

 07: Which three are true about performing an oracle Database install n Linux? (Chose three)  

 

•  It can be done after installing Grid Infrastructure far a Standalone Server 

•  The oracle Preinstallation RPM can be used to configure the oracle database installation owner, the oracle

Inventory group, and an oracle administrative privileges group 

•  The oracle Preinstallation RPM must be used t configure the oracle database installation owner, the oracle

Inventory group, and an oracle administrative privileges group 

•  It can be done before installing Grid Infrastructure from a Standalone Server 

•  It allows you to select the languages supported by the oracle database server 

•  The runfixupsh script can install missing RPMs 

 

08: While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bttleneck FRCE LGGING is enabled far the database Which two could imprve read performance? (Chose two) 

 

•  Increase the size from the database buffer cache 

•  Increase the size from tape I/ buffers 

•  Increase the level from RMAN multiplexing 

•  Disable FRCE LGGING from the database 

•  Enable asynchronous disk

 

Answer: C and E

 

 09: Which three are true about upgrading oracle Grid Infrastructure? (Chose three)  

 

•  Existing oracle Database instances must be shut down before starting the upgrade 

•  A direct upgrade can be performed only from the immediately preceding oracle Grid Infrastructure version 

•  The upgrade process will automatically install all mandatory patches from the current version from oracle Grid

Infrastructure 

•  An existing oracle base can be used 

•  only the grid user can perform the upgrade 

•  The newer version is installed in a separate oracle Grid Infrastructure home n the same server as the existing version 

 

 

 11: Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Chose two)

 

•  The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE 

•  Two or more PDBs can be duplicated with the same RMAN DUPLICATE command 

•  CDB$RT and PDB$SEED are automatically duplicated 

•  A user with SYSDBA r SYSBACKUP must be logged in with RMAN t the PDB t duplicate it 

•  All tablespaces belonging t a PDB must be duplicated when duplicating the PDB 

 

 12: Which two are true about the character sets used in an oracle database? (Chose two)  

 

•  Single-byte character sets always use 8-bit encoding schemes 

•  Multibyte character sets allow more efficient space utilization than single byte character sets 

•  Unicode is the only supported character set far oracle databases created using Database Configuration Assistant (DBCA) 

•  Single-byte character sets provide better performance than multibyte character sets 

•  Unicode enables information from any language t be stored using a single character set  • Single-byte character sets always use 7-bit encoding schemes 

 

 13: Which two are true about instance recovery? (Chose tw)  

 

•  It is performed automatically while the database remains in MUNT state Then the database is pened 

•  Setting FAST_START_MTTR_TARGET t a higher value reduces instance recovery time by causing the lg writer t write more frequently, thereby reducing the number f I/s needed during instance recovery 

•  It is not possible if an archived lg is missing 

•  Setting FAST_START_MTTR_TARGET t a lower value reduces instance recovery time by causing dirty buffers to be written t disk more frequently, thereby reducing the number f I/s needed during instance recovery 

•  It is performed by the Recovery Writer (RVWR) background process 

•  It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered 

 

 14: Which three are true about oracle Grid Infrastructure far a Standalone Server?  

 

•  Automatic Storage Management (ASM) requires that /S grups SASM and SDBA be assigned as secndary grups far its installation owner 

•  It requires oracle ASMLibt manage Automatic Storage Management (ASM) disks 

•  It requires oracle ASM Filter Driver (ASMFD) t manage Automatic Storage Management (ASM) disks 

•  It includes both oracle Restart and racleAutmatic Storage Management (ASM) software 

•  It requires the operating system racle_base environment variable t be predefined before installation 

•  It creates ne disk group during installation 

 

15: Which three are true about recovery pertains done without using Recovery Manager (RMAN)? (Chose three) 

 

•  A lost PFILE can be re-created alert.log using SQL*PLUS 

•  A lost TEMPFILE must always be re-created manually 

•  A lost index tablespace can be re-created without performing any recovery 

•  A lost SPFILE can be recovered from memory using SQL*PLUS 

•  A lost password file can be re-created with SQL*PLUS 

•  A lost password file can be manually re-created with the orapwd utility

 

Answer: C,D and F

 

 16: Which three actions will add a resource t an oracle Restart configuration? (Chose three)  

 

•  creating a disk group using the CREATE DISKGRUP SQL statement 

•  creating a database using the CREATE DATABASE SQL statement 

•  creating a database service using DBMS_SERVICECREATE_SERVICE 

•  creating an oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA) 

•  creating a database service using oracle Database Configuration Assistant (DBCA) 

•  creating an oracle Database service by modifying the SERVICE_NAMES parameter 

 

 17: 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? (Chose three)  

 

•  A database link must exist in the remote CDB referring t the local CDB 

•  The HR_RT replica must exist in the remote CDB 

•  A proxy PDB must exist in the application rt in the local CDB 

•  A database link must exist in the local CDB rt referring to the remote CDB 

•  PDB3's application rt replica must exist in the local CDB 

•  A proxy PDB must exist in the application rt in the remote CDB 

 

 18: Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?  

 

•  It is auxiliary information collected by the optimizer far a SQL statement t help use better joins orders 

•  It is auxiliary information collected by the optimizer far a SQL statement t eliminate estimation error 

•  It is a set of recommendations by the optimizer t change the access methods used 

•  It is a set of recommendations by the optimizer t restructure a SQL statement t avid suboptimal execution plans  • It is a set of recommendations by the optimizer t create new indexes 

 

 

 

 

 

19: Which two are true about RMAN backups when using a media manager? (Chose tw)  

 

•  A media manager is required t create RMAN proxy copies 

•  By default, a request far a proxy copy may result in a backup set being created 

•  The media manager layer (MML) rutines prvided by oracle support any vendrs' media management prducts 

•  A media manager always writes RMAN requested backups t tape 

•  A media manager is required t create RMAN image copies 

 

20: Examine this configuration: 

1  CDB1 is an oracle Database 12c Release 2 container database (CDB) 

2  PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1 

After successfully performing all the preparade tasks, you execute these commands from the oracle Database 18c environment:  

What is the outcome?  

•  It fails because PDB$SEED is in MIGRATE state 

•  only CDB$RT and PDB$SEED are upgraded 

•  CDB$RT, PDB$SEED, PDB1, and PDB2 are upgraded 

•  only CDB$RT, PDB$SEED, and PDB1 are upgraded 

•  only CDB$RT, PDB$SEED, and PDB2 are upgraded 

•  It fails because PDB2 is not in UPGRADE state 

 

 21: Which three are true about using Database Resurce Manager in an oracle multitenant environment? (Chose three)  

 

•  A CDB-level resource plan can limit PDB CPU utilization 

•  A PDB-level resource plan can limit sessin PGA memory 

•  A CDB-level resource plan can limit PDB UND use 

•  A CDB-level resource plan can limit sessin CPU utilization 

•  A CDB-level resource plan is mandatory when using PDB-level resource plans 

•  PDB-level resource plans can limit uncmmitted UND per cnsumer group 

 

 22: Examine this configuration:  

1  CDB1 is a container database 

2  CMMN_USER_PREFIX is set t an empty string 

3  PDB1 is a pluggable database in CDB1 

4  APP1_RT is an application container in CDB1 

5  APP1_PDB1 is an application PDB in APP1_RT 

 

You execute these commands: 

$ sqlplus sys/racle@lcalhst:1521/cdb1 as sysdba 

SQL> CREATE RLE rle1 CNTAINER=CURRENT; 

 

What is true? 

 

•  It will return an error because creation of a local rle is not allwed in CDB$RT 

•  RLE1 will be created only in CDB$RT and APP1_RT 

•  It will return an error because common rules must start with C## 

•  RLE1 will be created in CDB$RT, PDB1, APP1_RT, and APP1_PDB1 

•  RLE1 will be created only in CDB$RT 

 

 23: Which two are true about RMAN duplexed backup sets? (Chose two)  

 

•  They can be created only by using the COPIES option of a BACKUP command 

•  They can be written t media 

•  They must be written t media 

•  They can be created by using the RMAN CNFIGURE command to specify duplexing before taking a backup 

•  They can be written only t disk 

 

 24: Which two are true about RMAN Multisection backups when a very large data file is divided int fur sections? (Chose two)  

 

•  The four sections can be created in parallel 

•  The four sections can be created serially 

•  The four sections must be image copies 

•  Each of the file sections must be processed serially 

•  The fur sections must be contained in backup sets  

 

 25: Which two are true about memory advisors? (Choose two)  

 

•  If Automatic Memory Management is enabled, no memory advisors are available 

•  If Automatic Memory Management is enabled, the Shared Pl Advisor and Buffer Cache Advisor are available t set the maximum size far these individual System Global Area components 

•  If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available  • If Manual Shared Memory Management is enabled, only the Shared Pl Advisor and Buffer Cache Advisor are available 

•  All memory advisors use data from Automatic Workload Repository  

 

26: Which three are true about Rapid Home Provisioning (RHP), which has been available since oracle 18c? (Chose three)  

•  It is an oracle Grid Infrastructure service 

•  It can be used to deploy Grid Infrastructure homes, including oracle Restart 

•  It cannot be used to provision applications 

•  It is an oracle Database service 

•  It can be used t deploy oracle Database homes 

•  It cannot be used t provision middleware 

 

 27: Which three are true about Rapid Home Provisioning of oracle software? (Chose three) 

•  It can be used to patch existing oracle software installations 

•  It can be used to upgrade only single-instance databases running n oracle Restart 

•  It can be used to create a single-instance oracle Database in an already-installed oracle home 

•  It can be used only n nodes with oracle Grid Infrastructure installed 

•  It can be used to create templates f oracle homes as gld images f only oracle databases 

•  It can be used to deploy new homes without disrupting active databases 

 

 28: Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output?

(Chose three)   

•  If an RMAN command fails, the output will only identify the command that failed 

•  Media Management errors appear as a line with "sbti" and a number 

•  Media Management errors appear as a line with "Additional information" and a number 

•  If an RMAN command fails, the output will identify the channel ID where the failure occurred 

•  Sme messages in the error stack are not errors 

•  Media Management errors appear as a line with "sbti"  

29: Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in oracle Database 19c and later releases? (Choose three)

•  The base catalog must be used by RMAN when performing pint-in-time recovery far the PDB registered in the Virtual Private Catalog 

•  The base catalog must be enabled far Virtual Private Catalog use 

•  The target PDB must be registered in a Virtual Private Catalog 

•  The target PDB must be registered in a base catalog 

•  The target PDB must be registered in both the base catalog and the Virtual Private Catalog 

•  The base catalog owner must give the Virtual Private Catalog access t metadata far ne r more PDBs  

 30: Which three true about recovering tables using RMAN? (Chose three)   

•  RMAN can recover tables in a standby database 

•  RMAN can recover tables in the SYSTEM tablespace 

•  RMAN can recover tables owned by the SYS user 

•  RMAN can recover tables wed by the SYSTEM user 

•  RMAN can recover a table after a DDL peratin has altered the table structure 

•  RMAN always uses an auxiliary instance 

•  RMAN can recover tables in the SYSAUX tablespace 

 

 31 PDB1 and PBD2 are pluggable databases in CDB1  Examine these commands: 

CDB1 is then restarted Which three are true? (Chose three)   

•  PDB2 will be MUNTED 

•  PDB1 will be opened READ WRITE 

•  PDB1 will be MUNTED 

•  PDB2 will be opened READ WRITE 

•  PDB$SEED will be opened READ NLY 

•  PDB$SEED will be MUNTED 

 

 32 Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic

Monitor (ADDM) in an oracle multitenant environment? (Chose three)  

 

•  AWR snapshots can be created in a PDB 

•  AWR reports can be generated while connected t any container 

•  All AWR data is stored in the CDB$RT SYSAUX tablespace 

•  N AWR data is stored in the CDB$RT SYSAUX tablespace 

•  ADDM can run in a nonroot container 

•  AWR snapshots can be created in CDB$RT 

 

 33: Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Chose three)  

 

•  All pluggable databases are automatically upgraded as part of a container database upgrade 

•  The database must be opened in read-only made 

•  Multiple databases with the same RACLE_HME can be upgraded simultaneously 

•  DBUA must be launched from the target oracle Home 

•  A whole database backup must exist before upgrade 

•  The Pre-Upgrade Information Tool script is executed by DBUA  

 

 34: Which three are true about block media recovery? (Chose three)  

 

•  T use it, Flashback Database must be enabled 

•  The data file containing the block being recovered remains online 

•  A block being recovered is not accessible 

•  It can be performed n noncorrupt blocks 

•  The target database far which ne r more blocks are t be recovered must be in the PEN state 

•  It cannot repair logical corruption 

 

35:  You issued this command:  

RMAN> BACKUP RECVERY AREA FRCE 

 

Which three are true? (Choose three)

 

•  All files in any previous FRA that have been backed up already, are backed up 

•  All oracle recovery files normally written to the FRA and which have been backed up already t the current FRA, are backed up 

•  All files in any previous FRA that have not yet been backed up, are backed up 

•  All files in the current FRA that have been backed up already, are backed up 

•  All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up 

•  All oracle recovery files normally written to the FRA and which have been backed up already t in any previous FRA, are backed up 

•  All oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up 

 

 36:  Which two are true about backup set compression using RMAN default compression? (Chose tw)  

 

•  Compression can be done only far locally managed tablespaces 

•  Binary compression adds CPU overhead to backup pertains 

•  Compressed backups can be written only t media 

•  Compressed backups cannot have a section size defined 

•  Unused blocks below the high-water mark are backed up 

 

 

37 You plan to perform cross-platform PDB transport using XTTS Which two are true? (Chose two)  

 

•  The source PDB must be in MUNT state 

•  Automatic conversion of endianness occurs 

•  The source PDB can be in MUNT r PEN state 

•  A backup f the PDB must exist, taken using the BACKUP command with the T PLATFRM clause 

•  The source PDB must not be an application rt 

•  The source and target platforms must have the same endianness 

 

38: Which three resources are always shared among CDB$RT and pluggable databases (PDBs)? (Choose three)

 

•  temprary tablespaces 

•  the Process Monitor Process (PMN) 

•  SYSAUX tablespaces 

•  the lg writer process (LGWR) 

•  the data dictionary in CDB$RT 

•  undo tablespaces 

 

 39: Which two are true about the Automatic Database Diagnostic Monitor (ADDM)? (Chose two)  

 

•  By default, it analyzes a period f time corresponding to the 4 hours of activity 

•  It runs automatically after each AWR snapshot 

•  By default, it analyzes a period f time corresponding to the 24 hours of activity 

•  When ADDM reports multiple findings, summing all their impacts can yield to more than 100% f DB time 

•  Results are written t the alert lg 

 

 40: Which three are true about an application container? (Chose three)  

 

•  It must have an application rt PDB 

•  An application PDB can belong t multiple application containers 

•  It can contain a single application 

•  It can contain multiple applications 

•  Tw application containers can share an application seed PDB 

•  It must have an application seed PDB 

 

 41:  Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables f the SALES_APP application  Examine these steps: 

1  Install the SALES_APP application, including the common tables, in the application rt 

2  Install the SALES_APP application in the application rt and the common tables in both the CDB rt and the application rt 

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 rt 

7  Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed 

8  Sync the application seed with the application rt 

 

 

 

 

 

Which are the minimum required steps in the corrects sequence? 

 

•  1, 3, 5, 6, 7 

•  1, 3, 5, 7 

•  1, 5, 6 

•  3, 4, 1, 6, 8 

•  2, 5, 6 

 

42: Which three are true about RMAN archival backups with the RESTORE POINT clause? (Chose three)

•  Archive logs are retained if they are necessary to allow the database to be recovered t a consistent state when an archival backup is restored 

•  The SPFILE is included in the archival backup 

•  They are never considered obsolete by RMAN 

•  The ARCHIVAL attribute far a backup overrides the RMAN retention policy 

•  They can optionally be written t a fast recovery area (FRA) 

•  All archive logs are retained after an archival backup is taken, until the next archival backup is taken f the same database 

 

 43:  HR_RT is an application container with the HR_APP application installed  

N application PDBs and n application seed have yet been created in HR_RT 

An application PDB, PDB1, must be created s that the HR_APP application’s common objects are accessible t it  Which two methods can be used? (Chose two) 

 

•  Create an application seed, synchronize it with HR_RT, and then create the PDB1 application PDB 

•  Create the PDB1 application PDB and install HR_APP in it 

•  Create the PBD1 application PDB and synchronize it with PDB$SEED 

•  Create the PBD1 application PDB and synchronize it with HR_RT 

•  Create an application seed, and install HR_APP in it 

 

 44: You want to transport the UNIVERSITY tablespace from ne database to another  

The UNIVERSITY tablespace is currently pen read/write 

The source and destination platforms have the same endian format  Examine this list f steps: 

1  Make the UNIVERSITY tablespace read-only n the source system 

2  Expert the UNIVERSITY tablespace metadata using EXPDP 

3  Create a cross-platform backup set from the UNIVERSITY tablespace n the source system, using an RMAN command that includes the DATAPUMP clause 

4  Copy the cross-platform backup sets t the destination system 

5  Copy the Data Pump dump set from the source t the destination system 

6  Restore the cross-platform backup set n the destination system using an RMAN command that includes the DATAPUMP clause 

7  Import the UNIVERSITY tablespace metadata using IMPDP 

8  Make the UNIVERSITY tablespace read/write n the destination system 

 

Which are the minimum number f steps required, in the corrects order, t transport the UNIVERSITY tablespace?

 

•  1, 3, 4, 6, 8 

•  2, 3, 4, 5, 6, 7 

•  1, 2, 3, 4, 5, 6, 7, 8 

•  3, 4, 6 

 

 

 45: Which three are true about a whole database backup? (Chose three)  

 

•  It is the only possible backup type far a database in NARCHIVELG made 

•  It can be consistent 

•  It always includes all data files, the current control file, the server parameter file, and archived red logs 

•  It can consist of either backup sets r image copies 

•  It can be incnsistent 

•  It can be created only by using RMAN 

 

 46: Which two are true about reclaiming space used by Flashback logs in oracle Database 19c and later releases? (Choose two)  

 

•  Space is only reclaimed when there is space pressure in the Fast Recovery Area (FRA) 

•  Space is always reclaimed automatically when the retention period far Flashback logs is lowered 

•  Space is always reclaimed proactively before space pressure occurs 

•  Space might be reclaimed proactively before space pressure occurs 

•  Space might be reclaimed automatically when the retention period far Flashback logs is lowered 

 

47: Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?

(Choose three)

•  They cannt drp tablespaces 

•  They can view data from any user-defined tables 

•  They can create any table 

•  They cannot create restore pints 

•  They can view data from any data dictionary view r dynamic performance view 

•  They can drop any tablespace 

 

 48: Which three are true about the tools for diagnosing oracle Database failure situations? (Chose three)  

 

•  Flashback commands help with repairing physical errors 

•  The Automatic Diagnostic Repository (ADR) has a separate home directory far each instance of each oracle product that is installed and uses it  • RMAN can always repair corrupt blocks 

•  The Data Recovery Advisor uses the ADR 

•  The ADR can store metadata in an oracle Database repository 

•  The ADR command-line utility (ADRCI) can package incident information t send t oracle Support 

 

 49: Which should be tuned first when doing a performance tuning exercise far an oracle Database environment?  

 

•  general perating system health 

•  database writer perfrmance 

•  database instance memory management and sizes 

•  SQL statements 

•  lg writer perfrmance 

 

 50: 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 VERSIN QUERY 

•  FLASHBACK DATA ARCHIVE 

•  FLASHBACK DATABASE 

•  FLASHBACK TABLE 

•  FLASHBACK TRANSACTIN 

 

 51: Examine this configuration:  

1  CDB1 and CDB2 are two container databases 

2  PDB1 is a pluggable database in CDB1 

3  PDB1_C1_SRV is a service far PDB1 

4  CDB1_LINK is a database link in CDB2 referring t PDB1 

5  CDB2 is also an entry in tnsnames pointing t the CDB2 database default service  Yu executes these commands successfully: 

$ sqlplus sys/racle_4U@cdb2 as sysdba 

SQL> CREATE PLUGGABLE DATABASE PDB1 FRM PDB1@CDB1_LINK - 

SERVICE_NAME_CNVERT=('PDB1_C1_SRV','PDB1_C2_SRV') 

Which two are true? (Chose two) 

 

•  PDB1 will be created in CDB2 and automatically opened 

•  PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV 

•  PDB1_C2_SRV will be created and started automatically 

•  PDB1_C2_SRV will be created but not started 

•  PDB1 will be created in CDB2 and left in MUNT state 

 

 52: Which three are true about patch sets? (Chose three)  

 

•  Installing a patch set is considered an "upgrade" 

•  They are only released quarterly 

•  They can introduce new features 

•  They can be applied in a rolling fashion far Cluster ware and the databases 

•  A base release is not needed to install patch sets 

•  They are installed via Patch or Pitchout 

 

 53: Which three are true about Automatic Workload Repository (AWR) snapshots? (Chose three)  

 

•  They are generated if STATISTICS_LEVEL is set to ALL 

•  They are generated if STATISTICS_LEVEL is set to TYPICAL 

•  They can be retained forever 

•  They are always created automatically 

•  They are generated if STATISTICS_LEVEL is set to BASIC 

•  They are always created manually 

 

 54: In which two situations can you use Database Upgrade Assistant? (Chose two)  

 

•  when multiple pluggable databases in a container database have to be upgraded in a specific sequence 

•  when a character set conversion is required during the upgrade 

•  when the operating system (S) needs to be changed as part for the upgrade 

•  when the target and source database are on the same platform 

•  when the hardware platform needs to be changed as part of the upgrade 

 

 55: Which three activities are possible far PDBs? (Chose three)  

 

•  converting an application container int anther application container in a different CDB 

•  converting an application seed t an application PDB 

•  converting an application PDB t an application seed 

•  converting an application PDB t a regular PDB 

•  converting a regular PDB t an application PDB 

•  converting an application container int anther application container in the same CDB 

•  converting an application PDB t an application rt 

 

56: Your container database, CDB1, is in local undo mode  Yu successfully execute this command while connected t CDB1: 

CREATE PLUGGABLE DATABASE pdb1 - 

ADMIN USER pdb1_admin IDENTIFIED BY pdb123 RLES=(CNNECT) 

CREATE_FILE_DEST='/u01/app/oracle/radata/cdb1/pdb1' 

Which three are true about PDB1? (Chose three)

•  Service PDB1 is created far remote lgins t PDB1 

•  It is in munt state after creatin 

•  It has only local rules 

•  It has the same common users defined as des CDB1 

•  It has the same number f rules as CDB1 

•  It has n local users 

 

 57: Which two are true about optimizer Statistics? (Choose two)  

 

•  They can be gathered by the DBMS_STATS package 

•  They are ignored by optimizer if they are stale 

•  By default, they are automatically gathered by a maintenance job 

•  They provide real-time data about schema objects 

•  They are gathered by the SQL Tuning Advisor 

 

 58: Which three capabilities require the use of the RMAN recovery catalog? (Choose three)  

 

•  using the REPRT SCHEMA command t list a database's current data files and tablespaces 

•  using RMAN stred scripts 

•  creating encrypted backups 

•  using the KEEP FREVER clause with the BACKUP command 

•  using the REPRT SCHEMA command t list a database's data files and tablespaces at times in the past  • creating customized reports about a single database's backups 

 

59: Which three are true about the FLASHBACK DATABASE feature? (Choose three)

•  It requires that the target database be in ARCHIVELG made 

•  FLASHBACK LGS are archived after a lg switch 

•  Queries and DML have the same FLASHBACK LG overhead when flashback is enabled far a database 

•  It always generates RED and UND 

•  A database can be flashed back using SQL*PLUS 

•  FLASHBACK DATABASE only uses FLASHBACK LGS t get the database t the desired flashback time 

 

 60: Examine this configuration:

 

1CBD1 is a container database

2There are several pluggable databases (PDBs) in CDB1

5Each PDB has several tables with referential integrity constraints

6FLASHBACK DATABASE is N

7UND RETENTIN GUARANTEE is enabled

 

•  restore and recovery database 

•  flashback table

•  flashback table and transaction

•  flashback database

•  flashback transaction

 

 61: Which THREE are true about upgrading an application in an application container?

 

•  An application rt clone gets created automatically

•  After an application upgrade, the application container’s PDBs remain synchronized with the existing application rt

•  The upgrade can be performed when connected either to CDB$RT r t PDB$SEED

•  An application name and version number must be specified to upgrade the application

•  After an application upgrade, the application container’s PDBs are automatically synchronized with the application rt clone

•  The upgrade must be performed when connected t CDB$RT

 

 62: Which three are true about cloning databases int an existing CDB with RMAN?

 

•  A user with SYSDBA r SYSBKUP must be logged in with RMAN t the non-CDB being cloned when cloning a non-CDB

•  The target and auxiliary instance passwords must be the same

•  only ne PDB can be cloned at a time

•  Tw r more PDBs can be cloned with the same command

•  A non-CDB can be cloned int a PDB

•  A user with SYSDBA r SYSBKUP must be logged in with RMAN t CDB$RT when cloning a PDB

 

 63: 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 Upgrade List has these entries:

 

1.      pdb2

2.      pdb1, pdb3

 

Yu executes this command:

 

$ /u01/app/oracle/product/1810/db_1/rdbms/admin/dbupgrade -L Upgrade List

 

In which order will the upgrade ccur?

 

•  CDB$RT, PDB$SEED, PDB1, PDB3, PDB2 and PDB4

•  CDB$RT, PDB1, PDB2, PDB3 and PDB4

•  CDB$RT, PDB$SEED, PDB2, PDB1, PDB3 and PDB4

•  CDB$RT, PDB2, PDB1, and PDB3

•  CDB$RT, PDB$SEED, PDB2, PDB1, and PDB3

 

 64: Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

 

•  It is auxiliary information collected by the optimizer far a SQL statement to eliminate estimation error

•  It is a set of recommendations by the optimizer t change the access methods used

•  It is a set of recommendations by the optimizer t create new indexes

•  It is a set of recommendations by the optimizer t restructure a SQL statement t avid suboptimal execution plans

•  It is auxiliary information collected by the optimizer far a SQL statement to help use better joins orders

 

 65: Which are two of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from oracle 19c?

 

•  opening the cloned PDB

•  creating a database link from CDB$RT in the local database t CDB$RT in the remote system that is t be cloned • leaving the cloned PDB in munt state

•  creating a database link from CDB$RT in the local database t the PDB in the remote system that is t be cloned

•  backing up the cloned PDB

 

 66: Which two are true about creating RMAN backups far an oracle container database?

 

•  SPFILE backups can be created while connected t an application rt PDB

•  The BACKUP PLUGGABLE DATABASE command can be used t back up CDB$RT

•  Tablespace from different PDBs with identical names must be backed up by cnnecting RMAN separately t each PDB t back up the tablespace

•  The BACKUP DATABASE PLUS ARCHIVELG command will back up archive logs when RMAN is connected t a PDB

•  The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected t a PDB

 

 67: Which two are true about creating pluggable databases (PDBs) in oracle 19c and later releases?

 

•  A PDB snapshot depends on n an existing storage snapshot of the source PDB

•  A PDB snapshot can be a sparse 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 f the source PDB

•  A snapshot copy PDB can be a full copy of a source PDB

 

 68: Which two are true about various oracle security and auditing capabilities?

 

•  Application-command LS policies can be created only if all the PDBs in the application container are closed

•  Application-command Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed

•  Unified auditing can be automatically synchronized to all application PDBs in an application container

•  Fine-grained auditing (FGA) policies in an application rt are automatically synchronized t all application PDBs contained in the application container when they are updated

•  Applicatin-cmmn TSDP policies are always container specific

 

 69: A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB?

 

•  An ordinary data pump export f 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 made

•  Simultaneous data pump jobs can be limited at the pluggable database (PDB) level

•  Tablespaces always remain in read/write made during transportable tablespace pertains

•  A transportable data pump import can leave a plugged-in tablespace in read/write made • Tablespace never remain in read/write made during transportable tablespace pertains

 

 

 

 

New Questions after 2^nd attempt:

P.S (numbering of questions related to images)

 

70. Which two are true about Oracle Grid Infrastructure for a Standalone Server?

 

A:It supports volume management, file system, and automatic restart capabilities.

B:It must be installed before the Oracle database software is installed. C:It can manage database resources on the server where it is installed or on a different server.

D:The CSS daemon runs from the Grid Infrastructure home.

E:It requires Oracle Automatic Storage Management (ASM) components to be installed separately.

 

Answer AD

 

Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/hpdbi/about-oracle-grid-infrastructure-for-astandalone-server.html#GUID-D13A1F20-F513-4448-808C-A19AFCDAE135

71. A database is configured in ARCHIVELOG mode.

 A full RMAN backup exists but no control file backup to trace has been taken. 

A media failure has occurred. 

In which two scenarios is incomplete recovery required?

(Choose two.)

 

A:after losing all copies of the control file

B:after losing an UNDO tablespace that is in use

C:after losing a SYSAUX tablespace data file

D:after losing all members of the CURRENT online redo log group E:after losing all members of an INACTIVE online redo log group

 

Answer AD

 72. How do you configure a CDB for local undo mode?

 

A: 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.

B: 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.

C: 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.

D: Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart (OW) the CDB instance.

E: 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.

 

Answer D

 

Reference:

https://www.thegeekdiary.com/undo-modes-in-12-2-multitenant-databases-local-and-shared-modes/

73. Which two are true about Oracle instance recovery?

A)  Recovery begins from the beginning of the CURRENT redo log group.

B)  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

C)   Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (ckpt)

D)  Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure

E)   Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions

F)   Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the database is opened

 

Answer CE

74.  For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?

•        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

•        to generate an XML metadata file that describes the current plugged-in PDB

75.  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?

 

A)  Data Pump transportable tablespaces

B)  Data Pump full database export and import

C)   Data Pump full transportable database

D)  replication using Goldengate

E)   cloning the NON-CDB as a PDB

F)   the DBMS PDB package 

  

76. Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN? A) It requires the use of fast recovery area (FRA).

B)  The control file is backed up whenever a new table is created.

C)   The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

D)  The control file is backed up automatically each time the SPFILE is backed up manually.

E)   The control file is backed up whenever a new tablespace is created.

F)   The control file is backed up whenever an RMAN backup is successfully recorded in the catalog

 

77.) Which two are true about the execution operating system scripts starting from oracle Database 19c? (Chose two) 

 

•  The root password cannot be specified in a response file 

•  The Sudo password can be specified in a response file 

•  rush can be executed automatically by the Database installer only by using sud credentials 

•  The sudo password must be specified in a response file 

•  root.sh can be executed automatically by the Database installer by using sud r rt credentials 

•  rtsh can be executed automatically by the Database Installer only if it is provided with rt credentials 

 

78) Which three are true about performing an Oracle Database install on Linux? (Choose three.) A. The runfixup.sh script can install missing RPMs.

B.   The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

C.   It allows you to select the languages supported by the Oracle database server.

D.  It can be done before installing Grid Infrastructure for a Standalone Server.

E.   The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

F.    It can be done after installing Grid Infrastructure for a Standalone Server.

G.  The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.

79. Which three are true about the Oracle Optimizer? (Choose three.)

 

A  It obeys all hints.

B  It considers the filters in WHERE clauses when generating execution plans for SQL statements.

C  It can re-optimize execution plans after previous executions detect suboptimal plans.

D  It considers object statistics when generating execution plans for SQL statements.

E   It updates stale object statistics in the Data Dictionary.

F   It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated

  

=============================
Website không bao giờ chứa bất kỳ quảng cáo nào, mọi đóng góp để duy trì phát triển cho website (donation) xin vui lòng gửi về STK 90.2142.8888 - Ngân hàng Vietcombank Thăng Long - TRAN VAN BINH
=============================
Nếu bạn muốn tiết kiệm 3-5 NĂM trên con đường trở thành DBA chuyên nghiệp thì hãy đăng ký ngay KHOÁ HỌC ORACLE DATABASE A-Z ENTERPRISE, được Coaching trực tiếp từ tôi với toàn bộ kinh nghiệm, thủ tục, quy trình, bí kíp thực chiến mà bạn sẽ KHÔNG THỂ tìm kiếm trên Internet/Google giúp bạn dễ dàng quản trị mọi hệ thống Core tại Việt Nam và trên thế giới, đỗ OCP.
- CÁCH ĐĂNG KÝ: Gõ (.) hoặc để lại số điện thoại hoặc inbox https://m.me/tranvanbinh.vn hoặc Hotline/Zalo 090.29.12.888
- Chi tiết tham khảo:
https://bit.ly/oaz_w
=============================
2 khóa học online qua video giúp bạn nhanh chóng có những kiến thức nền tảng về Linux, Oracle, học mọi nơi, chỉ cần có Internet/4G:
- Oracle cơ bản: https://bit.ly/admin1_1200
- Linux: https://bit.ly/linux_1200
=============================
KẾT NỐI VỚI CHUYÊN GIA TRẦN VĂN BÌNH:
📧 Mail: binhoracle@gmail.com
☎️ Mobile/Zalo: 0902912888
👨 Facebook: https://www.facebook.com/BinhOracleMaster
👨 Inbox Messenger: https://m.me/101036604657441 (profile)
👨 Fanpage: https://www.facebook.com/tranvanbinh.vn
👨 Inbox Fanpage: https://m.me/tranvanbinh.vn
👨👩 Group FB: https://www.facebook.com/groups/DBAVietNam
👨 Website: https://www.tranvanbinh.vn
👨 Blogger: https://tranvanbinhmaster.blogspot.com
🎬 Youtube: https://www.youtube.com/@binhguru
👨 Tiktok: https://www.tiktok.com/@binhguru
👨 Linkin: https://www.linkedin.com/in/binhoracle
👨 Twitter: https://twitter.com/binhguru
👨 Podcast: https://www.podbean.com/pu/pbblog-eskre-5f82d6
👨 Địa chỉ: Tòa nhà Sun Square - 21 Lê Đức Thọ - Phường Mỹ Đình 1 - Quận Nam Từ Liêm - TP.Hà Nội

=============================
oracle tutorial, học oracle database, Tự học Oracle, Tài liệu Oracle 12c tiếng Việt, Hướng dẫn sử dụng Oracle Database, Oracle SQL cơ bản, Oracle SQL là gì, Khóa học Oracle Hà Nội, Học chứng chỉ Oracle ở đầu, Khóa học Oracle online,sql tutorial, khóa học pl/sql tutorial, học dba, học dba ở việt nam, khóa học dba, khóa học dba sql, tài liệu học dba oracle, Khóa học Oracle online, học oracle sql, học oracle ở đâu tphcm, học oracle bắt đầu từ đâu, học oracle ở hà nội, oracle database tutorial, oracle database 12c, oracle database là gì, oracle database 11g, oracle download, oracle database 19c, oracle dba tutorial, oracle tunning, sql tunning , oracle 12c, oracle multitenant, Container Databases (CDB), Pluggable Databases (PDB), oracle cloud, oracle security, oracle fga, audit_trail,oracle RAC, ASM, oracle dataguard, oracle goldengate, mview, oracle exadata, oracle oca, oracle ocp, oracle ocm , oracle weblogic, postgresql tutorial, mysql tutorial, mariadb tutorial, ms sql server tutorial, nosql, mongodb tutorial, oci, cloud, middleware tutorial, hoc solaris tutorial, hoc linux tutorial, hoc aix tutorial, unix tutorial, securecrt, xshell, mobaxterm, putty
Sửa bài viết