1z0-931-23 Actual Questions - Instant Download Tests Free Updated Today!
Get instant access of 100% real Oracle 1z0-931-23 exam questions with verified answers
NEW QUESTION # 47
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 evaluates user types, how users are authenticated, and the password policies assigned to each user.
- 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 helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
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 # 48
Where do you find the URL for Database Actions?
- A. in the Database Users card under Database Actions
- B. on the SQL Developer Client Connection tab
- C. in the database with a SQL query
- D. in Oracle Cloud Infrastructure Object Storage
Answer: A
NEW QUESTION # 49
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?
- A. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.
- B. 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.
- C. 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.
- D. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.
Answer: A
NEW QUESTION # 50
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?
- A. Under Core Infrastructure then Compute then Autonomous Exadata
- B. Under Database then Autonomous Transaction Processing then Autonomous Exadata
- C. Under Solutions and Platform then Platform Services then Autonomous Exadata
- D. Under Core Infrastructure then Autonomous Exadata
Answer: B
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory.
Even though the UI has changed recently, this documentation has the user go to Menu -> Database
NEW QUESTION # 51
Which three methods can be used to migrate on-premises databases to Oracle Autonomous Database (both Shared and Dedicated)?
- A. Oracle Data Pump
- B. Original imp/exp tools
- C. Oracle Golden Gate
- D. Physical migration methods, such as database cloning
- E. Orace Zero Downtime Migration (ZDM)
- F. RMAN backup & restore
Answer: A,C,E
NEW QUESTION # 52
Which two actions can be performed when an Autonomous Database is stopped?
- A. Start
- B. Update Network Access
- C. Update License Type
- D. Change Administrator Password
Answer: A,C
NEW QUESTION # 53
Which two statements apply to the Autonomous Database service on Dedicated Infrastructure?
- A. You can set a maintenance window for each individual Autonomous Container Database
- B. Patching occurs on the first Sunday of each quarter
- C. You can set a maintenance window for an Autonomous Exadata Infrastructure
- D. You, as the customer, are responsible for all patching operations
Answer: A,C
NEW QUESTION # 54
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. is-dedicated
- B. license-model
- C. db-workload
- D. db-type
Answer: A
Explanation:
https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html
NEW QUESTION # 55
Which option is not available to pick ( no.of days ) when configuring the backup retention for Oracle Container Database.
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Backup Retention
If you choose to enable automatic backups, you can choose one of the following preset retention periods: 7 days, 15 days, 30 days, 45 days, or 60 days. The system automatically deletes your incremental backups at the end of your chosen retention period.
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/backingupOS.htm
NEW QUESTION # 56
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: B
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION # 57
A Business Analyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst.
When restoring/cloning the ADB, you must select a backup which is atleast___ hours/minutes old.
- A. 1 day
- B. 24 hrs
- C. 2 hrs
- D. 5 min
Answer: B
NEW QUESTION # 58
Which three of the following data sources are available when using the Data Load page on Database Actions?
- A. Files in AWS S3 Storage
- B. REST endpoints
- C. Local Files
- D. Backup files in block storage
- E. Files in Oracle Cloud Storage
Answer: A,C,E
NEW QUESTION # 59
According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.
Which statement is true?
- A. Create at least 2 of each resource
- B. Create a separate VCN that contains only public subnets
- C. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.
- D. Only 1 of each is allowed to be allocated per environment.
Answer: A
Explanation:
Refer to Best Practices When Planning and Instituting Access Controls section in the https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/plan-and-create-access-constraints1.html#GUID-ED48C3D3-FC0F-41D5-882A-FC2D916FD6AA
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/plan-and-create-accessconstraints1.Html
NEW QUESTION # 60
Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?
- A. Data can be loaded from a remote database using Database Links (DBLinks)
- B. Data can be loaded from a local data source
- C. Data formats supported include: text, csv, json, avro and parquet
- D. Data can be uploaded from several cloud storage sources including 53, Azure, Google Cloud and Oracle Object Storage
- E. You must first manually create your database credentials using dms_cloud.create_credentia before accessing your Oracle Object Storage Bucket
Answer: E
NEW QUESTION # 61
What is the maximum number of days that an Autonomous Database Refreshable Clone can be trailing its source instance?
- A. 1 day
- B. 7 days
- C. 30 days
- D. 15 days
Answer: B
NEW QUESTION # 62
Which two methods can you use to define Oracle Machine Learning users?
- A. SQL Developer
- B. the DBMS_CLOUD_ADMIN package
- C. Oracle Cloud Infrastructure Console
- D. Service Console
Answer: C
NEW QUESTION # 63
Which four file formats are supported when loading data from Cloud Storage?
- A. DOC
- B. CSV
- C. JSON
- D. DDL
- E. AVRO
- F. Parquet
Answer: B,C,E,F
NEW QUESTION # 64
What are four methods to load data into an Autonomous Database?
- A. Oracle Data Pump
- B. Oracle GoldenGate
- C. Transportable Tablespace
- D. SQL*Loader
- E. Database Actions
- F. RMAN Restore
Answer: A,B,D,E
NEW QUESTION # 65
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 a new developer account.
- B. Access the APEX Administration Services and create the workspace for the developer.
- C. Create an IDCS user with the APEX role.
- D. Create a database user with the APEX role.
Answer: B
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 # 66
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?
- A. Route Table
- B. Network Security Group
- C. Subnet
- D. VCN
- E. Security List
Answer: B,C,D
Explanation:
To provision an Autonomous Database with a private endpoint, you must have the following resources already created:
A VCN within the region that will contain your Autonomous Database with shared Exadata infrastructure. Cannot be changed after provisioning.
A private subnet within your VCN configured with default DHCP options. Cannot be changed after provisioning.
At least 1 network security group (NSG) within your VCN for the Autonomous Database. Can be changed or edited after provisioning.
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbsprivateaccess.htm
NEW QUESTION # 67
What happened with the standby database when disabling Autonomous Data Guard?
- A. The standby database is started read only
- B. The standby database is started readwrite
- C. The standby database is transformed in a refreshable clone
- D. The standby database is terminated
Answer: D
NEW QUESTION # 68
Which statement is true about OCPUs and storage when you choose to scale your Autonomous Database?
- A. Use auto scaling to increase storage
- B. OCPUs and storage can be scaled independently
- C. Increasing OCPUs will automatically increase storage
- D. OCPUs and storage must remain in sync
Answer: B
NEW QUESTION # 69
Which statement is NOT correct when setting up compartment quotas?
- A. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
- B. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
- C. Compartment quotas are set by Oracle.
- D. There are three types of quota policy statements which are set, unset and zero.
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/Content/General/Concepts/resourcequotas.htm
NEW QUESTION # 70
Which two of the following statements are correct?
- A. ODI Web Edition is available only on Oracle Linux.
- B. All of the capabilities of ODI Classic are available with ODI Web Edition,
- C. ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.
- D. The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.
Answer: A,C
NEW QUESTION # 71
Which statement is not correct when the Autonomous Database is stopped?
- A. CPU billing is halted
- B. In-flight transactions queries are stopped
- C. Tools are no longer able to connect to a stopped instance
- D. User with DWROLE can still access the database
Answer: D
NEW QUESTION # 72
......
Download Latest & Valid Questions For Oracle 1z0-931-23 exam: https://www.dumpsactual.com/1z0-931-23-actualtests-dumps.html
Exam Dumps for the Preparation of Latest 1z0-931-23 Exam Questions: https://drive.google.com/open?id=1oc1sHEKa8_bz4sWM-Ba3sEkH1f1cmI8r
