1. Before a DBA creates a transportable
tablespace, which condition must be completed?
A. All indexes are disabled or dropped.
B. The target system has precreated the tablespace.
C. The target system is in the same operating system.
D. The tables containing nested tables are contained in the same tablespace.
correct answer: c
2. Can we transport tablespace from one database to another database which is having SYS owned objects?
A. Yes
B. No
correct answer: b
3. What is default value for TRANSPORT_TABLESPACE Parameter in EXP?
A. Yes
B. No
correct answer: b
4. How to find whether tablespace is created in that database or transported from another database?
A. V$database
B Dba_tablespaces
C. Dba_data_files
D. V$transport_tablespace
correct answer: b
5. Can we Perform TTS using EXPDP?
A. Yes
B. No
correct answer: a
6. Can we Transport Tablespace which has Materialized View in it?
A. Yes
B. No
correct answer: b
A. All indexes are disabled or dropped.
B. The target system has precreated the tablespace.
C. The target system is in the same operating system.
D. The tables containing nested tables are contained in the same tablespace.
correct answer: c
2. Can we transport tablespace from one database to another database which is having SYS owned objects?
A. Yes
B. No
correct answer: b
3. What is default value for TRANSPORT_TABLESPACE Parameter in EXP?
A. Yes
B. No
correct answer: b
4. How to find whether tablespace is created in that database or transported from another database?
A. V$database
B Dba_tablespaces
C. Dba_data_files
D. V$transport_tablespace
correct answer: b
5. Can we Perform TTS using EXPDP?
A. Yes
B. No
correct answer: a
6. Can we Transport Tablespace which has Materialized View in it?
A. Yes
B. No
correct answer: b
0 comments:
Post a Comment