Oracle Database Administration from Zero to Hero - Using Oracle Data Pump (Part 2 of 3)

The video tutorial covers Oracle Data Pump utilities, focusing on different modes like full, schema, and table. It explains how to set these modes using command line parameters and provides examples of using the export utility. Advanced techniques for exporting data, managing dump files, and filtering objects are discussed. The tutorial also covers estimating dump file sizes and using network links for export/import operations.

Which mode would you use to move the entire database including all schemas?

• Schema mode

• Table mode

• Full mode

• Tablespace mode

What parameter is used to export or import specific schemas?

• Tablespaces

• Tables

• Schema

• Full

If no mode parameter is specified, which mode does the Data Pump utility default to?

• Table mode

• Tablespace mode

• Schema mode

• Full mode

What is the advantage of using a parameter file with Data Pump utilities?

• It reduces the need for command line input

• It increases the speed of data transfer

• It allows for larger dump files

• It provides better data compression

Which parameter allows you to specify the maximum size of a dump file?

• Dump file

• File size

• Estimate

• Network link

How can you exclude certain objects from being exported using Data Pump?

• By using the include parameter

• By using the skip parameter

• By using the exclude parameter

• By using the filter parameter

What does the estimate only parameter do in Data Pump?

• Exports only system schemas

• Performs a full export

• Calculates the estimated size of the dump file

• Imports data from a network link

Which method is used to transfer data between databases over a network using Data Pump?

• Using the network link parameter

• Using the file size parameter

• Using the exclude parameter

• Using the include parameter

What is the default value for the estimate parameter in Data Pump?

• Blocks

• Schema

• Statistics

• Full

Which parameter is used to specify a database link for network export/import?

• Estimate

• File size

• Dump file

• Network link