oracle 1z0-931-21 practice test

Oracle Autonomous Database Cloud 2021 Specialist Exam

Last exam update: Jun 18 ,2024
Page 1 out of 8. Viewing questions 1-15 out of 112

Question 1

Which two of the following statements are correct?

  • A. ODI Web Edition is available only on Oracle Linux.
  • B. ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.
  • C. The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.
  • D. All of the capabilities of ODI Classic are available with ODI Web Edition,
Mark Question:
Answer:

A, B

User Votes:
A
50%
B 1 votes
50%
C 1 votes
50%
D
50%

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 2

Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to
an Autonomous Database on Shared Infrastructure?

  • A. The Autonomous Database must belong to a Network Security Group (NSG).
  • B. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.
  • C. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.
  • D. The marketplace OCI image can be used with an Always Free Autonomous Database account.
  • E. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.
Mark Question:
Answer:

E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 3

Which statement is FALSE about setting up compartment quotas?

  • A. Quotas set on a parent compartment override quotas set on child compartments.
  • B. Compartment quotas cannot be set on the root compartment.
  • 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.
Mark Question:
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 4

Which three of the following data sources are available when using the Data Load page on Database
Actions?

  • A. Files in Oracle Cloud Storage
  • B. Backup files in block storage
  • C. Local Files
  • D. REST endpoints
Mark Question:
Answer:

A, C, D

User Votes:
A
50%
B
50%
C
50%
D
50%

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 5

Which stage of the indexing pipeline divides text into tokens?

  • A. SECTIONER
  • B. FILTER
  • C. Otokenizer
  • D. LEXER
Mark Question:
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 6

Which two methods can you use to create database users and grant roles in Autonomous Database
services? O the Oracle Cloud Infrastructure

  • A. service console
  • B. SQL Developer
  • C. the DBMS_CLOUD_ADMIN package
  • D. SQL *Plus
Mark Question:
Answer:

B, D

User Votes:
A
50%
B
50%
C
50%
D
50%

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 7

While provisioning a dedicated Autonomous Container Database, which backup retention can NOT
be implemented?

  • A. 60 days
  • B. 7 days
  • C. 15 days
  • D. 120 days
Mark Question:
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8

Which is NOT needed to manage Oracle Autonomous Database with REST APIS?

  • A. User's OCID
  • B. Tenancy's OCID
  • C. Database ADMIN password
  • D. Fingerprint of the public key
Mark Question:
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 9

Which option should you use to create a graph with Graph Studio?

  • A. A graph license key
  • B. NoSQL configuration
  • C. Graph created by a special tool downloaded from oracle.com
  • D. Graph analytics algorithms
  • E. Tables in an Autonomous Database instance
Mark Question:
Answer:

E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 10

Which three are Oracle-recommended best practices for Autonomous Database alarms?

  • A. Suppress alarms during investigations.
  • B. Create multiple alarm metrics.
  • C. Create a single alarm for each metric.
  • D. Select the correct alarm interval for your metric.
  • E. Routinely tune your alarms.
  • F. Use a single interval for all alarms.
Mark Question:
Answer:

A, D, E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

Question 11

Which native data type is used to store spatial information?

  • A. SDO_RELATE
  • B. SDO_GEOMETRY
  • C. SDO_LOCATION
  • D. GEO_JSON
Mark Question:
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 12

Which four file formats are supported when loading data from Cloud Storage?

  • A. DOC
  • B. AVRO
  • C. JSON
  • D. DDL
  • E. Dcsv
  • F. Parquet
Mark Question:
Answer:

B, C, E, F

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%

Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000
rehansiddiq
9 months, 1 week ago

Answer E is Correct but it should be
E: CSV


Question 13

Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary
database indicates that it is
stopped.
Which statement is true?

  • A. The standby database is terminated.
  • B. The standby database is also stopped.
  • C. Switchover is automatically initiated.
  • D. Failover is automatically initiated.
Mark Question:
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 14

Which three tools can be used to monitor the usage and activities of Autonomous Database on
Dedicated Infrastructure?

  • A. RMAN
  • B. Logs
  • C. OCI Metrics
  • D. Performance Hub
  • E. Enterprise Manager Cloud Control
Mark Question:
Answer:

C, D, E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%

Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 15

Which two statements are true about Data Insights?

  • A. You can retrieve previously executed Data Insights searches.
  • B. Data Insights is available with on-premises deployments of Oracle Database.
  • C. Data Insights is an additional priced option.
  • D. You can search for Data Insights against a base table or business model.
Mark Question:
Answer:

A, D

User Votes:
A
50%
B
50%
C
50%
D
50%

Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2