exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam

Exam 1z0-082 topic 1 question 152 discussion

Actual exam question from Oracle's 1z0-082
Question #: 152
Topic #: 1
[All 1z0-082 Questions]

DATADIR1 and DATATDIR2 are database directory objects.

Examine this command:



Which two statements are true about the expdp operation? (Choose two.)

  • A. It fails if the total size of the dump file is more than 2GB.
  • B. It starts only when four worker processes are available.
  • C. It creates a master table to store details of the export operation.
  • D. It creates dump files for the entire database.
  • E. It creates dump files only for objects in the SYSTEM schema.
Show Suggested Answer Hide Answer
Suggested Answer: CD 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
point_up
2 weeks ago
Selected Answer: CD
But why ?
upvoted 1 times
...
it6567306
7 months, 1 week ago
Reason for determining that option B is incorrect: The PARALLEL=4 option specifies the parallel processing setting used in the Data Pump Export utility (expdp). This option sets the maximum number of active execution processes used for the export job. In the command provided in the question, PARALLEL=4 is specified. This instructs Data Pump to attempt to use a maximum of 4 parallel processes (a combination of worker processes and parallel I/O server processes) to perform the export. However, this does not guarantee that 4 processes will be used. The actual number of processes used depends on available system resources and other constraints.
upvoted 1 times
it6567306
7 months, 1 week ago
Explanation of option B: The choice "It starts only when four worker processes are available" is incorrect. PARALLEL=4 requests Data Pump to use 4 parallel processes, but it does not delay the start of the job until 4 processes are available. The specified number of worker processes are allocated based on available resources.
upvoted 1 times
it6567306
7 months, 1 week ago
According to the Oracle official reference, when PARALLEL=4 is specified, the behavior is as follows: 1. Data Pump attempts to use a maximum of 4 parallel processes (worker processes and parallel I/O server processes) to perform the export. 2. The actual number of processes used depends on system resources and other constraints. 3. Even if 4 processes are not available, the job starts with the number of processes that are available. 4. During job execution, the value of PARALLEL can be increased or decreased using interactive mode commands.
upvoted 1 times
it6567306
7 months, 1 week ago
Therefore, PARALLEL=4 requests the use of 4 parallel processes, but it does not guarantee that 4 processes will be used, nor does it delay the start of the job until 4 processes are available.
upvoted 1 times
it6567306
7 months, 1 week ago
Source: https://docs.oracle.com/cd/F19136_01/sutil/oracle-data-pump-export-utility.html#GUID-B8F3419F-6ECF-4F6A-B57B-938E4941C6BA
upvoted 1 times
it6567306
7 months, 1 week ago
2.6.5 Performing a Parallel Full Database Export To learn how to perform a parallel full database export, use this example to understand the syntax. This example shows a full database export that would use up to three parallel processes (worker or PQ worker processes) at any given time.
upvoted 1 times
...
...
...
...
...
...
Oracle2020
8 months ago
By discarding the other invalid options, the correct ones are CD
upvoted 1 times
...
piontk
1 year, 4 months ago
Selected Answer: BC
Correct is BC
upvoted 1 times
piontk
1 year, 4 months ago
C - https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-overview.html#GUID-B9A676E5-B3CB-417B-BC97-65FE33448C2F
upvoted 1 times
...
piontk
1 year, 4 months ago
B - Oracle uses the MAX_DATAPUMP_PARALLEL_PER_JOB parameter to set the maximum number of parallel processes allowed per Oracle Data Pump job. https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/MAX_DATAPUMP_PARALLEL_PER_JOB.html#GUID-33B1F962-B8C3-4DCE-BE68-66FC5D34ECA3 How to test it: alter session set container=cdb$root; alter system set max_datapump_parallel_per_job=2 scope=both; If you try to start a job with PARALLEL=4 Oracle will return an error: ORA-31626: job does not exist ORA-31637: cannot create job EXPFULL for user SYSTEM
upvoted 1 times
...
piontk
1 year, 4 months ago
D - Is wrong because "Several system schemas cannot be exported, because they are not user schemas; they contain Oracle-managed data and metadata. Examples of schemas that are not exported include SYS, ORDSYS, and MDSYS." https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-export-utility.html#GUID-FCB1FA15-5798-48C0-85ED-08E9DAC5E687
upvoted 1 times
sobrinho
7 months, 3 weeks ago
D is correct: "You can use Data Pump to carry out a full database export by using the FULL parameter. In a full database export, the ENTIRE DATABASE is unloaded. This mode requires that you have the DATAPUMP_EXP_FULL_DATABASE role." https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump- export-utility.html#GUID-079769D8-40F4-432F-88AD-E7264D7A2E2D
upvoted 2 times
...
...
...
auwia
1 year, 5 months ago
Selected Answer: CD
Agree with C and D.
upvoted 2 times
...
Darkseid1231
1 year, 5 months ago
C D is correct
upvoted 2 times
...
Gian1988
1 year, 6 months ago
Correct answer: C - D
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago