Oracle Autonomous Database Cloud 2023 Specialist - 1z0-931-23 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

A. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment B. the Client Credentials wallet which is used to connect to the Autonomous Database C. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator D. the 'High Availability Container Database' in which the Autonomous instance should run E. the Listener endpoint where the Autonomous Database should register on

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 2

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

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

Discussion 0

Correct Answer: A Vote an answer

Question 3

Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

A. Hybrid Columnar compression B. Autonomous Data Warehouse only C. ATP and ADW D. Autonomous Transaction Processing only

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 4

What are four methods to load data into an Autonomous Database?

A. Transportable Tablespace B. RMAN Restore C. SQL*Loader D. Oracle GoldenGate E. Oracle Data Pump F. Database Actions

Discussion 0

Correct Answer: C,D,E,F Vote an answer

Question 5

To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?

A. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB B. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB C. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure D. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

When an administrator rotates the instance wallet for an Autonomous Database on Shared Infrastructure, what happens to the regional wallets used with that instance?

A. They become invalid B. They revert to pending C. They continue to work D. They are also rotated

Discussion 0

Correct Answer: C Vote an answer

Question 7

Which two statements are true about accessing Autonomous Database Tools?

A. SQL Developer Web is available exclusively on the Autonomous Database. B. Oracle APEX can be accessed only from the Developer menu in the Service Console. C. Access to Database Actions is available for all users of Autonomous Database. D. Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpoint networking. E. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.

Discussion 0

Correct Answer: B,D Vote an answer

Question 8

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

A. Unplug into a pdb archive which can be uploaded to object storage. B. Unplug to an xml file so database files and xml file can be uploaded to object storage. C. Pluggable databases cannot be migrated to ADB using plug, unplug or clone. D. Create a database link from source database to the ADB environment and clone the PDB.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 9

What is the number of concurrent statements that can be handled by the medium database service name?

A. unlimited B. 20 X OCPU C. 1-25 X OCPU D. OS

Discussion 0

Correct Answer: C Vote an answer

Question 10

Which index type is designed to index catalog information?

A. CONTAINS B. CONTEXT C. CTXCAT D. CTXRULE

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 11

What are the two differentiators of Oracle Autonomous Data Base on Dedicated Infrastructure?

A. Users have OS access to the database machine B. Users have SYS privileges in the database C. Users can customize the OS stack and add additional packages D. Users have more control over the maintenance schedule E. Users are offered greater reutral and isolation starting at the Exade Cloud infrastructure level

Discussion 0

Correct Answer: B,E Vote an answer