Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Oracle
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Oracle
  3. 1Z0-082

Oracle 1Z0-082 Exam (page: 2)
Oracle Database Administration I
Updated on: 25-Aug-2025

Viewing Page 2 of 30
1Z0-082 PDF 178 Questions

You have been tasked to create a table for a banking application.

One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan remains unpaid

Which data type should you use?

  1. INTERVAL YEAR TO MONTH
  2. INTERVAL DAY TO SECOND
  3. TIMESTAMP WITH LOCAL TIMEZONE
  4. TIMESTAMP
  5. TIMESTAMP WITH TIMEZONE

Answer(s): B



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?

  1. Dynamic service registration cannot be used for this database instance
  2. The LREG process registers services dynamically with the LISTENER_1 listener
  3. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
  4. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
  5. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Answer(s): C


Reference:

https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292



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

  1. All tablespaces may have one or more data files
  2. The extents of a segment must always reside in the same datafile
  3. A smallfile tablespace might be bigger than a bigfile tablespace
  4. A segment can span multiple data files in some tablespaces
  5. A segment’s blocks can be of different sizes
  6. A segment might have only one extent
  7. Segments can span multiple tablespaces

Answer(s): C,F,G



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

  1. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
  2. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
  3. Only one SAVEPOINT may be issued in a transaction
  4. A SAVEPOINT does not issue a COMMIT
  5. Rolling back to a SAVEPOINT can undo a DELETE statement

Answer(s): D,E



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

  1. writing inbound request to the common request queue from all shared server connections
  2. checking for outbound shared server responses on the common outbound response queue
  3. receiving inbound requests from processes using shared server connections
  4. sending each connection input request to the appropriate shared server input queue
  5. broadcasting shared server session responses back to requesters on all connections
  6. sending shared server session responses back to requesters on the appropriate connection

Answer(s): A,C,D



Viewing Page 2 of 30



Share your comments for Oracle 1Z0-082 exam with other users:

Biswa 11/20/2023 8:50:00 AM

refresh db knowledge
Anonymous


Biswa 11/20/2023 9:07:00 AM

understanding about joins
Anonymous


Biswa 11/20/2023 9:28:00 AM

understand sql col.
Anonymous