What two are benefits of Data Pump? (Choose two.) A. It can execute in parallel. B. It can restart failed export jobs. C. It makes use of client system resources. D. It can export data into sequential media, such as…
orcl.dmp contains a full export of the ORCL database. This command is executed to load data from orcl.dmp into the TESTDB database: Which two are true? (Choose two.) A. It skips only tables that exist in both ORCL:SH and TESTDB:HR.…
Which is true about security rules on a compute node? A. The port used for HTTPS connections is enabled by default based on a predefined security rule. B. A security rule can restrict IP addresses that can connect to a…
Which is true about roles? A. A role can be granted to other roles. B. Roles can be created only by SYS or SYSTEM. C. Roles containing object privileges can be created only by the object owner. D. All roles…
In the ORCL database, DEFERRED_SEGMENT_CREATION is FALSE. Examine this command: Which table segments are created? A. T1 and an index segment created for the primary key only B. T1, an index segment for the primary key, a LOB segment, and…
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.) A. AWR snapshots must be deleted when no longer required by ADDM. B. ADDM can recommend shrinking the buffer…
What three are true about Oracle Flashback technology? (Choose three.) A. FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction. B. FLASHBACK TABLE can be used to rewind a table back in time. C. FLASHBACK…
Examine this command: Which two changes must you make so that TEMP_TBS is created? (Choose two.) A. Add the EXTENT MANAGEMENT LOCAL UNIFORM clause. B. Add the NOLOGGING clause. C. Remove the SEGMENT MANAGEMENT AUTO clause. D. Remove the AUTOEXTEND…
Which two can you use to recover a dropped table? (Choose two.) A. FLASHBACK QUERY B. FLASHBACK DATABASE C. FLASHBACK TRANSACTION D. FLASHBACK TABLE TO SCN E. FLASHBACK DROP
Which two are true about RETENTION GUARANTEE? (Choose two.) A. It is a tablespace attribute. B. It prevents FLASHBACK DATABASE operation failure. C. It prevents out-of-space errors. D. It prevents “Snapshot too old” errors. E. It is a static parameter.