Nov-2023 Free Oracle 1z0-931-23 Exam Question Practice Exams [Q49-Q72]

Share

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