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-062

Free Oracle 1Z0-062 Exam Questions (page: 13)

Page 13 of 87
PDF with 419 Questions

Examine the parameter for your database instance:



Identify the reason why the optimizer chose different execution plans.

  1. The optimizer used a dynamic plan for the query.
  2. The optimizer chose different plans because automatic dynamic sampling was enabled.
  3. The optimizer used re-optimization cardinality feedback for the query.
  4. The optimizer chose different plan because extended statistics were created for the columns used.

Answer(s): A



Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)

  1. The PDB must be open in read only mode.
  2. The PDB must be dosed.
  3. The unplugged PDB becomes a non-CDB.
  4. The unplugged PDB can be plugged into the same multitenant container database (CDB)
  5. The unplugged PDB can be plugged into another CDB.
  6. The PDB data files are automatically removed from disk.

Answer(s): B,D,E

Explanation:

B, not A: The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle
the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference. E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB's datafiles can remain in place.



You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?

  1. The ORACLE_BASE base parameter is not set.
  2. The installation is being performed by the root user.
  3. The operating system group that is specified should have the root user as its member.
  4. The operating system group that is specified must have permission to write to the inventory directory.

Answer(s): D

Explanation:

Note:
Providing a UNIX Group Name
If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of the group which should own the base directory. You must choose a UNIX group name which will have permissions to update, install, and deinstall Oracle software. Members of this group must have write permissions to the base directory chosen.
Only users who belong to this group are able to install or deinstall software on this machine.



You run a script that completes successfully using SQL*Plus that performs these actions:
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script? (Choose two.)

  1. The seed will be in mount state.
  2. The seed will be opened read-only.
  3. The seed will be opened read/write.
  4. The other PDBs will be in mount state.
  5. The other PDBs will be opened read-only.
  6. The PDBs will be opened read/write.

Answer(s): B,D

Explanation:

B: The seed is always read-only.
D: Pluggable databases can be started and stopped using SQL*Plus commands or the ALTER PLUGGABLE DATABASE command.



Viewing page 13 of 87



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

1Z0-062 Exam Discussions & Posts