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

Free Oracle 1z0-083 Exam Questions (page: 8)

Page 8 of 71
PDF with 286 Questions

Which three are true about opatch auto? (Choose three.)

  1. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
  2. It must be invoked by a user with root user privileges.
  3. Patches are applied via opatchauto.
  4. Users must always input patch plans to opatchauto.
  5. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
  6. It applies patches in nonrolling mode by default.
  7. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Answer(s): A,B,G



Which two are true about the character sets used in an Oracle database? (Choose two.)

  1. Single-byte character sets provide better performance than multibyte character sets.
  2. Unicode enables information from any language to be stored using a single character set.
  3. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).
  4. Single-byte character sets always use 7-bit encoding schemes.
  5. Multibyte character sets allow more efficient space utilization than single byte character sets.
  6. Single-byte character sets always use 8-bit encoding schemes.

Answer(s): A,B



Which three are true about monitoring waits for sessions and services? (Choose three.)

  1. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
  2. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
  3. V$SESSION_WAIT _CLASS displays waits broken down by wait class only for waiting sessions.
  4. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
  5. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
  6. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

Answer(s): B,C,F



You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have different endian formats.

Examine this list of actions:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
4. Copy the UNIVERSITY tablespace data files to the destination system.
5. Copy the Data Pump dump set to the destination system.
6. Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.

Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

  1. 1,2,4,5,7,8
  2. 1,2,4,6,7,8
  3. 1,2,3,4,5,7,8
  4. 1,2,3,4,5,6,7,8
  5. 2,4,5,6,7

Answer(s): C



Viewing page 8 of 71



Post your Comments and Discuss Oracle 1z0-083 exam prep with other Community members:

1z0-083 Exam Discussions & Posts