Online Access Free 1Z0-931-26 Exam Questions

What is a best practice when planning and instituting access controls for your Autonomous Dedicated environment regarding subnets, compartments, and user groups?

• A.Only 1 subnet and 1 compartment are allowed, multiple groups highly advised.
• B.Create at least 2 of each resource.
• C.Only 1 of each is allowed to be allocated per environment.
• D.Create a separate VCN that contains only public subnets.

Which statement is NOT correct when the Autonomous Database is stopped?

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

As a database architect, you are tasked with configuring a high concurrency, production OLTP (EXAM) application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode. Which connection service is appropriate for such a workload?

• A.TPURGENT
• B.HIGH
• C.TP
• D.MEDIUM

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

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

Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?

• A.Exadata
• B.Multitenant
• C.Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs
• D.Active Data Guard
• E.Transparent Data Encryption (TDE)