Oracle Database 19c 1Z0-083 Practice Test Engine Try These 279 Exam Questions [Q12-Q26] : Actual Test Materials : http://blog.actualtests4sure.com

Q12. Which four are true about RMAN backup sets? (Choose four.)

A backup piece can belong to only one backup set.

A data file can be split into multiple sections stored in different backup sets.

A data file can be split into multiple sections stored in different backup pieces in the same backup set.

Blocks from multiple data files can be contained in one backup piece,

A backup set can contain only one backup piece.

A backup set must be written to media.

A backup set must be written to disk.

Blocks from multiple data files can be contained in one backup set,.

Q13. Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

The number of table rows is considered when evaluating the cost of accessing a table using an index.

Index balanced B*Tree height is considered when evaluating the cost of using an index.

The Statistics Advisor can help recommend the best way to gather statistics.

Statistics collected using DBMS_STATS always yield the best optimizer result.

The Statistics Advisor generates actions for all recommendations.

Q14. Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)

ADDM can run in a nonroot container.

AWR snapshots can be created in CDB$ROOT.

AWR reports can be generated while connected to any container.

All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

AWR snapshots can be created in a PDB.

No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Q15. Which two are true about gathering optimizer statistics? (Choose two.)

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

System statistics can be gathered only while connected to CDB$ROOT.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Q16. Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx- preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)

performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met

creating the oracle OS user

creating the OSDBA (dba) group

creating thte oraInventory (oinstall) group

creating the grid OS user

configuring the OS for Oracle Automatic Storage Management shared storage access

Q17. 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 files to the destination platform format using RMANon 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 the destination platform format using RMANon the destination system.
7. Import the university tablespace metadata using impdp.
8. Make the university tablespace read/write on the destination system.
Which are the minimum number of actions required, in the correct order, to transport the university tablespace?

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

1, 2, 4, 5, 7, 8

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

1, 2, 4, 6, 7, 8

2. 4. 5. 6. 7

Q18. .Examine the RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?

The password for the encryption must be set up.

Oracle wallet for the encryption must be set up.

All the tablespaces in the database must be encrypted

Oracle Database Vault must be enabled.

Q19. Which three are true about requirements for various flashback operations?

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

flashback drop requires that the recyclebin parameter be set to on.

flashback data archive requires undo to store all versions of all rows of a table being tracked.

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

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

flashback version query requires that the recyclebin parameter be set to on.

Q20. Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PBD) starting from Oracle 19c? (Choose three.)

creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned

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 new empty PDB in the local database from PDB$SEED

creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database

automatically dropping the database link to the remote database if it already exists

creating a database link from CDB$ROOT in the remote database to the PDB in the local database

opening the cloned PDB

Q21. Which two statements are true when row archival management is enabled?

The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active. Correct

Q22. Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

It is integrated with the SQL Access Advisor.

It predicts the impact of system changes on SQL workload response time.

It provides before and after execution statistics for each SQL statement in the analysis task

It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

SQL statements that were originally run concurrently are run concurrently by SPA.

Q23. Which four are true about RMAN backup sets?

A backup set must be written to media.

Blocks from multiple data files can be contained in one backup set.

A backup set must be written to disk.

Blocks from multiple data files can be contained in one backup piece.

A data file can be split into multiple sections stored in different backup sets.

A backup piece can belong to only one backup set.

A backup set can contain only one backup piece.

A data file can be split into multiple sections stored in different backup pieces in the same backup set.

Q24. You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

It creates a binary backup of the control file.

It updates the alert log with the location and contents of the control file

It creates a file that contains SQL statements to re-create the control file.

It creates a file that contains RMAN scripts to create a duplicate database.

It creates a copy of the control file in the fast recovery area (FRA).

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

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

A connection to an auxiliary instance is always required.

A subset of the target database can be duplicated.

A new DBID is always created for the duplicated database.

A connection to the recovery catalog 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 connection to the target database instance is always required.

Q26. Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)

using the KEEP FOREVER clause with the BACKUP command

using RMAN stored scripts

using the REPORT SCHEMA command to list a database’s current data files and tablespaces

creating customized reports about a single database’s backups

creating encrypted backups

using the REPORT SCHEMA command to list a database’s data files and tablespaces at times in the past