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 Data Warehouse database template, with t he dedicated server mode option and AMM enabled
C. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled
D. a default database configuration
Which two are true about a read-only Oracle home? (Choose two).
A. It is enabled by performing a software-only Oracle Database installation and then running the roohctl -enable script.
B. It requires the Rapid Home Provisioning service.
C. Its configuration data and log files reside in subdirectories under the Oracle home.
D. It is enabled by performing an Oracle Database installation with database creation and then running the roohctl -enable script.
E. It contains an image that can be distributed across multiple servers.
Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)? (Choose two).
A. A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.
B. A PDB Lockdown profile can be created in an application root.
C. A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.
D. A PDB Lockdown profile can be created in a regular PDB.
E. A PDB Lockdown profile can be created in CDB$ROOT .
Which three are true about corrupted data blocks and their recovery in an Oracle Database? (Choose three).
A. If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.
B. DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.
C. A media corrupt block is one where the block is not formatted correctly.
D. The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.
E. If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.
F. DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.
Examine this configuration:
1.
CDB1 is an Oracle container database from an older release.
2.
PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1.
A priority list UpgrdList has these entries: 1, pdb2 2, pdb1, pdb3
You execute this command: $ /u01/app/oracle/product/18.1.0/ db_1/rdbms/admin/dbupgrade -L UpgrdList
In which order will the upgrade occur?
A. CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4
B. CDB$ROOT, PDB2, PDB1, and PDB3
C. CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3
D. CDB$ROOT, PDB1, PDB2, PDB3, and PDB4
E. CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4
A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Which three are required?
A. CDB2 must be in shared UNDO mode only.
B. CDB2 must be in archivelog mode.
C. CDB1 must be in archivelog mode.
D. CDB1 and CDB2 must both be in local UNDO mode.
E. CDB1 must be in shared UNDO mode only.A container database, CDB1, contains a pluggable database PDB1.
F. CDB1 and CDB2 must be in shared UNDO mode.
Which two are prerequisites for creating a backup-based duplicate database?
A. connecting to the target database and a recovery catalog to execute the duplicate command
B. creating a password file for an auxiliary instance
C. connecting to an auxiliary instance
D. matching the database identifier (DBID) of the source database and the duplicate database
E. creating an SPFILE for the target database
Examine this configuration:
1.
CDB1 is a container database.
2.
There are several pluggable databases (PDBs) in CDB1.
5.
Each PDB has several tables with referential integrity constraints.
6.
FLASHBACK DATABASE is ON.
7.
UNDO RETENTION GUARANTEE is enabled.
Multiple undesired multitable changes were made in all the PDBs.
Which method can be used to undo the changes using a single command?
A. restore and recover database
B. flashback transaction
C. flashback database
D. flashback table and transaction
E. flashback table
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three)
A. to report on the database schema at an earlier point in time
B. to store backups that would cause the controlfile to become too large
C. to allow database duplication without a connection to the target instance
D. to allow database duplication without a connection to the auxiliary instance
E. to store backup metadata that would cause the controlfile to become too large
Which four are true about performance-related Oracle tools? Choose four
A. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two consecutive periods.
B. SQL Performance Analyzer can suggest schema changes.
C. SQL Performance Analyzer can identify regressed SQL statements.
D. Database Replay always uses one replay client for all the original database sessions.
E. Database Replay always uses one replay client for each original database session.
F. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two non -consecutive periods.
G. The Active Session History (ASH) report is based on wait event samples.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-083 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.