Real Oracle 1Z0-083 Exam Questions Study Guide [Q13-Q36]

admin March 1, 2023 0 Comments

4.4/5 - (93 votes)

Real Oracle 1Z0-083 Exam Questions Study Guide

Updated and Accurate 1Z0-083 Questions for passing the exam Quickly

Q13. Which two are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?

It can be used to provision middleware.

It cannot be used to patch Grid Infrastructure homes containing Oracle Restart.

It Is an Oracle Database service.

It can be used to provision applications.

It cannot be used to upgrade Oracle Database homes.

Q14. Choose three. Which three are true in Oracle 19c and later releases?

Tablespaces always remain in read/write mode during transportable tablespace operations.

Tablespaces never remain in read/write mode during transportable tablespace operations.

A transportable data pump import can leave a plugged-in tablespace in read-only mode.

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

A transportable data pump import can leave a plugged-in tablespace in read/write mode.

An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

Q15. You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.
Examine this command and its outcome:

Which two are true? (Choose two.)

oracle will be an owner of the Oracle Inventory.

oracle must be the owner of every Oracle Database installation.

oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.

oracle will be granted the SYSASM privilege when installing the Oracle Database software.

The user account, oracle, and group, oinstall, can be used for all Oracle software installations.

Q16. Which two are true about the Oracle dataabse methodology? (Choose two.)

The Oracle Database time model should be used to find the database and instance areas most in need of tuning.

Tuning activities should stop once the user is satisfied with performance.

Tuning activities should stop once agreed service levels for performance have been met.

The database instance memory should always be tuned before tuning any file systems.

SQL statements should always be tuned before tuning any file systems.

The alert log should be used to find the database and instance areas most in need of tuning.

Q17. Which three true about recovering tables using RMAN? (Choose three.)

RMAN can recover tables in the SYSAUX tablespace.

RMAN can recover tables owned by the SYS user.

RMAN can recover tables in the SYSTEM tablespace.

RMAN always uses an auxiliary instance.

RMAN can recover tables in a standby database.

RMAN can recover a table after a DDL operation has altered the table structure.

RMAN can recover tables owed by the SYSTEM user.

Q18. A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING ‘/u01/app/oracle/oradata/pdb1.xml’
SOURCE_FILE_NAME_CONVERT =
(‘/u01/app/oracle/oradata/’, ‘/u02/app/oracle/oradata/’);
Which two are true? (Choose two.)

PDB1 data files already exist in the correct location.

DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.

PDB_FILE_NAME_CONVERT must be set before executing the command.

/u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.

PDB1 must be dropped from CDB1.

Q19. Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

defining primary keys for all tables to speed up all queries

using check constraints to speed up updates

defining foreign keys for all tables to speed up joins

the physical data model

the configuration of storage arrays

Q20. Which three are true? (Choose three.)

Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

Application-common TSDP policies are always container specific.

Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.

Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.

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

Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.

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

Q21. Which three are true about Database Point-in-Time Recovery?

The target point for the recovery must be specified as a time or System Change Number (SCN).

The database must be open resetlogs after Database Point-in-Time Recovery.

The database must be in archivelog mode.

Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)

The database must be in mount state when performing Database Point-in-Time Recovery.

The database must have flashback database on to perform Database Point-in-Time Recovery.

Q22. Choose the best answer. Which operating system group is NOT needed to perform an Oracle Database installation?

OSASM

OSRACDBA

OSKMDBA

OSDBA

OSOPER

Q23. Choose three. Which three are true about recovery operations done without using Recovery Manager (RMAN)?

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

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 SPFILE can be recovered from memory using SQL*PLUS.

A lost TEMPFILE must always be re-created manually.

Q24. Choose three. Which three are true about the Oracle Optimizer?

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

It obeys all hints.

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

It updates stale object statistics in the Data Dictionary.

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

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

Q25. 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 an application seed, synchronize it with HR_ROOT, and then create the PDB1 application PDB.

Create the PDB1 application PDB and synchronize it with HR_ROOT.

Create the PDB1 application PDB and install HR_APP in it.

Create the PDB1 application PDB and synchronize it with PDB$SEED.

Create an application seed, and install HR_APP in it.

Q26. Which two are true about instance recovery? (Choose two.)

It is not possible if an archived log is missing.

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

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

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

Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing the log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.

It is performed automatically while the database remains in MOUNT state. Then the database is opened.

Q27. Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

It recompiles all stored PL/SQL code by using utlrp.sql.

It empties the RECYCLE BIN.

It performs prerequisite checks to verify if the Oracle database is ready for upgrade.

It sets all user tablespaces to “read-only” before starting the upgrade.

It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles

It increases tablespace size, if required, to meet upgrade requirements.

Q28. Which two are true about server-generated alerts? (Choose two.)

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

Stateless alerts can be purged manually from the alert history.

Stateless alerts can be cleared manually.

Stateless alerts are automatically cleared.

Stateful alerts are purged automatically from the alert history.

Q29. Your SALES_ROOT application container has two application PDBs.
The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true? (Choose two.)

The CONTAINERS clause cannot be used in queries on the REVENUE table.

The REVENUE table must be a list-partitioned table.

The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.

The MAPTABLE table is a metadata-linked table.

A container map exists for the REVENUE table, but is not enabled.

The REVENUE table partitions are not pruned across the PDBs automatically.

Q30. Examine this output:

Which two are true? (Choose two.)

Any PDB not specified in the plan will be unable to execute statements in parallel.

PDB3 can use all available parallel execution processes at times.

PDB1 is always limited to 40% of the available system resources regardless of demand.

Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.

PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.

PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

Q31. Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.

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

SPFILE backups can be created while connected to an application root PDB.

The BACKUP DATABASE PLUS ARCHIVE LOG command will back up archive logs when RMAN is connected to a PDB.

The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

Q32. Choose three. 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.

PDB3’s application root replica must exist in the local CDB.

The HR_ROOT replica must exist in the remote CDB.

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

A proxy PDB must exist in the application root in the remote CDB.

A database link must exist in the local CDB root referring to the remoteCDB.

Q33. Which three are true about requirements for various FLASHBACKoperations? (Choose three.)

FLASHBACKtransaction query requires undo to retrieve all versions of a row that existed between two points in time.

FLASHBACKdrop requires that the RECYCLEBIN parameter be set to ON.

FLASHBACKversion query requires that the RECYCLEBINparameter be set to ON.

FLASHBACK DATA ARCHIVErequires undo to store all versions of all rows of a table being tracked.

FLASHBACKdrop requires undo to retrieve all versions of a row that existed between two points in time.

FLASHBACKversion query requires undo to retrieve all versions of a row that existed between two points in time.

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

Media Management messages for SBT devices are always written to sbtio.log.

RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.

RMAN error stacks should be read from the top down as that is the order in which errors are generated.

The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.

The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

Media Management messages for SBT devices are written to an Oracle trace file.

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

after losing all copies of the control file

after losing all members of an inactive online redo log group

after losing all members of the current online redo log group

after losing an undo tablespace that is in use

after losing a sysaux tablespace data file

Q36. Examine these queries and their output: An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1. How do you achieve this?

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to PDB1.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to PDB1.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to CDB$ROOT.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to CDB$ROOT.

This cannot be done due to the lack of a clean restore point.

Understanding functional and technical aspects of Oracle Database Administration II Exam Number: 1Z0-083

The following will be discussed in the ORACLE 1Z0-083 exam dumps:

Manage Security in Multitenant databases
Backup Strategies and Terminology
Configuring and Using RMAN
Oracle Database: Backup and Recovery Workshop
Upgrading and Transporting CDBs and Regular PDBs
Creating CDBs and Regular PDBs
Backup and Duplicate

Prepare Important Exam with 1Z0-083 Exam Dumps: https://www.vcedumps.com/1Z0-083-examcollection.html

Tags: 1Z0-083 dumps reviews, 1Z0-083 exam discount, 1Z0-083 latest exam forum, 1Z0-083 test assessment, 1Z0-083 updated Testkings, new 1Z0-083 exam voucher, reliable examcollection 1Z0-083

Real Oracle 1Z0-083 Exam Questions Study Guide [Q13-Q36]

Understanding functional and technical aspects of Oracle Database Administration II Exam Number: 1Z0-083

Leave a Reply Cancel reply

1Z0-083 Practice Tests

Related Certifications

Recent Posts

Categories

Archives