1Z0-082 practice questions 1–10

1. Question 1 · 167 in bank

   Select 2

   You execute this command:

   

   Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace? (Choose two.)

   • AAUTOEXTEND is possible for the datafile
   • BIt must be bigger than the largest SMALLFILE tablespace
   • CAdditional data files may not be added
   • DIt will be a dictionary-managed tablespace by default
   • EIt will always have a 32K blocksize

   Show answer

   Answer: AC

   Explanation

   Quotations originate in official Oracle Database 19c documentation. A – true; “With a bigfile tablespace, you can use the AUTOEXTEND clause outside of the ADD DATAFILE clause.” B – false; there is no restriction for minimal size of a bigfile tablespace mentioned in Oracle documentation C – true; “A bigfile tablespace is a tablespace with a single, but potentially very large (up to 4G blocks) data file. Traditional smallfile tablespaces, in contrast, can contain multiple data files, but the files cannot be as large.” D – false; “Bigfile tablespaces are supported only for locally managed tablespaces with automatic segment space management, with three exceptions: locally managed undo tablespaces, temporary tablespaces, and the SYSTEM tablespace.” E – false; “A.2 Physical Database Limits … Database Block Size … Maximum … Operating system dependent; never more than 32 KB“

   Source: Adapted from community discussion — nautil2

   Next question

2. Question 2 · 167 in bank

   Select 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

   Answer: ACF

   Explanation

   A is correct. All dispatchers are required to write incoming requests to a common response queue, which the (idle) shared server processes will monitor and pick up. B is wrong. Each dispatcher has it's own response queue. C is correct. This is the main purpose of dispatchers in a shared server architecture. D is wrong. Connection input requests are handled by the listener and, shared server processes do not have their own input queues, they monitor the common input queue. E is wrong. Shared server responses cannot be broadcasted to all connections. F is correct. Shared server responses must be sent back to the requester on it's own connection. Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/application-and-networking-architecture.html#GUID-EC8F8778-02B7-4CF9-9E6F-A5D88C777235

   Source: Adapted from community discussion — Franky_T

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

3. Question 3 · 167 in bank

   Select 2

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

   • AThere can be only one UNDO tablespace created in a database.
   • BUNDO segments are owned by SYSTEM.
   • CUNDO segments are owned by SYSBACKUP.
   • DAn UNDO tablespace may be owned by only one instance.
   • EAn instance will crash if the active undo tablespace is lost.

   Show answer

   Answer: DE

   Explanation

   When an undo tablespace is created, the corresponding undo segments are created as well. The ownership of the undo segments is then given to the user who creates the undo tablespace. Therefore, the ownership of the undo segments belongs to the user, not to the SYS or SYSTEM user. so the correct answer are D and E

   Source: Adapted from community discussion — markwu01

   Next question

4. Question 4 · 167 in bank

   Select 2

   You must create a tablespace of non-standard block size in a new file system and plan to use this command:

   

   The standard block size is 8k but other non-standard block sizes will also be used. Which two are requirements for this command to succeed? (Choose two.)

   • ADB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.
   • BDB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.
   • CDB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.
   • DThe /u02 file system must have at least 100g space for the datafile.
   • EThe operating system must use a 32k block size.
   • FDB_CACHE_SIZE must be set to a size that is smaller than DB_32K_CACHE_SIZE.

   Show answer

   Answer: BD

   Next question

5. Question 5 · 167 in bank

   Examine the description of the PRODUCTS table:

   

   Which query is valid?

   • ASELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id;
   • BSELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id, release_date;
   • CSELECT prod_id, AVG(MAX(cost)) FROM products GROUP BY prod_id;
   • DSELECT prod_id, MAX(AVG(cost)) FROM products GROUP BY prod_id;

   Show answer

   Answer: B

   Next question

6. Question 6 · 167 in bank

   Select 2

   Which two statements are true about the Oracle Data Dictionary? (Choose two.)

   • AAll data dictionary view join base tables to dynamic performance views.
   • BData dictionary base tables can be queried directly.
   • CIt is owned by the SYS user.
   • DIt is owned by the SYSTEM user.
   • EData dictionary views are always created with queries that join two or more base tables.

   Show answer

   Answer: BC

   References

   • Oracle documentation
   • Oracle documentation

   Next question

7. Question 7 · 167 in bank

   Select 2

   Which two Oracle database space management features require the use of locally managed tablespaces? (Choose two.)

   • AAutomatic data file extension (AUTOEXTEND)
   • BServer-generated tablespace space alerts
   • COnline segment shrink
   • DFree space management with bitmaps
   • EOracle Managed Files (OMF)

   Show answer

   Answer: CD

   Explanation

   A - false, as it can be used with both types B - false C - true, as it requires locally managed tablaspaces with automatic segment space management (ASSM) D - true, as the bitmap structure is stored in the data files of the tablespace E - false

   Source: Adapted from community discussion — hotink57

   Next question

8. Question 8 · 167 in bank

   Select 3

   Which three statements are true about connection strings and service names used to connect to an Oracle database instance? (Choose three.)

   • AA connection string must include the SID of a database instance.
   • BA connection string including a service name must be defined in the tnsnames.ora file.
   • CA single database instance can support connections for multiple service names.
   • DA single connection string can refer to multiple database instances.
   • EA service name is created by a listener.
   • FDifferent connection strings in the same tnsnames.ora file can contain the same service name, host and port parameters.

   Show answer

   Answer: CDF

   Next question

9. Question 9 · 167 in bank

   Select 3

   Which three statements are true about using SQL*Plus? (Choose three.)

   • AIt has both command-line and graphical user interfaces (GUI).
   • BIt must be downloaded from the Oracle Technology Network (OTN).
   • CIt can run Recovery Manager (RMAN) commands.
   • DIt has its own commands that are separate from any SQL statements.
   • EIt can run scripts entered at the SQL prompt.
   • FIt can run scripts passed to it by a shell script.

   Show answer

   Answer: DEF

   Next question

10. Question 10 · 167 in bank

    Select 2

    18. The orders table has a column ORDER_DATE of data type DATE. The default display format for a date is DD-MON-RR. Which two WHERE conditions demonstrate the correct usage of conversion functions? (Choose two.)

    • AWHERE order_date > TO_DATE(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
    • BWHERE order dare > TO DATE('JUL 10 2018', 'MON DD YYYY')
    • CWHERE TO_CHAR(order date, 'MON DD YYYY') = 'JAN 20 2019'
    • DWHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
    • EWHERE order_date IN (TO_DATE('Oct 21 2018', 'Mon DD YYYY'), TO_CHAR('Nov 21 2018', 'Mon DD YYYY'))

    Show answer

    Answer: BC

    Explanation

    B,C is correct. A. false - ORA-01843: not a valid month B. true - TO DATE >> TO_DATA : wrong entry?? - Normal operation after modification C. true - Normal operation after modification D. false - ORA-01858: a non-numeric character was found where a numeric was expected E. false - ORA-01722: invalid number

    Source: Adapted from community discussion — BeomK

    Next question

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

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