1z0-931-23 by Oracle Actual Free Exam Questions And Answers [UPDATED 2024]
1z0-931-23 Questions Truly Valid For Your Oracle Exam!
Oracle 1z0-931-23 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
NEW QUESTION # 106
Which statement is NOT correct when setting up compartment quotas?
- A. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
- B. There are three types of quota policy statements which are set, unset and zero.
- C. Compartment quotas are set by Oracle.
- D. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/Content/General/Concepts/resourcequotas.htm
NEW QUESTION # 107
Which predefined role that exists in Autonomous Database includes common privileges that are used by a Data Warehouse developer?
- A. DWROLE
- B. ADWC
- C. ADMIN
- D. ADBDEV
Answer: A
NEW QUESTION # 108
Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?
- A. Oracle Cloud Infrastructure Object Storage Classic
- B. Oracle Cloud Infrastructure Object Storage
- C. Amazon S3
- D. Google Cloud Storage
Answer: D
Explanation:
NEW QUESTION # 109
You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX.
What statement describes the step to provide the developer a new workspace in APEX?
- A. Create an IDCS user with the APEX role.
- B. Create a database user with the APEX role.
- C. Create a new developer account.
- D. Access the APEX Administration Services and create the workspace for the developer.
Answer: D
Explanation:
https://docs.oracle.com/en/database/oracle/application-express/19.1/htmig/creating-workspace-and-adding-Oracle-AE-users.html#GUID-1040F145-452A-49D4-BCF6-A80851AFFA74 Create a New Instance Administrator Login to the INTERNAL workspace as the ADMIN user, or another existing admin user.
Click the "Create User" link on the right-hand menu.
For a new admin user enter mandatory items and the following.
Workspace : INTERNAL
Default Schema : APEX_180200 {or whatever the highest version is}
User is an administrator: Yes
Account Availability : Unlocked
Password and Confirmation Password.
Require Change of Password on First Use : Yes
Click the "Create User" button.
https://oracle-base.com/articles/misc/apex-tips-basic-apex-management
NEW QUESTION # 110
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
- A. On the Autonomous Database Console.
- B. SSH keys cannot be added from console. They have to be added using REST APIs only.
- C. Navigate to Identity, select Users panel on the console and select "Add Public Key".
- D. SSH keys are not required in Oracle Cloud Infrastructure.
Answer: C
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 # 111
Which Database Actions tool is used to get information about the entries on your Oracle Autonomous Database and to see the effect that changing an object has on other objects.
- A. Catalog
- B. Data Load
- C. Data Insight
- D. JSON
Answer: A
Explanation:
Data Catalog
Data Catalog: it helps to get information about the entities in your Oracle Autonomous Database and to see the effect that changing an object has on other objects. Data lineage and impact analysis is key for a Data driven company.
NEW QUESTION # 112
What is the correct way to list all files in the default data pump directory?
- A. Log onto ADW server and issue is -al on the command line.
- B. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
- C. By executing select * from utl_file . list ( 'DATA_PUMP_DIR ' ) ;
- D. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
Answer: D
Explanation:
To list all files in the default data pump directory, you can use the DBMS_CLOUD.LIST_FILES procedure with the directory name as the parameter. See Listing Files in a Directory for more details.
NEW QUESTION # 113
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?
- A. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
- B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
- C. Oracle Data Safe only supports Autonomous Databases.
- D. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.
Answer: C
Explanation:
https://www.oracle.com/database/technologies/security/data-safe.html
https://www.oracle.com/a/tech/docs/dbsec/data-safe/faq-security-data-safe.pdf Data Safe works with the following Oracle Databases Oracle on-Premises Databases Oracle Cloud Databases
− Autonomous Database on Shared Exadata Infrastructure
− Autonomous Database on Dedicated Exadata Infrastructure
− Exadata DB systems
− Database Cloud Service on Virtual Machine
− Database Cloud Service on Bare Metal
− Oracle Database on Compute
NEW QUESTION # 114
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?
- A. Fleet Administrators are responsible for patching and backups of all container databases.
- B. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.
- C. Fleet Administrators create, monitor and manage Autonomous Databases.
- D. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbah/index.html#articletitle
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/index.html
NEW QUESTION # 115
When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?
- A. The SQL statement is executing.
- B. The SQL statement did not complete either due to an error.
- C. The SQL statement is queued.
- D. The SQL statement completed its execution.
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/perfhub.htm
NEW QUESTION # 116
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
- A. Transaction Count, Sessions, Running Statements
- B. CPU Utilization, Storage Utilization
- C. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
- D. Query Latency, User Calls, Execute Count
Answer: C
NEW QUESTION # 117
Which three event types are supported for Autonomous Database?
- A. Change Autoscaling Configuration Compartment
- B. Terminate End
- C. Maintenance Begin
- D. Update IORM Begin
- E. Change Compartment Begin
Answer: B,C,E
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Events/Reference/eventsproducers.htm
NEW QUESTION # 118
Which API is NOT available for developing with spatial on ADB?
- A. PL/SQL Gremlin
- B. Java
- C. REST
- D. Python
Answer: A
Explanation:
PL/SQL Gremlin is not an API for developing with spatial on ADB, but rather an API for developing with property graphs on ADB5. Spatial is a feature of ADB that allows developers and analysts to use spatial analysis in every application from basic spatial search and analysis to advanced geospatial applications and Geographic Information Systems (GIS)6. The APIs available for developing with spatial on ADB are REST, Python, Java, and PL/SQL7. Reference:
Oracle Autonomous Database - Oracle Autonomous Database, section "Graph Analytics", subsection "Property Graphs".
Oracle Autonomous Database - Oracle Autonomous Database, section "Spatial".
Oracle Autonomous Database - Oracle Autonomous Database, section "Spatial", subsection "Spatial APIs".
NEW QUESTION # 119
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?
- A. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
- B. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
- C. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
- D. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/components.html#GUID-
268B36E1-87D8-4649-A370-226E2AE3FC5C
NEW QUESTION # 120
You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?
- A. Create a notification alert using DBMS_SNMP package
- B. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"
- C. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric
- D. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database
Answer: B
NEW QUESTION # 121
For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?
- A. Allow group ADB-Admins to manage autonomous-database-family in tenancy.
- B. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'DW'
- C. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'
- D. Allow group ADB-Admins to manage autonomous-database in tenancy.
Answer: A
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Identity/Reference/adbpolicyreference.htm
NEW QUESTION # 122
What are the two supported infrastructure options for deploying an Autonomous Database?
- A. Bare-metal on Oracle Cloud Infrastructure
- B. Any Oracle Engineered System
- C. VM on Oracle Cloud Infrastructure
- D. Dedicated Exadata Infrastructure
- E. Shared Exadata Infrastructure
Answer: D,E
NEW QUESTION # 123
What infrastructure does the Autonomous Database run on?
- A. Bare-metal on Oracle Cloud Infrastructure
- B. Any Oracle Engineered system
- C. VM on Oracle Cloud Infrastructure
- D. Exadata on Oracle Cloud Infrastructure
Answer: D
NEW QUESTION # 124
Which command should you issue to enable application continuity on 0 Shared Infrastructure?
- A. alter system set application_continuity=true
- B. exec dbms_cloud admin.enable_app_cont('<cservice_name>');
- C. alter database set application_continuity=true
- D. alter session set application_continuity-true
Answer: B
NEW QUESTION # 125
Which statement is true when you provision an Autonomous Database using the cloning method?
- A. A clone database source can be a running database instance.
- B. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
- C. After an Autonomous database is created using a clone, the network access option can be changed.
- D. A clone database source can be from a point-in-time backup that is less than 2 hours old.
Answer: A
NEW QUESTION # 126
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?
- A. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
- B. Unplug into a pdb archive which can be uploaded to object storage.
- C. Unplug to an xml file so database files and xml file can be uploaded to object storage.
- D. Create a database link from source database to the ADB environment and clone the PDB.
Answer: A
Explanation:
Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.
In the current release you cannot use physical migration methods like backup/restore, Data Guard, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.
NEW QUESTION # 127
In Graph Studio which you can use to create a graph?
- A. Graph created by a special tool downloaded from Oracle.com
- B. A graph license key
- C. NoSQL configuration
- D. Tables in an Autonomous Database instance
- E. Graph analytics algorithms
Answer: D
Explanation:
NEW QUESTION # 128
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?
- A. SQL Developer Web
- B. Data Load
- C. APEX
- D. Business Models
Answer: B
NEW QUESTION # 129
What can you do with graphs? (Choose two)
- A. Find patterns that are anomalous and use that to detect fraud.
- B. Product recommendations
- C. 3-D modeling
- D. Facial recognition
Answer: A
Explanation:
Graphs are data structures that represent the connections and relationships between entities, such as people, products, places, etc. Graphs can be used to perform various types of analysis based on these connections, such as finding patterns that are anomalous and use that to detect fraud1 or generating product recommendations based on the preferences and behaviors of similar customers2. 3-D modeling and facial recognition are not applications of graphs, but rather of other types of data analysis techniques, such as computer graphics and machine learning34. Reference:
Oracle Autonomous Database - Oracle Autonomous Database, section "Graph Analytics".
Oracle Autonomous Database - Oracle Autonomous Database, section "Graph Analytics", subsection "Recommendation Engine".
3D modeling - Wikipedia.
Facial recognition system - Wikipedia.
NEW QUESTION # 130
......
Get instant access of 100% real exam questions with verified answers: https://www.actual4exams.com/1z0-931-23-valid-dump.html
1z0-931-23 Actual Questions - Instant Download Tests Free Updated Today!: https://drive.google.com/open?id=11VEfblqvv_dV1k4yRCRb941D7OfC1zCx