- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
96.
When exporting metadata for the transportable tablespaces, what is the correct next
step after confirming endian format?
- A.Export the tablespaces using Data Pump.
- B.Determine if the transportable set is self-contained.
- C.Convert the data files using RMAN.
- D.Copy the data files from source to destination.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Execute the DBMS_TTS.TRANSPORT_SET_CHECK procedure using the proposed list of tablespaces for the transportable set. Optionally, the last parameter should be TRUE to verify referential integrity constraints. |
97.
Which of the following are prerequisite steps to transport a database? (Choose all
that apply.)
- A.Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the intended destination is listed.
- B.Verify that there are no restrictions or limitations that the source or destination database may encounter.
- C.Verify that the source and destination have the same Oracle version, critical updates, patch-set version, and patch-set exceptions.
- D.Determine if you will perform the conversion on the source or destination platform.
- E.None of the above
- Answer & Explanation
- Report
Answer : [B, C, D]
Explanation :
Explanation :
| Option A is incorrect because the correct view name is V$DB_TRANSPORTABLE_ PLATFORM . You’ll need to verify that there are no restrictions or limitations such as stor- age or memory, verify that the version levels are the same, and determine where you will perform the conversion. |
98.
Which of the following supplied functions is used to identify external tables, directories,
and BFILES?
- A.DBMS_TDB.CHECK_DIRECTORIES
- B.DBMS_TDB.CHECK_EXTERNAL
- C.DBMS_TDB.CHECK_BFILE
- D.DBMS_TDB.CHECK_EXT
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The DBMS_TDB.CHECK_EXTERNAL function returns the list of external files that will need to be copied to the destination system. The other options are not valid. |
99.
Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful
completion?
- A.The database must be in read-write mode
- B.The database must have no external files.
- C.The database must open in read-only mode.
- D.The database must be mounted but not opened.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The DBMS_TDB.CHECK_DB function must execute with the database open and in read-only mode. |
100.
Which of the following options describes segment shrink?
- A.Reclaims space above and below the high-water mark without using additional space
- B.Moves rows to a new physical location, resetting the high-water mark, but uses additional space during the operation
- C.Deallocates space above the high-water mark that is currently not in use
- D.None of the above
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The segment shrink feature reclaims space above and below the high-water mark without using additional space to perform an operation. |
|
|
||||||||||||||||||||||||||||
