Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

1z0-082 by Oracle - Page 1 | ExamCademy

Mode Selection

Question 1

Question 2

Question 3

Examine the description of the PRODUCT_STATUS table:

Question 4

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

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

Question 5

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

Question 6

Examine the description of the PRODUCTS table:

Question 7

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

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

Question 8

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

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

Question 9

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

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

Question 10

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

A It has both command-line and graphical user interfaces (GUI).
B It must be downloaded from the Oracle Technology Network (OTN).
C It can run Recovery Manager (RMAN) commands.
D It has its own commands that are separate from any SQL statements.
E It can run scripts entered at the SQL prompt.
F It can run scripts passed to it by a shell script.

Question 11

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

A WHERE order_date > TO_DATE(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
B WHERE order dare > TO DATE('JUL 10 2018', 'MON DD YYYY')
C WHERE TO_CHAR(order date, 'MON DD YYYY') = 'JAN 20 2019'
D WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
E WHERE order_date IN (TO_DATE('Oct 21 2018', 'Mon DD YYYY'), TO_CHAR('Nov 21 2018', 'Mon DD YYYY'))

Question 12

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

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

Question 13

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

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

Question 14

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

A It can be an inner join.
B It can be a left outer join.
C It must be an equijoin.
D The join key column must have an index.
E It must be a full outer join.

Question 15

Which statement is true about database links?

A Private database link creation requires the same user to exist in both the local and the remote databases.
B 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.
C 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.
D A public database link can be created only by SYS.
E A database link can be created only between two Oracle databases.

Question 16

Which two queries execute successfully? (Choose two.)

A SELECT NULLIF(NULL, 100) FROM DUAL;
B SELECT NULLIF(100, 'A') FROM DUAL;
C SELECT COALESCE(100, 'A') FROM DUAL;
D SELECT COALESCE(100, NULL, 200) FROM DUAL;
E SELECT NULLIF(100, 100) FROM DUAL;

Question 17

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

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

Question 18

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

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

Question 19

Examine the description of the MEMBERS table:

Question 20

Which three statements are true about sequences in a single instance Oracle database? (Choose three.)

A Sequences can always have gaps.
B Two or more tables cannot have keys generated from the same sequence.
C A sequence's unallocated cached values are lost if the instance shuts down.
D A sequence can issue duplicate values.
E A sequence can only be dropped by a DBA.
F A sequence number that was allocated can be rolled back if a transaction fails.

Question 21

Your database instance is started with an SPFILE.

A PFILE is also available.

You execute this command:

ALTER SYSTEM SET DB_CACHE_SIZE=100K;

Where is the value changed?

A in the SPFILE, PFILE, and memory
B in the SPFILE and in memory
C only in the SPFILE
D only in memory
E in the SPFILE and PFILE

Question 22

You want to apply the principle of Least Privilege in all your live databases.

One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.

Which two are types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose two.)

A analysis of privileges that a user has on other schema’s objects
B analysis of privileges that a user has on their own schema objects
C analysis of all privileges used by the sys user.
D analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role
E analysis of privileges granted directly to a role that are then used by a user who has been granted that role

Question 23

Examine the description of the SALES table:

Question 24

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

A The ON clause must be used
B The query must use two different aliases for the table
C It must be an equijoin
D It must be an inner join
E The ON clause can be used
F It can be an outer join

Question 25

Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers defined? (Choose three.)

A Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.
B The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.
C Delete statements can always be done on a table through a view.
D Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.
E Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.
F Insert statements can always be done on a table through a view.

Page 1 of 7 • Questions 1-25 of 173

1 2 3 4 5

→

Know a question that should be here? Contribute to this exam

You execute this command:

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

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

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

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

The STATUS column contains the values 'IN STOCK' or 'OUT OF STOCK' for each row.

Which two queries will execute successfully? (Choose two.)

A
B
C
D
E
F

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

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

Which query is valid?

A SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id;
B SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id, release_date;
C SELECT prod_id, AVG(MAX(cost)) FROM products GROUP BY prod_id;
D SELECT prod_id, MAX(AVG(cost)) FROM products GROUP BY prod_id;

Examine the partial query:

SELECT city, last_name LNAME FROM members ...;

You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.

Which two clauses must you add to the query? (Choose two.)

A ORDER BY 1, 2
B WHERE city = '%AN%'
C WHERE city LIKE '%AN%'
D ORDER BY last_name DESC, city ASC
E WHERE city IN ('%AN%')
F ORDER BY 1, LNAME DESC

The SALES table has 55,000 rows.

Examine this statement:

Which two statements are true? (Choose two.)

A SALES1 is created with l row.
B SALES1 is created with no rows.
C SALES1 has primary KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.
D SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.
E SALES1 is created with 55,000 rows.

1z0-082Preview