Online Access Free 1Z0-931-25 Exam Questions

Which three advanced options can you enable or disable while creating a business model? (Choose three.)

• A.Display private tables
• B.Analytic View Base Table Query Transformation
• C.Autonomous Aggregate Cache
• D.Analytic View Transparency View
• E.Business Object Security Feature

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

• A.ORDS_ADMIN.ENABLE_SCHEMA
• B.ORDS_ADMIN.GRANT_SCHEMA
• C.ORDS_PRIV.ENABLE_SCHEMA
• D.SQLDEV_ADMIN.GRANT_SCHEMA

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.Prior Release Update Revision (PRUR)
• B.Prior Release Update (PRU)
• C.Quarterly Bundle Patch (QBP)
• D.Release Update (RU)

Which management operation is correct about Autonomous Databases on Shared Exadata Infrastructure?

• A.You cannot configure the scheduling for your Autonomous Databases on Shared Exadata Infrastructure
• B.You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node on the Autonomous Database is restarted separately while the remaining nodes continue to be available
• C.You can choose to use Release Update or Release Update Revision updates for your Autonomous Databases on Shared Infrastructure
• D.You can skip a scheduled maintenance run. For Autonomous Database on Shared Exadata Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed

How do you change the tablespace quota for user MTHEO on an Autonomous Database on Shared Infrastructure?

• A.Execute ALTER USER MTHEO QUOTA UNLIMITED ON TABLESPACE DATA;
• B.Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(username => 'MTHEO', tablespace_quota => 'UNLIMITED');
• C.Execute ALTER DATABASE FOR USER MTHEO TABLESPACE DATA QUOTA = 10G;
• D.Execute ALTER TABLESPACE DATA SET QUOTA = 10G;