Practice Exam: Oracle Autonomous Database Administration

Which two statements are true about accessing Autonomous Database Tools?

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

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statementis true about the workload

• Autonomous Transaction Processing memory usage optimizes workloads for parallel joins andaggregations.
• Autonomous Data Warehouse workloads are optimized for mixed workloads.
• Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and datalake.
• Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing whereAutonomous Data Warehouse data format is columnar.

The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?

• Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator,Database Administrator
• Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
• Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database,Autonomous Database
• Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure

Which statement is FALSE about setting up compartment quotas?

• Quotas set on a parent compartment override quotas set on childcompartments.
• Compartment quotas cannot be set on the root compartment.
• Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
• You cannot manage quotas in a compartment, unless you belong to a group that has the correctpermissions.

For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?

• SQLDEV_ADMIN.GRANT_SCHEMA
• ORDS_ADMIN.ENABLE_SCHEMA
• ORDS_ADMIN.GRANT_SCHEMA
• ORDS_PRIV.ENABLE_SCHEMA

Which option should you use to create a graph with Graph Studio?

• A graph license key
• NoSQL configuration
• Graph created by a special tool downloaded from oracle.com
• Graph analytics algorithms
• Tables in an Autonomous Database instance