Get all the Information About Oracle 1Z0-931-21 Exam 2022 Practice Test Questions [Q10-Q33]

Q10. 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?

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

Q12. How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

Q13. What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

Q14. Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?

Q15. A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data.
How does the developer connect to and interact with ADB from Python?

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

Q17. Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

Q18. You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?

Q19. Which statement is true about the use of Access Control Lists (ACLS) with an Autonomous Database on Shared Infrastructure?

Q20. You are requested to analyze a year’s stock purchase data which is stored in Autonomous Data Warehouse instance.
Which tool would you use to automate data exploration and create pivot tables?

Q21. Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?

Q22. What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?

Q23. Which can be Scaled Independently of the number of CPUs In an Autonomous Database?

Q24. Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE?

Q25. A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that’s low to zero maintenance, but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

Q26. What happened with the standby database when disabling Autonomous Data Guard?

Q27. Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE?

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

Q29. Which two of the following statements are correct?

Q30. Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

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

Q32. When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?

Q33. Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?