Oracle 1z0-082 Exam Actual Questions

The questions for 1z0-082 were last updated on July 8, 2024.

Viewing page 1 out of 40 pages.
Viewing questions 1-4 out of 158 questions

Topic 1 - Single Topic

Question #1 Topic 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. 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

Reveal Solution Discussion 37

Correct Answer: AB 🗳️

Question #2 Topic 1

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

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

Reveal Solution Discussion 15

Correct Answer: B 🗳️

Question #3 Topic 1

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

A. Connect Time Failover requires the use of Transparent Application Failover (TAF)
B. Source Routing requires the use of a name server
C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
E. Load Balancing requires the use of a name server
F. Connect Time Failover requires the connect string to have two or more listener addresses configured

Reveal Solution Discussion 13

Correct Answer: BCF 🗳️
Reference:
https://docs.oracle.com/cd/E11882_01/network.112/e41945/advcfg.htm#NETAG013

Question #4 Topic 1

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

Reveal Solution Discussion 33

Correct Answer: CF 🗳️

Oracle 1z0-082 Exam Actual Questions

The questions for 1z0-082 were last updated on July 8, 2024.

Topic 1 - Single Topic

Get IT Certification

New Version GCP Professional Cloud Architect Certificate & Helpful Information

The 5 Most In-Demand Project Management Certifications of 2019