Autonomous Database II Flashcards
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
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.
DataSync
Perform 2 Points
Perform incremental data loads or rolling deletes
Perform insert-only or append strategies.
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
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
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.
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
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
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
The Wallet Files include?
tnsnames sqlnet.ora cwallet.sso keystore.jks odbc.properties README
Two Security Feature Enabled by default
SQL Net Encryption
Transparent Data Encryption (TDE)
Two Methods of migration from on-premise
Data Pump
Golden Gate
3 Methods of Loadding data to ADB
Data Pump
Golden Gate
SQL *Loader
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
Two system Privileges to create analytic views?
CREATE ATTRIBUTE DIMENSION
CREATE ANALYTIC VIEW
Validate Analytic View
VALIDATE_ANALYTIC_VIEW
VALIDATE_HIERACHY
Three data dictionary views contain information about analytic view objects
ALL_ANALYTIC_VIEW_DIM_CLASS
ALL_ANALYTIC_VIEW_LVLGRPS
ALL_ANALYTIC_VIEW_KEYS
Two Options to restore
Specify the point in time (timestamp) to restore.
Select the backup which restore needs to be done.
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.
Two methods to define ML User
SQL Developer
Oracle Cloud Infrastructure Console
Two methods to create user and grant roles in ADB
SQL Developer SQLPlus
SQL Plus
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.
DBMS_CLOUD Procedures
DELETE_FILE Procedure
removes the specified file from the specified directory on ADW
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.
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