This page was exported from Exams Labs Braindumps [ http://blog.examslabs.com ] Export date:Sat Nov 23 10:12:55 2024 / +0000 GMT ___________________________________________________ Title: [Q47-Q65] Updated Oct-2023 Test Engine to Practice Test for 1z0-931-23 Exam Questions and Answers! --------------------------------------------------- Updated Oct-2023 Test Engine to Practice Test for 1z0-931-23 Exam Questions and Answers! Oracle Autonomous Database Cloud 2023 Specialist Certification Sample Questions and Practice Exam QUESTION 47Which can be Scaled Independently of the number of CPUs In an Autonomous Database?  Parallelism  Storage  Concurency  Memory  Sessions https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846 Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:QUESTION 48Autonomous Database’s auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.Which statement is FALSE regarding the auto scaling feature?  For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren’t being used by other auto scaling databases to meet high-load demands.  The base number of OCPU cores allocated to a database is not guaranteed.  For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.  Auto scaling is enabled by default and can be enabled or disabled at any time. QUESTION 49When an administrator rotates the instance wallet for an Autonomous Database on Shared Infrastructure, what happens to the regional wallets used with that instance?  They continue to work  They revert to pending  They are also rotated  They become invalid QUESTION 50What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?  Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.  Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.  Fleet Administrators are responsible for patching and backups of all container databases.  Fleet Administrators create, monitor and manage Autonomous Databases. https://docs.oracle.com/en/cloud/paas/autonomous-database/adbah/index.html#articletitlehttps://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/index.htmlQUESTION 51Which two statements are true about Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for Autonomous Data Guard?  RPO is adjustable, but RTO I always 5 minutes  RTO and RPO are adjustable through the OCI console  RTO and RPO are 0 minutes for manual failovers  RTO is 2 minutes for an automatic failover  RPO is 0 minutes for an automatic failover QUESTION 52For 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 As an alternative, the ADMIN can provide Web Access for a user, REST enable a user, with SQL commands. As the ADMIN user run the following code:BEGINORDS_ADMIN.ENABLE_SCHEMA(..);COMMIT;END;/https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/sql-developer-web.html#GUID-4B404CE3-C832-4089-B37A-ADE1036C7EEAQUESTION 53Which are the two restrictions for an Always Free Autonomous Database?  supports only ATP as a workload type  maximum of two Always Free Databases per OCI tenancy  Oracle Application Express (APEX) not included  maximum of one OCPU per Database QUESTION 54Which statement is correct about managing and monitoring of Autonomous Database?  You can use Service console to move Autonomous DB between compartments.  You can use Service console to create manual backups of Autonomous database.  You can use Service console to enable or disable auto scaling of Autonomous DB.  You can use Service console to manage runaway SQL statements on Autonomous DB. https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-sql-statements.html#GUID-4861BA7F-F9FA-4909-8DC0-4F46AFF80706QUESTION 55Which workload type does the Autonomous Database on dedicated infrastructure service currently support?  Autonomous Transaction Processing only  ATP and ADW  Autonomous Data Warehouse only  Hybrid Columnar compression QUESTION 56What infrastructure does the Autonomous Database run on?  VM on Oracle Cloud Infrastructure  Bare-metal on Oracle Cloud Infrastructure  Exadata on Oracle Cloud Infrastructure  Any Oracle Engineered system QUESTION 57Which statement is true about the use of Access Control Lists (ACLS) with an Autonomous Database on Shared Infrastructure?  When you restore a database, the existing ACLs are not overwritten by the restore.  An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.  ACLs can only be used with private endpoints.  An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time. QUESTION 58Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to also see how changing an object affects other objects?  Data Insights  JSON  Catalog  Data Load QUESTION 59To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?  Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB  Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure  Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB  Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbddoverview.htmQUESTION 60How do you change the tablespace quota for user MTHEO on Autonomous Database on Shared Infrastructure?  Execute alter database for user MTHEO tableapace DATA quota = 10G;  Execute alter user MTHEO quota unlimited on tablespace DATA;  Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username = MTHEO’, V U tablespace_quota -> UNLIMITED’);  Execute alter tablespace DATA det quota = 10G; QUESTION 61You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:* Autonomous Transaction Processing* License Included* Shared InfrastructureWhich parameter would you NOT use?  db-workload  is-dedicated  db-type  license-model https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.htmlQUESTION 62Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?  You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.  You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.  You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.  You can perform a “rolling restart” on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available. QUESTION 63Which three of the following data sources are available when using the Data Load page on Database Actions?  Files in Oracle Cloud Storage  Backup files in block storage  Local Files  Files in AWS S3 Storage  REST endpoints QUESTION 64Your customer wants to permanently disable scheduled maintenance on the Autonomous Database on Dedicated Infrastructure to keep their current database version(s).How can they achieve this?  Change the Automatic Maintenance Schedule to “No Preference”  You cannot permanently disable scheduled automatic maintenance  Change the Automatic Maintenance Schedule to “None”  Change the Automatic Maintenance Schedule to “Specify a Schedule,” but do not select any ^ month, week, or day QUESTION 65Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?  Oracle Cloud Infrastructure Object Storage  Google Cloud Storage  Amazon S3  Oracle Cloud Infrastructure Object Storage Classic  Loading … Certification dumps Oracle Cloud 1z0-931-23 guides - 100% valid: https://www.examslabs.com/Oracle/Oracle-Cloud/best-1z0-931-23-exam-dumps.html --------------------------------------------------- Images: https://blog.examslabs.com/wp-content/plugins/watu/loading.gif https://blog.examslabs.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2023-10-30 12:46:23 Post date GMT: 2023-10-30 12:46:23 Post modified date: 2023-10-30 12:46:23 Post modified date GMT: 2023-10-30 12:46:23