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.
单项选择题WhichstatementistrueaboutloadingdatausingtheconventionalpathofSQL*Loader()
A.Redo is not generated while performing conventional path loads. B.Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked. C.No exclusive locks are acquired when the conventional path loads are performed. D.Instead of performing transactions, SQL*Loader directly writes data blocks to the data files. E.INSERT triggers are disabled before the conventional path load and reenabled at the end of the load.
多项选择题Whichtwooperationscanbeperformedonanexternaltable()
A.Create a view on the table. B.Create an index on the table. C.Create a synonym on the table. D.Add a virtual column to the table. E.Update the table using the UPDATE statement. F.Delete rows in the table using the DELETE command.