ADB PRACTICE EXAM QUESTIONS &
ANSWERS SOLVED 100% CORRECT
ANSWERS!!
1
What are two advantages of using Data Pump to migrate your Oracle
Databases to Autonomous Database? (Choose two.) 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 Datbases 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? Answer - MODIFY_SNAPSHOT_SETTINGS
3
Which task is NOT automatically performed by the Oracle Autonomous
Database? Answer - B. Mask your sensitive data.
4
Which three statements are true about procedures in the DBMS_CLOUD
package? (Choose three.) 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?
Answer - D. Java in the Database
6 Which two statements are true with regards to Oracle Data Sync? (Choose
two.) 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)? 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? Answer - C.
DWROLE
9 Which two system privileges does a user need to create analytic views?
(Choose two.) Answer - D. CREATE ANALYTIC VIEW
E. CREATE ATTRIBUTE DIMENSION
ANSWERS SOLVED 100% CORRECT
ANSWERS!!
1
What are two advantages of using Data Pump to migrate your Oracle
Databases to Autonomous Database? (Choose two.) 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 Datbases 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? Answer - MODIFY_SNAPSHOT_SETTINGS
3
Which task is NOT automatically performed by the Oracle Autonomous
Database? Answer - B. Mask your sensitive data.
4
Which three statements are true about procedures in the DBMS_CLOUD
package? (Choose three.) 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?
Answer - D. Java in the Database
6 Which two statements are true with regards to Oracle Data Sync? (Choose
two.) 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)? 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? Answer - C.
DWROLE
9 Which two system privileges does a user need to create analytic views?
(Choose two.) Answer - D. CREATE ANALYTIC VIEW
E. CREATE ATTRIBUTE DIMENSION
