Question No. 1

Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

AIt overwrites data in EMP with data in EMP.DAT

BIt uses the database buffer cache to load data

CIt generates a log that contains control file entries, which can be used with normal SQL*Loader operations

DIt generates a sql script that it uses to load data from EMP.DAT to EMP

EIt appends data from EMP.DAT to EMP

Show Answer

Correct Answer: C, E

Question No. 2

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

AAggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query

BWHERE and HAVING clauses can be used in the same statement only if applied to different table columns

CThe HAVING clause can be used with aggregating functions in subqueries

DThe WHERE clause can be used to exclude rows before dividing them into groups

EThe WHERE clause can be used to exclude rows after dividing them into groups

Show Answer

Correct Answer: C, D

Question No. 3

Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

Awriting inbound request to the common request queue from all shared server connections

Bchecking for outbound shared server responses on the common outbound response queue

Creceiving inbound requests from processes using shared server connections

Dsending each connection input request to the appropriate shared server input queue

Ebroadcasting shared server session responses back to requesters on all connections

Fsending shared server session responses back to requesters on the appropriate connection

Show Answer

Correct Answer: A, C, F

https://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc001.htm#ADMIN11168

Question No. 4

Which two statements are true about UNDO and REDO? (Choose two.)

AThe generation of UNDO generates REDO

BDML modifies Oracle database objects and only generates UNDO

CThe generation of REDO generates UNDO

DDML modifies Oracle database objects and only generates REDO

EDML modifies Oracle database objects and generates UNDO and REDO

Show Answer

Correct Answer: A, E

https://www.experts-exchange.com/articles/13880/UNDO-AND-REDO-IN-ORACLE.html

Question No. 5

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

AIf sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

BAny user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

CColumn ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

DSequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

ESequence ORD_SEQ is guaranteed not to generate duplicate numbers

Show Answer

Correct Answer: B, C

Free Oracle 1Z0-082 Exam Actual Questions

The questions for 1Z0-082 were last updated On Jan 15, 2025