Free Oracle 1Z1-083 Practice Test & Real Exam Questions, Page 3

Question #23

Which three statements are true about Flashback Database?

A. Flashback logs are written sequentially, and are archived.

B. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

C. Flashback Database can recover a database to the state that it was in before a reset logs operation.

D. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.

F. Flashback Database uses a restored control file to recover a database.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #24

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

A. Results are written to the alert log.

B. A DBA can run it manually.

C. It analyzes a period of time corresponding to the last day of activity.

D. It runs automatically after each AWR snapshot.

E. It analyzes a period of time corresponding to the 12 hours of activity.

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #25

You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?

A. The statistics_level parameter is set to all only for PDB2 when it is reopened.

B. The statistics_level parameter is set to all when the root database is restarted.

C. The statement is ignored because there is no SPFILE for a PDB.

D. The statistics_level parameter is set to all when any of the PDBs is reopened.

Discussion 0

Correct Answer: A Vote an answer

Question #26

Examine this configuration:
1. CDB1 is a container database.
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.
Which two are true?

A. USER1 can connect only to APP1_ROOT.

B. USER1 can connect to APP1_ROOT and APP1_PDB1.

C. USER1 can connect to CDB1.

D. USER1 is defined in APP1_PDB2. E) USER1 can connect only to APP1_PDB1.

E. USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.

Discussion 0

Correct Answer: B,D Vote an answer

Question #27

Which two are true about an RPM-based Oracle Database installation? (Choose two.)

A. It performs a software-only Oracle Database installation.

B. It requires an Unbreakable Linux Network (ULN) subscription.

C. It uses a service configuration script to create a single-instance database as part of the installation.

D. From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.

E. It includes the Oracle Preinstallation RPM.

Discussion 0

Correct Answer: A,C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #28

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

A. A Virtual Private Catalog used to register a container database can be created in a pluggable database.

B. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.

C. A Virtual Private Catalog used to register a container database can be created in a non-container database.

D. A Virtual Private Catalog used to register a container database must be created in a pluggable database.

E. It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.

F. It is always possible for RMAN to connect to a pluggable database as a target.

Discussion 0

Correct Answer: A,C,F Vote an answer

Question #29

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

A. using check constraints to speed up updates

B. defining foreign keys for all tables to speed up joins

C. the physical data model

D. the configuration of storage arrays

E. defining primary keys for all tables to speed up all queries

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #30

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

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

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

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

D. The Statistics Advisor generates actions for all recommendations.

E. Statistics collected using DBMS_STATS always yield the best optimizer result.

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #31

Which three are true about OPatch?

A. It requires installation of Oracle Universal Installer.

B. It must be invoked as the user that owns the software being patched.

C. It can be used to apply interim patches to the Grid Infrastructure and Database Home combination.

D. It is a Java-based utility for applying patchsets.

E. It is platform independent.

F. It supports Rolling Patching.

Discussion 0

Correct Answer: B,C,F Vote an answer

Question #32

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

A. Results are written to the alert log.

B. A DBA can run it manually.

C. It analyzes a period of time corresponding to the last day of activity.

D. It runs automatically after each AWR snapshot.

E. It analyzes a period of time corresponding to the 12 hours of activity.

Discussion 0

Correct Answer: B,D Vote an answer

Question #33

Which two are prerequisites for performing Flashback Transaction?

A. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.

B. Fast Recovery Area must be enabled for the database

C. A supplemental log must be enabled for the primary key.

D. Undo retention guarantee must be configured for the database.

E. Row movement must be enabled.

Discussion 0

Correct Answer: A,C Vote an answer

Free Oracle 1Z1-083 Practice Test & Real Exam Questions

Download Free Oracle 1Z1-083 Demo