Oracle OCP 9i to 11g Load and Unload Data

Card Set Information

Author:
Tralala
ID:
191143
Filename:
Oracle OCP 9i to 11g Load and Unload Data
Updated:
2014-05-16 10:07:42
Tags:
Oracle OCP 9i 11g Load Unload Data
Folders:

Description:
Oracle OCP 9i to 11g Load and Unload Data
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. Which view shows which platforms are supported for Cross Platform tablespace transport?
    V$TRANSPORTABLE_PLATFORM
  2. What must the source and target database share for transportable tablespaces?
    Character set and national character set
  3. What cannot be transported in transportable tablespaces?
    • SYSTEM tablespace or objects owned by the user SYS
    • Materialized Views
    • A table partition, the entire table must be transported
  4. Which view will show you what platform you are on?
    V$database (select platform_name from v$database)
  5. Which view will show the endian format of your platform?
    V$TRANSPORTABLE_PLATFORM
  6. Which utility can be used to check if a tablespace is ready for transportation?
    • DBMS_TTS.TRANSPORT_SET_CHECK
    • DBMS_TTS.TRANSPORT_SET_CHECK( TS_LIST=>'sales_1,sales_2', INCL_CONSTRAINTS =>TRUE,FULL_CHECK =>TRUE)
  7. To use DBMS_TTS, what role must you have been granted?
    EXECUTE_CATALOG_ROLE
  8. Which view shows what issues should be addressed before transporting a tablespace?
    TRANSPORT_SET_VIOLATIONS
  9. Which utility is used for transporting a tablespace?
    expdb
  10. What utility is used for converting tablespaces to a different platform?
    RMAN
  11. What can you do with Export and Import Data Pump utilities?
    • export and import data faster than Old export/import utilities
    • estimate job times
    • perform fine-grained object selection
    • monitor jobs effectively
    • directly load one database from a remote instance
    • call the utilities from PL/SQL using Data Dump API
    • stop, resume and restart the utilities
    • attach a running job to monitor jobs, as well as to modify certain parameters interactively.
    • have fine-grained data import capability
    • remap objects of a specific schema to another schema
  12. Which package contains the main Data Pump utilities?
    DBMS_Data Pump
  13. Which packaged is used to extract data dictionary data?
    DBMS_METADATA
  14. When cannot the direct method method be used to access tables in data pump?
    • Clustered tables
    • Presence of active triggers in the tables
    • Export of a single partition in a table with a global index
    • Presence of referential integrity constraints
    • Presence of domain indexes on LOB columns
    • Tables with fine-grained access control enabled in the insert mode
    • Tables with BFILE or opaque type columns
  15. Where is the default data pump directory located?
    • The one defined by DATA_PUMP_DIR in DBA_DIRECTORIES
    • $ORACLE_BASEadmin<SID>dpdump
  16. In Data Pump what does the parameter DIRECTORY:FILE do?
    • Allows the Directory and the filename to be defined in one command
    • expdp LOGFILE=dpump_dir2:salapati.log
  17. If you choose to use your own export directory in data pump, what option must be used
    DIRECTORY
  18. How is the OS variable DATA_PUMP_DIR be used?
    • If DIRECTORY is not given in the expdp command, this can be used to define the export directory
    • NB The directory must be in DBA_DIRECTORIES
  19. What is the dm00 process?
    The data pump Master Process.
  20. What does the data pump Master Process do?
    • Creates jobs and controls them
    • Creates and manages the worker processes
    • Monitors the jobs and logs the progress
    • Maintains the job state and restart information in the master table
    • Manages the necessary files, including the dump file set
  21. Where is Master Process table created?
    In the schema of the executing user.
  22. Which data pump parameter controls how many worker processes are spawned?
    PARALLEL
  23. How are the data pump worker processes called at OS level?
    • DWnn
    • Where nn is the number of the process.
  24. What are the data pump client processes?
    expdp and impdp
  25. What are the data pump export modes?
    • Full export mode: using FULL parameter
    • Schema mode: using SCHEMAS parameter
    • Tablespace mode: using TABLESPACES and/or TRANSPORT_TABLESPACES parameters
    • Table mode: using TABLES parameter
  26. Which data pump parameter will suppress logfile generation?
    NOLOGFILE=Y
  27. Which data pump parameter will specifiy the maximum size of the export file?
    FILESIZE
  28. What does data pump TRANSPORT_FULL_CHECK parameter do?
    Checks to make sure that the tablespaces you are trying to transport meet all the conditions.
  29. What are the possible options for the data pump CONTENT parameter?
    • ALL exports data and definitions (metadata).
    • DATA_ONLY exports only table rows.
    • METADATA_ONLY exports only metadata (this is equivalent to rows=n)
  30. What are the possible options for data pump EXCLUDE and INCLUDE parameter?
    • A list of objects types to exclude or include
    • THEY ARE MUTUALLY EXCLUSIVE
  31. How can one selectively export table row data using data pump?
    • Using the Query parameter
    • QUERY=SCOTT.EMP:"WHERE sal > 3000"
  32. What is the default ESTIMATION method in data pump?
    Blocks
  33. What are the ESTIMATION methods options in data pump?
    Blocks and Statistics
  34. How can data pump get an estimate of the export filesize?
    ESTIMATE_ONLY=Y
  35. What role do you require to attach and control Data Pump jobs of other users?
    EXP_FULL_DATABASE or IMP_FULL_DATABASE
  36. What command allows connection to a running data pump job?
    ATTACH
  37. What command stops a running Data Pump job?
    STOP_JOB
  38. What command restarts a Data Pump job?
    START_JOB
  39. What command terminates a Data Pump job?
    KILL_JOB
  40. What does the Data Pump command KILL_JOB do?
    Kills the job drops the master table
  41. What command allows a datafile to be added to a Data Pump job?
    ADD_FILE
  42. How can the current progress of a data pump job be found?
    STATUS command in Data Pump
  43. How can the default name of the export job be overidden?
    JOB_NAME=...
  44. What is the format for a default Data Pump job name?
    • <USER>_<OPERATION>_<MODE>_%N
    • ie SYSTEM_EXPORT_FULL_01
  45. When using the PARALLEL command, what souuld one consider about the export datafiles?
    There should be the same number of datafiles as the degree of parallism.
  46. What a the options for Data Pump COMPRESSION parameter?
    ALL, DATA_ONLY, METADATA_ONLY, NONE
  47. How do you extract the SQL from an export dump file?
    • SQLFILE=<DIRECTORY>:<FILENAME>
  48. How does one import the data from one user to another user?
    • Using REMAP_SCHEMA
    • REMAP_SCHEMA=OE:HR OE objects will be remapped to HR
  49. What does the TRANSFORM Data Pump parameter do?
    Allows the user to modify storage attributes
  50. Which view shows a summary of currently running Data Pumps jobs?
    DBA_Data Pump_JOBS
  51. Which view identifies the users essions currently attached to a Data Pump export or import job?
    DBA_Data Pump_SESSIONS
  52. Which view shows progress of a Data Pump job?
    V$SESSION_LONGOPS
  53. What is not permitted for external tables that is for normal tables?
    • INDEXES
    • DML
    • ANALYZE
    • VIRTUAL COLUMNS
  54. Which two utilities can utilise external tables
    • ORACLE_LOADER
    • ORACLE_DATAPUMP
  55. What clause defines create external table?
    ORGANIZATION EXTERNAL
  56. What clauses in create external table can speed up reading?
    • PARALLEL
    • PROECT COLUMN REFERENCED
  57. What does DROP TABLE do for an external table?
    Drops metadata only, not the underlying data
  58. What is REJECT LIMIT for external table. What is the max value?
    • Number of row that can be rejected before and error is generated.
    • Unlimited
  59. What are the only ALTER TABLE allowed against external tables?
    • REJECT LIMIT
    • DEFAULT DIRECTORY
    • PROJECT COLUMN ALL
    • PROJECT COLUMN REFERENCED
  60. Which table can be usered to show datapump tasks running for the current user?
    USER_DATAPUMP_JOBS
  61. What expdp parameter would allow an 11g export to be imported into a 10g database?
    VERSION
  62. If one creates an external table with and AS subquey, which access driver MUST be used?
    ORACLE_DATAPUMP

What would you like to do?

Home > Flashcards > Print Preview