1Z0-082 Practice Exam — Free Oracle Certification Prep

Join Us Among the Stars

Sign Up & unlock 100% of Exam Questions

Log in / Sign up

No Strings Attached!

162Practice Questions

3Study Modes

Free

TopicSort

Question 1

Using Single-Row and Aggregate Functions

Which three statements are true about single-row functions? (Choose three.)

A They can be used only in the WHERE clause of a SELECT statement
B The argument can be a column name, variable, literal or an expression
C The data type returned can be different from the data type of the argument
D They can be nested to any level
E They can accept only one argument
F They return a single result row per table

Question 2

Managing Storage

Question 3

Creating and Managing Tables

Question 4

Managing Schema Objects

Question 5

Manipulating Data

Question 6

Using Single-Row and Aggregate Functions

Question 7

Creating Views and Synonyms

Question 8

Moving Data

Question 9

Using Single-Row and Aggregate Functions

Question 10

Using Subqueries

Question 11

Using Subqueries

Question 12

Accessing an Oracle Database with Oracle Supplied Tools

Question 13

Managing Tablespaces and Datafiles

Question 14

Restricting and Sorting Data

Question 15

Restricting and Sorting Data

Question 16

Using DML and Transaction Control Statements

Question 17

Managing Undo

Question 18

Managing Constraints

Question 20

Managing Data in Different Time Zones

Question 21

Understanding Oracle Database Architecture

Question 22

Configuring Oracle Net Services

Question 23

Using Single-Row and Aggregate Functions

Question 24

Accessing an Oracle Database with Oracle Supplied Tools

Question 25

Managing Tablespaces and Datafiles

Question 26

Managing Tablespaces and Datafiles

Page 1 of 7 • Questions 1-25 of 162

1 2 3 4 5

→

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

Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

A Private Temporary Tables (PTTS) store metadata in memory only
B An index created with the UNUSABLE attribute has no segment
C If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement
D An index that is altered to be UNUSABLE will retain its segment
E A table that is truncated will always have its segment removed

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

A A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
B GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
C GLOBAL TEMPORARY TABLE space allocation occurs at session start.
D Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
E A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
F A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Which two statements are true about the DUAL table? (Choose two.)

A It can be accessed only by the SYS user
B It consists of a single row and single column of VARCHAR2 data type
C It can display multiple rows but only a single column
D It can be used to display only constants or pseudo columns
E It can be accessed by any user who has the SELECT privilege in any schema
F It can display multiple rows and columns

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

A The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.
B The number, but not names, of columns must be identical for all SELECT statements in the query.
C The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
D The names and number of columns must be identical for all SELECT statements in the query.
E The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

Question 6

Using Single-Row and Aggregate Functions

Question 7

Creating Views and Synonyms

Question 8

Moving Data

Question 9

Using Single-Row and Aggregate Functions

Question 10

Using Subqueries

Question 11

Using Subqueries

Question 12

Accessing an Oracle Database with Oracle Supplied Tools

Question 13

Managing Tablespaces and Datafiles

Question 14

Restricting and Sorting Data

Question 15

Restricting and Sorting Data

Question 16

Using DML and Transaction Control Statements

Question 17

Managing Undo

Question 18

Managing Constraints

Question 20

Managing Data in Different Time Zones

Question 21

Understanding Oracle Database Architecture

Question 22

Configuring Oracle Net Services

Question 23

Using Single-Row and Aggregate Functions

Question 24

Accessing an Oracle Database with Oracle Supplied Tools

Question 25

Managing Tablespaces and Datafiles

Question 26

Managing Tablespaces and Datafiles

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?

A Statement 1 returns only one row of output.
B Statement 2 returns only one row of output.
C Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.
D Both the statements give the same output.
E Statement 2 may return multiple rows of output.

Which three statements are true about views in an Oracle database? (Choose three.)

A Views can be updated without the need to re-grant privileges on the view
B Tables in the defining query of a view must always exist in order to create the view
C The WITH CHECK clause prevents certain rows from being displayed when querying the view
D Data Manipulation Language (DML) can always be used on views
E Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
F Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

A External table files can be used for other external tables in a different database
B The ORACLE_LOADER access driver can be used to unload data from a database into an external table
C The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
D They cannot be partitioned
E The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
F They support UPDATEs but not INSERTs and DELETEs

Which statement is true about aggregate functions?

A Aggregate functions can be nested to any number of levels
B The AVG function implicitly converts NULLS to zero
C Aggregate functions can be used in any clause of a SELECT statement
D The MAX and MIN functions can be used on columns with character data types

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Question Image

Which two statements are true? (Choose two.)

A Employee 100 will have SALARY set to the same value as the SALARY of employee 200
B Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
C Employee 200 will have SALARY set to the same value as the SALARY of employee 100
D Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
E Employees 100 and 200 will have the same JOB_ID as before the update command
F Employees 100 and 200 will have the same SALARY as before the update command

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

A Column names in each SELECT in the compound query can be different
B The number of columns in each SELECT in the compound query can be different
C Reversing the order of the intersected tables can sometimes affect the output
D INTERSECT returns rows common to both sides of the compound query
E INTERSECT ignores NULLs

Which three statements are true about the DESCRIBE command? (Choose three.)

A It displays the PRIMARY KEY constraint for any column or columns that have that constraint
B It can be used from SQL Developer
C It displays the NOT NULL constraint for any columns that have that constraint
D It can be used to display the structure of an existing view
E It displays all constraints that are defined for each column
F It can be used only from SQL*Plus

You execute this command:

Question Image

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 two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

A Column positions must be used in the ORDER BY clause
B Only column names from the first SELECT statement in the compound query are recognized
C The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause
D Each SELECT statement in the compound query must have its own ORDER BY clause
E Each SELECT statement in the compound query can have its own ORDER BY clause

Which two statements are true about the rules of precedence for operators? (Choose two.)

A The concatenation operator | | is always evaluated before addition and subtraction in an expression
B NULLS influence the precedence of operators in an expression
C The + binary operator has the highest precedence in an expression in a SQL statement
D Arithmetic operators with equal precedence are evaluated from left to right within an expression
E Multiple parentheses can be used to override the default precedence of operators in an expression

In which three situations does a new transaction always start? (Choose three.)

A when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
B when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
C when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
D when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
E when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
F when issuing a DML statement after a DML statement failed in the same session

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

A The generation of UNDO generates REDO
B DML modifies Oracle database objects and only generates UNDO
C The generation of REDO generates UNDO
D DML modifies Oracle database objects and only generates REDO
E DML modifies Oracle database objects and generates UNDO and REDO

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

A A table can have only one primary key but multiple foreign keys
B A table can have only one primary key and one foreign key
C The foreign key columns and parent table primary key columns must have the same names
D It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
E It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
F Only the primary key can be defined at the column and table level

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

A The CURRENT_TIMESTAMP function returns data without time zone information
B A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
C A TIMESTAMP data type column contains information about year, month, and day
D The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
E The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

A They can be written by server processes
B Trace files are written to the Fast Recovery Area (FRA)
C They can be written by background processes
D All trace files contain error information that require contacting Oracle Support
E Trace file names are based on the database name concatenated with a sequential number

Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

A The Oracle Net Configuration Assistant is only used when running the Oracle installer
B Oracle Net Manager can be used to centrally configure listeners on any database server target
C The lsnrctl utility requires a listener.ora file to exist before it is started
D Oracle Net Manager can be used to locally configure naming methods on a database server
E Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
F Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

A CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
B SYSDATE can be queried only from the DUAL table
C CURRENT_DATE returns the current date and time as per the session time zone
D SYSDATE can be used in expressions only if the default date format is DD-MON-RR
E SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
F CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

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 &&

Examine this command:

Question Image

Which two statements are true? (Choose two.)

A DML may be performed on tables with one or more extents in this data file during the execution of this command.
B The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
C The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
D If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
E The file is renamed and stored in the same location

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE
User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:

SQL> CREATE TABLE t1 AS -
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017-03-06T12:15:17.183438+05:30
statement in resumable session 'User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace 'DATA'
Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

A Add a data file to DATA
B Drop other U1 objects in DATA
C Increase U1's quota sufficiently in DATA
D Set DEFERRED_SEGMENT_CREATION to TRUE
E Grant UNLIMITED TABLESPACE to U1
F Set AUTOEXTEND ON for data files in DATA

Join Us Among the Stars

1Z0-082Preview

About the 1Z0-082 Exam

Mode Selection

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Question 26

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Question 26