READ Free Dumps For Oracle- 1z0-050
| Question ID 5999 | In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command: SQL>SELECT /*+ RESULT_CACHE 7 sale_categoiy, sum(sale_amt) FROM sales GROUP BY sale_categoiy; Where would the result of this query be stored? |
| Option A | PGA |
| Option B | large pool |
| Option C | shared pool |
| Option D | database buffer cache |
| Correct Answer | C |
| Question ID 6000 | You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the userRC011. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recover catalog owned by RC011.
What happens when you execute the above commands? (Choose all that apply.) |
| Option A | They deregister all databases registered in the RCAT10 catalog. |
| Option B | They import metadata for all registered databases in the RCAT10 database. |
| Option C | They register all the RCATIO-catalog registered databases in the RC011 catalog. |
| Option D | They overwrite all stored scripts in the RC011 catalog with the same name as that in the RCAT10 catalog. |
| Correct Answer | A,B,C |
You executed the following RMAN commands:
RMAN> CONNECT CATALOG rco1 1/password@catdb RMAN> IMPORT CATALOG rcat1 0/oracle@inst1;