1z0-082 Actual Exam Questions

Last updated on Jan. 2, 2025.
Vendor:Oracle
Exam Code:1z0-082
Exam Name:Oracle Database Administration I
Exam Questions:178
 

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   36

Correct Answer: AC 🗳️

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   14

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   15

Correct Answer: CDF 🗳️

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   26

Correct Answer: CF 🗳️

file Viewing page 1 out of 45 pages.
Viewing questions 1-4 out of 178 questions
Next Questions
Browse atleast 50% to increase passing rate cup
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.
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago