This page was exported from Exams Labs Braindumps [ http://blog.examslabs.com ] Export date:Thu Nov 21 18:30:38 2024 / +0000 GMT ___________________________________________________ Title: View All 1Z0-931-21 Actual Exam Questions, Answers and Explanations for Free [Q16-Q37] --------------------------------------------------- View All 1Z0-931-21 Actual Exam Questions, Answers and Explanations for Free 1Z0-931-21 Exam Free Practice Test with100% Accurate Answers Oracle 1Z0-931-21 Exam Syllabus Topics: TopicDetailsTopic 1Monitor ADB performance and set up service notifications Managing and Maintaining Autonomous DatabaseTopic 2Use Autonomous Database with Oracle Machine Learning, APEX and SQL Developer Web (Database actions) Use services in ADB: auto indexing, data safe, compartment quotasTopic 3Provision Dedicated ADB (ADB, Exadata, Container DB, VM Cluster for Cloud @ Customer) Autonomous Database Dedicated & Autonomous Database Cloud @ CustomerTopic 4Migrating to Autonomous Database Autonomous Database Technical Overview Manage maintenance scheduling (patching)Topic 5Manage ADB Backups and Restores, Patching and upgrading Manage Autonomous Database instances: REST APIs, OCI CLI, moving resourcesTopic 6Incorporate Location-based analysis (Autonomous Spatial) Understand the Oracle Cloud InfrastructureTopic 7Describe ADB Dedicated and ADB Cloud@Customer resources, workflows and functionality Describe the Different Autonomous Database offeringsTopic 8Developing on Autonomous Database Use ADB connectivity: Wallets, service handlesTopic 9Configure Disaster Recovery (Data Guard) - both Shared and Dedicated Describe Autonomous Database architecture, integrations and license types   QUESTION 16Where can a user’s public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?  On the Autonomous Database Console.  SSH keys are not required in Oracle Cloud Infrastructure.  SSH keys cannot be added from console. They have to be added using REST APIs only.  Navigate to Identity, select Users panel on the console and select “Add Public Key”. – In the Console, click Identity, and then click Users. Locate the user in the list, and then click the user’s name to view the details.-Click Add Public Key.– Paste the key’s value into the window and click Add.QUESTION 17Which two are correct actions to take in order to Download the Autonomous Database Credentials?  Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.  Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.  Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.  Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.  Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet). https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1QUESTION 18Which 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 19Which 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) when the Autonomous Database is configured with Private Endpoint networking.  Oracle APEX can be accessed only from the Developer menu in the Service Console. QUESTION 20Which statement is true when you provision an Autonomous Database using the cloning method?  After an Autonomous database is created using a clone, the network access option can be changed.  A clone database source can be a running database instance.  A clone database source can be from a point-in-time backup that is less than 2 hours old.  When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database. QUESTION 21What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?  alter database set application_continuity=true  alter session set application_continuity=true  exec dbms_cloucl_admin. enable_app_cont ( ‘ <service_name> ‘ ) ;  alter system set application_continuity=true https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-42B9DDB0-12A7-4EE3-9860-30EFA41061E9 If it was asking for Autonomous Database Dedicated Infrastructure, then answer would be execute DBMS_APP_CONT_ADMIN.ENABLE_AC( ‘databaseid_tpurgent.adb.oraclecloud.com’, ‘LEVEL1’, 600);QUESTION 22Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).How can they achieve this?  Change the Automatic Maintenance Schedule to ‘None’d.  Change the Automatic Maintenance Schedule to ‘Specify a Schedule’ but do not select any month, week or day.  You cannot permanently disable scheduled Automatic Maintenance.  Change the Automatic Maintenance Schedule to ‘No Preference’. QUESTION 23What are three methods to load data into the Autonomous Database?  Oracle GoldenGate  Transportable Tablespace  RMAN Restore  Oracle Data Pump  SQL*Loader https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATPDhttps://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-intro.html#GUID-5D2F70D8-4FA1-482C-BFB0-43441FB897F3QUESTION 24Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?  Admin page of the Cloud Service Console  OCI CLI  OS command line from the database server.  SQLDeveloper QUESTION 25When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?  The SQL statement completed its execution.  The SQL statement is executing.  The SQL statement is queued.  The SQL statement did not complete either due to an error. https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/perfhub.htmQUESTION 26Which native data type is used to store spatial information?  SDO_RELATE  SDO_GEOMETRY  SDO_LOCATION  GEO_JSON QUESTION 27You 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?  Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.  Create a database user with the default privileges.  Create a database user with connect, resource, and object privileges.  Create an IDCS user. Create a database user with connect, resource, and object privileges. QUESTION 28Which three event types are supported for Autonomous Database?  Terminate End  Maintenance Begin  Change Compartment Begin  Change Autoscaling Configuration Compartment  Update IORM Begin https://docs.oracle.com/en-us/iaas/Content/Events/Reference/eventsproducers.htmQUESTION 29In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?  Oracle Machine Learning notebook  Compartment quotas  Resource Manager settings  SQL Developer Web Console QUESTION 30What is the default port number for accessing a newly created Autonomous Database?  1524  1522  1521  1523  1526 https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdfQUESTION 31Which 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. QUESTION 32For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?  Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘DW’  Allow group ADB-Admins to manage autonomous-database in tenancy.  Allow group ADB-Admins to manage autonomous-database-family in tenancy.  Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘OLTP’ https://docs.oracle.com/en-us/iaas/Content/Identity/Reference/adbpolicyreference.htmQUESTION 33Which four file formats are supported when loading data from Cloud Storage?  DOC  AVRO  JSON  DDL  Dcsv  Parquet QUESTION 34Which 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 35Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints  A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints  An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.  Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.  You can configure Private Endpoints for an Always Free Autonomous Database https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/network-private-endpoint-change.html#GUID-9F76DD5E-85A3-4F5E-A88D-3D4D131FC2CA Enabling a private endpoint for an Autonomous Database ensures that the only access path to the database is via a VCN inside your Oracle Cloud Infrastructure tenancy.This network configuration completely blocks access to the database from public endpointsQUESTION 36Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?  The Autonomous Database must be in the same VCN and Subnet as the Compute instance.  The OCI compute instance does not support connecting to a Shared Autonomous Database.  The Autonomous Database must belong to a Network Security Group (NSG).  The OCI compute instance can be used with an Always-Free Autonomous Database account.  A Private Endpoint is required to connect to the Shared-Autonomous Database. QUESTION 37Which 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.  Loading … 1Z0-931-21 dumps Free Test Engine Verified By It Certified Experts: https://www.examslabs.com/Oracle/Oracle-Autonomous-Database/best-1Z0-931-21-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: 2022-11-13 16:45:14 Post date GMT: 2022-11-13 16:45:14 Post modified date: 2022-11-13 16:45:14 Post modified date GMT: 2022-11-13 16:45:14