1Z0-083 Practice Exams and Training Solutions for Certifications [Q160-Q181]

Rate this post

1Z0-083 Practice Exams and Training Solutions for Certifications

Dumps Free Test Engine Player Verified Answers

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

OSASM

OSRACDBA

OSKMDBA

OSDBA

OSOPER

NO.161 Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Which three are true?

APP1 can never be unplugged.

Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.

An application seed PDB Is created for APP1.

Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

An application root PDB is created for APP1.

A default service Is created for the application root APP1.

NO.162 Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true? (Choose two.)

Data file 24 can be recovered while PDB2 is opened.

Data file 24 must be recovered while the CDB is opened.

Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.

Data file 24 cannot be recovered while the CDB is opened.

Data file 24 must be recovered while PDB2 is closed.

NO.163 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.

PDB1is 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.

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

NO.164 Examine these actions:
1.Create a new database for a recovery catalog.
2.Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3.Configure ARCHIVELOG mode for the catalog database.
4.Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.
5.Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.
6.Grant the SYSBACKUP privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

2, 4, 5, 6

1, 2, 3, 4, 5, 6

1, 2, 4, 5

2, 4, 5

1, 3, 4, 5

NO.165 Choose three. Which three are true about Oracle Restart?

It is used in both clustered and non-clustered environments.

You can add and remove components from an Oracle Restart configuration with Server Control (SRVCTL) commands.

It runs from the Oracle Grid Infrastructure home.

If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.

The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart.

It can manage Oracle Database instances, Oracle Net Listeners, and Oracle Automatic Storage Management instances.

NO.166 A database is configured in ARCHIVELOGmode.
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? (Choose two.)

after losing a SYSAUXtablespace data file

after losing all members of an INACTIVE online redo log group

after losing all members of the CURRENTonline redo log group

after losing all copies of the control file

after losing an UNDOtablespace that is in use

NO.167 Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL ‘ALTER SYSTEM ARCHIVE LOG CURRENT’; } Which statement is true about the command?

It uses multisection backup.

It uses parallelization for the backup set.

It uses asynchronousI/O for the backup.

It creates compressed backup sets.

NO.168 Which two are true about a Recovery Manager (RMAN) duplication without a target connection?

RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

The undo tablespace clause is always required when no connection exists to the recovery catalog and the target database is closed.

RMAN “pushes” the backups of the database to be duplicated over the network to the auxiliary instance.

The undo tablespace clause is always required when no connection exists to the target instance.

RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

NO.169 Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.

Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.

After the change, only one undo tablespace can exist in CDB$ROOT.

After the change, any user with the required privilege can create an undo tablespace in the PDBs.

Undo tablespaces existing in PDBs must be dropped before the change.

After the change, each existing PDB has to be reopened for the new undo mode to take effect.

NO.170 Choose two. Which two are true about the execution of operating system scripts starting from Oracle Database 19c?

The root password cannot be specified in a response file.

The sudo password must be specified in a response file.

orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.

root.sh can be executed automatically by the Database installer only if it is provided with root credentials.

root.sh can be executed automatically by the Database installer only by using sudo credentials.

NO.171 Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

All metrics are instance related.

Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

A space usage management alert is automatically cleared after the underlying problem is resolved.

They are generated by SMON when a tablespace is 97% full.

Metrics are statistical counts for a specific unit.

STATISTICS_LEVEL must be set to ALL to generate alerts.

NO.172 Choose two. Which two are true about Oracle Grid Infrastructure for a Standalone Server?

It can manage database resources on the server where it is installed or on a different server.

The CSS daemon runs from the Grid Infrastructure home.

It supports volume management, file system, and automatic restart capabilities.

It requires Oracle Automatic Storage Management (ASM) components to be installed separately.

It must be installed before the Oracle database software is installed.

NO.173 Which two are true about RMAN encryption? (Choose two.)

RMAN encryption keys are stored in a database keystore.

RMAN can encrypt the Oracle Database password file.

Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.

The SET ENCRYPTIONcommand overrides encryption settings specified by the CONFIGURE ENCRYPTIONcommand.

Password encryption can be persistently configured using the CONFIGURE ENCRYPTIONcommand.

NO.174 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.

NO.175 Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?

by using the RMAN switch command to set the new location for the data files

by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host

by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host

by creating a new database in the new host, and then using the RMAN recover command

NO.176 Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

In a PDB plan, subplans may be used with up to eight consumer groups.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

NO.177 For which two requirements can you use the user_tablespaces clause with the create pluggable database command?

to specify a default tablespace in a PDB cloned from another PDB in the same CDB

to specify the list of user tablespaces to include when moving a non-CDB to a PDB

to include specific user tablespaces only when relocating a PDB

to exclude all tablespaces except system, sysaux, and temp when plugging in a PDB

to exclude a temp tablespace when plugging in a PDB

to specify the list of tablespaces to include when creating a PDB from the CDB seed

NO.178 You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true?

All non-Oracle files in the current FRA that have not been backed up already, are backed up.

All Oracle recovery files in the current fast recovery area (FRA) are backed up.

All Oracle recovery files in the current FRA that have not been backed up already, are backed up.

All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.

These backups can be written to disk or SBT.

NO.179 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.)

Data file 24 can be recovered only while connected to PDB2.

Data file 24 can be restored and recovered while connected to CDB$ROOT.

Data file 24 can be restored only while connected to CDB$ROOT.

Data file 24 can be restored only while connected to PDB2.

Data file 24 can be recovered while connected to PDB2.

Data file 24 can be recovered while connected to CDB$ROOT.

NO.180 A database is configured in ARCHIVE LOG 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.)

when any archived log from, before, or after the most recent backup is corrupt.

after losing all copies of the control file

after losing an archived log from after the most recent backup

after losing an archived log from before the most recent backup

after losing the SYSTEM tablespace

NO.181 Examine this configuration:
1. The orcl database data files are in Automatic Storage Management (Oracle ASM) disk group +data.
2. orcl uses disk group +fra for 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:
$ srvctl start database -d ORCL
What is the outcome?

The ORCL database, the Oracle ASM instances, the +data and +fra disk groups, and the listener are started.

Only the orcl database instance is started.

Only the orcl database instance and the +data and +fra disk groups are started.

Only the orcl database instance, the Oracle ASM instance, and the +data and +fra disk groups are started.

Only the orcl database and the ASM instances are started.

Q&As with Explanations Verified & Correct Answers: https://www.pdf4test.com/1Z0-083-dump-torrent.html

Free certification test prep

1Z0-083 Practice Exams and Training Solutions for Certifications [Q160-Q181]

Leave a Reply Cancel reply