Category Archives: Oracle Certification

Oracle Certification Question and Answers

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.What steps do you need to take? A. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with… Read More »

Which statement is NOT correct when setting up compartment quotas?

Which statement is NOT correct when setting up compartment quotas? A. There are three types of quota policy statements which are set, unset and zero. B. Compartment quotas use policies that allow allocation of resources with a high level of flexibility. C. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending. D. Compartment… Read More »

Which two statements are true about Data Insights?

Which two statements are true about Data Insights? A. Data Insights is available with on-premises deployments of Oracle Database. B. You can retrieve previously executed Data Insights searches. C. You can search for Data Insights against a base table or business model. D. Data Insights is an additional priced option. Correct Answer: B,C

For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned? A. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType=”DW” B. Allow group ADB-Admins to manage autonomous-database in tenancy. C. Allow group ADB-Admins to manage autonomous-database-family in tenancy. D. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType=”OLTP” Correct Answer: C https://docs.oracle.com/en-us/iaas/Content/Identity/Reference/adbpolicyreference.htm

Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated

Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure? A. CPU Utilization, Storage Utilization B. Transaction Count, Sessions, Running Statements C. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag D. Query Latency, User Calls, Execute Count Correct Answer: A

While creating a business model what advanced options you can enable or disable? (Choose three)

While creating a business model what advanced options you can enable or disable? (Choose three) A. Business Object Security Feature B. Analytic View Transparency View C. Autonomous Aggregate Cache D. Display private tables E. Analytic View Base Table Query Transformation Correct Answer: B,C,E