oracle 1Z0-082 Exam Questions

Questions for the 1Z0-082 were updated on : Apr 09 ,2024

Page 1 out of 7. Viewing questions 1-15 out of 96

Question 1

You execute this command:

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

  • A. SELECT * FROM customers WHERE city LIKE ‘D_%’;
  • A. AUTOEXTEND is possible for the datafile
  • B. SELECT * FROM customers WHERE city = ‘%D_’;
  • B. It must be bigger than the largest SMALLFILE tablespace
  • C. SELECT * FROM customers WHERE city LIKE ‘D_’;
  • C. Additional data files may not be added
  • D. SELECT * FROM customers WHERE city = ‘D_%’;
  • D. It will be a dictionary-managed tablespace by default
  • E. It will always have a 32K blocksize
Answer:

A,C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
0 / 1000

Question 2

Which statement is true about the INTERSECT operator used in compound queries?

  • A. INTERSECT
  • A. Multiple INTERSECT operators are not possible in the same SQL statement
  • B. UNION ALL
  • B. It processes NULLs in the selected columns
  • C. UNION
  • C. INTERSECT is of lower precedence than UNION or UNION ALL
  • D. SUBTRACT
  • D. It ignores NULLs
  • E. MINUS
Answer:

B

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
0 / 1000

Question 3

Which three statements are true about advanced connection options supported by Oracle Net for
connection to Oracle Database instances? (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.
  • A. Connect Time Failover requires the use of Transparent Application Failover (TAF)
  • B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
  • B. Source Routing requires the use of a name server
  • C. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
  • C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
  • D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
  • D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
  • E. A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.
  • E. Load Balancing requires the use of a name server
  • F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
  • F. Connect Time Failover requires the connect string to have two or more listener addresses configured
Answer:

CDF

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
F
50%

Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rilin/shared-server-configuration-for-an-oracle-rac-database.html#GUID-2EFBA08D-FEEE-407F-BC42-E548DA946DF9

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
F
0 / 1000

Question 4

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. Views can be updated without the need to re-grant privileges on the view
  • A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
  • B. Tables in the defining query of a view must always exist in order to create the view
  • B. SYSDATE can be queried only from the DUAL table
  • C. The WITH CHECK clause prevents certain rows from being displayed when querying the view
  • C. CURRENT_DATE returns the current date and time as per the session time zone
  • D. Data Manipulation Language (DML) can always be used on views
  • D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
  • E. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
  • E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
  • F. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
  • F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
  • G. The WITH CHECK clause prevents certain rows from being updated or inserted
Answer:

CF

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
F
50%
G
50%

Explanation:
https://www.w3resource.com/oracle/datetime-functions/oracle-current_timestamp-function.php

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
F
G
0 / 1000

Question 5

A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

  • A. in the undo tablespace
  • B. in the SYSAUX tablespace
  • C. in the SGA
  • D. in the PGA
  • E. in the temporary tablespace
Answer:

E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Explanation:
http://www.dba-oracle.com/t_temp_undo_enabled.htm

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 6

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
Be stored in a format supporting date arithmetic without using conversion functions
Store a loan period of up to 10 years
Be used for calculating interest for the number of days the loan remains unpaid
Which data type should you use?

  • A. It is available only when the database is open
  • A. INTERVAL YEAR TO MONTH
  • B. It can be used to perform database recovery
  • B. INTERVAL DAY TO SECOND
  • C. The same port number can be used for Database Express configurations for databases on different hosts
  • C. TIMESTAMP WITH LOCAL TIMEZONE
  • D. It can be used to switch a database into ARCHIVELOGMODE
  • D. TIMESTAMP
  • E. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
  • E. TIMESTAMP WITH TIMEZONE
Answer:

B

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 7

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

  • A. It gives an error because the ALL keyword is not valid
  • A. Dynamic service registration cannot be used for this database instance
  • B. It gives an error because the GROUP BY clause is not valid
  • B. The LREG process registers services dynamically with the LISTENER_1 listener
  • C. It executes successfully but does not give the required result
  • C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
  • D. It executes successfully and gives the required result
  • D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
  • E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
Answer:

B

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%

Explanation:
The listener forwards client requests to supported services. These services are dynamically registered
with the listener. This dynamic registration feature is called service registration. The registration is
performed by the Listener Registration (LREG) process. Dynamic service registration does not require
any manual configuration in the listener.ora file.
Reference:
https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292
Reference:
https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
0 / 1000

Question 8

Which three statements are true concerning logical and physical database structures? (Choose
three.)

  • A. External table files can be used for other external tables in a different database
  • A. All tablespaces may have one or more data files
  • B. The ORACLE_LOADER access driver can be used to unload data from a database into an external table
  • B. The extents of a segment must always reside in the same datafile
  • C. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
  • C. A smallfile tablespace might be bigger than a bigfile tablespace
  • D. They cannot be partitioned
  • D. A segment can span multiple data files in some tablespaces
  • E. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
  • E. A segment’s blocks can be of different sizes
  • F. They support UPDATEs but not INSERTs and DELETEs
  • F. A segment might have only one extent
  • G. Segments can span multiple tablespaces
Answer:

BCF

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
F
50%
G
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
F
G
0 / 1000

Question 9

Which two statements are true regarding a SAVEPOINT? (Choose two.)

  • A. It can be used only in SQL*Plus
  • A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
  • B. It displays values for variables used only in the WHERE clause of a query
  • B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
  • C. It can be used in SQL Developer and SQL*Plus
  • C. Only one SAVEPOINT may be issued in a transaction
  • D. It displays values for variables created by the DEFINE command
  • D. A SAVEPOINT does not issue a COMMIT
  • E. It displays values for variables prefixed with &&
  • E. Rolling back to a SAVEPOINT can undo a DELETE statement
Answer:

D,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 10

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

  • A. You can no longer monitor it
  • A. writing inbound request to the common request queue from all shared server connections
  • B. You can reattach to it and monitor it
  • B. checking for outbound shared server responses on the common outbound response queue
  • C. It is paused and can be resumed
  • C. receiving inbound requests from processes using shared server connections
  • D. It continues to run in the background
  • D. sending each connection input request to the appropriate shared server input queue
  • E. It terminates
  • 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
Answer:

A,C,F

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%

Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc001.htm#ADMIN11168

Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 11

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

  • A. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
  • A. It can be used only in SQL*Plus
  • B. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
  • B. It displays values for variables used only in the WHERE clause of a query
  • C. The HAVING clause can be used with aggregating functions in subqueries
  • C. It can be used in SQL Developer and SQL*Plus
  • D. The WHERE clause can be used to exclude rows before dividing them into groups
  • D. It displays values for variables created by the DEFINE command
  • E. The WHERE clause can be used to exclude rows after dividing them into groups
  • E. It displays values for variables prefixed with &&
Answer:

CE

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 12

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

  • A. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
  • A. The ON clause must be used
  • B. SELECT DISTINCT promo_cost || ’ in ‘ || DISTINCT promo_category FROM promotions ORDER BY 1;
  • B. The query must use two different aliases for the table
  • C. SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;
  • C. It must be an equijoin
  • D. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
  • D. It must be an inner join
  • E. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
  • E. The ON clause can be used
  • F. It can be an outer join
Answer:

B, E, F

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 13

You want to write a query that prompts for two column names and the WHERE condition each time it
is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?

  • A. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
  • A. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;
  • B. It can be used from SQL Developer
  • B. SELECT &col1, &col2FROM &&tableWHERE &condition;
  • C. It displays the NOT NULL constraint for any columns that have that constraint
  • C. SELECT &col1, &col2FROM “&table”WHERE &condition;
  • D. It can be used to display the structure of an existing view
  • D. SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;
  • E. It displays all constraints that are defined for each column
  • E. SELECT &&col1, &&col2FROM &tableWHERE &&condition;
  • F. It can be used only from SQL*Plus
Answer:

B

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 14

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by
at least two characters.
Which query can be used?

  • A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
  • A. SELECT * FROM customers WHERE city LIKE ‘D_%’;
  • B. SYSDATE can be queried only from the DUAL table
  • B. SELECT * FROM customers WHERE city = ‘%D_’;
  • C. CURRENT_DATE returns the current date and time as per the session time zone
  • C. SELECT * FROM customers WHERE city LIKE ‘D_’;
  • D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
  • D. SELECT * FROM customers WHERE city = ‘D_%’;
  • 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
Answer:

A

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
F
0 / 1000

Question 15

Examine this command:

Which two statements are true? (Choose two.)

  • A. The command succeeds and HR will be connected to the orcl and abc.sql databases
  • A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
  • B. The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed
  • B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
  • C. The command fails because the script must refer to the full path name
  • C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
  • D. The command fails and reports an error because @ is used twice
  • 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
Answer:

A, E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
0 / 1000
To page 2