Note: This Question is unanswered, help us to find answer for this one
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
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
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
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
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
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
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
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
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
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
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