This certification validates practical skills in enterprise business systems, with emphasis on configuring processes, managing information, and supporting business outcomes. It is intended for professionals who implement or operate enterprise business systems.
The database is configured in ARCHIEVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?
You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.
Identify two prerequisites to perform the backups. (Choose two.)
You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the
DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?
View the Exhibit and examine the RMAN commands.
Which statement describes the effect of a backup retention policy on the backup of a backup set?