Autonomous Database II Flashcards by Dirk Schwarz

Explain Data Pump

2 Points

DP can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
Faster to migrate than using RMAN

How well did you know this?

Not at all

Perfectly

Explain Golden Gate (3 Points)

ADB instance can be configured as target database for Oracle GoldenGate On Premise
But ADB Cloud can’t be the source for Oracle Goldengate On Premise
Only the migration from GoldenGate OnPremise to ADB Cloud is possible.

How well did you know this?

Not at all

Perfectly

DataSync

Perform 2 Points

Perform incremental data loads or rolling deletes

Perform insert-only or append strategies.

How well did you know this?

Not at all

Perfectly

Data Sync 
(4 Points)

Data Sync can load a combination of data source - such as .csv, .xlsx and Oracle rel. files.
Data Sync can connect to any jdbc compytible source like MongoDB, Redshift and Sybase.
Transform your data
Schedule data loads

How well did you know this?

Not at all

Perfectly

SQL Developer
(3 Points)

can be used to export/move/import of a database to ADB in 1 set of wizard steps
can import .csv files into ADB which are located on the system where SQL Dev is running
can import files (.dmp and .csv) into ADB which are located on Amazon S3 Object Storage

How well did you know this?

Not at all

Perfectly

DBMS_CLOUD.COPY_DATA

What must be created before running D…?

A valid credential must be cretaed prior to running the DBMS_CLOUD.COPY_DATA procedure.

How well did you know this?

Not at all

Perfectly

DBMS_CLOUD.COPY_DATA
on Oracle CLoud Infrastructure Object Storage Classic
Username?

Oracle Cloud Infrastructure Classic user name and the password is your Oracle Cloud Infrastructure Classic password

How well did you know this?

Not at all

Perfectly

DBMS_CLOUD.COPY_DATA

Source file reside on Amazon S3 (or calling an AWS API)

the username is your AWS acces key ID and the password is your AWS secret access key

How well did you know this?

Not at all

Perfectly

DBMS_CLOUD.COPY_DATA

Source file reside in Azure Blob Storage (or you calling an Azure API)

the username is your Azure Storage account name and the password is an Azure storage account access key

How well did you know this?

Not at all

Perfectly

The Wallet Files include?

tnsnames
sqlnet.ora
cwallet.sso
keystore.jks
odbc.properties
README

How well did you know this?

Not at all

Perfectly

Two Security Feature Enabled by default

SQL Net Encryption

Transparent Data Encryption (TDE)

How well did you know this?

Not at all

Perfectly

Two Methods of migration from on-premise

Data Pump

Golden Gate

How well did you know this?

Not at all

Perfectly

3 Methods of Loadding data to ADB

Data Pump
Golden Gate
SQL *Loader

How well did you know this?

Not at all

Perfectly

What happens when ADB is stopped?

Tools are no longer able to connect to a stopped instance
CPU billing is halted on full cycle of usage
In-flight transactions and queries are stopped

How well did you know this?

Not at all

Perfectly

Two system Privileges to create analytic views?

CREATE ATTRIBUTE DIMENSION

CREATE ANALYTIC VIEW

How well did you know this?

Not at all

Perfectly

Validate Analytic View

VALIDATE_ANALYTIC_VIEW

VALIDATE_HIERACHY

How well did you know this?

Not at all

Perfectly

Three data dictionary views contain information about analytic view objects

ALL_ANALYTIC_VIEW_DIM_CLASS
ALL_ANALYTIC_VIEW_LVLGRPS
ALL_ANALYTIC_VIEW_KEYS

How well did you know this?

Not at all

Perfectly

Two Options to restore

Specify the point in time (timestamp) to restore.

Select the backup which restore needs to be done.

How well did you know this?

Not at all

Perfectly

Two tasks can be executed from the service console:

ADB monitoring for usage and query performance.

Wizard to download connection wallet for connection from desktop.

How well did you know this?

Not at all

Perfectly

Two methods to define ML User

SQL Developer

Oracle Cloud Infrastructure Console

How well did you know this?

Not at all

Perfectly

Two methods to create user and grant roles in ADB

SQL Developer SQLPlus

SQL Plus

How well did you know this?

Not at all

Perfectly

DBMS_CLOUD Procedures

CREATE_CREDENTIALS Procedure

stores Cloud Object Storage credentials in the ADW database. Use stored credentials for data loading or for querying external data residing in the Cloud.

How well did you know this?

Not at all

Perfectly

DBMS_CLOUD Procedures

DELETE_FILE Procedure

removes the specified file from the specified directory on ADW

How well did you know this?

Not at all

Perfectly

DBMS_CLOUD Procedures

PUT_OBJECT Procedure

Copies a file from ADW to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 GB.

How well did you know this?

Not at all

Perfectly

DBMS_CLOUD Procedures | **VALIDATE_EXTERNAL_TABLE Procedure**

validates the source files for an external table, generates log information and stores the row that do not match the format options specified for the external table on ADW

DBMS_CLOUD Procedures | **CREATE_EXTERNAL_TABLE Procedure**

creates an external table on files in the Cloud. This allows to run queries on external data from ADW

ANALYTIC VIEW | **CREATE ANALYTIC VIEW**

Create an analytic view in the grantee's schema

ANALYTIC VIEW | **CREATE ANY ANALYTIC VIEW**

Create analytic views in any schema except SYS

ANALYTIC VIEW | **CREATE ATTRIBUTE DIMENSION**

Create an attribute dimension in the grantee's schema

ANALYTIC VIEW | **CREATE ANY ATTRIBUTE DIMENSION**

Create attribute demensions in any schema except SYS

ANALYTIC VIEW | **CREATE HIERARCHY**

Create a hierarchie in the grantee's schema

ANALYTIC VIEW | **CREATE ANY HIERARCHY**

creates hierarchies in any schema except SYS

``` ANALYTIC VIEW **ALTER ANY .... ANALYTIC VIEW ATTRIBUTE DIMENSION HIERARCHY** ```

Statt create = Rename

``` ANALYTIC VIEW **DROP ANY .... ANALYTIC VIEW ATTRIBUTE DIMENSION HIERARCHY** ```

Statt create = drop

ANALYTIC VIEW | **SELECT ANY TABLE**

Query or view any analytic view or hierarchy in any schema

How to ignore hints in SQL Statements

**->** ADW

Rest verb is used to create an ADB service using REST APIs

A "POST" REST call

predefined user created when ADB instance is created

ADMIN

predefined role in ADB

DWROLE

Feature is NOT part of the ADB

JAVA in Database

Not automated performed

Mask sensitive data

Modify default 8 days retention period for performance data in DATA_WORKLOAD_REPOSITORY

MODIFY_SNAPSHOT_SETTINGS

Provision resource without logging in

CLI + REST API call

Set HTTP Proxy in JDBC

tnsnames.ora

Add user's public ssh key in console

Identity-Select User - add Public key

Oracle allow to scale compute and storage independently?

YES

When scaling OCPU's Active Transactions continue running unaffected?

Yes

Connect Oracle Analytics Cloud to the ADW - you need ?

CWALLET.SSO

Not required to connect ADB from SQL Developer

Database Name

Default Port Number to connect to ADB

1522

OS can run Data Visualization Desktop

Windows and MAC

Import tables into the Oracle Analytics Cloud (OAC)

create a Data Set

JDBC Thinclient versions than 18.1 do not support connections through HTTP proxy

YES

Subset of services offered via OCI-CLI

Create, Get , List, Stop, Restore

Default retention period for both Automatic and Manual ADB Backup

60 Days

LOW provides highest concurrency - lowest resources and DoP =1

Yes

How can SQL Developer help you test your data loading scenario?

In the column Definition Phase - the system cross-reference with the file-contents and shows the conflict with the definition

Which two actions can be performed from the OCI Console for an Oracle Autonomous Database? (Choose all correct answers) Scale up/down Memory Increase Network Bandwidth Increase Storage allocated for Database Scale up/down CPU

Increase Storage allocated for Database | Scale up/down CPU

Which statement is true about Autonomous Data Warehouse? Data is stored in row format. Missing indexes are detected and created. Data is stored in columnar format. Response time is optimized for queries.

Data is stored in columnar format.

Which statement is true about Autonomous Transaction Processing? It is used for analytic workloads. Data is stored in columnar format. It is used with data marts and machine learning. It is used for OLTP and mixed workloads.

It is used for OLTP and mixed workloads.

Which statements are true about Autonomous Transaction Processing? (Choose two) Data is stored in columnar format. Data is stored in row format. Missing indexes are detected and created. Complex SQL queries are optimized.

Data is stored in row format. | Missing indexes are detected and created.

Which operations are included in automated data center operations? ``` Provisioning a database Patching a database Online backups of a database Automatically handling failures and errors All of the above ```

All of the above

Which statements are true about using Oracle Cloud Infrastructure? (Choose three) (Choose all correct answers) (1/1) Points It supports only Bare Metal DB Systems. It provides complete lifecycle automation. It provides high availability and scalability. It enables you to run everything from small VMs to large bare metal clusters. It supports only Exadata systems. It supports only Virtual Machine and Bare Metal DB Systems.

It provides complete lifecycle automation. It provides high availability and scalability. It enables you to run everything from small VMs to large bare metal clusters.

Which statement is true about Notification Service? (0/1) Points It helps you broadcast messages to distributed components using a private-subscribe model. It helps you broadcast messages to distributed components using a hybrid-subscribe model. It helps you broadcast messages to distributed components using a publish-subscribe model. It helps you broadcast messages to distributed components using a Exadata-subscribe model.

It helps you broadcast messages to distributed components using a publish-subscribe model.

``` Which three are required for provisioning an Oracle Autonomous Database instance? (Choose three) (Choose all correct answers) (1/1) Points Backup Location FRA Size Number of Tablespaces Database Name Workload Type Number of CPUs ```

Database Name Workload Type Number of CPUs

Which statements are true about Autonomous Database Cloning? (Choose two) As a refreshable (read-write) clone of the source Autonomous Database As a refreshable (read-only) clone of the source Autonomous Database Containing just the data of the source Autonomous Database Containing just the metadata of the source Autonomous Database

As a refreshable (read-only) clone of the source Autonomous Database Containing just the metadata of the source Autonomous Database

Which two are required for Autonomous Database Manual Backups? (Choose two) (Choose all correct answers) (0/1) Points The name format for the bucket in object storage must follow backup_ The object bucket name must be in uppercase. The object bucket name must be in lowercase. The name format for the bucket in object storage must follow backup#

The name format for the bucket in object storage must follow backup_ The object bucket name must be in lowercase.

Which are the capabilities of Oracle Autonomous Database that can accelerate innovation? (Choose three) Provisions a data warehouse in seconds Instant scaling of storage Scaling of CPUs with very little downtime Built-in AI and ML helps find patterns that could identify undiscovered anomalies

Built-in AI and ML helps find patterns that could identify undiscovered anomalies Provisions a data warehouse in seconds Instant scaling of storage

Which statement is true about moving Autonomous Database Resources? After a resource is moved to a new tenant, inherent policies apply later and affect access to that resource. After a resource is moved to a new compartment, inherent policies apply immediately and affect access to that resource. After a resource is moved to a new tenant, inherent policies apply immediately and affect access to that resource. After a resource is moved to a new compartment, inherent policies apply later and affect access to that resource.

After a resource is moved to a new compartment, inherent policies apply immediately and affect access to that resource.

Which levels of access can be defined in the policies? (Choose four) ``` Use Write Read Manage Inspect Create ```

Use /Read /Manage /Inspect

At what levels can we implement isolation with Autonomous Database Dedicated Deployment? (Choose three) ``` Virtual Cloud Network (VCN) level (*) Database level (*) Subnet Level Region level Container Database level (*) ```

Virtual Cloud Network (VCN) level Database level Container Database level

Which actions can be performed from the Autonomous Container Database (CDB) details page? (Choose four) ``` Change backup retention policy for CDB Change maintenance schedule Move CDB to a different compartment Stop CDB Stop Autonomous Database Restart CDB ```

Change backup retention policy for CDB Change maintenance schedule Move CDB to a different compartment Restart CDB

What are the inputs you provide when creating an Autonomous Exadata Infrastructure resource? (Choose three) Shape Availability Domain Storage VCN

Shape Availability Domain VCN

Ideally which of the following tasks will a Fleet Administrator perform? (Choose two) ``` Provision Autonomous Exadata Infrastructure Provision Autonomous Database Instances Provision Autonomous Container Databases Create IAM users Manage Autonomous Databases ```

Provision Autonomous Exadata Infrastructure Provision Autonomous Container Databases

What is the main use case for REST APIs? ``` Monitoring only Monitoring, DevOps, & Development Monitoring & DevOps Monitoring & Development DevOps only ```

Monitoring, DevOps, & Development

Which statements are true about automated tuning? (Choose three) Fast performance out of the box with zero tuning Parallel execution of the queries needs to be monitored manually. Built-in resource management plans Partitioning not covered under the automated tuning Simple web-based monitoring console

Fast performance out of the box with zero tuning Built-in resource management plans Simple web-based monitoring console

Which of these do you need to enter when you set up the Config File using the oci setup config command? (Choose three) ``` OCI Region OCID File format of the config file Location of the config file User OCID Tenancy OCID ```

Location of the config file User OCID Tenancy OCID

Which statements are true about scaling on demand? (Choose two) Independently scale compute or storage. Resizing needs a restart. Compute and storage must be scaled together. Resizing occurs instantly, fully online.

Independently scale compute or storage. | Resizing occurs instantly, fully online.

Which statements are true about OCI Command Line Interface? (Choose two) Runs on Linux operating systems only Does not use REST APIs Is easy to use and lightweight to install Calls OCI REST APIs Is easy to use but involves complex installation and configuration

Is easy to use and lightweight to install | Calls OCI REST APIs

Which statements are true about REST APIs and RESTful services? (Choose two) REST APIs only use JSON for communication. REST APIs also use the HTTP communication protocol but mainly use JSON for communication. REST stands for Representational State Transfer. RESTful services are complex when compared to traditional XML SOAP communications.

REST APIs also use the HTTP communication protocol but mainly use JSON for communication. REST stands for Representational State Transfer.

With which of the following does Oracle Machine Learning allow access to data in Autonomous Database? Data Ingestion and Selection only Data Viewing and Discovery and Data Ingestion and Selection Data Ingestion and Selection and Data Viewing and Discovery Data Ingestion and Selection and Data Viewing and Discovery, and Data Analysis

Data Ingestion and Selection and Data Viewing and Discovery, and Data Analysis

Which statements are true about built-in SQL Worksheet and Notebook? (Choose two) Based on Apache Tomcat Need to install client query tool for the PL/SQL No need to install a client query tool Quickly start running queries with built-in web-based notebooks

No need to install a client query tool | Quickly start running queries with built-in web-based notebooks

``` Which three actions can be performed by a workspace administrator? (Choose three) View usage reports for a workspace. Monitor workspace activity. Manage user accounts. Add space to a schema. Manage workspace to schema assignments. Approve workspace requests. ```

View usage reports for a workspace Monitor workspace activity. Manage user accounts

Which are the prerequisites for connecting to an Autonomous Database using SQL Developer? (Choose three) ``` Listener port number DB username and password Service Name Credential Wallet Public Key Private key DB System Public IP ```

DB username and password Service Name Credential Wallet

Which is true about a workspace in Oracle APEX? It can be associated with multiple schemas from different databases. It is not associated with any schemas. It can be associated with multiple schemas in the same database. It can be associated only with one schema.

It can be associated with multiple schemas in the same database.

You want to move some unstructured data consisting of images and videos to cloud storage. Which Storage would you use and is most cost-effective? Object Storage Block Volume File Storage Archive Storage

Object Storage

Which clause is used in Property Graph query language to specify patterns? Between Like Distinct Match

Match

Which statement is true about Oracle Text? (Choose two) It combines relational content searching via SQL. It supports PDFs only. It provides full-text content searching. It renders search result to HTML format only.

It provides full-text content searching. | It combines relational content searching via SQL.

Which statements are true about Oracle Autonomous JSON Database? (Choose two) (Choose all correct answers) (1/1) Points It allows to store JSON data in the database. It does not support autoscaling. It supports NoSQL-Style document-centric applications. It supports MySQL-Style database applications.

It allows to store JSON data in the database. | It supports NoSQL-Style document-centric applications.

Which statement is true about Spatial studio? It is a self-service application to create interactive maps. It does not need additional resources. It comes with an Autonomous Database at an additional cost. It is a fully managed service available in OCI.

It is a self-service application to create interactive maps.

For which cloud services does DBMS_CLOUD provide support for loading data from files to tables in Autonomous Database? (Choose three) Google Cloud Storage Azure Blob Storage Amazon AWS S3 OCI Object Storage

Azure Blob Storage Amazon AWS S3 OCI Object Storage

What is used by Database migration service for migration? GoldenGate replication Data Guard RMAN Backup Backup Cloud Module

GoldenGate replication

Which methods can be used to migrate an on-prem database to Oracle Autonomous Database? (Choose two) RMAN Data Guard GoldenGate Data Pump

GoldenGate | Data Pump

Which procedure can be used to load data directly into the existing Autonomous Database tables? DBMS_CLOUD.CREATE_EXTERNAL_TABLE DBMS_CLOUD.COPY_DATA DBMS_CLOUD.PUT_OBJECT DBMS_CLOUD.LIST_FILES

DBMS_CLOUD.COPY_DATA