Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-082

Free Oracle 1Z0-082 Exam Questions (page: 4)

Page 4 of 36
PDF with 178 Questions

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



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

  1. It can be used only in SQL*Plus
  2. It displays values for variables used only in the WHERE clause of a query
  3. It can be used in SQL Developer and SQL*Plus
  4. It displays values for variables created by the DEFINE command
  5. It displays values for variables prefixed with &&

Answer(s): A,D



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

  1. The ON clause must be used
  2. The query must use two different aliases for the table
  3. It must be an equijoin
  4. It must be an inner join
  5. The ON clause can be used
  6. It can be an outer join

Answer(s): B,D,E



Viewing page 4 of 36



Post your Comments and Discuss Oracle 1Z0-082 exam prep with other Community members:

1Z0-082 Exam Discussions & Posts