1Z0-082 practice questions 161–167

1. Question 161 · 167 in bank

   Select 2

   Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)

   • AUNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
   • BUNDO_RETENTION specifies how long all types of UNDO are retained.
   • CUnexpired UNDO is always retained.
   • DActive UNDO is always retained.
   • EUNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

   Show answer

   Answer: CD

   Explanation

   "...If retention guarantee is enabled, the specified minimum undo retention is guaranteed; the database never overwrites unexpired undo data even if it means that transactions fail due to lack of space in the undo tablespace. If retention guarantee is not enabled, the database can overwrite unexpired undo when space is low, thus lowering the undo retention for the system..." Acoording to this, correct answers should be C and E.

   Source: Adapted from community discussion — Rivaldo11

   References

   • Oracle documentation

   Next question

2. Question 162 · 167 in bank

   Select 2

   Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER. Examine these SQL statements: Statement 1: SELECT MAX(unit_price * quantity) `Maximum Order` FROM order_items; Statement 2: SELECT MAX(unit_price * quantity) `Maximum Order` FROM order_items - GROUP BY order_id; Which two statements are true?

   • AStatement 1 returns only one row of output.
   • BStatement 2 returns only one row of output.
   • CBoth statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.
   • DBoth the statements give the same output.
   • EStatement 2 may return multiple rows of output.

   Show answer

   Answer: AE

   Explanation

   A E because https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj27781.html The Expression can contain multiple column references or expressions, but it cannot contain another aggregate or subquery. It must evaluate to a built-in data type. You can therefore call methods that evaluate to built-in data types. (For example, a method that returns a java.lang.Integer or int evaluates to an INTEGER.) If an expression evaluates to NULL, the aggregate skips that value.

   Source: Adapted from community discussion — danito

   References

   • Oracle documentation

   Next question

3. Question 163 · 167 in bank

   Select 3

   Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

   • Adump files
   • Bcontrol files
   • Cpassword files
   • Dbad files
   • Einput files

   Show answer

   Answer: BDE

   References

   • Oracle documentation
   • Oracle documentation

   Next question

4. Question 164 · 167 in bank

   Select 3

   Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information? (Choose three.)

   • ALocal Naming requires setting the TNS_ADMIN environment variable on the client side.
   • BA client can connect to an Oracle database instance even if no client side network admin has been configured.
   • CDirectory Naming can be used if Connect-Time Failover is required.
   • DEasy Connect supports TCP/IP and SSL.
   • ELocal naming can be used if Connect-Time Failover is required.
   • FDirectory Naming requires setting the TNS_ADMIN environment variable on the client side.

   Show answer

   Answer: BCE

   Explanation

   I think BCE. B - Easy Connect requires no client-side configuration. C - Local Naming supports the advanced connection option Connect-time failover. E - Directory Naming supports Connect-time failover.

   Source: Adapted from community discussion — [Removed]

   References

   • Oracle documentation

   Next question

5. Question 165 · 167 in bank

   Select 2

   Which two statements are true about User Authentication in an Oracle Database? (Choose two.)

   • APassword authentication must be used for system-privileged administrative users.
   • BPassword File authentication must be used for system-privileged administrative users.
   • COperating System authentication may be used for system-privileged administrative users.
   • DPassword File authentication is supported for any type of database user.
   • EREMOTE_LOGIN_PASSWORDFILE must be set to exclusive to permit password changes for system-privileged administrative users.

   Show answer

   Answer: CD

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

6. Question 166 · 167 in bank

   Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

   • Athe first NUMBER column in the first SELECT of the compound query
   • Bthe first NUMBER or VARCHAR2 column in the last SELECT of the compound query
   • Cthe first column in the last SELECT of the compound query
   • Dthe first column in the first SELECT of the compound query
   • Ethe first VARCHAR2 column in the first SELECT of the compound query

   Show answer

   Answer: D

   Next question

7. Question 167 · 167 in bank

   Select 2

   Which two statements are true about table data storage in an Oracle Database? (Choose two.)

   • AMultiple row pieces from the same row may be stored in different database blocks.
   • BIndex block free space is always contiguous in the middle of the block.
   • CA table row can be chained across several database blocks.
   • DMultiple row pieces from the same row must be stored in different database blocks.
   • EData block free space is always contiguous in the middle of the block.

   Show answer

   Answer: AC

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

1Z0-082 practice, question 161. 167 questions available.