Free 1Z1-083 braindumps download (1Z1-083 exam dumps Free Updated May 12, 2024) [Q54-Q71]

4/5 - (1 vote)

Free 1Z1-083 braindumps download (1Z1-083 exam dumps Free Updated May 12, 2024)

1Z1-083 Dumps for Pass Guaranteed – Pass 1Z1-083 Exam 2024

Q54. Which two are true about automatic block repair? (Choose two.)

Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.

Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.

Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.

It is not possible for media corrupt blocks.

Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

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

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

Q57. Which two are true about RMAN duplexed backup sets? (Choose two.)

They can be written only to disk.

They must be written to media.

They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.

They can be created only by using the COPIES option of a BACKUP command.

They can be written to media.

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

Which two are true? (Choose two.)

PDB1 and PDB2 are in MOUNT state.

Redo logs are opened.

PDB1 and PDB2 are in READ ONLY state.

CDB$ROOT is in MOUNT state.

PDB$SEED is in READ ONLY state.

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

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

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

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

Data file 24 can be restored and recovered 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.

Q60. Examine this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are pluggable databases in CDB1.
* PDB1 and PDB2 are OPEN in READ WRITE mode.
You execute these commands successfully:

Which two are true? (Choose two.)

Uncommitted transactions in PDB1 have been rolled back.

PDB1 is closed.

Uncommitted transactions in CDB1 and PDB1 have been rolled back.

CDB1 is shut down.

CDB1 is in MOUNT state

Q61. 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:
# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall) , 54322(dba) Which two are true?

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

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

oracle will be an owner of the Oracle Inventory.

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

oracle must be the owner of every Oracle Database installation.

Q62. Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
(Choose two.)

Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

A failure can be closed only when it has been repaired.

Data Recovery Advisor can be used if a database is closed.

The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.

Data Recovery Advisor can proactively check for failures.

Q63. Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

Run the SQL Access Advisor.

Run the Memory Advisor for the shared pool.

Run the SQL Tunning Advisor.

Run the Memory Advisor for the Program Global Area.

Run the Memory Advisor for the System Global Area.

Q64. You are managing this configuration:
1. CDB1 is a container database.
2. BDB1 and PDB2 are two pluggable databases in CDB1.
3. user1 .EMP Is a table In PDBI and user2.DEPT is a table in PDB2.

Which two are true?

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

The insert on user2.dept is uncommitted.

The inserts on USER1. EMP were committed when the session inserted a row into user2 .dept.

The inserts on USER 1 . EMP remain uncommitted when the session connected to pdb2.

The insert on user2.dept Is a recursive autonomous transaction by the child session and is committed.

The insert on user2.dept fails because of the active transaction in the parent container.

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

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

Q66. Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)

It can be used for applications and middleware.

It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.

It can be used only for Oracle Grid Infrastructure, including Oracle Restart.

It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.

It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.

Q67. You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage.
Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command:
RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE;
What is a prerequisite for the successful execution of this command?

RMAN must be connected to the target database instance and the auxiliary instance.

A most recent backup set of the PROD database must exist.

Flashback must be enabled for the PROD database.

The target database must be in MOUNT state.

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

Q69. Choose the best answer. Examine this configuration:
1. CDB1 is a container database running in ARCHIVELOG mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are INACTIVE.
4. Redo log group 3 is the CURRENT group.
All members of redo log group 3 are lost before it is archived. Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABASE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABASE OPEN
10. ALTER DATABASE OPEN RESETLOGS
Choose the minimum required steps in the correct order to recover the database.

1,3,5, 6, 9

1,3,5, 7, 10

1,2, 5, 7,4, 10

1,3, 5, 6, 10

1,3,5, 6, 10

1,3,5,8, 6, 10

Q70. Which are the three steps in the SQL tuning process for Oracle Database environments?

Tune individual SQL statements using the SQL Tuning Advisor.

Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.

Test the application as a whole using tuned SQL statements.

Test tuned SQL statements one at a time for all statements in the application.

Identify poorly tuned SQL statements using the SQL Tuning Advisor.

Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.

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