摘要:
The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST an 阅读全文
摘要:
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL T 阅读全文
摘要:
Note the following parameters settings in your database:SGA_MAX_SIZE = 1024M SGA_TARGET = 700MDB_8K_CACHE_SIZE = 124MLOG_BUFFER = 200MYou issued the f 阅读全文
摘要:
The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MIN 阅读全文
摘要:
Consider the following scenario for your database:-Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The most rece 阅读全文
摘要:
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain aseparation of responsibilities along with a consolidation of 阅读全文
摘要:
You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these 阅读全文
摘要:
Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met bef 阅读全文
摘要:
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?(Choose two.)A.viewsB.fixed tablesC.heap tablesD.extern 阅读全文
摘要:
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best optio 阅读全文