Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-083

Oracle 1z0-083 Exam Practice Questions (P. 4)

  • Full Access (181 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #16
A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1.
PDB1 was unplugged from CDB1 earlier in the week.
Examine this command, which will be executed in CDB1:

CREATE PLUGGABLE DATABASE pdb1 -
USING `˜/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
(`˜/u01/app/oracle/oradata/', `˜/u02/app/oracle/oradata/');
Which two are true? (Choose two.)
  1. A
    PDB1 data files already exist in the correct location.
  2. B
    DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
  3. C
    PDB_FILE_NAME_CONVERT must be set before executing the command.
  4. D
    /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
  5. E
    PDB1 must be dropped from CDB1.

Correct Answer:
CD
Reference:
http://anjaniappsdba.blogspot.com/2016/09/oracle-database-12102c-hot-cloning-of.html

Question #17
Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)
  1. A
    By default, the transported database will use Oracle Managed Files (OMF)
  2. B
    Data files can be converted on the destination system.
  3. C
    Data files can be converted on the source system.
  4. D
    A new DBID is automatically created for the transported database.
  5. E
    Databases can be transported between systems with different endian formats.
  6. F
    The password file is automatically converted by RMAN.

Correct Answer:
CEF
Password file is automatically converted by RMAN.

Question #18
Examine this command:
$ rhpctl move database `"sourcehome Oracle_home_path `"destinationhome Oracle_home_path
For which two purposes can you use this command? (Choose two.)
  1. A
    to switch an existing Oracle Database home to a newer release of Oracle software on the same server
  2. B
    to switch to a read-only Oracle home
  3. C
    to switch back to the previous Oracle home as part of a rollback operation
  4. D
    to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
  5. E
    to switch to a patched Oracle Database home

Correct Answer:
AE
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/18/cwadd/rapid-home-provisioning.html#GUID-856C7378-2510-4B3E-8BE1-
B4D79DF4FE8B

Question #19
Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)
  1. A
    After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
  2. B
    Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
  3. C
    After the change, only one undo tablespace can exist in CDB$ROOT.
  4. D
    After the change, any user with the required privilege can create an undo tablespace in the PDBs.
  5. E
    Undo tablespaces existing in PDBs must be dropped before the change.
  6. F
    After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Correct Answer:
AD
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/creating-and-configuring-a-cdb.html#GUID-12ADA04D-F81D-4579-A68C-
0958CC7D6C2F

Question #20
Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)
  1. A
    It is integrated with the SQL Access Advisor.
  2. B
    It predicts the impact of system changes on SQL workload response time.
  3. C
    It provides before and after execution statistics for each SQL statement in the analysis task
  4. D
    It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
  5. E
    SQL statements that were originally run concurrently are run concurrently by SPA.

Correct Answer:
BD
Reference:
https://www.oracle.com/technetwork/database/manageability/spa-ow09-131455.pdf
(4)

Previous Questions Next Questions

All Pages