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