[Oct-2022] Exam Sure Pass Oracle Certification with 1z0-931-22 exam questions
Real Oracle 1z0-931-22 Exam Questions Study Guide
Oracle 1z0-931-22 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
NEW QUESTION 58
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
- A. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
- B. Transaction Count, Sessions, Running Statements
- C. CPU Utilization, Storage Utilization
- D. Query Latency, User Calls, Execute Count
Answer: C
NEW QUESTION 59
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?
- A. RAC, but only when scaling beyond 16 OCPUs
- B. Multitenant
- C. Transparent Data Encryption
- D. Exadata
- E. Active Data Guard
Answer: A,B
Explanation:
Refer to https://www.oracle.com/autonomous-database/autonomous-data-warehouse/pricing/ If you run Oracle Database Enterprise Edition and the required options listed below, then your BYOL requirements are as follows:
For 1-16 OCPUs of a single Oracle Autonomous Data Warehouse instance:
For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate up to 2 OCPUs of the BYOL Cloud Service.
For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate 1 OCPU of the BYOL Cloud Service.
For 17 OCPUs or more of a single Oracle Autonomous Data Warehouse:
For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate up to 2 OCPUs of the BYOL Cloud Service.
For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate 1 OCPU of the BYOL Cloud Service.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html "Do customers need Exadata licenses to benefit from BYOL?"
NEW QUESTION 60
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?
- A. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day.
- B. Change the Automatic Maintenance Schedule to 'None'd.
- C. You cannot permanently disable scheduled Automatic Maintenance.
- D. Change the Automatic Maintenance Schedule to 'No Preference'.
Answer: C
Explanation:
"If the Autonomous Exadata Infrastructure resource doesn't have a customized schedule, its maintenance schedule will be automatically modified so that it precedes the Autonomous Container Database schedule you define."
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/change-maintenance-scheduleacd.html#GUID-CA028A37-5510-473E-B4D0-A5D454B8DA6E
NEW QUESTION 61
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute alter tablespace DATA set quota = 10G;
- B. Execute alter database for user MTHEO tablespace DATA quota = 10G;
- C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
- D. Execute alter user MTHEO quota unlimited on tablespace DATA;
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0
NEW QUESTION 62
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
- A. OS command line from the database server.
- B. SQLDeveloper
- C. OCI CLI
- D. Admin page of the Cloud Service Console
Answer: A
NEW QUESTION 63
You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.
Which service will you need to connect to?
- A. LOW
- B. MEDIUM
- C. TPURGENT
- D. TP
Answer: C
Explanation:
tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE
NEW QUESTION 64
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: D
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION 65
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
- A. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure
- B. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database
- C. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure
- D. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator
Answer: B
NEW QUESTION 66
Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)
- A. Dataguard Physical Standby
- B. Golden Gate on-premise installation
- C. Golden Gate Cloud service
- D. PDB unplug / plug operation
- E. Datapump export / import
- F. RMAN Cross-Platform backup and restore
Answer: B,C,E
Explanation:
Reference:
https://k21academy.com/1z0-931/migrate-database-to-oracle-autonomous-database-cloud-optionsdata-pump-sql-loader-dbms_cloud-goldengate/
NEW QUESTION 67
Which statement is FALSE about setting up compartment quotas?
- A. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
- B. You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions.
- C. Quotas set on a parent compartment override quotas set on child compartments.
- D. Compartment quotas cannot be set on the root compartment.
Answer: D
NEW QUESTION 68
Which option should you use to create a graph with Graph Studio?
- A. Tables in an Autonomous Database instance
- B. NoSQL configuration
- C. Graph created by a special tool downloaded from oracle.com
- D. A graph license key
- E. Graph analytics algorithms
Answer: A
NEW QUESTION 69
Which two are correct actions to take in order to Download the Autonomous Database Credentials?
- A. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
- B. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
- C. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
- D. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
- E. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
Answer: B,C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1
NEW QUESTION 70
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?
- A. Tablespaces
- B. Data
- C. Reports
- D. Schemas
Answer: B,D
NEW QUESTION 71
You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:
* Autonomous Transaction Processing
* License Included
* Shared Infrastructure
Which parameter would you NOT use?
- A. license-model
- B. db-workload
- C. is-dedicated
- D. db-type
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html
NEW QUESTION 72
Which can be Scaled Independently of the number of CPUs In an Autonomous Database?
- A. Storage
- B. Memory
- C. Concurency
- D. Sessions
- E. Parallelism
Answer: A
Explanation:
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:
NEW QUESTION 73
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
- A. SSH keys are not required in Oracle Cloud Infrastructure.
- B. SSH keys cannot be added from console. They have to be added using REST APIs only.
- C. On the Autonomous Database Console.
- D. Navigate to Identity, select Users panel on the console and select "Add Public Key".
Answer: D
Explanation:
- 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.
NEW QUESTION 74
Which statement is FALSE about Oracle Autonomous JSON Database?
- A. JSON data is stored natively in the database
- B. It supports NoSQL-style, document-centric application
- C. You can promote Autonomous JSON Database to Autonomous Transaction /Processing
- D. There is a 20 GB limit on JSON collection
Answer: D
Explanation:
NEW QUESTION 75
When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?
- A. 2 hours
- B. 30 minutes
- C. 24 hours
- D. 1 hours
Answer: A
Explanation:
Clone Sources
You can use a running database to create a clone. For databases running on shared Exadata infrastructure, you can also use a backup as the source of your clone. When using a backup, you can select a listed backup to clone from, or create a point-in-time clone. Point-in-time clones contain all data up to a specified timestamp. The specified timestamp must be in the past.
Note When you create a clone from a backup, you must select a backup that is at least two hours old.
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbcloning.htm
NEW QUESTION 76
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 = 'OLTP'
- B. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'DW'
- C. Allow group ADB-Admins to manage autonomous-database-family in tenancy.
- D. Allow group ADB-Admins to manage autonomous-database in tenancy.
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Identity/Reference/adbpolicyreference.htm
NEW QUESTION 77
Which two options are available to restore an Oracle Autonomous Database?
- A. Specify the archived custom image.
- B. Select the backup from which restore needs to be done.
- C. Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.
- D. Select the snapshot of the backup.
- E. Specify the point in time (timestamp) to restore.
Answer: B,E
NEW QUESTION 78
Autonomous 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?
- A. 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.
- B. 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.
- C. The base number of OCPU cores allocated to a database is not guaranteed.
- D. Auto scaling is enabled by default and can be enabled or disabled at any time.
Answer: C
NEW QUESTION 79
While creating a business model what advanced options you can enable or disable? (Choose three)
- A. Analytic View Base Table Query Transformation
- B. Display private tables
- C. Autonomous Aggregate Cache
- D. Analytic View Transparency View
- E. Business Object Security Feature
Answer: A,C,D
Explanation:
NEW QUESTION 80
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, and object privileges.
- B. Create an IDCS user. Create a database user with connect, resource, and object privileges.
- C. Create a database user with the default privileges.
- D. 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.
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-database-actions.html#GUID-55BA432E-098A-48ED-B2EA-F2960A9EF586
NEW QUESTION 81
To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?
- A. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB
- B. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB
- C. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB
- D. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure
Answer: A
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbddoverview.htm
NEW QUESTION 82
Which statement is true when connecting OCI Marketplace image to shared autonomous database?
- A. ADB must be configured with NSG
- B. ADB must be configured with Private endpoints
- C. Compute Image and Shared ADB must be in same VCN and Subnet
- D. Cannot connect OCI Market image to shared ADB
Answer: C
NEW QUESTION 83
......
Updated and Accurate 1z0-931-22 Questions for passing the exam Quickly: https://www.passleadervce.com/Oracle-Autonomous-Database/reliable-1z0-931-22-exam-learning-guide.html
Download Real 1z0-931-22 Exam Dumps for candidates. 100% Free Dump Files: https://drive.google.com/open?id=1cfFly1kSQjBi242xZZYIGyBuGDkPpy7E