A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the followingError message:Which is the recommended sequence of operations you need to perform for the query successfully?
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)
You perform a backup using the following BACKUP command:RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;Which statement is true of this command?
You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'GLOBAL');You need statistics to be collected more quickly.What can you do to achieve this?
The INV_HISTORY table is created using the command:The following data has been inserted into the INV_HISTORY table:You would like to store the data belonging to the year 2006 in a single partition and issue the command:SQL> ALTER TABLE inv_history -MERGE PARTITIONS -FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')),FOR(TO_DATE('15-apr-2006'))INTO PARTITION sys_py;What would be the outcome of this command?
