wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

1z0-931 Part 2

Total questions: 169

Worksheet time: 2hrs 42mins

Name
Class
Date
1.

Which is the recommended data loading tool to migrate data from third-party databases?

a)

SQL Developer Data Import Wizard

b)

SQL Loader

c)

SQL Developer Migration Workbench

d)

Oracle Data Pump

2.

In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?

a)

  1. In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition.

b)

  1. In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.

c)

  1. In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.

d)

In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.

3.

Which two system privileges does a user need to create analytic views? (Choose two)

a)

create analytic view

b)

  1. create analytic level

c)

  1. create analytic measure

d)

create attribute dimension

e)

create analytic hierarchy

4.

Which is correct about security features that are available in Oracle Autonomous Database?

a)

  1. Data Redaction but not TDE.

b)

  1. Neither Data Redaction nor TDE are supported.

c)

  1. TDE but not Data Redaction.

d)

Data Redaction and TDE are both supported.

5.

Which statement is true about Oracle Text? (Choose two)

a)

It provides full-text content searching.

b)

  • It supports pdf only.

c)

It combines relational content searching via SQL.

d)

It renders search results to HTML format only.

6.

Which can be used to ensure that your Autonomous Database is accessible only from a given set of IPs?

a)

  • IPSec List

b)

  • IP Vault

c)

Access Control List

d)

  • Security List

7.

Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option? (Choose two.)

a)

  • current settings for acls are cloned.

b)

All OML notebooks are cloned.

c)

All underlying data for OML notebooks is cloned.

d)

  • All resource management rules are cloned.

e)

Clones can be in a different region.

8.

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?

a)

File Storage

b)

Archive Storage

c)

Object Storage

d)

Block Volume

9.

Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?

a)

The Oracle Client Credential file is downloaded as a ZIP file.

b)

You Must have an oracle client credential wallet in order to connect to autonomous database.

c)

The Wallet for the Autonomous Database is same as the TDE wallet

d)

In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database.

10.

For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?

a)

ORDS_ADMIN.ENABLE_SCHEMA

b)

ORDS_PRIV.ENABLE_SCHEMA

c)

SQLDEV_ADMIN.GRANT_SCHEMA

d)

ORDS_ADMIN.GRANT_SCHEMA

11.

Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

a)

  1. Import Table

b)

  1. Load data using Data Pump

c)

Create a Data Set

d)

  1. Replicate the table using Golden Gate

12.

Which is true about a workspace in Oracle APEX?

a)

It can be associated with multiple schemas in same database.

b)

  • It is not associated with any schemas.

c)

  • It can be associated only with one schema.

d)

  • It can be associate with multiple schemas with different databases.

13.

With which of the following does Oracle Machine Learning allow access to data in Autonomous Database?

a)

  • Data Ingestion and Selection only.

b)

None of the above

c)

Data Ingestion and selection and data viewing and discovery and data analysis.

d)

Data Viewing and Discovery and Data Ingestion and Selection.
 

14.

Which statement is true in regards to database links?

a)

  1. Connect to Autonomous Database from remote database using a database link.

b)

  1. You can call PL/SQL procedures and functions using a database link.

c)

Create a database link from one Autonomous Database to another Autonomous Database instance.

d)

  1. Connect from Autonomous Database to remote database using a database link.

15.

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure Console?

a)

  1. It cannot be done.

b)

using the cloud infrastructure command line interface or rest api calls

c)

  1. Connecting to the cloud infrastructure console using the ssh wallet.

d)

  1. using the dbca on the database server

16.

Which two statements are true with regards to Oracle Data Sync? (Choose two)

a)

Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata

b)

  1. Data Sync can use a normal OCI client connection to connect to an oracle database.

c)

  1. Data Sync can connect to any jdbc compatible source like MongoDB, Redshift and Sybase.

d)

Data Sync can load your data in parallel in order to speed up the loading process.

17.

Which TWO Data Guard Replication Modes are available in Autonomous Database Dedicated? (Choose two.)

a)

  • Max Synchronization

b)

Max Availability

c)

Max Performance

d)

  • Max Protection

18.

When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?

a)

Under Database then Autonomous Transaction processing then autonomous exadata

b)

  1. Under solutions and platforms then platform services then autonomous exadata

c)

  1. Under Core Infrastructure then Autonomous Exadata

d)

  1. Under Core Infrastructure then compute then Autonomous Exadata

19.

You want to enable automatic indexing in a database, but any new auto indexes should be created as invisible indexes, so that they cannot be used in SQL statements. Which command will you use?

a)

EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','INVISIBLE');

b)

EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','REPORT ONLY');

c)

EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','IMPLEMENT');

d)

EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','OFF');

20.

In Graph Studio which you can use to create a graph?

a)

  • A graph license key

b)

  • Graph analytics algorithms

c)

  • NoSQL configuration

d)

  • Graph created by a special tool downloaded from Oracle.com

e)

Tables in an Autonomous Database instance

21.

What is the default retention period for both Automatic and Manual Autonomous Database Backups?

a)

7 days

b)

One Year

c)

45 days

d)

60 days

e)

90 days

22.

Which statement is true regarding database client credentials file required to connect to your Autonomous Database?

a)

The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database.

b)

  1. Place the credential files on a share drive that all users can use to connect to the database.

c)

Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database.

d)

When you share the credential files with authorized users, mail the wallet password and the file in the same email.

23.

Which statement is NOT correct when setting up compartment quotas?

a)

Compartment quotas use policies that allow allocation of resources with a high level of flexibility.

b)

There are three types of quota policy statements which are set,unset and zero

c)

Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.

d)

Compartment quotas are set by oracle.

24.

Which statement is FALSE about compartment quotas?

a)

Three types of compartment quotas are zero, unset and set

b)

My Oracle Support (MOS) sets compartment quotas

c)

Compartment quotas can be used to enforce spendings

d)

To clear quotas, unset statement should be used to remove quota for a resource

25.

For Fleet admins to access dedicated exadata infrastructure, which policy should be assigned?

a)

Allow group adb-admins to manage autonomous-database in tenancy where target.workloadType='OLTP'

b)

Allow group adb-admins to manage autonomous-database-family in tenancy

c)

Allou group adb-admins to manage autonomous-database in tenancy where target.workloadType='DW'

d)

Allow group adb-admins to manage autonomous-database in tenancy

26.

When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?

a)

Active transactions are paused.

b)

Active transactions are terminated and rolled back.

c)

Active transactions continue running unaffected.

d)

Scaling cannot happen while there are active transactions in the database.

27.

Which are the three pre-requisities for connecting to an Autonomous database using SQL Developer? (Choose Three)

a)

DB Username and Password

b)

DB System Public IP

c)

Credential Wallet

d)

Service Name

e)

Public Key

28.

How many Network Security Groups (NSGs) can you configure for an Autonomous Database?

a)

9

b)

7

c)

3

d)

5

29.

Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this. Which statement is true regarding Oracle Data Sync?

a)

Data Sync can not transform your data while loading it into the destination table.

b)

Data Sync can only load files into tables (insert-only), the customer has to write the additional code.

c)

Data Sync can only load data from one source into one destination table.

d)

Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files.

30.

What is used by Database Migration Service for migration?

a)

DataGuard

b)

RMAN Backup

c)

Backup Cloud Module

d)

Goldengate Replication

31.

Which statement is true about Spatial studio?

a)

It is a fully managed service available in OCI.

b)

It does not need additional resources.

c)

It comes with Autonomous Database at additional cost

d)

It is a self-service application to create interactive maps

32.

Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

a)

ATP and ADW

b)

Autonomous Data Warehouse only

c)

Autonomous Transaction Processing only

d)

  • Hybrid Columnar Compression

33.

You have moved an Autonomous Database from compartment C01 to C02. Which TWO are TRUE? (Choose two.)

a)

An Autonomous Data Guard for the database is created in C01 post successful migration to C02.

b)

The Automatic Backups are moved to C02, as well.

c)

Any Policy defined on C02 will be immediately applied to the database

d)

You need to shut down the database in C01 before you can move it to C02.

34.

What is the default port number for accessing a newly created Autonomous Database?

a)

1521

b)

1524

c)

1523

d)

1522

35.

Which statement is true when connecting OCI Marketplace image to shared autonomous database?

a)

Compute Image and Shared ADB must be in same VCN and Subnet

b)

ADB must be configured with NSG

c)

ADB must be configured with Private endpoints

d)

Cannot connect OCI Market image to shared ADB

36.

Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

a)

The Autonomous Database must be in the same VCN and Subnet as the Compute instance.

b)

The OCI compute instance does not support connecting to a Shared Autonomous Database.

c)

The Autonomous Database must belong to a Network Security Group (NSG).

d)

The OCI compute instance can be used with an Always-Free Autonomous Database account.

e)

A Private Endpoint is required to connect to the Shared-Autonomous Database.

37.

When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?

a)

Scan partition tables

b)

scan hybrid partition tables

c)

prun column in parquet files

d)

prun columns in csv files

38.

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?

a)

Release Update (RU)

b)

Prior Release Update Revision (PRUR)

c)

Prior Release Update (PRU)

d)

Quarterly Bundle Patch (QBP)

39.

A Corporation is building a web application to allow its customers to schedule service requests online.

There is also a need to run operational reports at times during non-peak hours.

The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart.

The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance,

but meets their strict performance requirements as well. Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

a)

  1. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.

b)

  1. ADW since operational reporting is a higher priority in this scenario.

c)

It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.

d)

ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

40.

Which three security features are available in Oracle Autonomous Database Shared Infrastructure?

a)

Transparent Data Encryption

b)

Database Vault

c)

Customer Managed Keys

d)

Data Redaction

e)

Audit Vault

41.

Which statement is true when the Autonomous Database has auto scaling enabled?

a)

Database concurrency is scaled up when needed by the workload.

b)

Increases the number of sessions available to the database.

c)

Scales the PGA and SGA size when needed for the workload.

d)

Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.

42.

Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)

a)

RMAN Cross-Platform backup and restore

b)

  1. Golden Gate on-premise installation

c)

PDB unplug / plug operation

d)

Datapump export / import

e)

Golden Gate Cloud service

43.

What are three methods to load data into the Autonomous Database?

a)

Oracle GoldenGate

b)

Transportable Tablespace

c)

RMAN Restore

d)

Oracle Data Pump

e)

SQL*Loader

44.

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web. What steps do you need to take?

a)

Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.

b)

Create a database user with the default privileges.

c)

  1. Create a database user with connect, resource, and object privileges.

d)

  1. Create an IDCS user. Create a database user with connect, resource, and object privileges.

45.

Which statement is FALSE for Oracle Data Safe? (Choose the best answer.)

a)

  • Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations

b)

  • Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user

c)

Oracle Data Safe only supports Autonomous Database

d)

  • Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary

46.

To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?

a)

  1. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB

b)

  1. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure

c)

Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB

d)

Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator ->Autonomous Container DB -> Autonomous DB

47.

Which predefined role that exists in Autonomous Database includes common privileges that are used by a Data Warehouse developer?

a)

ADMIN

b)

ADBDEV

c)

DWROLE

d)

ADWC

48.

What predefined user is created when provisioning an Autonomous Database (ADB) instance to which you connect to create other users and grant roles?

a)

DWDEV

b)

ADMIN

c)

SCOTT

d)

SYS

49.

Which tab in the Data Load Explore tool shows the size of the table and the number of rows and columns?

a)

Hierarchies tab

b)

Statistics tab

c)

Measures tab

d)

Data Sources tab

50.

Which two (should be THREE) optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?

a)

Backup Retention

b)

Memory Usage

c)

Data Organization

d)

Undo Management

e)

Index Storage

51.

Which index type is designed to index catalog information?

a)

CONTEXT

b)

CTXRULE

c)

CONTRAINS

d)

CTXCAT

52.

Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?

a)

You must first manually create your database credentials using dbms_cloud.create_credential before accesing your Oracle Object Storage Bucket.

b)

  • Data can be uploaded from several cloud storage sources including S3, Azure, Google Cloud and Oracle Object Storage.

c)

Data formats supported include: text, csv, json, avro and parquet.

d)

Data can be loaded from a local data source

e)

Data can be loaded from a remote database using Database Links (DBLinks).

53.

Which subset of services is offered via OCI-CLI (command line interface) for Autonomous Database (ADB) via calls made to the OCI APIs?

a)

Start, Delete, Update, Query, Stop

b)

Create, Get, List, Stop, Restore

c)

Create, Query, Update, List, Start

d)

Create, Query, List, Stop, Restore

54.

Which of the following two statements regarding Data Transforms are correct?

a)

Data Transforms allow you to design data transformations in the form of data loads, data, flows, and workflows.

b)

Data Transforms provides access to Oracle Data Integrator (ODI) Web Edition.

c)

All capabilities to transform data in ODI Classic are available with ODI Web Edition.

d)

Workflows for data transform is only available on the ODI Web Edition.

55.

What two actions can you do when a refreshable clone passes the refresh time limit?

a)

You can use the instance as a read only database

b)

You can disconnect from the source to make the database a read/write database.

c)

You can extend the refresh time limit

d)

You can manually refresh the clone.

56.

Which are two available options when creating an Autonomous Database?

a)

APEX Service on Shared Infrastructure

b)

Autonomous JSON Database on Shared Infrastructure

c)

Autonomous JSON Database on Dedicated Infrastructure

d)

APEX Service on Dedicated Infrastructure

57.

What is the default time range in Performance Hub?

a)

1 Week

b)

1 Hour

c)

24 Hours

d)

15 Minutes

58.

Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure?

a)

Oracle Cloud Infrastructure Vault, Oracle Database Vault.

b)

Oracle Database Vault, Oracle Key Vault.

c)

Oracle Audit Vault, Oracle Key Vault.

d)

Oracle Key Vault, Oracle Cloud Infrastructure Vault.

59.

Which option describes the connection types that third-party sotfware an use to connect to an Autonomous Database (ADB)?

a)

JDBC only

b)

new ADB-specific protocols

c)

any protocol supported by Oracle Net Services

d)

SQL*NET only

60.

Your company has a .NET application and wants to deploy it on Autonomous Database (ADB). What software is used to connect to ADB from the .NET application?

a)

You cannot use .NET with ADB

b)

Java

c)

SQL*Plus

d)

Oracle Data Access Components for Windows.

61.

Which two cloud services allow you to import Data Pump files to an Autonomous Database on Dedicated Infrastructure?

a)

Oracle Cloud Infrastructure Object Storage

b)

Amazon S3

c)

Azure Blob Storage

d)

Oracle Cloud Infrastructure Object Storage Classic

e)

Google Cloud Storage

62.

Which of the below cloud services is supported to import Data Pump files?

a)

Microsoft Azure

b)

Blue Cloud

c)

AWS S3

d)

Alibaba Cloud

63.

Which workload is particularly suited to Oracle Autonomous JSON Database?

a)

Transactions

b)

Data Lakes

c)

Schemaless, document centric

d)

Data Marts

64.

Which three functions are provided by Spatial Studio?

a)

Map visualization

b)

Custom SQL queries

c)

Spatial data editing

d)

Spatial analysis

e)

Geocoding

65.

Which two statements apply to the Autonomous Database service on Dedicated Infrastructure?

a)

You, as the customer, are responsible for all patching operations.

b)

Patching occurs on the first Sunday of each quarter.

c)

You can set maintenance windows for each individual Autonomous Container Database.

d)

You can set maintenance windows for an Autonomous Exadata Infrastructure.

66.

Which two statements are true about Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for Autonomous Data Guard?

a)

RTO and RPO are 0 minutes for manual failovers.

b)

RPO is adjustable, but RTO is always 5 minutes.

c)

RPO is 0 minutes for an automatic failover.

d)

RTO and RPO are adjustable through the OCI console.

e)

RTO is 2 minutes for an automatic failover.

67.

Users connect to Autonomous Data Warehouse by using one of the following consumer groups: High, (EXAM) Medium, and Low.?

a)

High provides highest concurrency and lowest resources, and Dop is 1.

b)

Low provides highest concurrency and lowest resources, and Dop is 1.

c)

Medium provides intermediate resource and concurrency, and queries run serially.

d)

High provides highest resource and lowest concurrency, and Degree od parallelism (DoP) is 1.

68.

Which statement is FALSE about the Catalog tool?

a)

You can delete an entity from the autonomous Database via the Catalog tool.

b)

You can view the data definition of an entity.

c)

Impact shows the entities that depend on the source.

d)

  • You can limit the display of entities to only those with certain names, schemas, types, or applicactions by entering values in the Search field.

69.

What are three characteristics of Data Lake data captured in Object Storage?

a)

  • high concurrency

b)

high transaction performance

c)

multiple subject areas

d)

mixed data types

e)

schema on read

70.

Which is a feature of a graph query language?

a)

Scripting language

b)

Run key-value queries

c)

Object-oriented language

d)

Ability to specify patterns

71.

Which FOUR levels of access can be defined in policies?

a)

use

b)

inspect

c)

manage

d)

read

e)

create

72.

When you are increasing the number of OCPUs in your Autonomous Database, what does its status show?

a)

SCALING IN PROGRESS

b)

UPSCALE IN PROGRESS

c)

UPLIFT IN PROGRESS

d)

RESIZING IN PROGRESS

73.

Which Oracle Package is used to load data to an ADB from object storage?

a)

DBMS_LOAD

b)

DBMS_CLOUD

c)

DBMS_MIGRATE

d)

DBMS_RPC

74.

Which terminology is used to refer to a communication channel for sending messages to a subscription, such as email or SMS?

a)

Event

b)

Topic

c)

Notification

d)

Subject

75.

Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)

a)

An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.

b)

Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region.

c)

A single fault domain can be associated with multiple regions and availability domains.

d)

Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.

76.

Which statement is true about OCPUs and storage when you choose to scale your Autonomous Database?

a)

Use auto scaling to increase storage.

b)

OCPUs and storage can be scaled independently.

c)

OCPUs and storage must remain in sync.

d)

Increasing OCPUs will automatically increase storage.

77.

Which two statements are true regarding active transactions when scaling OCPUs in an Autonomous Database?

a)

Scaling can happen while there are active transactions in the database.

b)

Active transactions are paused.

c)

Active transactions are terminated and rolled back.

d)

Active transactions continue running unaffected.

78.

Which TWO infrastructure support deployment of Oracle Autonomous Database? (Choose all correct answers)

a)

Dedicated Exadata Infrastructure

b)

Virtual Machines on Oracle Cloud Infrastructure

c)

Shared Exadata Infrastructure

d)

Oracle Bare Metal Servers

79.

Which command can you use to create an Autonomous Database?

a)

POST /20160918/createautonomousDatabases

b)

POST /20160918/autonomousDatabases

c)

POST /20160918/createDatabases

d)

POST /20160918/createADB

80.

DBSRV1 is an Autonomous Database with the display name PRODDB. You plan to take manual backup of this database periodically. What must be the name of the bucket that will be used to store manual backups?

a)

BACKUP_DBSRV1

b)

BACKUP_PRODDB

c)

backup_proddb

d)

backup_dbsrv1

81.

Which is an Autonomous Database critical event?

a)

NewMaintenanceSchedule

b)

ScheduleMaintenanceWarning

c)

DatabaseConnection

d)

MaintenanceBegin

e)

AdminPasswordWarning

82.

Which two objects are imported when using Data Pump to migrate your Oracle database Autonomous Database?

a)

Data

b)

Report

c)

Schemas

d)

Tablespaces

83.

Who, and in which order, provisions dedicated Exadata Infrastructure resources?

a)

The database administrator provisions the Autonomous Container DB and the Autonomous DB. Then, the fleet administrator provisions the Autonomous Exadata Infrastructure.

b)

  • The Fleet administrator provisions the Autonomous Exadata Infrastructure. Then, The database administrator provisions the Autonomous Container DB and then the Autonomous DB.

c)

  • The database administrator provisions the Autonomous Exadata Infrastructure. Then, The Fleet administrator provisions the Autonomous Container DB and then the Autonomous DB.

d)

The Fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB and then, the database administrator provisions the Autonomous DB.

84.

As a database architect you are tasked with configuring a high concurrency, production OLTP (EXAM) application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode. Which connection service is appropriate for such a workload?

a)

TP

b)

TPURGENT

c)

MEDIUM

d)

HIGH

85.

Which file is NOT a component of the client credentials wallet used to connect to an Oracle Autonomous Database?

a)

cwallet.sso

b)

sqlnet.ora

c)

trustore.jks

d)

keystore.jks

e)

protocol.ora

86.

Which three operations are available for a quarterly maintenance update on Autonomous Container Database?

a)

Reschedule patching

b)

Reschedule and patch immediately.

c)

Apply a partial patch.

d)

  • Patch immediately.

e)

Skip patching.

87.

Which two actions can you perform with Autonomous Data Guard enabled on Autonomous Database on Shared Infrastructure?

a)

Switchover

b)

View Apply Lag

c)

Reinstate

d)

Failover

e)

Change Protection Mode

88.

Which statement is FALSE about Data Insights?

a)

Data Insights provides a wide range of graphical data presentation capabilities.

b)

The results of the Insight analysis appear as a series of bar charts in the Data Insights dashboard.

c)

Data Insights display information about patterns and anormalles in the data of entities in your Oracle Autonnomous Database.

d)

Data Insight are automatically generated by varios analytic functions built into the database

89.

Which are the two restrictions for and Always free Autonomous Database?

a)

  • Oracle Application Express (APEX) not included

b)

  • supports only ATP as a workload type

c)

maximum of two Always Free Database per OCI tenanc

d)

maximum of one OCPU per Database

90.

How can you keep Autonomous Database tables in sync with an on-premises data source?

a)

  • Use THE ords package on the Data Load page

b)

  • Use the FEED DATA option on the Data Load page

c)

Use the Cloud Locations card on the Data Load page

d)

  • Use the Link Data option on the Data Load page.

91.

Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endponits with security rules to allow incoming and outgoing traffic to and form the Autonomous Database instance?

a)

  • The destination port range is set to 1522.

b)

  • The source is set to the address range you want to allow to connect to your database.

c)

  • The IP Protocol is set to TCP.

d)

A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance.

92.

You created an Autonomous Database without auto scaling. Which two ways can you enable auto scaling?

a)

Click Scale Up/Down and select the Auto Scaling checkbox.

b)

  • Shut down the Instance, click Scale Scale Up/Down and select the Auto Scaling checkbox, then restart the Instance.

c)

Use a Rest call to enable Auto Scalling.

d)

  • Use a Rest call to Shut down the Instance, Then a second Rest call to enable Auto Scalling, and a REST call to restart the instance.

93.

Which of the following is not required for connecting to ADB via SQLDeveloper?

a)

Connection Name

b)

Usename

c)

Password

d)

Service

e)

Database name

94.

A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during nonpeak hours. The architecture team is debating whether such reports should be run on the online transaction processing (OLTP) database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well. Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

a)

  1. Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority In this scenario.

b)

  1. The application should be deployed on a Kubernetes Cluster because it needs to be highly available.

c)

Use Autonomous Transaction Processing (ATP) with "tpurgent" and "high" TNS services to separate connection types.

d)

  1. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.

95.

Which statement is true when the Autonomous Database has auto scaling enabled?

a)

  • Database concurrency is scaled up when needed by the workload.

b)

scales the PGA and SGA size when needed for the workload.

c)

It enables the database to use up to 3x OCPU/IO resources immediately when needed by the workload.

d)

  • It Increases the number of sessions available to the database.

96.

What can you do with graphs? (Choose two.)

a)

Facial recognition

b)

Product recommendations

c)

3-D modeling

d)

  • Find patterns that are anomalous and use that to detect fraud.

97.

On which two infrastructure classes can the Autonomous Database service be deployed?

a)

Dedicated Exadata Infrastructure

b)

Oracle Cloud Infrastructure Virtual Machines

c)

Shared Exadata Infrastructure

d)

Exadata Cloud Service

98.

Which two statements are true for Spatial Studio?

a)

It is a free app on the OCI Marketplace.

b)

It is a self service no-code web tool for Spatial.

c)

It is a developer IDE for Spatial.

d)

It is a managed OCI service.

99.

Which privilege is NOT included in the DWROLE role?

a)

PDB unplug / plug operation

b)

Golden Gate Cloud service

c)

Data Pump export / import

d)

  1. RMAN Cross-Platform backup and restore

e)

Golden Gate on-premises installation

100.

Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure?

a)

Maximum Protection

b)

Maximum Performance

c)

  • Maximum Continuity

d)

Maximum Availability

101.

Which statement is FALSE about Autonomous Data Guard on Autonomous Database on Dedicated Infrastructure?

a)

  • Switchover, Failover, and Reinstate operations can be initiated by a user.

b)

Autonomous Data Guard is enabled at the Container database level.

c)

  • The standby database is available for read-only workloads.

d)

A standby database can be on the same Exadata machine as the primary database.

102.

Which two are ways Oracle Database can optimally access data in Object Storage?

a)

  • Scan avoidance using columnar pruning for .csv files

b)

  • Optimized data archive using hybrid partitioned tables

c)

Optimized data archive using partitioned external tables

d)

Scan avoidance using partitioned external tables

103.

Which two of the following data sources are available when using the Data Load page on Database Actions?

a)

Backup files in block storage

b)

REST endpoints

c)

Files in Oracle Cloud Storage

d)

Local Files

104.

Which three options do NOT change when enabling auto scaling?

a)

Amount of storage

b)

I/O resources

c)

  • Level of concurrency

d)

  • Parallelism settings

e)

Number of OCPUs displayed in the console

105.

Which three statements are true about changing license options in Oracle Autonomous Database?

a)

You can upgrade from an Always Free Autonomous Database account to a paid account any time.

b)

You cannot update the License Included option to BYOL after the Database has been created

c)

  • You cannot update your BYOL to License Included after the Database has been created.

d)

  • You can update the License Included option to BYOL after the Database has been created.

e)

You can update your Bring Your Own License (BYOL) to License Included after the Database has been created.

106.

Which statement is FALSE about Oracle Text?

a)

It uses standard SQL queries

b)

It requires an Oracle Text license for Autonomous Database.

c)

  • It is suited to search document collections.

d)

It provides indexing, word and theme searches.

107.

Which four resources need to be provisioned by the fleet administrator and the database administrator before a developer can connect to an Autonomous Database on Dedicated Infrastructure as a database user?

a)

Oracle Database licenses

b)

Autonomous Database instance

c)

Identity and Access Management (IAM) policy rules that allow access to the database

d)

  • Autonomous Container Database

e)

Virtual Cloud Network and Subnet

108.

Which two security features are enabled by default by the Autonomous Database?

a)

Encrypted Database Links

b)

One SYSDBA account

c)

Transparent Data Encryption (TDE)

d)

SQL* Net Encryption

e)

Read-only access to OS

109.

Which option is not available to access data in an Autonomous JSON Database?

a)

  • Regular Oracle SQL statements using a connection string to the database.

b)

  • NoSQL statements using Simple Oracle Document Access (SODA) drivers

c)

Oracle Cloud Infrastructure console using the JSON Developer tool.

d)

  • REST API calls to the database.

110.

With regard to Autonomous JSON Database, which statement are TRUE?
Select TWO correct answer.

a)

There is no storage limit for JSON collections

b)

  1. Autonomous JSON Database service can be promoted to an Autonomous Data Warehouse service

c)

  1. JSON Database don’t have any schema

d)

  1. There is a storage limit of 20GB for data including JSON document collections

111.

If you need to connect to Autonomous Data Warehouse (ADW) using Java Database Connectivity (JDBC) via an HTTP proxy, where do you set the proxy details?

a)

tnsnames.ora

b)

keystore.jks

c)

sqlnet.ora

d)

cwallet.sso

e)

ojdbc.properties

112.

A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB Instance for a switch back.

Which statement about the migration using Golden Gate is correct?

a)

  • Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB.

b)

  • Only the migration to ADB is possible from an on-premise installation of Golden Gate.

  • C. Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this.

c)

Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this.

d)

The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB.

e)

The described scenario is correct, can be used for migration and fallback scenarios.

113.

Which statement is true in regards to database links?

a)

You can call PL/SQL procedures and functions using a database link.

b)

Connect from Autonomous Database to remote database using a database link.

c)

Connect to Autonomous Database from remote database using a database link.

d)

Create a database link from one Autonomous Database to another Autonomous Database instance.

114.

Which three statements are true regarding how Autonomous Database provides data security?

(Choose three.)

a)

Data is encrypted at rest using transparent data encryption.

b)

Network connections from clients to Autonomous Database are encrypted using the client credentials wallet.

c)

Users are given OS logons or SYSDBA privileges to prevent phishing attacking.

d)

Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors.

115.

What two tasks can be executed from the service console for Autonomous Databases?

a)

Autonomous Databases monitoring for usage and query performance.

b)

Creating schemas.

c)

Creating and scaling of Autonomous Database service.

d)

Wizard to download connection wallet for connection from desktop tools.

116.

Which two PL/SQL functions can be used to validate an analytic view?

a)

VALIDATE_LEVELS

b)

VALIDATE_HIERARCHY

c)

VALIDATE_DIMENSION

d)

VALIDATE_ANALYTIC_VIEW

e)

VALIDATE_MEASURES

117.

What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.)

a)

Golden Gate

b)

Recovery Manager (RMAN)

c)

CSV files copied to Autonomous Database block storage

d)

Data Pump

118.

Which is the correct subset of services offered via OCI-CLI (command line interface) for Autonomous Database (ABD) via calls made to the OCI API's?

a)

Create, Query, Update, List, Start

b)

Create, Get, List, Stop, Restore

c)

Start, Delete, Update, Query, Stop

d)

Create, Query, List, Stop, Restore

119.

Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location, running datapump export and running a datapump import.

Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading? (Choose three.)

a)

SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps.

b)

SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage.

c)

SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running.

d)

SQL Developer can only export/move/import files using datapump from databases running on Linux systems.

120.

Which statement about the Export Wizard used to export database objects and data is NOT correct?

a)

If "Dependents" is checked as a DDL Option, for non-privileged users, only dependent objects in their schema are exported.

b)

Export DDL includes features such as "Show schema," "Storage," and "Terminator."

c)

If "Grants" is checked as a DDL Option, GRANT statements are included for any grant objects on the exported objects, including those owned by the SYS schema.

d)

If "Clipboard" is selected as the "Output," the output will be placed on the system clipboard, so that it can be pasted into a file, a command line, or other location appropriate for the format.

121.

Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

a)

Replicate the table using Golden Gate

b)

Create a Data Set

c)

Load data using Data Pump

d)

Import Table

122.

Which 3 data dictionary views contain information about analytic view objects?

a)

ALL_ANALYTIC_VIEW_PATHS

b)

ALL_ANALYTIC_VIEW_DIM_CLASS

c)

ALL_ANALYTIC_VIEW_ID_ATTRS

d)

ALL_ANALYTIC_VIEW_LVLGRPS

e)

ALL_ANALYTIC_VIEW_KEYS

123.

Oracle ADB runs/build on which hardware?

a)

System Engineer Build Server

b)

Virtual Machine (VM)

c)

Bare Metal (BM)

d)

Both services ignore hints by default

e)

Oracle Exadata Database Machine

124.

You must implement a backup solution for your Autonomous Data Warehouse (ADW) that will enable you to restore data as old as one year with a recovery point objective (RPO) of 10 days. Which database backup strategy would you select?

a)

Take monthly manual backups to supplement the automated backups and preserve them for 12 months.

b)

Take weekly manual backups to supplement the automated backups and preserve them for 12 months.

c)

Take quarterly manual backups to supplement the automated backups and preserve them for 12 months.

d)

Use the automated backups

125.

You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX. What statement describes the step to provide the developer a new workspace in APEX?

a)

Access the APEX Administration Services and create the workspace for the developer.

b)

Create a new developer account.

c)

Create an IDCS user with the APEX role.

d)

Create a database user with the APEX role.

126.

Which statement is true regarding Autonomous Transaction Processing (ATP)?

a)

A database name cannot be used concurrently for both an Autonomous Data Warehouse (ADW) and an ATP database

b)

After terminating a database, the database name is available for immediate reuse

c)

A maximum of 8 cores can be enabled for an ATP database

d)

A maximum of 2 TB of storage can be enabled for an ATP database

127.

Which two statements are correct with respect to the Private Cloud setup in the Autonomous Database Dedicated deployment?

a)

OCI Compartments are assigned to IT and end-users based on the organizational structure.

b)

You need to create private networking overlay for the organizational structure.

c)

It is not necessary to create compartments.

d)

Half hack does not offer various shapes to choose from.

128.

Which two valid ADB connectivity methods are used from a third-party software?

a)

.NET uses public internet only

b)

ODBC uses SSL with public internet

c)

SQL *Net uses SSL for encryption

d)

JDBC uses FastConnect only

129.

Which two can be used for troubleshooting the data load operation in the Autonomous Database?

a)

Log and bad files accessible as tables.

b)

Log files only accessible as tables.

c)

Load operations logged in *_load_operations dictionary.

d)

Load operations logged in file system.

e)

Log files accessible from file system.

130.

Which three selections are required for provisioning an Autonomous Database Service after login to the OCI Console?

a)

Compartment

b)

Object Storage

c)

Tenant

d)

Availability Domain

e)

Workload type

131.

Which three considerations are necessary for migrating to the Autonomous Database?

a)

Does the method support third-party database?

b)

What is the output file format?

c)

Does the method support using Oracle and/or third-party Object Storage?

d)

How large is the dataset to be imported?

e)

How small is the dataset to be exported?

132.

Which three statements are true about the Autonomous Database OCI Integration?

a)

Backups can be accessed like any other file on object store.

b)

Autonomous Database is hosted in the availability domain.

c)

It offers unlimited access to the Autonomous Database for all OCI resources.

d)

Its components include Oracle Machine Learning.

e)

It allows connectivity to object storas such as Amazon S3.

133.

Which two features differentiate the Dedicated from the Shared Infrastructure Deploymenty options?

a)

Backup retention configuration

b)

Controllable software update version

c)

VCN and private IP connect

d)

 Availability domain placement choice

134.

Which statement is correct about managing and monitoring of Autonomous Database? (Choose the best answer.)

a)

You can use Service console to enable or disable auto scaling of Autonomous DB.

b)

You can use Service console to manage runaway SQL statements on Autonomous DB.

c)

You can use Service console to move Autonomous DB between compartments.

d)

You can use Service console to create manual backups of Autonomous database.

135.

Your company is developing a new database application in Oracle Cloud Infrastructure. You need to test application functionality including a hardware failure scenario. Since the application is still in the development phase, you want to minimize infrastructure costs. Which database service deployment option meets this requirement?

a)

two node real application cluster (RAC) system

b)

Autonomous Data Warehouse (ADW) system as it provides auto fail over functionality

c)

two node bare metal system with data guard enabled

d)

single node bare metal system

136.

You have provisioned an Autonomous Data Warehouse (ADW) database with 16 enabled OCPUs and need to configure the consumer group for your application. Which two are true when deciding the number of sessions for each application? (Choose two.)

a)

 The MEDIUM and LOW consumer group can run up to 16 concurrent SQL statements if HIGH consumer group has 0 SQL statements

b)

The HIGH consumer group can run up to 16 concurrent SQL statements as long as MEDIUM and LOW consumer groups have 0 SQL statements

c)

The MEDIUM consumer group can run 20 concurrent SQL statements when HIGH consumer group has 0 SQL statements

d)

The HIGH consumer group can run up to 16 concurrent SQL statements in addition to 32 concurrent SQL statements in MEDIUM and LOW consumer group each

e)

The HIGH consumer group can run 3 concurrent SQL statements when MEDIUM consumer group has 0 SQL statements

137.

You have just created an Autonomous Data Warehouse (ADW) and you want to connect to the ADW using SQL Developer. What three items are needed to connect to the ADW using SQL Developer? (Choose three.)

a)

the keystore passworda

b)

a security list with an ingress rule for TCP port 1521

c)

 the client credentials file

d)

the public IP address of the ADW server

e)

the admin password

138.

According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups. Which statement is true?

a)

Create a separate VCN that contains only public subnets

b)

Only 1 of each is allowed to be allocated per environment.

c)

Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.

d)

Create at least 2 of each resource

139.

Where do you find the tnsnames.ora for your Autonomous Data Warehouse (ADW) database?

a)

You can download tnsnames.ora from Oracle Cloud Infrastructure web console under ADW details page

b)

The tnsnames.ora file is included in credentials.zip file that you download from service console of ADW

c)

The ADW database will place the tnsnames.ora file in an object storage bucket

d)

You are automatically prompted to download the tnsnames.ora file upon creation of the ADW database

140.

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.

141.

Which two Oracle Cloud Infrastructure database services allow you to dynamically scale both CPU and storage? (Choose two.)

a)

bare metal DB system

b)

virtual machine DB system

c)

Autonomous Data Warehouse (ADW)

d)

Autonomous Transaction Processing (ATP)

142.

Which two choices are true for Autonomous Data Warehouse (ADW)? (Choose two.)

a)

Billing stops only when the ADW is terminated

b)

Billing stops for both CPU usage and storage usage when ADW is stopped

c)

Billing for compute stops when ADW is stopped

d)

Billing for storage continues when ADW is stopped

143.

Which two Security features are enabled by default in the Autonomous Database?

a)

data pump export dump file

b)

cloud backups only

c)

Oracle native network

d)

 transparent data encryption

e)

RMAN backups only

144.

Which statement is true about the Security feature in the Oracle Autonomous Database?

a)

Certificate-based authentication uses an encrypted key store in a wallet on the server.

b)

Database clients can connect securely using the wallet.

c)

Database clients can connect securely using TLS/wallet.

d)

Some connections use certificate-based suthentication and SSL.

145.

Which three can be accessed via the Service Console of the Autonomous Database?

a)

database restore

b)

 scaling CPU

c)

disable transparent data encryption

d)

enable database security

e)

manage Oracle ML

146.

Which three benefits are offered by the Self-Securing capability of the Autonomous Database?

a)

Sensitive data protection from privileged users.

b)

Automatic application of security updates offline.

c)

Automatic application of security updates online.

d)

Protection from external and malicious internal threats.

e)

Secure configuration with full database encryption.

147.

Which migration approach is not supported for Autonomous Database (ADB)?

a)

Golden Gate Cloud service

b)

Golden Gate on-premise installation

c)

RMAN Cross-Platform backup and restore

d)

 SQL developer migration workbench

e)

Datapump export / import

148.

What are the utilities that can be used for loading data into Autonomous Database?

Select TWO correct answer.

a)

  1. Oracle GoldenPump

b)

  1. SQL workbench

c)

  1. Oracle Appliication Express (APEX)

d)

  1. DBMS_CLOUD Package

149.

Which is not a valid resource in the Autonomous Database Dedicated Deployment?

a)

autonomous container infrastructure

b)

autonomous database

c)

autonomous container database

d)

autonomous exadata infrastructure

150.

Which three tools are bundled with the Autonomous Database?

a)

SQL developer web

b)

OCI console

c)

enterprise manager cloud control

d)

enterprise manager grid control

e)

SQL developer

151.

Which statement is true about effectively protecting customer data in the Oracle Autonomouse Database?

a)

It automatically identifies sensitive data and masks it for use in development environments only.

b)

Customers can identify sensitive data and mask it for use in priduction environments only.

c)

Customers can identity sensitive data and mask it for use in partner or development environments.

d)

It automatically identifies sensitive data and masks it for use in production environments only.

152.

Which three are required to connect to the Autonomous Database instance from the SQL Developer?

a)

Oracle cloud username and password

b)

wallet file

c)

database service name

d)

Oracle cloud service name

e)

database username and password

153.

Which metric shows the number of running SQL Statements during the selected interval in the Autonomous Database?

a)

top SQL statements

b)

running SQL statements

c)

queued statements

d)

current SQL statements

e)

SQL statements

154.

Which two statements are correct about Autonomous Database Backups?

a)

The retention period for backups is 30 days.

b)

Manual backups are placed in ASM.

c)

Manual backups are placed in the Cloud Object Storage bucket.

d)

The Autonomous Database automatically performs recovery of point-in-time specified.

e)

Point-in-time recovery cannot be initiated using the Cloud console manually.

155.

Which Oracle spatial native datatype is used for vector data in Object-Relational Model

a)

  1. SDO_POSITION

b)

  1. SDO_WITHIN_DISTANCE

c)

  1. SDO_GEOMETRY

d)

  1. SDO_DESTINATION

156.

What should the name of the bucket that will store manual backups for autonomous database named CLOUDGURUAMIT with display name as DEVDBD?

a)

  1. backup_cloudguruamit

b)

  1. BACKUP_CLOUDGURU

c)

backup_devdb

d)

  1. BACKUP_DEVDB

157.

Which TWO are correct IAM access policies for autonomous database?

a)

Use

b)

Alter

c)

Create

d)

Read

158.

Under Performance Hub in SQL Monitoring tab if you see a red cross in the status column, what does this mean?

a)

  1. SQL query is still executing

b)

  1. SQL query is queued

c)

  1. SQL query did not complete either due to an error or due to the session getting terminated

d)

  1. SQL query is successfully executed

159.

Under Performance Hub in SQL Monitoring tab if you see a spinning icon in the status column, what does this mean?

a)

  1. SQL query is still executing

b)

  1. SQL query is queued

c)

  1. SQL query did not complete either due to an error or due to the session getting terminated

d)

  1. SQL query is successfully executed

160.

Under Performance Hub in SQL Monitoring tab if you see a clock icon in the status column, what does this mean?

a)

SQL query is still executing

b)

  1. SQL query is queued

c)

  1. SQL query did not complete either due to an error or due to the session getting terminated

d)

SQL query is successfully executed

161.

What are the significance of Graph & Graph Database when deploying in real world model?

Select THREE correct answers.

a)

  1. Product recommendations

b)

  1. Clustering of the vertices

c)

Face ID in mobile phones

d)

Pattern Recognition

162.

With regard to Autonomous JSON Database, which statements are CORRECT?

Select two correct answer

a)

  1. JSON Database supports applications of all programming language

b)

JSON Database is a document database service

c)

  1. JSON Database supports only Node.js and Java

d)

  1. JSON Database supports Open-Source NoSQL-style document APIs

163.

Which Oracle Package supports for working with data in Object Storage starting with Oracle Database 19c and later releases?

a)

  1. DBMS_CUBE

b)

  1. DBMS_HADOOP

c)

  1. DBMS_CLOUD

d)

DBMS_DATAPUMP

164.

How is data stored in an Oracle Autonomous Data Warehouse database?

a)

  1. Row Format

b)

  1. Slowly Changing Dimention (SCD)

c)

  1. Infrastructure As a Code

d)

  1. Column Format

165.

A data driven company needs a tool which can help get information about the entities in the Oracle Autonomous Database and to see the effect that changing an object has on other object.

Which data tool should the company use?

a)

Data Transform

b)

  1. Data Load

c)

  1. Data Catalog

d)

  1. Data Pump

166.

A data driven company needs a tool which can help "drag -and-drop" based on ELT tool Oracle Data Integrator.

Which data tool should the company use?

a)

  1. Data Transform

b)

  1. Data Load

c)

  1. Data Catalog

d)

Data Pump

167.

Which role provides the common privileges for a data scientist or database developer to perform real-time analytics?

a)

DUSERROLE

b)

  1. DWROLE

c)

DBROLE

d)

  1. ADMINROLE

168.

Which metrics are NOT used up while autoscaling an Autonomous Database instance?

Select TWO correct answer.

a)

OCPU

b)

Parallelism

c)

Storage

d)

  1. Concurrency

169.

Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database.

Which statement is true regarding the default configuration of the Autonomous Data Warehouse?

a)

In Autonomous Data Warehouse direct access to the database node and the local file system is allowed.

b)

Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to.

c)

Adding, removing, or modifying tablespaces is allowed.

d)

Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.