What two are the prerequisites for enabling Flashback Database?
Which statements are true regarding system-partitioned tables? (Choose all that apply.)
The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations.How would you achieve this?
You created a database with the Database Configuration Assistant (DBCA) by using one of the default templates.Which tablespace will be the default permanent tablespace for non-system users, excluding DBSNMP and OUTLN?
While exporting data with Data Pump, you find that the export takes longer than expected. You decide to stop the job and restart it during off-peak hours.Which view would you query to determine the name and status of the stopped job?
Note the output of the following query:SQL> SELECTflashback_archive_name,status FROM dba_flashback_archive;FLASHBACK_ARCHIVE_NAMESTATUS ---------------------------------------------------------------FLA1 -You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:ALTERTABLEexchange_rateFLASHBACK ARCHIVE;What is the outcome of this command?
