[Q84-Q105] 1Z0-931-24 by Oracle Actual Free Exam Questions And Answers [UPDATED 2025] – IT Certification Exam Questions & Answers

Rate this post

1Z0-931-24 by Oracle Actual Free Exam Questions And Answers [UPDATED 2025]

1Z0-931-24 Questions Truly Valid For Your Oracle Exam!

Q84. Which of these database features is NOT part of the Autonomous Database?

Online Indexing

Flashback Database

Real Application Clusters (RAC)

Java in the Database

Q85. In Graph Studio which you can use to create a graph?

A graph license key

Tables in an Autonomous Database instance

NoSQL configuration

Graph analytics algorithms

Graph created by a special tool downloaded from Oracle.com

Q86. 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?

TPURGENT

MEDIUM

LOW

Q87. Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)

An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.

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 unlikely to impact the availability of the others within the same region.

A single fault domain can be associated with multiple regions and availability domains.

Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.

Q88. When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?

Scan partition tables

scan hybrid partition tables

prun column in parquet files

prun columns in csv files

Q89. Which statement is true when you provision an Autonomous Database using the cloning method?

After an Autonomous database is created using a clone, the network access option can be changed.

A clone database source can be a running database instance.

A clone database source can be from a point-in-time backup that is less than 2 hours old.

When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.

Q90. What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)

Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.

Data Pump is platform independent – it can migrate Oracle Databases running on any platform.

Data Pump is faster to migrate database than using RMAN.

Data Pump creates the tablespaces used by your Autonomous Database.

Q91. Which command should you issue to enable application continuity on 0 Shared Infrastructure?

alter system set application_continuity=true

alter session set application_continuity-true

exec dbms_cloud admin.enable_app_cont(‘<cservice_name>’);

alter database set application_continuity=true

Q92. When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)

DBNAME_MEDIUM

DBNAME_HIGH

DBNAME_CONCURRENT

DBNAME_LOW

Q93. The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?

UPDATE_OBJECT_INFO

MODIFY_SNAPSHOT_SETTINGS

CREATE_BASELINE_TEMPLATE

MODIFY_BASELINE_WINDOW_SIZE

Q94. Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.

Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.

You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.

Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.

Q95. When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

OCPUs and storage can be scaled independently.

OCPUs and storage must remain in sync.

Storage in TB cannot be larger than the number of OCPUs.

Increasing OCPUs will automatically increase storage.

Q96. What infrastructure does the Autonomous Database run on?

VM on Oracle Cloud Infrastructure

Bare-metal on Oracle Cloud Infrastructure

Exadata on Oracle Cloud Infrastructure

Any Oracle Engineered system

Q97. Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)

RMAN Cross-Platform backup and restore

Golden Gate on-premise installation

PDB unplug / plug operation

Datapump export / import

Dataguard Physical Standby

Golden Gate Cloud service

Q98. In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?

In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition.

In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.

In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.

In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.

Q99. As a database architect, you are tasked with configuring a high concurrency, production OLTP (online transaction processing) application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.
Which connection service is appropriate for such a workload?

MEDIUM

HIGH

TPURGENT

Q100. Which two options are available to restore an Oracle Autonomous Database?

Select the backup from which restore needs to be done.

Specify the point in time (timestamp) to restore.

Select the snapshot of the backup.

Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.

Specify the archived custom image.

Q101. Which two system privileges does a user need to create analytic views? (Choose two.)

CREATE ANALYTIC MEASURE

CREATE ANALYTIC LEVEL

CREATE ANALYTIC HIERARCHY

CREATE ANALYTIC VIEW

CREATE ATTRIBUTE DIMENSION

Q102. What is the correct way to list all files in the default data pump directory?

By executing select * from DBMS_CLOUD.LIST_FILES(‘DATA_PUMP_DIR’);

You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).

Log onto ADW server and issue is -al on the command line.

By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ‘ ) ;

Q103. Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?

Only ATP manages optimizer statistics.

Only ATP supports automatic backups.

Only ADW uses columnar compression by default.

Only ADW supports autoscaling.

Q104. Which three tasks are performed from the service console of an Autonomous Database on Shared Infrastructure?

Manage Oracle Machine Learning users

Download the wallet

Rotate the wallet

Set resource management rules

Enable autoscaling

Q105. What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

Users have OS access to the database machine.

Users can customize the maintenance schedule.

It offers greater control and isolation starting at the Exadata cloud infrastructure level.

Users have SYS privileges in the database.

Users can customize the OS stack and add additional packages

Get instant access of 100% real exam questions with verified answers: https://www.it-tests.com/1Z0-931-24.html

IT Certification Exam Questions & Answers

Leave a Reply Cancel reply