Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
ALTER DATABASE...CREATE DATAFILE
Note: This Question is unanswered, help us to find answer for this one
3. Which can you use Recovery Manager (RMAN) to perform incremental backup?
Answer
Correct Answer:
All
Note: This Question is unanswered, help us to find answer for this one
4. An Oracle Instance consists of Processes and Memory Structures, Processes can be subdivided as follows?
Answer
Correct Answer:
All
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
MAP_OBJECT
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
REMAP_SCHEMA
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
If the above operation were successful, media recovery would be required to bring the Tablespace online
Note: This Question is unanswered, help us to find answer for this one
8. Which is Used by Oracle during Table and Index creation and for sorting?
Answer
Correct Answer:
Temporary Segments
Note: This Question is unanswered, help us to find answer for this one
9. Which two statements are true about the roles in the Oracle database?
Answer
Correct Answer:
Roles can be granted to other roles And A role can contain both system and object privileges
Note: This Question is unanswered, help us to find answer for this one
10. In mapping structure describes the link between an element and the next elements in the I/O mapping stack?
Answer
Correct Answer:
Subelements Mapping
Note: This Question is unanswered, help us to find answer for this one
11. In mapping structure which describes the link between an element and the next elements in the I/O mapping stack?
Answer
Correct Answer:
Subelements Mapping
Note: This Question is unanswered, help us to find answer for this one
12. Which statement we used for you can manually increase or decrease the size of a datafile?
Answer
Correct Answer:
ALTER DATABASE
Note: This Question is unanswered, help us to find answer for this one
