
Nov-2023 Free Oracle 1z0-931-23 Exam Question Practice Exams
Ace 1z0-931-23 Certification with 175 Actual Questions
NEW QUESTION # 49
Which statement is not correct when the Autonomous Database is stopped?
- A. In-flight transactions queries are stopped
- B. CPU billing is halted
- C. User with DWROLE can still access the database
- D. Tools are no longer able to connect to a stopped instance
Answer: C
NEW QUESTION # 50
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 # 51
What are three methods to load data into the Autonomous Database?
- A. RMAN Restore
- B. SQL*Loader
- C. Oracle GoldenGate
- D. Transportable Tablespace
- E. Oracle Data Pump
Answer: B,C,E
Explanation:
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATPD
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-intro.html#GUID-5D2F70D8-4FA1-482C-BFB0-43441FB897F3
NEW QUESTION # 52
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 # 53
Which statement is true about the use of Access Control Lists (ACLS) with an Autonomous Database on Shared Infrastructure?
- A. When you restore a database, the existing ACLs are not overwritten by the restore.
- B. An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.
- C. ACLs can only be used with private endpoints.
- D. An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time.
Answer: A
NEW QUESTION # 54
A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during nonpeak hours. The architecture team is debating whether such reports should be run on the online transaction processing (OLTP) database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well
- A. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis
- B. Use Autonomous Transaction Processing (ATP) with "tpurgent" and "high" TNS services to separate connection types
- C. Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority in this scenario
- D. The application should be deployed on a Kubernetes Cluster because it needs to be highly available
Answer: C
NEW QUESTION # 55
Which two objects are imported when using Data Pump to migrate your Oracle database to Autonomous Database?
- A. Data
- B. Schemas
- C. Tablespaces
- D. Reports
Answer: A,B
NEW QUESTION # 56
Which predefined role that exists in Autonomous Database includes common privileges that are used by a Data Warehouse developer?
- A. ADWC
- B. ADBDEV
- C. DWROLE
- D. ADMIN
Answer: C
NEW QUESTION # 57
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
- A. JSON
- B. Parquet
- C. Microsoft SQL Server (.mdf)
- D. Avro
- E. Text
- F. Data Pump Export File
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/format-options.html#GUID-08C44CDA-7C81-481A-BA0A-F7346473B703
.mdf format is for MS SQL server database file
NEW QUESTION # 58
Which two are ways Oracle Database can optimally access data in Object Storage?
- A. Optimized data archive using hybrid partitioned tables
- B. Scan avoidance using partitioned external tables
- C. Optimized data archive using partitioned external tables
- D. Scan avoidance using columnar pruning for .csv files
Answer: A,B
NEW QUESTION # 59
Which native data type is used to store spatial information?
- A. SDO_RELATE
- B. SDO_GEOMETRY
- C. SDO_LOCATION
- D. GEO_JSON
Answer: B
NEW QUESTION # 60
Which statement is FALSE regarding database links?
- A. You can connect to a remote database from an Autonomous Database by using a database line
- B. You can connect to an Autonomous Database from a remote database using a database link
- C. You can create a database link from one Autonomous Database to another Autonomous Database instance
- D. You can call PL/SQL procedures and functions by using a database link
Answer: D
NEW QUESTION # 61
Which two actions are available to perform when an Autonomous Database is stopped?
- A. Update License Type
- B. Start
- C. Change administrator password
- D. Update Network Access
Answer: A,B
NEW QUESTION # 62
Which two statements are true about Oracle Cloud Infrastructure (OCI)?
- A. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region
- B. Because availability domains do not share infrastructure, such as power or cooling, or the Internal availability domain network, a failure at one availability domain within a region is u likely to impact the availability of the there within the same region
- C. A single fault domain can be associated with multiple regions and availability domains
- D. Regions are dependent on other regions and must be located within five thousand kilometers of each other
Answer: A,B
NEW QUESTION # 63
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. db-workload
- B. db-type
- C. is-dedicated
- D. license-model
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 # 64
Which statement is FALSE about setting up compartment quotas?
- A. Compartment quotas cannot be set on the root compartment.
- B. Quotas set on a parent compartment override quotas set on child compartments.
- C. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
- D. You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions.
Answer: A
NEW QUESTION # 65
Which two tasks can be executed from the service console for Autonomous Databases?
- A. monitoring Autonomous Databases for usage and query performance
- B. creating and scaling an Autonomous Database service
- C. using a wizard to download connection wallet for connection from desktop tools
- D. starting and stopping an instance
- E. configuring virtual cloud networks (VCNS)
Answer: A,C
NEW QUESTION # 66
Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?
- A. Oracle Cloud Infrastructure Object Storage Classic
- B. Azure Blob Storage
- C. Google Cloud Storage
- D. Amazon S3
- E. Oracle Cloud Infrastructure Object Storage
Answer: A,E
NEW QUESTION # 67
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)
- A. DBNAME_HIGH
- B. DBNAME_LOW
- C. DBNAME_MEDIUM
- D. DBNAME_CONCURRENT
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
NEW QUESTION # 68
Which two statements apply to the Autonomous Database service on Dedicated Infrastructure?
- A. You can set a maintenance window for an Autonomous Exadata Infrastructure
- B. You can set a maintenance window for each individual Autonomous Container Database
- C. You, as the customer, are responsible for all patching operations
- D. Patching occurs on the first Sunday of each quarter
Answer: A,B
NEW QUESTION # 69
Which option describes the connection type that third-party software can use to connect to an Autonomous Database (ADB)?
- A. SQL*Net only
- B. new ADB-specific protocols
- C. JDBC only
- D. any protocol supported by Oracle Net Services
Answer: D
NEW QUESTION # 70
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Backup Retention
- B. Undo Management
- C. Data Organization
- D. Index Storage
- E. Memory Usage
Answer: D,E
NEW QUESTION # 71
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?
- A. Security List
- B. Route Table
- C. VCN
- D. Network Security Group
- E. Subnet
Answer: C,D,E
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 # 72
......
1z0-931-23 Questions PDF [2023] Use Valid New dump to Clear Exam: https://www.examslabs.com/Oracle/Oracle-Cloud/best-1z0-931-23-exam-dumps.html
PASS Oracle 1z0-931-23 EXAM WITH UPDATED DUMPS: https://drive.google.com/open?id=1AnQMK-L6lPTmYXtXC1iafaxp3PnpdDh4