OCI Autonomous DB Practice 2 Exam With
Questions And Answer Rated 100% Correct 2022
Which two tasks can be executed from the service console for
... [Show More] Autonomous Database? Correct
Answer: Autonomous Database for monitoring usage and query performance
Wizard to download connection wallet for connection from desktop tools
The default port number to connect to Autonomous database? Correct Answer: 1522
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle
database, which statement is true about the workloads? Correct Answer: Data that is bulk loaded, bu
default, uses the row format in Autonomous Transaction Processing where Autonomous Data
Warehouse data format is columnar
Which two statements are true when running DBMS_CLOUD.COPY_DATA? Correct Answer: valid
credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure
The source files can reside in Oracle Object Storage, Amazon S3 Object storage or Azure Blob
storage
When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs
and storage? Correct Answer: OCPUs and storage can be scaled independently
What are two security features enabled by default by the Autonomous Database? Correct Answer:
SQL Net Encryption
Transparent Data Encryption
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the
database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)? Correct
Answer: Pluggable databases cannot be migrated to ADB using plug, unplug or clone
What are three methods to load data into the Autonomous Database? Correct Answer: Oracle Data
Pump
Oracle GoldenGate
SQL*Loader
Which three statements are correct when the Autonomous Database is stopped? (Choose three.)
Correct Answer: Tools are no longer able to connect to a stopped instance
CPU billing is halted based of full-hour cycles of usage
In-flight transactions and queries are stopped
A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window
of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance
of their... [Show Less]