Autonomous Database II Flashcards

1
Q

Explain Data Pump

2 Points

A

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?
1
Not at all
2
3
4
5
Perfectly
2
Q

Explain Golden Gate (3 Points)

A

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?
1
Not at all
2
3
4
5
Perfectly
3
Q

DataSync

Perform 2 Points

A

Perform incremental data loads or rolling deletes

Perform insert-only or append strategies.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q
Data Sync 
(4 Points)
A

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?
1
Not at all
2
3
4
5
Perfectly
5
Q
SQL Developer
(3 Points)
A

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?
1
Not at all
2
3
4
5
Perfectly
6
Q

DBMS_CLOUD.COPY_DATA

What must be created before running D…?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

DBMS_CLOUD.COPY_DATA

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

DBMS_CLOUD.COPY_DATA

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

The Wallet Files include?

A
tnsnames
sqlnet.ora
cwallet.sso
keystore.jks
odbc.properties
README
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Two Security Feature Enabled by default

A

SQL Net Encryption

Transparent Data Encryption (TDE)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Two Methods of migration from on-premise

A

Data Pump

Golden Gate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

3 Methods of Loadding data to ADB

A

Data Pump
Golden Gate
SQL *Loader

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What happens when ADB is stopped?

A

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?
1
Not at all
2
3
4
5
Perfectly
15
Q

Two system Privileges to create analytic views?

A

CREATE ATTRIBUTE DIMENSION

CREATE ANALYTIC VIEW

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Validate Analytic View

A

VALIDATE_ANALYTIC_VIEW

VALIDATE_HIERACHY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Three data dictionary views contain information about analytic view objects

A

ALL_ANALYTIC_VIEW_DIM_CLASS
ALL_ANALYTIC_VIEW_LVLGRPS
ALL_ANALYTIC_VIEW_KEYS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Two Options to restore

A

Specify the point in time (timestamp) to restore.

Select the backup which restore needs to be done.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Two tasks can be executed from the service console:

A

ADB monitoring for usage and query performance.

Wizard to download connection wallet for connection from desktop.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Two methods to define ML User

A

SQL Developer

Oracle Cloud Infrastructure Console

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Two methods to create user and grant roles in ADB

A

SQL Developer SQLPlus

SQL Plus

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

DBMS_CLOUD Procedures

CREATE_CREDENTIALS Procedure

A

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?
1
Not at all
2
3
4
5
Perfectly
23
Q

DBMS_CLOUD Procedures

DELETE_FILE Procedure

A

removes the specified file from the specified directory on ADW

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

DBMS_CLOUD Procedures

PUT_OBJECT Procedure

A

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?
1
Not at all
2
3
4
5
Perfectly
25
Q

DBMS_CLOUD Procedures

VALIDATE_EXTERNAL_TABLE Procedure

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

DBMS_CLOUD Procedures

CREATE_EXTERNAL_TABLE Procedure

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

ANALYTIC VIEW

CREATE ANALYTIC VIEW

A

Create an analytic view in the grantee’s schema

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

ANALYTIC VIEW

CREATE ANY ANALYTIC VIEW

A

Create analytic views in any schema except SYS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

ANALYTIC VIEW

CREATE ATTRIBUTE DIMENSION

A

Create an attribute dimension in the grantee’s schema

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

ANALYTIC VIEW

CREATE ANY ATTRIBUTE DIMENSION

A

Create attribute demensions in any schema except SYS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

ANALYTIC VIEW

CREATE HIERARCHY

A

Create a hierarchie in the grantee’s schema

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

ANALYTIC VIEW

CREATE ANY HIERARCHY

A

creates hierarchies in any schema except SYS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q
ANALYTIC VIEW
**ALTER ANY ....
ANALYTIC VIEW
ATTRIBUTE DIMENSION
HIERARCHY**
A

Statt create = Rename

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q
ANALYTIC VIEW
**DROP ANY ....
ANALYTIC VIEW
ATTRIBUTE DIMENSION
HIERARCHY**
A

Statt create = drop

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

ANALYTIC VIEW

SELECT ANY TABLE

A

Query or view any analytic view or hierarchy in any schema

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

How to ignore hints in SQL Statements

A

-> ADW

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

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

A

A “POST” REST call

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

predefined user created when ADB instance is created

A

ADMIN

39
Q

predefined role in ADB

A

DWROLE

40
Q

Feature is NOT part of the ADB

A

JAVA in Database

41
Q

Not automated performed

A

Mask sensitive data

42
Q

Modify default 8 days retention period for performance data in DATA_WORKLOAD_REPOSITORY

A

MODIFY_SNAPSHOT_SETTINGS

43
Q

Provision resource without logging in

A

CLI + REST API call

44
Q

Set HTTP Proxy in JDBC

A

tnsnames.ora

45
Q

Add user’s public ssh key in console

A

Identity-Select User - add Public key

46
Q

Oracle allow to scale compute and storage independently?

A

YES

47
Q

When scaling OCPU’s Active Transactions continue running unaffected?

A

Yes

48
Q

Connect Oracle Analytics Cloud to the ADW - you need ?

A

CWALLET.SSO

49
Q

Not required to connect ADB from SQL Developer

A

Database Name

50
Q

Default Port Number to connect to ADB

A

1522

51
Q

OS can run Data Visualization Desktop

A

Windows and MAC

52
Q

Import tables into the Oracle Analytics Cloud (OAC)

A

create a Data Set

53
Q

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

A

YES

54
Q

Subset of services offered via OCI-CLI

A

Create, Get , List, Stop, Restore

55
Q

Default retention period for both Automatic and Manual ADB Backup

A

60 Days

56
Q

LOW provides highest concurrency - lowest resources and DoP =1

A

Yes

57
Q

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

A

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

58
Q

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

A

Increase Storage allocated for Database

Scale up/down CPU

59
Q

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.

A

Data is stored in columnar format.

60
Q

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.

A

It is used for OLTP and mixed workloads.

61
Q

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.

A

Data is stored in row format.

Missing indexes are detected and created.

62
Q

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
A

All of the above

63
Q

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.

A

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.

64
Q

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.

A

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

65
Q
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
A

Database Name
Workload Type
Number of CPUs

66
Q

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

A

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

67
Q

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#

A

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

68
Q

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

A

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

69
Q

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.

A

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

70
Q

Which levels of access can be defined in the policies? (Choose four)

Use
Write
Read
Manage
Inspect
Create
A

Use /Read /Manage /Inspect

71
Q

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(*)
A

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

72
Q

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
A

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

73
Q

What are the inputs you provide when creating an Autonomous Exadata Infrastructure resource? (Choose three)

Shape
Availability Domain
Storage
VCN

A

Shape
Availability Domain
VCN

74
Q

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
A

Provision Autonomous Exadata Infrastructure

Provision Autonomous Container Databases

75
Q

What is the main use case for REST APIs?

Monitoring only
Monitoring, DevOps, & Development
Monitoring & DevOps
Monitoring & Development
DevOps only
A

Monitoring, DevOps, & Development

76
Q

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

A

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

77
Q

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
A

Location of the config file
User OCID
Tenancy OCID

78
Q

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.

A

Independently scale compute or storage.

Resizing occurs instantly, fully online.

79
Q

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

A

Is easy to use and lightweight to install

Calls OCI REST APIs

80
Q

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.

A

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

81
Q

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

A

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

82
Q

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

A

No need to install a client query tool

Quickly start running queries with built-in web-based notebooks

83
Q
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.
A

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

84
Q

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
A

DB username and password
Service Name
Credential Wallet

85
Q

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.

A

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

86
Q

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

A

Object Storage

87
Q

Which clause is used in Property Graph query language to specify patterns?

Between
Like
Distinct
Match

A

Match

88
Q

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.

A

It provides full-text content searching.

It combines relational content searching via SQL.

89
Q

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.

A

It allows to store JSON data in the database.

It supports NoSQL-Style document-centric applications.

90
Q

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.

A

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

91
Q

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

A

Azure Blob Storage
Amazon AWS S3
OCI Object Storage

92
Q

What is used by Database migration service for migration?

GoldenGate replication
Data Guard
RMAN Backup
Backup Cloud Module

A

GoldenGate replication

93
Q

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

RMAN
Data Guard
GoldenGate
Data Pump

A

GoldenGate

Data Pump

94
Q

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

A

DBMS_CLOUD.COPY_DATA