Latest 1Z1-083 Actual Free Exam Updated 279 Questions
Online Questions - Valid Practice 1Z1-083 Exam Dumps Test Questions
NEW QUESTION 30
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.)
- A. after losing the SYSTEM tablespace
- B. after losing an archived log from before the most recent backup
- C. when any archived log from, before, or after the most recent backup is corrupt.
- D. after losing an archived log from after the most recent backup
- E. after losing all copies of the control file
Answer: A,B
NEW QUESTION 31
Which two are true about common objects? (Choose two.)
- A. They can be extended data-linked in CDB$ROOT.
- B. They can be created only in an application root.
- C. They can be only metadata-linked in an application container.
- D. They can exist in CDB$ROOT and an application root.
- E. They can exist in user-defined schemas only in application containers.
- F. They can be created only in CDB$ROOT.
Answer: D
NEW QUESTION 32
Examine the statements that use flashback technologies:
FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMM-DD HH:MI:SS'); SELECT * FROM customers AS OF SCN 123456; FLASHBACK TABLE customers TO BEFORE DROP; FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS'); SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999; ALTER TABLE customers FLASHBACK ARCHIVE; Which set ofstatements depends on the availability of relevant undo data in the undo tablespace?
- A. 1,3,6
- B. 2,3,5,6
- C. 3,4,5
- D. 1,2,5
Answer: D
NEW QUESTION 33
Which three are true about managing memory components in an Oracle database instance? (Choose three.)
- A. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
- B. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
- C. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
- D. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
- E. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
- F. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
Answer: A,D,F
NEW QUESTION 34
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?
- A. Run the SQL Tuning Advisor.
- B. Run the Memory Advisor for the Program Global Area.
- C. Run the Memory Advisor for the System Global Area.
- D. Run the Memory Advisor for the shared pool.
- E. Run the SQL Access Advisor.
Answer: D
NEW QUESTION 35
Which four are true about RMAN backup sets? (Choose four.)
- A. A backup set must be written to media.
- B. Blocks from multiple data files can be contained in one backup set,.
- C. A backup set must be written to disk.
- D. A backup piece can belong to only one backup set.
- E. Blocks from multiple data files can be contained in one backup piece,
- F. A data file can be split into multiple sections stored in different backup pieces in the same backup set.
- G. A data file can be split into multiple sections stored in different backup sets.
- H. A backup set can contain only one backup piece.
Answer: B,D,E,F
NEW QUESTION 36
Which two are prerequisites for performing Flashback Transaction?
- A. Fast Recovery Area must be enabled for the database
- B. A supplemental log must be enabled for the primary key.
- C. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
- D. A supplemental log must be enabled for the primary key.
- E. Undo retention guarantee must be configured for the database.
Answer: C,D
NEW QUESTION 37
Which three are true? (Choose three.)
- A. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
- B. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
- C. Application-common TSDP policies are always container specific.
- D. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
- E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
- F. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
- G. Unified auditing can be automatically synchronized to all application PDBs in an application container.
Answer: B,F,G
NEW QUESTION 38
Which three are true about an application seed pluggable database (PDB)? (Choose three.)
- A. It cannot be dropped from its application container.
- B. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
- C. It is automatically synchronized with its application root PDB when an application is upgraded. B)It cannot be added to an application container after the application container has already been created.
- D. A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.
- E. It is automatically synchronized with its application root PDB when an application is installed.
- F. It is not required in an application container.
Answer: E,F
NEW QUESTION 39
Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed: Which three are true? (Choose three.)
- A. An application seed PDB is created for APP1.
- B. A default service is created for the application root APP1.
- 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. Application PDBsthat are subsequently created in the APP1 application container will be cloned from APP1$SEED.
- F. APP1 can never be unplugged.
Answer: B,C,D
NEW QUESTION 40
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)
- A. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
- B. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
- C. These backups can be written to disk or SBT.
- D. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
- E. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
Answer: A,C
Explanation:
Explanation
NEW QUESTION 41
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?
- A. PDB1 and PDB2 are in mount state.
- B. PDB1 and PDB2 are in read only state.
- C. PDB$SEED is in read only state.
- D. Redo logs are opened.
- E. CDB$ROOT is in mount state.
Answer: D,E
NEW QUESTION 42
Which three are true about a whole database backup? (Choose three.)
- A. It can be consistent.
- B. It can consist of either backup sets or image copies.
- C. It always includes all data files, the current control file, the server parameter file, and archived redo logs.
- D. It can be inconsistent.
- E. It is the only possible backup type for a database in NOARCHIVELOG mode.
- F. It can be created only by using RMAN.
Answer: A,B,C
NEW QUESTION 43
Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx- preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)
- A. creating the oracle OS user
- B. creating thte oraInventory (oinstall) group
- C. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
- D. creating the OSDBA (dba) group
- E. creating the grid OS user
- F. configuring the OS for Oracle Automatic Storage Management shared storage access
Answer: B,D,F
NEW QUESTION 44
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)
- A. A subset of the target database can be duplicated.
- B. A new DBID is always created for the duplicated database.
- C. A backup of the target database is always required.
- D. A connection to an auxiliary instance is always required.
- E. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
- F. A connection to the target database instance is always required.
- G. Duplication can be done by having the auxiliary databaseinstance pull backup sets from the target database instance.
- H. A connection tothe recovery catalog instance is always required.
Answer: C,D,E,G
NEW QUESTION 45
For which two requirements can you use the user_tablespaces clause with the create pluggable database command?
- A. to specify the list of tablespaces to include when creating a PDB from the CDB seed
- B. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
- C. to specify a default tablespace in a PDB cloned from another PDB in the same CDB
- D. to include specific user tablespaces only when relocating a PDB
- E. to exclude all tablespaces except system, sysaux, and temp when plugging in a PDB
- F. to exclude a temp tablespace when plugging in a PDB
Answer: B,D
NEW QUESTION 46
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
- A. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
- B. Oracle DBCA templates can store only logical structure and not database files.
- C. The Data Warehouse template is most suitable when transaction response time is the key criterion.
- D. Oracle DBCA templates can be used to create new databases and duplicate existing databases.
- E. New templates can only be created by modifying an existing user-created template.
Answer: A,D
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/ADMQS/GUID-2B8A3B5E-D319-4377-8B22-
8BB67DCC9885.htm#ADMQS0235
NEW QUESTION 47
Choose two You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs). Examine the query and its output: SQL> SELECT * FROM v $PWFILE_users; USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID ------------------------------------------------------------------------SYS TRUE TRUE FALSE FALSE FALSE FALSE 0 Which two tasks must you perform to add users with the SYSBACKUP, SYSDG, and SYSKM prileges to the password file?
- A. Copy the password file from a sample file in the DBS dierectory
- B. Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
- C. Re-create or migrate the password file to the Oracle Database 12c format
- D. Assign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.
Answer: B,C
NEW QUESTION 48
choose three Which three are true about unified auditing in full mode?
- A. The unified audit trail is written to a read-only external file.
- B. Audit records are created for SYS.
- C. The unified audit trail is written to a read-only table.
- D. Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.
- E. Audit records are created for non-sys users.
Answer: B,C,E
NEW QUESTION 49
Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?
- A. mandatory Oracle-supplied PL/SQL packages
- B. all data dictionary metadata
- C. temporary tablespaces
- D. user-defined PL/SQL packages
- E. control files
- F. redo logs
- G. undo tablespaces
Answer: B,E,F
NEW QUESTION 50
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)
- A. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
- B. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
- C. The Oracle Grid Infrastructure installation must be owned by the grid user.
- D. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
- E. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
- F. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
Answer: B,D
Explanation:
Reference:
https://docs.oracle.com/database/121/CWWIN/usrgrps.htm#CWWIN-GUID-6FD3C6AE-5A99- 4C6D-85D6-868CBA6F5DAE
NEW QUESTION 51
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c?
- A. relocating a remote container database in silent mode
- B. relocating a remote pluggable database in interactive mode
- C. cloning a remote container database in silent mode
- D. cloning a remote container database in interactive mode
- E. relocating a remote pluggable database in silent mode
- F. relocating a remote container database in interactive mode
- G. cloning a remote pluggable database in silent mode
Answer: A,E,F
NEW QUESTION 52
......
1Z1-083 Exam PDF [2022] Tests Free Updated Today with Correct 279 Questions: https://vcepractice.pass4guide.com/1Z1-083-dumps-questions.html