Q1. You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
A. USERS
B. SYSTEM
C. SYSAUX
D. EXAMPLE
Answer: A
Explanation:
This table space is used to store permanent user objects and data. Like the TEMP table space, every database should have a table space for permanent user data that is assigned to users. Otherwise, user objects will be created in the SYSTEM table space, which is not good practice. In the preconfigured database, USERS is assigned the default table space, and space for all objects created by non-system users comes from this table space. For system users, the default permanent table space remains SYSTEM.
Q2. Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.
Which two actions would you take to solve this problem?
A. Enable temporary undo for the database.
B. Enable undo retention guarantee.
C. Increase the size of the redo log buffer.
D. Enable Automatic Memory Management (AMM).
E. Increase the size of the temporary tablespace.
Answer: D,E
Q3. You want to reduce fragmentation and reclaim unused space for the sales table but not its
dependent objects. During this operation, you want toensure the following:
i.Long-running queries are not affected.
ii.No extra space is used.
iii.Data manipulation language (DML) operations on the table succeed at all times
throughout theprocess.
iv.Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?
A. DEALLOCATE UNUSED
B. SHRINK SPACE CASCADE
C. SHRINK SPACE COMPACT
D. ROW STORE COMPRESS BASIC
Answer: A
Q4. In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?
A. heap table with a primary key index
B. external table
C. hash clustered table
D. global temporary table
E. index clustered table
Answer: E
Q5. Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
A. Tables or table partitions can be recovered by using an auxiliary instance only.
B. Tables or table partitions with a foreign key cannot be recovered.
C. Tables or table partitions can be recovered only when the database is in mount state.
D. Tables or table partitions from the system and sysauxtablespaces cannot be recovered.
E. Tables with not null constraints cannot be recovered.
Answer: A,D
Reference:http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695(Limitat ions of Recovering Tablesand Table Partitions from RMAN Backups)
Q6. You have a production Oracle 12c database running on a host.
You want toinstall and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1.Create directory structures similar to the production database on all new machines.
2.Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3.Create a database clone template for the database.
4.Run the Database Configuration Assistant (DBCA) to create the database.
5.Run OUI in graphical mode on each machine.
6.Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirementwith minimal human intervention.
A. 2, 1, 6, and 4
B. 2, 3, and 6
C. 3, 1, 5, and 6
D. 2, 3, 1, and 6
E. 1, 5, and 4
Answer: D
Q7. Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database(COB) plan using Oracle Database Resource Manager?
A. maximum undo per consumer group
B. maximum idle time for a session in a PDB
C. parallel server limit
D. CPU
E. maximum number of sessions for a PDB
Answer: C,D
Q8. Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
A. whenthe duplicate ... from active database command contains the section size clause
B. when you perform active database duplication on a database with flashback disabled
C. when you specify set encryption before the duplicate ... from active database command
D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
E. when you perform active database duplication on a database that has read-onlytablespaces
Answer: A,C,D
Reference:http://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV298
Q9. Which three statements are true about persistent lightweight jobs?
A. A user cannot set privileges on them.
B. They generate large amounts of metadata.
C. They may be created as fully self-contained jobs.
D. They must reference an existing Scheduler Program.
E. The are useful when users need to create a large number of jobs quickly.
Answer: A,D,E
Q10. You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?
A. The backup must be performed in mount state.
B. The tablespace must betaken offline.
C. All files must be backed up as backup sets.
D. The database must be backed up as an image copy.
Answer: A