Page 1 out of 7. Viewing questions 1-15 out of 112
Question 1
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 1 votes
50%
C
50%
D
50%
Discussions
0/ 1000
Question 2
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 1 votes
50%
B 1 votes
50%
C 1 votes
50%
D 1 votes
50%
E
50%
F 1 votes
50%
Discussions
0/ 1000
rehansiddiq
10 months, 1 week ago
Answer E is Correct but it should be E: CSV
Question 3
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 1 votes
50%
B 1 votes
50%
C
50%
D
50%
Discussions
0/ 1000
Question 4
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 1 votes
50%
B
50%
C 1 votes
50%
D 1 votes
50%
E 1 votes
50%
Discussions
0/ 1000
Question 5
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.
Answer:
A, D
User Votes:
A 1 votes
50%
B
50%
C
50%
D 1 votes
50%
Discussions
0/ 1000
Question 6
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. Oracle Cloud Infrastructure Object Storage
C. Google Cloud Storage
D. Amazon S3
E. Azure Blob Storage
Answer:
A, B
User Votes:
A 2 votes
50%
B 2 votes
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
Question 7
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
User Votes:
A 1 votes
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 8
Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?
A. Only ATP manages optimizer statistics.
B. Only ATP supports automatic backups.
C. Only ADW uses columnar compression by default.
D. Only ADW supports autoscaling.
Answer:
C
User Votes:
A
50%
B
50%
C 1 votes
50%
D
50%
Discussions
0/ 1000
Question 9
Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?
A. inside the Autonomous Database wallet
B. inside the backups of the container database
C. In a separate key vault external to the Exadata Infrastructure
D. on the Exadata Infrastructure where Autonomous Database Dedicated is hosted
Answer:
C
User Votes:
A
50%
B
50%
C
50%
D 1 votes
50%
Discussions
0/ 1000
cesar.arias
1 month, 2 weeks ago
The customer-managed encryption key is stored in Oracle Cloud Infrastructure Vault, external to the database host
cesar.arias
1 month, 1 week ago
Must be D, "Encryption Key By default, Autonomous Database creates and manages all the master encryption keys used to protect your data, storing them in a secure PKCS 12 keystore on the same Exadata systems where the databases reside. If your company security policies require, Autonomous Database can instead use keys you create and manage."
Question 10
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
A. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure
B. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator
C. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database
D. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure
Answer:
C
User Votes:
A
50%
B 1 votes
50%
C 1 votes
50%
D
50%
Discussions
0/ 1000
Question 11
A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment. What should they do to remove this bottleneck?
A. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.
B. Remove any non-JSON data from the database.
C. Increase the number of OCPUs allocated to the database.
D. Ask Support to migrate their setup to a node without noisy neighbors.
Answer:
D
User Votes:
A
50%
B
50%
C 1 votes
50%
D
50%
Discussions
0/ 1000
Question 12
Which three options are available to access data in an Autonomous JSON Database?
A. Oracle Cloud Infrastructure console using the JSON Online Developer tool
B. Oracle JSON Developer tool downloaded from OTN
C. NOSQL statements using Oracle SODA drivers
D. REST API calls to the database (not enabled by default)
E. Regular Oracle SQL statements using a connection through the listener
Answer:
A, C, D
User Votes:
A 1 votes
50%
B
50%
C 1 votes
50%
D 1 votes
50%
E 1 votes
50%
Discussions
0/ 1000
Question 13
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
A. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
B. CPU Utilization, Storage Utilization
C. Query Latency, User Calls, Execute Count
D. Transaction Count, Sessions, Running Statements
Answer:
B
User Votes:
A 1 votes
50%
B
50%
C 1 votes
50%
D
50%
Discussions
0/ 1000
KP
8 months ago
Answer is A
Question 14
Which statement is FALSE about Oracle Data Safe?
A. It supports only Autonomous Databases.
B. It helps you assess the security of your cloud database configurations by analyzing database configurations.
C. It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary.
D. It evaluates user types, how users are authenticated, and the password policies assigned to each user.
E. It helps you evaluate risks to data, assess user security, monitor user activity, and address data security compliance requirements.
Answer:
E
User Votes:
A 1 votes
50%
B
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
KP
8 months ago
Answer is A
Question 15
Which two options are available to restore an Oracle Autonomous Database?
A. Select the backup from which restore needs to be done.
B. Specify the point in time (timestamp) to restore.
C. Select the snapshot of the backup.
D. Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.