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,
Answer:
A, B
User Votes:
A
50%
B 1 votes
50%
C 1 votes
50%
D
50%
Discussions
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.
Answer:
E
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
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.
Answer:
B
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
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
Answer:
A, C, D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 5
Which stage of the indexing pipeline divides text into tokens?
A. SECTIONER
B. FILTER
C. Otokenizer
D. LEXER
Answer:
D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
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
Answer:
B, D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
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
Answer:
D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
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
Answer:
C
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
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
Answer:
E
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
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.
Answer:
A, D, E
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
Discussions
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
Answer:
B
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
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
Answer:
B, C, E, F
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
Discussions
0/ 1000
rehansiddiq
7 months 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.
Answer:
B
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
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
Answer:
C, D, E
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
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.