Oracle Autonomous Database Cloud 2021 Specialist - 1Z0-931-21 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?

A. Release Update (RU) B. Prior Release Update (PRU) C. Quarterly Bundle Patch (QBP) D. Prior Release Update Revision (PRUR)

Discussion 0

Correct Answer: A Vote an answer

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

Question 2

You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.
Which service will you need to connect to?

A. MEDIUM B. TP C. LOW D. TPURGENT

Discussion 0

Correct Answer: D Vote an answer

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

Question 3

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

A. Autonomous Data Warehouse B. Neither service ignores hints by default C. Autonomous Transaction Processing D. Both services ignore hints by default

Discussion 0

Correct Answer: A Vote an answer

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

Question 4

Which statement is correct about managing and monitoring of Autonomous Database?

A. You can use Service console to enable or disable auto scaling of Autonomous DB. B. You can use Service console to move Autonomous DB between compartments. C. You can use Service console to create manual backups of Autonomous database. D. You can use Service console to manage runaway SQL statements on Autonomous DB.

Discussion 0

Correct Answer: D Vote an answer

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

Question 5

Which three event types are supported for Autonomous Database?

A. Update IORM Begin B. Change Autoscaling Configuration Compartment C. Terminate End D. Change Compartment Begin E. Maintenance Begin

Discussion 0

Correct Answer: C,D,E Vote an answer

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

Question 6

What are three methods to load data into the Autonomous Database?

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

Discussion 0

Correct Answer: C,D,E Vote an answer

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

Question 7

Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

A. An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List. B. You can configure Private Endpoints for an Always Free Autonomous Database C. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints D. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.

Discussion 0

Correct Answer: C,D Vote an answer

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

Question 8

When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?

A. 2 hours B. 1 hours C. 24 hours D. 30 minutes

Discussion 0

Correct Answer: A Vote an answer

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

Question 9

What is the correct way to list all files in the default data pump directory?

A. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW). B. Log onto ADW server and issue is -al on the command line. C. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR'); D. By executing select * from utl_file . list ( 'DATA_PUMP_DIR ' ) ;

Discussion 0

Correct Answer: C Vote an answer

Question 10

Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)

A. Dataguard Physical Standby B. RMAN Cross-Platform backup and restore C. Golden Gate Cloud service D. Datapump export / import E. PDB unplug / plug operation F. Golden Gate on-premise installation

Discussion 0

Correct Answer: C,D,F Vote an answer

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