Get Instant Access of 100% Real Oracle 1Z0-083 Exam Questions with Verified Answers [Q141-Q157]

Share

Get Instant Access of 100% Real Oracle 1Z0-083 Exam Questions with Verified Answers

Exam Dumps for the Preparation of Latest 1Z0-083 Exam Questions

NEW QUESTION # 141
Which three are true about Database Point-in-Time Recovery? (Choose three.)

  • A. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
  • B. The database must be open RESETLOGS after Database Point-in-Time Recovery.
  • C. The Database must be in ARCHIVELOG mode.
  • D. The database must be in MOUNT state when performing Database Point-in-Time Recovery.
  • E. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
  • F. The target point for the recovery must be specified as a stime or System Change Number (SCN).

Answer: B,C,D

Explanation:
Archivelog mode and mount state are needed (B, and D)
After the restore you need to open with reset logs (F)
E is discarted because sequence number also is valid
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database%2
0point%2Din%2Dtime%20recovery%20(DBPITR)%20restores%20the,forward%20to%20the%20t arget%20time.


NEW QUESTION # 142
Your database is in ARCHIVELOG mode and you plan to use Flashback Database.
Which two features or parameters manage space availability in the fast recovery area? (Choose two.)

  • A. the DB_RECOVERY_FILE_DEST parameter setting
  • B. the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
  • C. using guaranteed UNDO retention
  • D. the backup retention policy
  • E. the archived log deletion policy
  • F. the backup optimization policy

Answer: D,E

Explanation:
RMAN automatically manages files in the fast recovery area by deleting obsolete backups and archiving files no longer required for recovery.
https://docs.oracle.com/en/database/oracle/oracle-database/18/ssdbi/about-the-fast-recovery- area-and-the-fast-recovery-area-disk-group.html#GUID-05343E2B-24CF-427E-A068-
9AC2104BEF81


NEW QUESTION # 143
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

  • A. A PDB snapshot depends on a storage snapshot which can be stored on any file system.
  • B. A PDB snapshot is always a full copy of the source PDB.
  • C. A snapshot copy PDB can be created from a stand-alone clone PDB.
  • D. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
  • E. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
  • F. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
  • G. A PDB snapshot is always a sparse copy of the source PDB.

Answer: B,F

Explanation:
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-pdb- snapshots.html#GUID-35B03C37-00BA-4945-BF20-9A7C4C541955


NEW QUESTION # 144
Your SALES_ROOT application container has two application PDBs.
The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true? (Choose two.)

  • A. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.
  • B. The MAPTABLE table is a metadata-linked table.
  • C. The REVENUE table partitions are not pruned across the PDBs automatically.
  • D. The CONTAINERS clause cannot be used in queries on the REVENUE table.
  • E. The REVENUE table must be a list-partitioned table.
  • F. A container map exists for the REVENUE table, but is not enabled.

Answer: A,F


NEW QUESTION # 145
Which two are true about common objects? (Choose two.)

  • A. They can exist in CDB$ROOT and an application root.
  • B. They can be only metadata-linked in an application container.
  • C. They can be extended data-linked in CDB$ROOT.
  • D. They can exist in user-defined schemas only in application containers.
  • E. They can be created only in CDB$ROOT.
  • F. They can be created only in an application root.

Answer: A,F

Explanation:
A common object is defined in either the CDB root or an application root, and can be referenced using metadata links or object links. A local object is every object that is not a common object.
Database-supplied common objects are defined in CDB$ROOT and cannot be changed. Oracle Database does not support creation of common objects in CDB$ROOT.
You can create most schema objects - such as tables, views, PL/SQL and Java program units, sequences, and so on-as common objects in an application root. If the object exists in an application root, then it is called an application common object.
A local user can own a common object. Also, a common user can own a local object, but only when the object is not data-linked or metadata-linked, and is also neither a metadata link nor a data link.


NEW QUESTION # 146
Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?
(Choose three.)

  • A. They can view data from any data dictionary view or dynamic performance view.
  • B. They cannot create restore points.
  • C. They can drop any tablespace.
  • D. They can view data from any user-defined tables.
  • E. They can create any table.
  • F. They cannot drop tablespaces.

Answer: E,F


NEW QUESTION # 147
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 to CDB1.
  • B. USER1 is defined in APP1_PDB2. E) USER1 can connect only to APP1_PDB1.
  • C. USER1 can connect only to APP1_ROOT.
  • D. USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.
  • E. USER1 can connect to APP1_ROOT and APP1_PDB1.

Answer: B,E


NEW QUESTION # 148
Which three are true? (Choose three.)

  • A. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
  • B. Unified auditing can be automatically synchronized to all application PDBs in an application container.
  • C. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
  • D. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
  • E. Application-common TSDP policies are always container specific.
  • F. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
  • G. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

Answer: B,F,G


NEW QUESTION # 149
Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

  • A. It provides before and after execution statistics for each SQL statement in the analysis task
  • B. SQL statements that were originally run concurrently are run concurrently by SPA.
  • C. It is integrated with the SQL Access Advisor.
  • D. It predicts the impact of system changes on SQL workload response time.
  • E. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

Answer: D,E

Explanation:
Reference:
https://www.oracle.com/technetwork/database/manageability/spa-ow09-131455.pdf (4)


NEW QUESTION # 150
Which two are true about the SQL Tuning Advisor?

  • A. It prevents performance regressions for SQL statements when changes are made.
  • B. It checks each query being analyzed for missing or stale statistics.
  • C. It only recommends syntactic changes to SQL statements.
  • D. It considers all SQL statements being analyzed by the advisor task as a group.
  • E. It can recommend semantic changes to SQL statements.

Answer: C,E


NEW QUESTION # 151
Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Which three are true?

  • A. A default service Is created for the application root APP1.
  • B. APP1 can never be unplugged.
  • C. An application root PDB is created for APP1.
  • D. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
  • E. An application seed PDB Is created for APP1.
  • F. Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.

Answer: A,C,F


NEW QUESTION # 152
Examine this configuration:
19.CDB1is a container database.
20.APP_ROOTis an application root in CDB1.
21.APP_PDB1is an application PDB in APP_ROOT.
22.FLASHBACK DATABASEis ON.
You execute these commands:

Which table or set of tables will exist after the Flashback operation has completed?

  • A. CDB1_TAB and APP_PDB1_TAB
  • B. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
  • C. CDB1_TAB only
  • D. CDB1_TAB and APP_ROOT_TAB
  • E. none of the tables, because all three tables will be dropped

Answer: A

Explanation:
To perform a flashback operation for an application container, you must perform flashback operations for the application root and all the individual application PDBs that are part of the application container. Performing a flashback operation on the application root reverts only the application root to the specified point in time.
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-performing- flashback-dbpitr.html#GUID-66B1A12D-1C92-43B5-A204-AA8A6D177ABD


NEW QUESTION # 153
Choose three. Which three are true about Recovery Manager (RMAN) active database duplication?

  • A. Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.
  • B. Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.
  • C. Pre-existing backups of the database to be duplicated are always used if they exist.
  • D. No connection to the recovery catalog is required for active database duplication.
  • E. Image copies can be used to duplicate the active database.
  • F. The active database must be duplicated while in OPEN state.
  • G. Backup sets can be used to duplicate the active database.

Answer: D,E,G


NEW QUESTION # 154
Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)

  • A. It requires Oracle Automatic Storage Management (ASM) components to be installed separately.
  • B. The CSS daemon runs from the Grid Infrastructure home.
  • C. It supports volume management, file system, and automatic restart capabilities.
  • D. It must be installed before the Oracle database software is installed.
  • E. It can manage database resources on the server where it is installed or on a different server.

Answer: C,D


NEW QUESTION # 155
Which two are true about Oracle instance recovery? (Choose three.)

  • A. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
  • B. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
  • C. Recovery begins from the beginning of the CURRENT redo log group.
  • D. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
  • E. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.
  • F. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.

Answer: B,D,E


NEW QUESTION # 156
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.)

  • A. The insert on USER2.DEPT fails because of the active transaction in the parent container.
  • B. The inserts on USER1.EMP were committed when the session connected to PDB2.
  • C. The insert on USER2.DEPT is uncommitted.
  • D. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
  • E. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
  • F. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
  • G. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

Answer: B,C


NEW QUESTION # 157
......

Download Latest & Valid Questions For Oracle 1Z0-083 exam: https://www.test4cram.com/1Z0-083_real-exam-dumps.html

Ensure Success With Updated Verified 1Z0-083 Exam Dumps: https://drive.google.com/open?id=1fCFwuZT9T5S6IVerLxuHxPve2AWiKAMm