1z0-082 practice test

1. Question 1 · 1

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

   Choose all answers that apply.

   

   • AUTOEXTEND is possible for the datafile
   • It must be bigger than the largest SMALLFILE tablespace
   • Additional data files may not be added
   • It will be a dictionary-managed tablespace by default
   • It will always have a 32K blocksize

2. Question 2 · 1

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

   Choose all answers that apply.

   • writing inbound request to the common request queue from all shared server connections
   • checking for outbound shared server responses on the common outbound response queue
   • receiving inbound requests from processes using shared server connections
   • sending each connection input request to the appropriate shared server input queue
   • broadcasting shared server session responses back to requesters on all connections
   • sending shared server session responses back to requesters on the appropriate connection

3. Question 3 · 1

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

   Choose all answers that apply.

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

4. Question 4 · 1

   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.)

   Choose all answers that apply.

   

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

5. Question 5 · 1

   Examine the description of the PRODUCTS table: Which query is valid?

   Choose one answer.

   

   • SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id;
   • SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id, release_date;
   • SELECT prod_id, AVG(MAX(cost)) FROM products GROUP BY prod_id;
   • SELECT prod_id, MAX(AVG(cost)) FROM products GROUP BY prod_id;

6. Question 6 · 1

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

   Choose all answers that apply.

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

7. Question 7 · 1

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

   Choose all answers that apply.

   • Automatic data file extension (AUTOEXTEND)
   • Server-generated tablespace space alerts
   • Online segment shrink
   • Free space management with bitmaps
   • Oracle Managed Files (OMF)

8. Question 8 · 1

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

   Choose all answers that apply.

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

9. Question 9 · 1

   Which three statements are true about the Automatic Diagnostic Repository (ADR)? (Choose three.)

   Choose all answers that apply.

   • It can be used for problem diagnosis of a database when that database's instance is down.
   • The ADR base is specified in the DIAGNIOSTIC_DEST database parameter.
   • It is held inside an Oracle database schema.
   • It is a file-based repository held outside any database.
   • It is only used for Oracle Database diagnostic information.

10. Question 10 · 1

    Which two statements are true about the SET VERIFY ON command? (Choose two.)

    Choose all answers that apply.

    • It can be used only in SQL*Plus
    • It displays values for variables used only in the WHERE clause of a query
    • It can be used in SQL Developer and SQL*Plus
    • It displays values for variables created by the DEFINE command
    • It displays values for variables prefixed with &&

11. Question 11 · 1

    Which two statements are true about a self join? (Choose two.)

    Choose all answers that apply.

    • It can be an inner join.
    • It can be a left outer join.
    • It must be an equijoin.
    • The join key column must have an index.
    • It must be a full outer join.

12. Question 12 · 1

    Which statement is true about database links?

    Choose one answer.

    • Private database link creation requires the same user to exist in both the local and the remote databases.
    • A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa.
    • A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.
    • A public database link can be created only by SYS.
    • A database link can be created only between two Oracle databases.

13. Question 13 · 1

    Which two queries execute successfully? (Choose two.)

    Choose all answers that apply.

    • SELECT NULLIF(NULL, 100) FROM DUAL;
    • SELECT NULLIF(100, 'A') FROM DUAL;
    • SELECT COALESCE(100, 'A') FROM DUAL;
    • SELECT COALESCE(100, NULL, 200) FROM DUAL;
    • SELECT NULLIF(100, 100) FROM DUAL;

14. Question 14 · 1

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

    Choose all answers that apply.

    • An index block can contain row data.
    • A data block header is of a fixed length.
    • Row data is stored starting at the end of the block.
    • A table block must always contain row data.
    • A block header contains a row directory pointing to all rows in the block.

15. Question 15 · 1

    Which two are benefits of external tables? (Choose two.)

    Choose all answers that apply.

    • They support DELETES which transparently deletes records in the file system as if they were table rows.
    • They can be queried, transformed, and joined with other tables without having to load the data first.
    • They support UPDATES which transparently updates records in the file system as if they were table rows.
    • The results of a complex join or aggregating function or both can be unloaded to a file for transportation to another database.
    • They can be queried while the database is in the MOUNT state like dynamic performance views.

Paid access to all 145 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.