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. 3)

  • 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 #11
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
  1. A
    Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
  2. B
    Autonomous Data Warehouse workloads are optimized for mixed workloads.
  3. C
    Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
  4. D
    Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

Correct Answer:
B
Reference:
https://www.oracle.com/a/ocom/docs/database/oracle-autonomous-database-strategy-wp.pdf

Question #12
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?
  1. A
    Active transactions continue running unaffected.
  2. B
    Active transactions are paused.
  3. C
    Scaling cannot happen while there are active transactions in the database.
  4. D
    Active transactions are terminated and rolled back.

Correct Answer:
B

Question #13
Which three statements are correct when the Autonomous Database is stopped? (Choose three.)
  1. A
    User with DWROLE can still access the database.
  2. B
    Tools are no longer able to connect to a stopped instance.
  3. C
    CPU billing is halted based on full-hour cycles of usage.
  4. D
    In-flight transactions and queries are stopped.

Correct Answer:
BCD
Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-stop.html#GUID-9AF677F3-027A-43FD-B018-
9F4A42D5CDE9

Question #14
Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.)
  1. A
    Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
  2. B
    Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
  3. C
    Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
  4. D
    Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials. E. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.

Correct Answer:
AC
Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-
3B174F75D4B1

Question #15
How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?
  1. A
    Two. They are called ATP and ADW.
  2. B
    None. There are no pre-defined service names in tnsnames.ora.
  3. C
    Three. They are called high, medium and low.
  4. D
    Five. They are called tpurgent, tp, high, medium and low.

Correct Answer:
D
Reference:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE

Previous Questions Next Questions

All Pages