Course 2023 1Z1-083 Test Prep Training Practice Exam Download [Q62-Q79]

4/5 - (1 vote)

Course 2023 1Z1-083 Test Prep Training Practice Exam Download

1Z1-083 Exam Info and Free Practice Test Professional Quiz Study Materials

The exam is composed of 84 multiple-choice questions that must be completed within 105 minutes. The exam measures the candidate’s knowledge and abilities in areas such as database architecture, backup and recovery, performance tuning, security, and database management. The exam is available in English and Japanese, and candidates can take it at any Pearson VUE testing center worldwide.

QUESTION 62
Choose the best answer. You want to transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have the same endian Examine this list of steps:. 1. Make the UNIVERSITY tablespace read-only on the source 2. Export the UNIVERSITY tablespace metadata using EXPDP. 3. Create a cross-platform backup set from the UNIVERSITY source system, using an RMAN command that includes the DATAPUMP clause. 4. Copy the cross-platform backup sets to the destination system. 5. Copy the Data Pump dump set from the source to the destination system. 6. Restore the cross-platform backup set on 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 on the destination system. Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

3,4,6

2,3,4,5,6,7

1,3,4,6,8

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

QUESTION 63
Choose two. Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)?

A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.

A PDB Lockdown profile can be created in an application root.

A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.

A PDB Lockdown profile can be created in a regular PDB.

A PDB Lockdown profile can be created in CDB$ROOT .

QUESTION 64
Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)

CDB1 and CDB2 must be in shared undo mode.

A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

Cloning HR_ROOT automatically clones HR_PDB1.

The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

QUESTION 65
Choose two. You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are prerequisites?

an operating system user to own this installation

the Oracle Inventory group oinstall

an operating system account called grid

a group called dba

the installation of Oracle ASMLIB

QUESTION 66
You are managing this configuration:
CDB1 is a container database.
PDB1 and PDB2 are two pluggable databases in CDB1.
USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.
CDB1 user SYS executes these commands after connecting successfully to PDB2:

Which two are true? (Choose two.)

The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.

The insert on USER2.DEPT fails because of the active transaction in the parent container.

The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

The inserts on USER1.EMP were rolled back when the session connected to PDB2.

The insert on USER2.DEPT is uncommitted.

The inserts on USER1.EMP were committed when the session connected to PDB2.

QUESTION 67
Choose three. Which three capabilities require the use of the RMAN recovery catalog?

using RMAN stored scripts

creating encrypted backups

creating customized reports about a single database’s backups

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

using the KEEP FOREVER clause with the BACKUP command

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

QUESTION 68
Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:

Which two are true?

Redo logs are opened.

PDB$SEED is in read only state.

PDB1 and PDB2 are in read only state.

PDB1 and PDB2 are in mount state.

CDB$ROOT is in mount state.

QUESTION 69
Choose three. Which three are true about a container database (CDB)?

It can be created from a non-CDB.

It can contain only one PDB$SEED, which is created when the CDB is created.

It can have local users with the same name in different PDBs.

It can contain only one Application Container seed, which is created when the Application Container is created.

It can be created by cloning an existing CDB.

It can have any number of pluggable databases (PDBs) limited only by space availability.

It contains predefined common roles in both the root and the seed.

QUESTION 70
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)

QUESTION 71
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.

QUESTION 72
Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)

to switch an existing Oracle Database home to a newer release of Oracle software on the same server

to switch to a read-only Oracle home

to switch back to the previous Oracle home as part of a rollback operation

to switch the Oracle Database home when using a centralized Rapid Home Provisioning server

to switch to a patched Oracle Database home

QUESTION 73
Which two are true about the execution of operating system scripts starting from Oracle Database 19c?
(Choose two.)

orainstRoot.shcan be executed automatically by the Database installer by using sudoor root credentials.

root.shcan be executed automatically by the Database Installer only if it is provided with root credentials.

The sudopassword can be specified in a response file.

root.shcan be executed automatically by the Database installer only by using sudocredentials.

The sudopassword must be specified in a response file.

The rootpassword cannot be specified in a response file.

QUESTION 74
Which three actions are performed by Database Upgrade Assistant (DBUA)?

It removes the audsys schema and the audit_admin and audit_viewer roles.

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

It recompiles all stored pl/sql code by using utlrp.sql.

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

It empties the recycle bin.

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

QUESTION 75
Choose two. Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?

Space might be reclaimed proactively before space pressure occurs.

Space is always reclaimed proactively before space pressure occurs.

Space might be reclaimed automatically when the retention period for Flashback logs is lowered.

Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

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

QUESTION 76
Which two are true about RMAN backups when using a media manager? (Choose two.)

A media manager always writes RMAN requested backups to tape.

By default, a request for a proxy copy may result in a backup set being created.

A media manager is required to create RMAN proxy copies.

A media manager is required to create RMAN image copies.

The media manager layer (MML) routines provided by Oracle support any vendors’ media management products.

QUESTION 77
Choose three. PDB1 and PDB2 are pluggable databases in CDB1. Examine these commands: $ export ORACLE_SID=CDB1 $ sqlplus / as sysdba SQL> STARTUP ……. Database opened. SQL> SHOW PDBS CON_ID CON_NAME ——————————————————————–OPEN MODE READ ONLY NO MOUNTED MOUNTED SQL> ALTER PLUGGABLE Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 SAVE STATE; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 CLOSE; Pluggable database altered. SQL> ALTER PLUGGABLE A DATABASE pdb2 OPEN; Pluggable database altered. CDB1 is then restarted. Which three are true?

PDB2 will be opened READ WRITE.

PDB1 will be opened READ WRITE.

PDB1 will be MOUNTED.

PDB$SEED will be opened READ ONLY.

PDB$SEED will be MOUNTED

PDB2 will be MOUNTED.

QUESTION 78
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.)

oraclewill be an owner of the Oracle Inventory.

oracle must be the owner of every Oracle Database installation.

oraclecan own an Oracle Database installation but not an Oracle Grid Infrastructure installation.

oraclewill be granted the SYSASMprivilege when installing the Oracle Database software.

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

QUESTION 79
Which three are true about performing an Oracle Database install on Linux? (Choose three.)

The runfixup.sh script can install missing RPMs.

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

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

It can be done before installing Grid Infrastructure for 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

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

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