单项选择题
You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database.
Which option of IMPDP would you use to accomplish this task()
A.FULL
B.SCHEMAS
C.TRANSFORM
D.REMAP_SCHEMA
E.REMAP_TABLESPACE
相关考题
-
多项选择题
InwhichsituationsdoestheOracleDataPumpuseexternaltablesandnotthedirectpathloadwhileexportingatable()
A.if a table is not in a cluster
B.if a table has an active trigger
C.if a table has an encrypted
D.if a table has a column of data type LONG defined on it
E.if a table has a referential integrity constraint defined on it -
多项选择题
WhichtwostatementsaretrueregardingOracleDataPump()
A.EXPDP and IMPDP are the client components of Oracle Data Pump.
B.DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
C.Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
D.Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
E.EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands. -
多项选择题
WhichtwostatementsaretrueregardingtheusageoftheSQL*Loaderutility()
A.You can load data into multiple tables during the same load session.
B.You can load data from multiple files to a table during the same load session.
C.You cannot perform selective data loading based on the values available in the records.
D.You can use an export file generated by the EXPDP utility as an input data file to load the data.
E.You can load data only if the input file is available on the disk and tape but not in a named pipes.
