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

  • 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 #21
In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?
  1. A
    In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition.
  2. B
    In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.
  3. C
    In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.
  4. D
    In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.

Correct Answer:
C

Question #22
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
  1. A
    On the Autonomous Database Console.
  2. B
    SSH keys are not required in Oracle Cloud Infrastructure.
  3. C
    SSH keys cannot be added from console. They have to be added using REST APIs only.
  4. D
    Navigate to Identity, select Users panel on the console and select "Add Public Key".

Correct Answer:
D
Reference:
https://www.dbarj.com.br/en/2018/09/creating-a-read-only-user-in-oracle-cloud-infrastructure/

Question #23
Which statement is true in regards to database links?
  1. A
    You can call PL/SQL procedures and functions using a database link.
  2. B
    Connect from Autonomous Database to remote database using a database link.
  3. C
    Connect to Autonomous Database from remote database using a database link.
  4. D
    Create a database link from one Autonomous Database to another Autonomous Database instance.

Correct Answer:
D
Reference:
https://blogs.oracle.com/datawarehousing/making-database-links-from-adw-to-other-databases

Question #24
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
  1. A
    Using Database Configuration Assistant (DBCA) on the database server.
  2. B
    It cannot be done.
  3. C
    Connecting to the Cloud Infrastructure Command console via SSH wallet.
  4. D
    Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

Correct Answer:
D
Reference:
https://docs.cloud.oracle.com/en-us/iaas/Content/Database/Tasks/adbcreating.htm

Question #25
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
  1. A
    Autonomous Transaction Processing.
  2. B
    Autonomous Data Warehouse.
  3. C
    Neither service ignores hints by default.
  4. D
    Both services ignore hints by default.

Correct Answer:
B
Reference:
http://blog.umairmansoob.com/tag/oracle-autonomous-data-warehouse/

Previous Questions Next Questions

All Pages