ADB Exam
Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction
Processing (ATP) databases?
-Only ATP manages optimizer statistics
-Only ADW uses columnar compression by default
-Only ATP supports automatic backups
-Only ADW supports autoscaling - -Only ADW uses columnar compression by default.
Autonomous Database's auto scaling feature allows your databa base number of OCPU cores at any
time. As demand increases, auto number of cores in use. Likewise, as demand drops, auto scaling
automatically cores in use. Which statement is FALSE regarding the auto scaling feature?
-The base number of OCPU cores allocated to a database is not guaranteed
-For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the
number of free cores that aren't being used by other auto scaling databases to meet high-load demands
-Auto scaling is enabled by default and can be enabled or disabled at any time
-For databases on dedicated Exadata infrastructure, the maximum number of cores available to a
database depends on the total number of cores available in the Exadata infrastructure instance. - -
The base number of OCPU cores allocated to a database is not guaranteed
You see a clock icon in the Status column on the SQL Monitoring tab of the Performance Hub. What does
it indicate?
-The SQL statement completed its execution
-The SQL statement is executing
-The SQL statement is queued
-The SQL statement did not complete due to an error - -The SQL statement is queued
, During the provisioning of an Autonomous Database on dedicated hardware, what does the database
administrator need to select to determine where the Autonomous Database is created on the dedicated
infrastructure?
-The Listener endpoint where the Autonomous Database should register on
-The container database in which the Autonomous instance should run
-The compartment of the dedicated infrastructure because each compartment only runs one dedicated
environment
-The Client Credentials wallet, which is used to connect to the Autonomous Database - -The
container database in which the Autonomous instance should run
How do you change the tablespace quota for user mrizo on autonomous database on shared
infrastructure?
-Execute alter database for user MTHEO tablespace DATA quota = 10G
-execute alter user MTHEO quota unlimited on tablespace DATA
-execute nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username> "MTHEO, tablespace quota>
UNLIMITED)
-execute alter tablespace DATA set quote = 10G - -execute
nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username> "MTHEO, tablespace quota>
UNLIMITED)
In the Autonomous Database on Dedicated Infrastructure service, what does the fleet administrator use
to control OCPU utilization?
-SQL Develope Web Console
-Compartment quotas
-Resource Manager settings
-Oracle Machine Learning notebook - -Compartment quotas
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction
Processing (ATP) databases?
-Only ATP manages optimizer statistics
-Only ADW uses columnar compression by default
-Only ATP supports automatic backups
-Only ADW supports autoscaling - -Only ADW uses columnar compression by default.
Autonomous Database's auto scaling feature allows your databa base number of OCPU cores at any
time. As demand increases, auto number of cores in use. Likewise, as demand drops, auto scaling
automatically cores in use. Which statement is FALSE regarding the auto scaling feature?
-The base number of OCPU cores allocated to a database is not guaranteed
-For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the
number of free cores that aren't being used by other auto scaling databases to meet high-load demands
-Auto scaling is enabled by default and can be enabled or disabled at any time
-For databases on dedicated Exadata infrastructure, the maximum number of cores available to a
database depends on the total number of cores available in the Exadata infrastructure instance. - -
The base number of OCPU cores allocated to a database is not guaranteed
You see a clock icon in the Status column on the SQL Monitoring tab of the Performance Hub. What does
it indicate?
-The SQL statement completed its execution
-The SQL statement is executing
-The SQL statement is queued
-The SQL statement did not complete due to an error - -The SQL statement is queued
, During the provisioning of an Autonomous Database on dedicated hardware, what does the database
administrator need to select to determine where the Autonomous Database is created on the dedicated
infrastructure?
-The Listener endpoint where the Autonomous Database should register on
-The container database in which the Autonomous instance should run
-The compartment of the dedicated infrastructure because each compartment only runs one dedicated
environment
-The Client Credentials wallet, which is used to connect to the Autonomous Database - -The
container database in which the Autonomous instance should run
How do you change the tablespace quota for user mrizo on autonomous database on shared
infrastructure?
-Execute alter database for user MTHEO tablespace DATA quota = 10G
-execute alter user MTHEO quota unlimited on tablespace DATA
-execute nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username> "MTHEO, tablespace quota>
UNLIMITED)
-execute alter tablespace DATA set quote = 10G - -execute
nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username> "MTHEO, tablespace quota>
UNLIMITED)
In the Autonomous Database on Dedicated Infrastructure service, what does the fleet administrator use
to control OCPU utilization?
-SQL Develope Web Console
-Compartment quotas
-Resource Manager settings
-Oracle Machine Learning notebook - -Compartment quotas
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
