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

Oracle 1z0-931 Exam Practice Questions (P. 2)

  • Full Access (60 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 #6
Which two statements are true with regards to Oracle Data Sync? (Choose two.)
  1. A
    Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
  2. B
    Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
  3. C
    Data Sync can load your data in parallel in order to speed up the loading process.
  4. D
    Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.

Correct Answer:
AC
Reference:
https://www.oracle.com/technetwork/middleware/bicloud/downloads/bicsdatasync2-3-readme-3715844.pdf
(4)

Question #7
Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?
  1. A
    In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database.
  2. B
    The Oracle Client Credential file is downloaded as a ZIP file.
  3. C
    The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.
  4. D
    You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.

Correct Answer:
A

Question #8
What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?
  1. A
    ADBDEV
  2. B
    ADMIN
  3. C
    DWROLE
  4. D
    ADWC

Correct Answer:
C
Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-privileges.html#GUID-50450FAD-9769-4CF7-B0D1-
EC14B465B873

Question #9
Which two system privileges does a user need to create analytic views? (Choose two.)
  1. A
    CREATE ANALYTIC MEASURE
  2. B
    CREATE ANALYTIC LEVEL
  3. C
    CREATE ANALYTIC HIERARCHY
  4. D
    CREATE ANALYTIC VIEW
  5. E
    CREATE ATTRIBUTE DIMENSION

Correct Answer:
DE
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.html#GUID-6F948948-6AE6-4A89-8AAC-
5B8952CEF41D

Question #10
What are three methods to load data into the Autonomous Database? (Choose three.)
  1. A
    Oracle GoldenGate
  2. B
    Transportable Tablespace
  3. C
    RMAN Restore
  4. D
    Oracle Data Pump
  5. E
    SQL*Loader

Correct Answer:
ADE
Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data.html#GUID-1351807C-E3F7-4C6D-AF83-2AEEADE2F83E

Previous Questions Next Questions

All Pages