Autonomous IV Flashcards
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.) A. DBNAME_MEDIUM B. DBNAME_HIGH C. DBNAME_CONCURRENT D. DBNAME_LOW
DBNAME_LOW
When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column.
What does this mean? (Choose the best answer.)
A. The SQL statement is executing.
B. The SQL statement did not complete either due to an error.
C. The SQL statement is queued.
D. The SQL statement completed its execution.
C. The SQL statement is queued.
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing? (Choose two.) A. Backup Retention B. Index Storage C. Data Organization D. Memory Usage E. Undo Management
B. Index Storage
C. Data Organization
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint? (Choose three.) A. Security List B. Route Table C. Subnet D. VCN E. Network Security Group
C. Subnet
D. VCN
E. Network Security Group
Which three event types are supported for Autonomous Database? (Choose three.)
A. Update IORM Begin
B. Maintenance Begin
C. Terminate End
D. Change Autoscaling Configuration Compartment
E. Change Compartment Begin
B. Maintenance Begin
C. Terminate End
E. Change Compartment Begin
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure? (Choose two.)
A. Users have OS access to the database machine.
B. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
C. Users can customize the OS stack and add additional packages.
D. Users have SYS privileges in the database.
E. Users can customize the maintenance schedule.
B. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
D. Users have SYS privileges in the database.
Data Safe
Data Safe support more than ADB
Which statement is true when you provision an Autonomous Database using the cloning method? (Choose the best answer.)
A. A clone database source can be a running database instance.
B. A clone database source can be from a point-in-time backup that is less than 2 hours old.
C. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new
database.
D. After an Autonomous database is created using a clone, the network access option can be changed.
A. A clone database source can be a running database instance.
Which statement is NOT correct when setting up compartment quotas? (Choose the best answer.)
A. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
B. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
C. Compartment quotas are set by Oracle.
D. There are three types of quota policy statements which are set, unset and zero.
C. Compartment quotas are set by Oracle.
UESTION 16
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)
A. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
B. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
C. The target table will be created in Autonomous Database if it does not already exist.
D. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
E. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
B. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
E. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
dbms_cloud admin.grant_tablespace_quota()
Change tablespace quota
Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure? (Choose two.)
A. You have direct access to the database node.
B. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
C. Oracle Database Result Cache is enabled by default for all SQL statements.
D. Parallelism is not enabled by default.
B. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
C. Oracle Database Result Cache is enabled by default for all SQL statements.
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure? (Choose the best answer.)
A. You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two
consecutive quarters if needed.
B. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata
infrastructure.
C. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.
D. You can perform a “rolling restart” on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately
while the remaining nodes continue to be available
A. You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two
consecutive quarters if needed.
While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to
be applied during maintenance? (Choose the best answer.)
A. Prior Release Update Revision (PRUR)
B. Prior Release Update (PRU)
C. Release Update (RU)
D. Quarterly Bundle Patch (QBP)
C. Release Update (RU)
Which three security features are available in Oracle Autonomous Database Shared Infrastructure? (Choose three.) A. Data Redaction B. Database Vault C. Audit Vault D. Customer Managed Keys E. Transparent Data Encryption
B. Database Vault
D. Customer Managed Keys
E. Transparent Data Encryption
