ADB Practice Exam UPDATED
QUESTIONS AND CORRECT ANSWERS
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.
C. Data Pump is faster to migrate database than using RMAN.
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 on Autonomous Data
Warehouse.
, 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
QUESTIONS AND CORRECT ANSWERS
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.
C. Data Pump is faster to migrate database than using RMAN.
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 on Autonomous Data
Warehouse.
, 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
