ADB Practice Exam questions with
verified solutions A+ graded
1
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous
Database? (Choose two.) - correct answer ✔✔A. Data Pump can exclude migration of objects like
indexes and materialized views that are not needed by Autonomous Database.
B. Data Pump is platform independent - it can migrate Oracle Databases running on any platform
2
The default eight-day retention period for Autonomous Database performance data can be modified
using which DBMS_WORKLOAD_REPOSITORY subprogram procedure? - correct answer
✔✔MODIFY_SNAPSHOT_SETTINGS
3
Which task is NOT automatically performed by the Oracle Autonomous Database? - correct answer
✔✔B. Mask your sensitive data.
4
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.) -
correct answer ✔✔B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage
credentials in the Autonomous Data Warehouse database.
C. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external
table, generates log information, and stores the rows that do not match the format options specified for
the external table in a badfile table or ADW
E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud.
You can run queries on external data from the Autonomous Data Warehouse.
, 5 Which of these database features is NOT part of the Autonomous Database? - correct answer ✔✔D.
Java in the Database
6 Which two statements are true with regards to Oracle Data Sync? (Choose two.) - correct answer
✔✔A. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
C. Data Sync can load your data in parallel in order to speed up the loading process.
7 Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)? - correct
answer ✔✔C. The Wallet for the Autonomous Database is the same as the Transparent Data Encryption
(TDE) wallet.
8
What is the predefined role that exists in Autonomous Database that includes common privileges that
are used by a Data Warehouse developer? - correct answer ✔✔C. DWROLE
9 Which two system privileges does a user need to create analytic views? (Choose two.) - correct answer
✔✔D. CREATE ANALYTIC VIEW
E. CREATE ATTRIBUTE DIMENSION
10 What are three methods to load data into the Autonomous Database? (Choose three.) - correct
answer ✔✔A. Oracle GoldenGate
D. Oracle Data Pump
E. SQL*Loader
11
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle
database, which statement is true about the workloads? - correct answer ✔✔D. Data that is bulk loaded,
by default, uses the row format in Autonomous Transaction Processing where Autonomous Data
Warehouse data format is columnar.
12
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?
- correct answer ✔✔A. Active transactions continue running unaffected
verified solutions A+ graded
1
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous
Database? (Choose two.) - correct answer ✔✔A. Data Pump can exclude migration of objects like
indexes and materialized views that are not needed by Autonomous Database.
B. Data Pump is platform independent - it can migrate Oracle Databases running on any platform
2
The default eight-day retention period for Autonomous Database performance data can be modified
using which DBMS_WORKLOAD_REPOSITORY subprogram procedure? - correct answer
✔✔MODIFY_SNAPSHOT_SETTINGS
3
Which task is NOT automatically performed by the Oracle Autonomous Database? - correct answer
✔✔B. Mask your sensitive data.
4
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.) -
correct answer ✔✔B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage
credentials in the Autonomous Data Warehouse database.
C. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external
table, generates log information, and stores the rows that do not match the format options specified for
the external table in a badfile table or ADW
E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud.
You can run queries on external data from the Autonomous Data Warehouse.
, 5 Which of these database features is NOT part of the Autonomous Database? - correct answer ✔✔D.
Java in the Database
6 Which two statements are true with regards to Oracle Data Sync? (Choose two.) - correct answer
✔✔A. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
C. Data Sync can load your data in parallel in order to speed up the loading process.
7 Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)? - correct
answer ✔✔C. The Wallet for the Autonomous Database is the same as the Transparent Data Encryption
(TDE) wallet.
8
What is the predefined role that exists in Autonomous Database that includes common privileges that
are used by a Data Warehouse developer? - correct answer ✔✔C. DWROLE
9 Which two system privileges does a user need to create analytic views? (Choose two.) - correct answer
✔✔D. CREATE ANALYTIC VIEW
E. CREATE ATTRIBUTE DIMENSION
10 What are three methods to load data into the Autonomous Database? (Choose three.) - correct
answer ✔✔A. Oracle GoldenGate
D. Oracle Data Pump
E. SQL*Loader
11
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle
database, which statement is true about the workloads? - correct answer ✔✔D. Data that is bulk loaded,
by default, uses the row format in Autonomous Transaction Processing where Autonomous Data
Warehouse data format is columnar.
12
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?
- correct answer ✔✔A. Active transactions continue running unaffected
