Managing Data-files And Temp-files MCQ

1. In oracle, dates have the format ____.

2. Which SQL Statement creates a new empty datafiles in place of an old one--useful to re-create a datafiles that was lost with no backup?

3. Which can you use Recovery Manager (RMAN) to perform incremental backup?

4. An Oracle Instance consists of Processes and Memory Structures, Processes can be subdivided as follows?

5. The DBMS_STORAGE_MAP package procedure enables you to build the mapping information for the database object identified by object name, owner, and type?

6. You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?

7. Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario?

8. Which is Used by Oracle during Table and Index creation and for sorting?

9. Which two statements are true about the roles in the Oracle database?

10. In mapping structure describes the link between an element and the next elements in the I/O mapping stack?

11. In mapping structure which describes the link between an element and the next elements in the I/O mapping stack?

12. Which statement we used for you can manually increase or decrease the size of a datafile?