Top Tips Of Update 1z0-083 Practice Exam

NEW QUESTION 1
A user complains about poor database performance.
You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

• A. V$SESSION_EVENT
• B. V$SESSTAT
• C. V$SESSION_WAIT
• D. V$SESSION_WAIT_CLASS
• E. V$SESSION

Answer: A

NEW QUESTION 2
Which three are true about an application seed pluggable database (PDB)? (Choose three.)

• A. It is automatically synchronized with its application root PDB when an application is upgraded.
• B. It cannot be added to an application container after the application container has already been created.
• C. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
• D. It is automatically synchronized with its application root PDB when an application is installed.
• E. It cannot be dropped from its application container.
• F. A new application PDB created by cloning an application seed PDB canhave an up-to-date version of the application installed after cloning completes.
• G. It is not required in an application container.

Answer: DFG

NEW QUESTION 3
Examine this configuration:
* 1.The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA. * 2.ORCL uses disk group +FRAfor the Fast Recovery Area.
* 3. LISTENER is the listener for ORCL.
* 4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart. 5.All components are currently shut down.
You execute this command:

What is the outcome?

• A. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENERare started.
• B. Only the ORCL database instance is started.
• C. Only the ORCL database and the ASM instances are started.
• D. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
• E. Only the ORCL database instance and the +DATA and +FRA disk groups are started.

Answer: D

NEW QUESTION 4
Which three are true about Oracle Grid Infrastructure for a Standalone Server?

• A. It includes both Oracle Restart and OracleAutomatic Storage Management (ASM) software.
• B. It creates one disk group during installation.
• C. It requires the operating system oracle_base environment variable to be predefined before installation.
• D. It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks
• E. It requires Oracle ASMLibto manage Automatic Storage Management (ASM) disks.
• F. Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installationowner.

Answer: ABD

NEW QUESTION 5
Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

• A. Media Management messages for SBT devices are always written to sbtio.log.
• B. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
• C. RMAN error stacks should be read from the top down as that is the order in which errors are generated.
• D. The RMAN LOG command line clause causes output issued during RMAN commandcompilation to bewritten to a log file and to standard output.
• E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
• F. Media Management messages for SBT devices are written to an Oracletrace file.

Answer: EF

NEW QUESTION 6
Examine this configuration:
CDB1is a container database.
COMMON_USER_PREFIXisC##.
PDB1is a pluggable database contained inCDB1.
APP1_ROOTis an application container contained inCDB1.
APP1_PDB1is an application PDB contained inAPP1_ROOT.
You execute these commands successfully:

Which two are true? (Choose two.)

• A. APP1_USER1 can be created in PDB1.
• B. APP1_USER1 can be created in CDB1.
• C. APP1_USER1 canhave different privileges in each Application PDB contained in APP1_ROOT.
• D. C##_APP_USER1 can be created in CDB1.
• E. P1_USER1 can be created in CDB1.
• F. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.

Answer: CF

NEW QUESTION 7
Which three are located by using environment variables? (Choose three.)

• A. the Optimal Flexible Architecture (OFA) compliant path to storeOracle software and configuration files.
• B. the location of Oracle Net Services configuration files
• C. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup
• D. default directories for temporary files used by temporary tablespaces
• E. the temporary disk space used by Oracle Installer during installation
• F. the maximum number of database files that can be opened by a database instance

Answer: ABE

NEW QUESTION 8
Which two are true about Oracle Flashback features? (Choose two.)

• A. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
• B. FLASHBACKVERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDOLOG files.
• C. FLASHBACK TABLE can undrop a column.
• D. FLASHBACK DROP can undrop an index when undropping a table.
• E. After a database is restored from flashback logs using the FLASHBACKDATABASE command, it is sometimes rolled forward using redo logs.

Answer: DE

NEW QUESTION 9
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

• A. A PDB snapshot is always a full copy of the source PDB.
• B. A PDB snapshot is always a sparse copy of the source PDB.
• C. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
• D. A PDB snapshot depends on a storage snapshot which can be stored on any file system.
• E. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
• F. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
• G. A snapshot copy PDB can be created from a stand-alone clone PDB.

Answer: AE

NEW QUESTION 10
Automatic Shared Memory Management is disabled for one of your database instances.
SomeSQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?

• A. Run the SQL Access Advisor.
• B. Run the Memory Advisor for the shared pool.
• C. Run the SQL Tunning Advisor.
• D. Run theMemory Advisor for the Program Global Area.
• E. Run the Memory Advisor for the System Global Area.

Answer: B

NEW QUESTION 11
Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)

• A. It is an Oracle Database service
• B. It cannot be usedto upgrade Oracle Database homes.
• C. It can be used to provision applications.
• D. It can be used to patch Grid Infrastructure homes containing Oracle Restart.
• E. It can be used to provision middleware.

Answer: DE

NEW QUESTION 12
A database is configured in ARCHIVELOG mode.
Full RMAN backups are taken 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? (Choose two.)

• A. when any archived log from, before, or after the most recent backup is corrupt.
• B. after losing all copies of the control file
• C. after losing an archived log from after the most recent backup
• D. after losing an archived log from before the most recent backup
• E. after losing the SYSTEM tablespace

Answer: DE

NEW QUESTION 13
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? (Choose three.)

• A. Data file 24 can be recovered only while connected to PDB2.
• B. Data file 24 can be restored and recovered while connected to CDB$ROOT.
• C. Data file 24 can be restored only while connected toCDB$ROOT.
• D. Data file 24 can be restored only while connected to PDB2.
• E. Data file 24 can be recovered while connected to PDB2.
• F. Data file 24 can be recovered while connected to CDB$ROOT.

Answer: BCF

NEW QUESTION 14
Which three are true? (Choose three.)

• A. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs containedin the application container.
• B. Application-common TSDP policies are always container specific.
• C. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
• D. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
• E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
• F. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-ENDblock.
• G. Unified auditing can be automatically synchronized to all application PDBs in an applicationcontainer.

Answer: ADG

NEW QUESTION 15
You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have different endian formats. Examine this list of actions:
* 1.Make the UNIVERSITY tablespace read-only on the source system.
* 2. Export the UNIVERSITY tablespace metadata using EXPDP.
* 3. Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
* 4. Copy the UNIVERSITY tablespace data files to the destination system.
* 5.Copy the Data Pump dump set to the destination system.
* 6. Convert the UNIVERSITY tablespace data files to thedestination platform format using RMAN on the destination system.
* 7. Import the UNIVERSITY tablespace metadata using IMPDP.
* 8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

• A. 1, 2, 4, 5, 7, 8
• B. 1, 2, 4, 6, 7, 8
• C. 1, 2, 3, 4, 5, 7, 8
• D. 1, 2, 3, 4, 5, 6, 7, 8
• E. 2, 4, 5, 6, 7

Answer: B

NEW QUESTION 16
Which three are true about an application container?

• A. It must have an application root PDB.
• B. It can contain multiple applications.
• C. An application PDB can belong to multiple application containers.
• D. Two application containers can share an application seed PDB.
• E. It can contain a single application.
• F. It must have an application seed PDB.

Answer: BDE

NEW QUESTION 17
How do you configure a CDB for local undo mode?

• A. Open the CDB instance in upgrade mod
• B. In cdb$root, execute alter database local undo on, and then restart the CDB instance.
• C. Open the CDB in read-only mod
• D. In cdb$root, execute alter database local undo on, and then change the CDB to read/write mode.
• E. Open the CDB instance in restricted mod
• F. In cdb$root, execute alter database local undo o
• G. create an undo tablespace in each PDB, and then restart the CDB instance
• H. Open the CDB instance in restricted mod
• I. In cdb$root, drop the undo tablespac
• J. Execute alter database local undo on in each PDB, and then restart the CDB instance.
• K. Open the CDB instance in upgrade mod
• L. In each PDB, execute alter database local undo on, create an undo tablespace, and then restart the CDB instance.

Answer: D

NEW QUESTION 18
Which four are true about RMAN backup sets? (Choose four.)

• A. A backup piece can belong to only one backup set.
• B. A data file can be split into multiple sections stored in different backup sets.
• C. A data file canbe split into multiple sections stored in different backup pieces in the same backup set.
• D. Blocks from multiple data files can be contained in one backup piece,
• E. A backup set can contain only one backup piece.
• F. A backup set must be written to media.
• G. A backup set must be written to disk.
• H. Blocks from multiple data files can be contained in one backup set,

Answer: BEFH

NEW QUESTION 19
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

• A. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
• B. It isalways possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
• C. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
• D. A Virtual Private Catalog used to registera container database can be created in a pluggable database.
• E. It is always possible for RMAN to connect to a pluggable database as a target.
• F. A Virtual Private Catalog used to register a container database can be created in a non-container database.

Answer: DEF

NEW QUESTION 20
Which two are trueabout changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

• A. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
• B. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
• C. After the change, only one undo tablespace can exist in CDB$ROOT.
• D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
• E. Undo tablespaces existing in PDBs must be dropped before the change.
• F. After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Answer: BC

Explanation:
You can set a CDB in local UNDO mode either at CDB creation or by altering the CDB property. When the database property LOCAL_UNDO_ENABLE is FALSE, which is the default, there is only one UNDO tablespace that is created in the CDB root, and that is shared by all containers. When LOCAL_UNDO_ENABLE is TRUE, every container in the CDB uses local undo and each PDB must have its own local UNDO tablespace. To maintain ease of management and provisioning, UNDO tablespace creation happens automatically and does not require any action from the user. When a PDB is opened and an UNDO tablespace is not available, its automatically created.

NEW QUESTION 21
Which two are true about unplugging an application container from a container database and plugging it into a different container database?

• A. It requires local undo mode in both container databases.
• B. It requires only local undo mode in the database where the application container will be unplugged.
• C. Plugging the application root into a different CDB plugs In all its application PDBs.
• D. Application PDBs In the application container must beunplugged before the application root Is unplugged.
• E. Unplugging the application root from a CDB unplugs all its application PDBs.
• F. The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.

Answer: DE

NEW QUESTION 22
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

• A. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
• B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMPwhen plugging in a PDB
• C. to include specific user tablespaces only when relocating a PDB
• D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
• E. to exclude a temp tablespace when plugging in a PDB
• F. to specify the list oftablespaces to include when creating a PDB from the CDB seed

Answer: BD

NEW QUESTION 23
Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

• A. It is integrated with the SQL Access Advisor.
• B. It predicts the impact of system changes on SQL workloadresponse time.
• C. It provides before and after execution statistics for each SQL statement in the analysis task
• D. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
• E. SQL statements that were originally run concurrently are run concurrently by SPA.

Answer: BD

NEW QUESTION 24
Which three are true about monitoring waits for sessions and services? (Choose three.)

• A. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
• B. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
• C. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
• D. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
• E. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
• F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

Answer: BDE

NEW QUESTION 25
Which two are true about OS groups and users for OracleGrid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

• A. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
• B. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
• C. The Oracle Grid Infrastructure installation must be owned by the grid user.
• D. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
• E. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
• F. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.

Answer: EF

NEW QUESTION 26
......