Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?
A database is configured in ARCHIVE LOG mode. 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.)
Choose three. Which three are true about cloning databases into an existing CDB with RMAN?
Choose two. Which two statements are true when row-archival management is enabled?
You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS table?
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)
choose two Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which two statements are true about the DUPLICATE command?
Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)
Choose three. Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?
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.)
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
Choose three. Which three are true about SGA memory management in a multitenant database?
Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5; Which two statements are true about the DUPLICATE command?
choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database: RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE NOFILENAMECHECK PASSWORD FILE SPFILE; Which two statements are true about the execution of the duplicate command?
Choose two. RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog?
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?
Choose three. The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3. Which three are true?
Choose three. Which three are true about recovery operations done without using Recovery Manager (RMAN)?
Choose two. You are managing this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are two pluggable databases in CDB1. 3. 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: SQL> ALTER SESSION SET CONTAINER=pdb1; Session altered. SQL> INSERT INTO user1.emp VALUES (100, 'Alan' ,1) ; 1 row created. SQL> INSERT INTO user1.emp VALUES (101, 'Ben' ,1) ; 1 row created. SQL> ALTER SESSION SET CONTAINER=pdb2; Session altered. SQL> INSERT INTO user2.dept VALUES(1, 'IT'); Which two are true? Which two are true? (Choose two.)
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?
Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)
Choose three. Which are the three steps in the SQL tuning process for Oracle Database environments?
Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)
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?
choose one You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?
Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)
Choose two. A database is configured in ARCHIVELOG mode. 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?
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?
Choose two. Which two are true about backup set compression using RMAN default compression?
Choose the best answer. SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?
Choose the best answer. On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days. Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups. Today is the 26th of August. Which backups will be obsolete?
The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)
Choose two. Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup?
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.)
Choose three. Which three are true about Data Pump in an Oracle multitenant environment?
Choose two. Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c?
choose two You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy?
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have different endian formats.
Examine this list of actions:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
4. Copy the UNIVERSITY tablespace data files to the destination system.
5. Copy the Data Pump dump set to the destination system.
6. Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release: For which databases will fixup scripts be created?
choose three Which three are true about RMAN duplexed backup sets or image copies?
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?
Choose the best answer. Which operating system group is NOT needed to perform an Oracle Database installation?
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)
Which three are true about an application seed pluggable database (PDB)? (Choose three.)
Choose three. Which three are true about corrupted data blocks and their recovery in an Oracle Database?
Choose two. Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases?
Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES APP application. Examine these steps:
Install the SALES_APP application, induding the common tables, in the application root.
Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.
Create an application seed.
Install the SALES_APP application in the application seed.
Create the SALES_APP1 and SALES_APP2 application PDBs.
Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
Sync the application seed with the application root. Which are the minimum required steps in the correct sequence?
Choose two. 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: SELECT containers_default, container_map, table_name FROM dba_tables WHERE owner='FIN' ; CONTAINERS_DEFAULT CONTAINER_MAP CONTAINER_MAP_OBJECT TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------NO YES NO REVENUE NO NO YES MAPTABLE Which two are true?
Which three are true about managing memory components in an Oracle database instance? (Choose three.)
Choose three. Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?
Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT. Which two are always true? (Choose two.)
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)
Choose the best answer 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
Choose three. Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
Choose two. Which two are true about Oracle Grid Infrastructure for a Standalone Server?
Oracle Database 19c | 1z0-083 Questions Answers | 1z0-083 Test Prep | Oracle Database Administration II Questions PDF | 1z0-083 Online Exam | 1z0-083 Practice Test | 1z0-083 PDF | 1z0-083 Test Questions | 1z0-083 Study Material | 1z0-083 Exam Preparation | 1z0-083 Valid Dumps | 1z0-083 Real Questions | Oracle Database 19c 1z0-083 Exam Questions