Oracle Autonomous Database Cloud 2020 Specialist

Here you have the best Oracle 1z0-931-20 practice exam questions

  • You have 60 total questions to study from
  • Each page has 5 questions, making a total of 12 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on November 20, 2024
Question 1 of 60

When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)

    Correct Answer: D

    When running a high number of concurrent queries in Autonomous Database, the predefined service connection to use is DBNAME_LOW. This service connection is designed to handle the highest concurrency by allocating the least resources to each session, which is ideal for managing numerous simultaneous queries.

Question 2 of 60

Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls? (Choose the best answer.)

    Correct Answer: D

    To execute API calls on Oracle Cloud Infrastructure, a user's public SSH key needs to be added via the Identity service in the Users panel on the console. This includes navigating to Identity, selecting the Users panel, and then selecting the option to add a public key. Other options, such as adding the SSH key to the Autonomous Database Console or using REST APIs only, are incorrect, as they do not pertain to the console method of adding SSH keys.

Question 3 of 60

When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column.

What does this mean? (Choose the best answer.)

    Correct Answer: C

    The clock icon in the status column of the SQL Monitoring tab of the Performance Hub indicates that the SQL statement is queued. This means that the statement is waiting for resources to become available before it can execute.

Question 4 of 60

Which can be Scaled independently of the number of CPUs in an Autonomous Database? (Choose the best answer.)

    Correct Answer: B

    In an Autonomous Database, storage can be scaled independently of the number of CPUs. This allows for flexibility in managing database workloads by adjusting storage capacity as needed without affecting the computational resources, ensuring optimal performance and resource utilization.

Question 5 of 60

Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance? (Choose the best answer.)

    Correct Answer: E

    The correct answer is 'LOY'. Autonomous Transaction Processing (ATP) provides different service levels including HIGH, MEDIUM, TPURGENT, and TPPERFORMANT, but 'LOY' does not exist as a service level option. It appears to be a typo intended to represent 'LOW'. However, given the options provided, 'LOY' is the one that does not fit as a standard service level for ATP.