Oracle Autonomous Database Cloud 2023 Professional v1.0 (1z0-931-23)

Page:    1 / 4   
Total 58 questions

Which three advanced options can you enable or disable while creating a business model? (Choose three.)

  • A. Analytic View Transparency Views
  • B. Display Private Tables
  • C. Analytic View Base Table Query Transformation
  • D. Business Object Security Feature
  • E. Autonomous Aggregate Cache


Answer : ACE

Which option is not available to access data in an Autonomous JSON Database?

  • A. Oracle Cloud Infrastructure console using the JSON Developer tool.
  • B. NoSQL statements using Simple Oracle Document Access (SODA) drivers.
  • C. REST API calls to the database.
  • D. Regular Oracle SQL statements using a connection string to the database.


Answer : A

Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)

  • A. Using Oracle Zero Downtime Migration (ZDM).
  • B. Using Recovery Manager (RMAN).
  • C. Using Data Pump.
  • D. Using GoldenGate.
  • E. Using SFTP to copy CSV files into an Autonomous Database.


Answer : ACD

Your customer has upgraded their on-premises 11.2 Database to 12.2. During this migration, the database was migrated to a pluggable database (PDB) and is now in production.
How should the customer unplug their database to migrate to an Autonomous Database?

  • A. PDBs cannot be migrated to an Autonomous Database using plug, unplug, or clone.
  • B. Unplug into a PDB archive, which can be uploaded to Object Storage.
  • C. Unplug into an XML file so that the database and XML files can be uploaded to Object Storage.
  • D. Create a database link from the source database to the Autonomous Database environment and clone the PDB.


Answer : B

Which index type is designed to index catalog information?

  • A. CONTEXT
  • B. CTXCATC. CTXRULE
  • D. CONTAINS


Answer : B

What are the two supported infrastructure options for deploying an Autonomous Database? (Choose two.)

  • A. Bare-metal on Oracle Cloud Infrastructure
  • B. Any Oracle Engineered System
  • C. Shared Exadata Infrastructure
  • D. VM on Oracle Cloud Infrastructure
  • E. Dedicated Exadata Infrastructure


Answer : CE

While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?

  • A. 7 days
  • B. 15 days
  • C. 60 days
  • D. 120 days


Answer : D

Which option describes the connection types that third-party software can use to connect to an Autonomous Database (ADB)?

  • A. any protocol supported by Oracle Net Services
  • B. new ADB-specific protocols
  • C. JDBC only
  • D. SQL*Net only


Answer : A

Which three statements are correct when an Autonomous Database on Shared Infrastructure is stopped? (Choose three.)

  • A. CPU billing continues.
  • B. User with DWROLE can still access the database.
  • C. CPU billing is halted.
  • D. In-flight transactions and queries are stopped.
  • E. Tools are no longer able to connect to a stopped instance.


Answer : CDE

Which statement is FALSE about setting up compartment quotas?

  • A. Compartment quotas cannot be set on the root compartment.
  • B. Quotas in a compartment cannot be managed unless you belong to a group that has the correct permissions.
  • C. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
  • D. Quotas set on a parent compartment override quotas set on child compartments.


Answer : D

Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endpoints with security rules to allow incoming and outgoing traffic to and from the Autonomous Database instance?

  • A. The IP Protocol is set to TCP.
  • B. The source is set to the address range you want to allow to connect to your database.
  • C. A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance.
  • D. The destination port range is set to 1522.


Answer : D

Which statement is correct about the Service console in an Autonomous Database?

  • A. You can use the Service console to manage runaway SQL statements on an Autonomous Database.
  • B. You can use the Service console to move an Autonomous Database between compartments.
  • C. You can use the Service console to create manual backups of an Autonomous Database.
  • D. You can use the Service console to enable or disable autoscaling of an Autonomous Database.


Answer : A

Which DBMS_WORKLOAD_REPOSITORY subprogram procedure can be used to modify the default eight day retention period for Autonomous Database performance data?

  • A. MODIFY_BASELINE_WINDOW_SIZE
  • B. UPDATE_OBJECT_INFO
  • C. MODIFY_SNAPSHOT_SETTINGS
  • D. CREATE_BASELINE_TEMPLATE


Answer : C

Which predefined role that exists in Autonomous Database includes common privileges that are used by a Data Warehouse developer?

  • A. DWROLE
  • B. ADBDEV
  • C. ADMIN
  • D. ADWC


Answer : A

Who, and in which order, provisions dedicated Exadata Infrastructure resources?

  • A. The database administrator provisions the Autonomous Exadata Infrastructure. Then, the fleet administrator provisions the Autonomous Container DB and then the Autonomous DB.
  • B. The fleet administrator provisions the Autonomous Exadata Infrastructure. Then, the database administrator provisions the Autonomous Container DB and then the Autonomous DB.
  • C. The fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB. Then, the database administrator provisions the Autonomous DB.
  • D. The database administrator provisions the Autonomous Container DB and the Autonomous DB. Then, the fleet administrator provisions the Autonomous Exadata Infrastructure.


Answer : C

Page:    1 / 4   
Total 58 questions