多选题Which  statements are true regarding the Oracle Data Pump export and import operations()AYou cannot export data from a remote database.BYou can rename tables during an import operation.CYou can overwrite existing dump files during an export operation.DYou can compress the data during export but not the metadata because it is not supported

多选题
Which  statements are true regarding the Oracle Data Pump export and import operations()
A

You cannot export data from a remote database.

B

You can rename tables during an import operation.

C

You can overwrite existing dump files during an export operation.

D

You can compress the data during export but not the metadata because it is not supported


参考解析

解析: 暂无解析

相关考题:

单选题Which statement is true about loading data using the conventional path of SQL*Loader()ARedo is not generated while performing conventional path loads.BOnly PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked.CNo exclusive locks are acquired when the conventional path loads are performed.DInstead of performing transactions, SQL*Loader directly writes data blocks to the data files.EINSERT triggers are disabled before the conventional path load and reenabled at the end of the load.

单选题Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future.  What action would you take to achieve this task()AInsert finding directives for ADDM tasks in the future.BCreate a baseline on a pair of snapshots spanning the peak-load period.CDecrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.DSet the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots.

单选题Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client  while connecting to the database instance from a remote machine()Ahost naming methodBlocal naming methodCexternal naming methodDdirectory naming method

多选题Which  statements are true regarding the Oracle Data Pump export and import operations()AYou cannot export data from a remote database.BYou can rename tables during an import operation.CYou can overwrite existing dump files during an export operation.DYou can compress the data during export but not the metadata because it is not supported

单选题These are points that describe the contents of different memory components:  1: Descriptive information or metadata about schema objects that are queried by using SQL statements  2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements  3: Results of SQL queries and PL/SQL functions  4: Executable forms of SQL cursors, PL/SQL programs, and Java classes  5: The information necessary to reconstruct changes made to the database by a transaction  Which of these will be stored in theShared Poolif the necessary configurations are done()A1 and 2B2 and 5C1,3,and 4D3,4,and 5E1,2,3,and 4

多选题You configured the Flash Recovery Area (FRA) for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which twofiles are removed automatically if the space is required in the FRA as per the retention policy()AFlashback log filesBBackups that have become obsoleteCUser managed backups of the data files and control filesDArchived redo log files that have multiple copies in a different archive location and not backed up

多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, orany data definition language (DDL) command: SQL SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session()ALOCK TABLE emp IN SHARE MODE;BLOCK TABLE emp IN EXCLUSIVE MODE;CUPDATE emp SET sal=sal*1.2 WHERE job=ANAGER?UPDATE emp SET sal=sal*1.2 WHERE job=?ANAGER?DINSERT INTO emp(empno,ename) VALUES (1289,’Harry’);ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

单选题Identify the memory component from which memory may be allocated for:() 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager (RMAN) backup and restore operationsALarge PoolBRedo Log BufferCDatabase Buffer CacheDProgram Global Area (PGA)

单选题Identify the logical structure that will never have more than one data segment created for it.()Aexternal tableBpartitioned tableCpartitioned indexDnonclustered tableEglobal temporary table

多选题Which operations require undo data()ACommitting a transactionBFlashing back a transactionCRecovering a failed transactionDRunning a read-consistent queryEChanging a tablespace status from READ ONLY to READ WRITE