Load data from a disk, tape, or named pipes.
Load data into an Oracle database using DML statements.
Extract, reorganize, and insert data within an Oracle database.
Load data from external files into tables in an Oracle database.
Load data into an Oracle database using operating system commands.
Load data directly from a non-Oracle database to an Oracle database.
第1题:
You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database()
第2题:
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning,media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation?()
第3题:
You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()
第4题:
You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance, you plan to move the data from the flat files toclustered tablesin an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database()
第5题:
Which two client requests are captured during database replay Capture?() (Choose two)
第6题:
Note the following points describing various utilities in Oracle Database 11g: 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup, restoration, and recovery needs of the entire database. 3. It enables the loading of data from an external file into tables of an Oracle database. 4. It provides a tape backup management for the Oracle ecosystem. Which point describes the Oracle Data Pump utility()
第7题:
Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g?()
第8题:
Flashback queries
Shared server requests
Login and logoff activities of sessions
Direct path load of data from external files by using utilities such as SQL *loader
Data definition language (DDL) and data manipulation language (DML) operations
第9题:
You cannot export data from a remote database.
You can rename tables during an import operation.
You can overwrite existing dump files during an export operation.
You can compress the data during export but not the metadata because it is not supported.
第10题:
When loading selected rows into each table.
When loading data from an export dump file.
When loading data from disk, tape, or named pipes.
When your data is NOT being inserted from a flat file.
When using a record management system to access data files.
第11题:
EXPDP and IMPDP are the client components of Oracle Data Pump.
DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
第12题:
Flashback queries
Shared server requests
Login and logoff activities of sessions
Direct path load of data from external files by using utilities such as SQL *loader
Data definition language (DDL) and data manipulation language (DML) operations
第13题:
For which two tasks would it be best NOT to use the utility SQL*Loader?()
第14题:
The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?()
第15题:
Which two statements are true regarding Oracle Data Pump()
第16题:
Which two client requests are captured during database replay Capture?()
第17题:
You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()
第18题:
Which two statements are true regarding the usage of the SQL*Loader utility()
第19题:
ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database. Which is the most effectivemethod to access this data in your database()
第20题:
Generate reports on data failure such as data file failures.
You can track the Service Request (SR) and implement repairs.
You can package and upload diagnostic data to Oracle Support.
You can manually run health checks to gather diagnostic data for a problem.
第21题:
1
2
3
4
1 and 3
1, 2, 3, and 4
第22题:
You can load data into multiple tables during the same load session.
You can load data from multiple files to a table during the same load session.
You cannot perform selective data loading based on the values available in the records.
You can use an export file generated by the EXPDP utility as an input data file to load the data.
You can load data only if the input file is available on the disk and tape but not in a named pipes.
第23题:
Oracle Flashback uses undo information to construct consistent data.
You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.
You can only use Oracle Flashback view of the data if the required records are still in the online redo log files.
Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.