279 Q&As in UPDATED 1Z0-083 Exam Questions Certification Test Engine to PDF
Get The Important Preparation Guide With 1Z0-083 Dumps
How much Oracle Database Administration II Exam Number: 1Z0-083 costs
- No. of Questions: 85 Questions
- Types of questions: Performance Based Questions
- Length of Exam: 150 min
- Passing Score: 60% or higher
- Examination Fees: $250 USD
NEW QUESTION 152
Which two are true about RMAN encryption? (Choose two.)
- A. The SET ENCRYPTIONcommand overrides encryption settings specified by the CONFIGURE ENCRYPTIONcommand.
- B. Password encryption can be persistently configured using the CONFIGURE ENCRYPTIONcommand.
- C. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
- D. RMAN can encrypt the Oracle Database password file.
- E. RMAN encryption keys are stored in a database keystore.
Answer: A,C
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/BRADV/rcmconfa.htm#BRADV89476
NEW QUESTION 153
Which two are prerequisites for performing Flashback Transaction?
- A. A supplemental log must be enabled for the primary key.
- B. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
- C. Fast Recovery Area must be enabled for the database
- D. Undo retention guarantee must be configured for the database.
- E. A supplemental log must be enabled for the primary key.
Answer: B,E
NEW QUESTION 154
choose three Which three are true about Transparent Data Encryption (TDE)?
- A. Master encryption keys are managed by Oracle Database Vault.
- B. It can encrypt data at the column level.
- C. It stores the current and all past master keys in the keystore.
- D. It replaces secure application roles.
- E. It encrypts only data on the client.
- F. It uses a single master key for a database.
Answer: A,B,C
NEW QUESTION 155
hoose two. Which two are true about Recovery Manager (RMAN) diagnostic message output?
- A. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.
- B. Media Management messages for SBT devices are written to an Oracle trace file.
- C. MAN error stacks should be read from the top down as that is the order in which errors are generated.
- D. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
- E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
Answer: C,E
NEW QUESTION 156
A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)
- A. PDB_FILE_NAME_CONVERT must be set before executing the command.
- B. PDB1 data files already exist in the correct location.
- C. PDB1 must be dropped from CDB1.
- D. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
- E. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
Answer: A,E
NEW QUESTION 157
Examine this output:
Which two are true? (Choose two.)
- A. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
- B. Any PDB not specified in the plan will be unable to execute statements in parallel.
- C. PDB1 is always limited to 40% of the available system resources regardless of demand.
- D. PDB3 can use all available parallel execution processes at times.
- E. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
- F. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
Answer: A,B
NEW QUESTION 158
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.)
- A. Data file 24 can be restored and recovered while connected to CDB$ROOT.
- B. Data file 24 can be recovered while connected to PDB2.
- C. Data file 24 can be recovered only while connected to PDB2.
- D. Data file 24 can be restored only while connected to CDB$ROOT.
- E. Data file 24 can be restored only while connected to PDB2.
- F. Data file 24 can be recovered while connected to CDB$ROOT.
Answer: A,E,F
NEW QUESTION 159
Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle
19c and later releases? (Choose three.)
- A. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
- B. A PDB snapshot depends on an existing storage snapshot of the source PDB.
- C. A snapshot copy PDB can be a full copy of a source PDB.
- D. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
- E. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
- F. A PDB snapshot can be a full copy of a source PDB.
- G. A PDB snapshot can be a sparse copy of a source PDB.
Answer: B,C,G
NEW QUESTION 160
Examine this command for creating pluggable database PDB2 in container database CDB2 CREATE PLUGGABLE DATABASE pdb2 ADMIN USER pdb2_adrn IDENTIFIED BY 12 3pdb ROLES=(CONNECT) ; Select three options, any one of which is required for it to execute successfully.
- A. Add the file_name_convert clause to the statement and set the pdb_file_name_convert parameter.
- B. Set the pdb_file_name_convert parameter and enable OMF.
- C. Enable only OMF.
- D. Add only the create_file_dest clause to the statement.
- E. Add the file_mame_comvert clause to the statement and enable Oracle Managed Files (OMF).
- F. Set only the pdb_file_name_convert parameter.
Answer: A,B,E
NEW QUESTION 161
Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)
- A. It is used to change failure priority only for the CRITICAL priority.
- B. It is used to execute the advised repair script.
- C. It is used to change failure priority only for HIGH or LOW priorities.
- D. It is used to inform the database about the repair after the repair script executes.
- E. It is used to explicitly close the open failures.
Answer: C,E
NEW QUESTION 162
Examine this output:
Which two are true? (Choose two.)
- A. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
- B. Any PDB not specified in the plan will be unable to execute statements in parallel.
- C. PDB3 can use all available parallel execution processes at times.
- D. PDB2is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
- E. PDB1is always limited to 40% of the available system resources regardless of demand.
- F. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
Answer: A,B
NEW QUESTION 163
choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).
- A. to allow database duplication without a connection to the target instance.
- B. to allow database duplication without a connection to the auxiliary instance.
- C. to store backups that would cause the controlfile to become too large.
- D. to report on the database schema at an earlier point in time.
- E. to store backup metadata that would cause the controlfile to become too large.
Answer: A,D,E
NEW QUESTION 164
You plan to create a database by using the Database Configuration Assistant (DBCA), with t he following specifications: Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with t he execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?
- A. a General Purpose database template with default memory allocation
- B. a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled
- C. a Data Warehouse database template, with t he dedicated server mode option and AMM enabled
- D. a default database configuration
Answer: B
NEW QUESTION 165
Choose two. Which two are true about backup set compression using RMAN default compression?
- A. Compression can be done only for locally managed tablespaces.
- B. Compressed backups can be written only to media.
- C. Compressed backups cannot have a section size defined.
- D. Binary compression adds CPU overhead to backup operations.
- E. Unused blocks below the high water mark are backed up.
Answer: A,D
NEW QUESTION 166
Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1. After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment: $ export ORACLE_SID=cdb1 $ sqlplus / as sysdba SQL> STARTUP UPGRADE; SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------------------------------------------------------------2 PDB$SEED 3 PDB1 4 PDB2 MIGRATE YES MOUNTED YES MOUNTED YES SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggable database altered. SQL> exit $ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2' What is the outcome?
- A. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
- B. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
- C. It fails because PDB$SEED is in MIGRATE state.
- D. Only CDB$ROOT and PDB$SEED are upgraded.
- E. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
- F. It fails because PDB2 is not in UPGRADE state.
Answer: F
NEW QUESTION 167
......
Prepare With Top Rated High-quality 1Z0-083 Dumps For Success in Exam: https://www.exam4free.com/1Z0-083-valid-dumps.html
Get Totally Free Updates on 1Z0-083 Dumps PDF Questions: https://drive.google.com/open?id=1wXemu2IFF69PnN2a7aOWbGiDFHAeyiGJ
