Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Oracle 1z0-082 Exam Actual Questions

The questions for 1z0-082 were last updated at June 9, 2022.
  • Viewing page 1 out of 24 pages.
  • Viewing questions 1-4 out of 101 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 Hide Solution   Discussion   20

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 Hide Solution   Discussion   7

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 Hide Solution   Discussion   11

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 Hide Solution   Discussion   27

Correct Answer: BC 🗳️

Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...