多项选择题Which two statements are true regarding Oracle Data Pump()

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.


您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题Which two statements are true regarding the usage of the SQL*Loader utility()

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.

2.单项选择题Which statement is true about loading data using the conventional path of SQL*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.

3.多项选择题Which two operations can be performed on an external table()

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.

7.单项选择题

You executed the following commands in an RMAN session for your database instance that has failures: 
RMAN> LIST FAILURE; 
After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE; 
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution ofthe last LIST FAILURE command. 
Which statement is true for the above ADVISE FAILURE command in this scenario()

A.It produces a warning for new failures before advising for CRITICAL and HIGH failures.
B.It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
C.It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored
D.It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

8.单项选择题

View the Exhibit to examine the error that occurred during the database startup.

You opened an RMAN session for the database. To repair the failure, you executed the followingcommand as the first RMAN command: 
RMAN>REPAIR FAILURE; 
Which statement describes the consequence of this command()

A.The command performs the recovery and closes the failure.
B.The command only displays the advice and the RMAN script required for recovery.
C.The command executes the RMAN script to repair the failure and remove the entry from the Automatic Diagnostic Repository (ADR).
D.The command produces an error because the ADVISE FAILURE command was not executed beforethe REPAIR FAILURE command.

9.多项选择题Which two activities are NOT supported by the Data Recovery Advisor (DRA)()

A.Recover from failures in the RAC environment.
B.Diagnose and repair a data file corruption online.
C.Diagnose and repair a data file corruption offline.
D.Diagnose and repair failures on a standby database

10.多项选择题Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist()

A.failure when no standby database is configured
B.failure because a data file is renamed accidentally
C.failure that requires no archive logs to be applied for recovery
D.failure due to loss of connectivity-for example, an unplugged disk cable

最新试题

The database instance has the following parameter setting:OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD, and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process()

题型:单项选择题

You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database()

题型:单项选择题

You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90Critical (%): 95Which background process is responsible for issuing alerts when the threshold is crossed()

题型:单项选择题

All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions:SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’; 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’;3 rows deleted.The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands()

题型:单项选择题

You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE;Which statements describe the effect of the command()

题型:多项选择题

Which  statements are true regarding listeners()

题型:多项选择题

You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this()

题型:单项选择题

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()

题型:多项选择题

Which statements are true about logical structures of the Oracle database()

题型:多项选择题

Which statement is true about loading data using the conventional path of SQL*Loader()

题型:单项选择题