Friday, December 31, 2021

Oracle Autonomous Database Cloud 2021 Specialist dumps

 

Oracle Autonomous Database Cloud 2021 Specialist dumps

Which two methods can you use to create users and grant roles in Autonomous Database?

A.      using DBMS_CLOUD_ADMIN package X

B.      through the Oracle Cloud Infrastructure service console

C.      through SQL/Developers

D.      through SQL*Plus

Answer

C,D

When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection?

A.      DBNAME_MEDIUM

B.      DBNAME_HIGH

C.      DBNAME_CONCURRENT

D.      DBNAME_LOW

Answer

D

Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

A.      SSH keys are not required in Oracle Cloud Infrastructure

B.      SSH keys cannot be added from console. They have to be added using REST APIs only.

C.      On the Autonomous Database Console.

D.      Navigate to Identity, select Users panel on the console and select "Add Public Key"

Answer

D

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

A.      Security List

B.      Route Table

C.      Subnet

D.      VCN

E.       Network Security Group

Answer

C,D,E

Q5. Which three event types are supported for Autonomous Database? (Choose three.)

A.      Update IORM Begin

B.      Maintenance Begin

C.      Terminate End

D.      Change Autoscaling Configuration Compartment

E.       Change Compartment Begin

Answer

B,C,E

When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column, What does this mean?

A.      The SQL statement is executing

B.      The SQL statement did not complete either due to an error

C.      The SQL statement is queued

D.      The SQL statement completed its execution

Answer

C

Which three are use cases for Graph Studio? (Choose three.)

A.      3-D modelling

B.      Churn analysis

C.      Pattern matching

D.      Facial recognition

E.       Clustering

Answer

A,C,E

When enabling auto-scaling, which two options change? (Choose two.)

A.      Number of OCPUs displayed in the console

B.      Amount of storage

C.      Parallelism settings

D.      I/O resources

E.       Level of concurrency

Answer

A,D

Which can be Scaled independently of the number of CPUs in an Autonomous Database?

A.      Sessions

B.      Storage

C.      Parallelism

D.      Concurency

Answer

B

What happened with the standby database when disabling Autonomous Data Guard?

A.      The standby database is started readwrite

B.      The standby database is transformed in a refreshable clone

C.      The standby database is terminated

D.      The standby database is started read only

Answer

C

You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.

The load on the database increases from three OCPUs to nine OCPUs.

What is the total number of concurrent statements that the TPURGENT service can support?

A.      2700

B.      1500

C.      900

D.      1800

Answer

A

Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance ?

A.      HIGH

B.      MEDIUM

C.      TPPERFORMANT

D.      TPURGENT

Answer

C

Which statement is FALSE about Oracle Autonomous JSON Database?

A.      JSON data is stored natively in the database

B.      You can promote Autonomous JSON Database to Autonomous Transaction Processing

C.      It supports NoSQL-style, document-centric application

D.      There is a 20 GB limit on JSON collection

Answer

D

Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?

A.      Avro X

B.      Parquet

C.      JSON

D.      Microsoft SQL Server (.mdf)

Answer

D

Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?

A.      Oracle Cloud Infrastructure Object Storage

B.      Google Cloud Storage

C.      Amazon S3

D.      Oracle Cloud Infrastructure Object Storage Classic

Answer

B

In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?

A.      Oracle Machine Learning notebook

B.      Compartment quotas

C.      SQL Developer Web Console

D.      Resource Manager settings

Answer

B

Which statement is not correct when the Autonomous Database is stopped?

A.      In-flight transactions queries are stopped

B.      Tools are no longer able to connect to a stopped instance

C.      User with DWROLE can still access the database

D.      CPU billing is halted

Answer

C

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

A.      Create at least 2 of each resource

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

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

D.      Create a Separate VCN that contains only public subnets

Answer

A

How do you change the tablespace quota for a user MTHEO on Autonomous Database on Shared Infrastructure?

A.      Execute alter tablespace DATA set quota = 10G

B.      Execute alter tablespace for user ADBUSER tablespace DATA quota = 10G

C.      Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE QUOTA (username => ‘MTHEO’ ,tablespace_quota => UNLIMITED)

D.      Execute alter user ADBUSER quota unlimited on tablespace DATA

Answer

C

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

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

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

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

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

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

Answer

D

Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

A.      Select the snapshot of the backup

B.      Select the backup from which restore needs to be done

C.      Backup and recovery must be done using Recovery Manager (RMAN)

D.      Select the archived redo logs

E.       Specify the point in time (timestamp) to restore

Answer

B,E

Which statement is correct about the Service console in an Autonomous Database?

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.

Answer

B

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

A.      Autonomous Transaction Processing

B.      Autonomous Data Warehouse

C.      Neither service ignores hints by default

D.      Both services ignore hints by default

Answer

B

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? (Choose two.)

A.      Create a new developer account

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

C.      Create a database user with the APEX role

D.      Create an IDCS user with the APEX role

Answer

B

Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?

A.      OS command line from the database server

B.      OCI CLI

C.      Admin page of the Cloud Service Console

D.      SQLDeveloper

Answer

A

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

A.      Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations

B.      Autonomous Data Warehouse workloads are optimized for mixed workloads

C.      Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake

D.      Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar

 

Answer

D

What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure? (Choose two.)

A.      Users have OS access to the database machine

B.      It offers greater control and isolation starting at the Exadata cloud infrastructure level

C.      Users can customize the OS stack and add additional packages

D.      Users have SYS privileges in the database

E.       Users have more control over the maintenance schedule

 

Answer

B,E

Which Database Actions tool is used to get information about the entries on your Oracle Autonomous Database and to see the effect that changing an object has on other objects?

A.      Data Load

B.      Catalog

C.      JSON

D.      Data Insight

Answer

B

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 an IDCS user. Create a database user with connect, resource, and object privileges

B.      Create a database user with the default privileges

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

D.      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

Answer

D

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 Databases

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

Answer

C

Which three are Oracle-recommended best practices for Autonomous Database alarms? (Choose three)

A.      Select the correct alarm interval for your metric

B.      Create multiple alarm metrics

C.      Routinely tune your alarms

D.      Suppress alarms during investigations

E.       Create a single alarm for each metric

F.       Use a single interval for all alarms

Answer

A,C,D

Which statement is true when you provision an Autonomous Database using the cloning method?

A.      A clone database source can be a running database instance

B.      A clone database source can be from a point-in-time backup that is less than 2 hours old

C.      There is only one type of cloning option available in Autonomous Database

D.      You can clone a database in a security zone to create a database that isn't in a security zone

Answer

A

Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated?

A.      Week of the Quarter, Day of the Week, Start Hour

B.      Month of the Year, Week of the Month, Day of the Week, Start Hour

C.      Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour

D.      Month of the Quarter, Week of the Month, Day of the Week, Start Hour

Answer

D

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.      Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending

C.      Compartment quotas are set by Oracle

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

Answer

C

You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance.

Which tool would you use to automate data exploration and create pivot tables?

A.      Business Models

B.      Data Load

C.      SQL Developer Web

D.      APEX

Answer

A

An Autonomous Database (ADB) user with an instance wallet has left the company and shared database user id with other users when accessing ADB. Other than changing the shared user password, what can the admin do to protect the instance?

A.      Delete the user

B.      Rotate the instance wallet and share the new wallet with the remaining users

C.      Shutdown and restart the instance

D.      Trust the user who left, not to access the database

Answer

B

When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?

A.      2 hours

B.      30 minutes

C.      1 hours

D.      24 HOURS

Answer

A

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

A.      Autonomous Data Warehouse only

B.      Hybrid Columnar compression

C.      Autonomous Transaction Processing only

D.      ATP and ADW

Answer

D

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

A.      A graph license key

B.      Tables in an Autonomous Database instance

C.      NoSQL configuration

D.      Graph analytics algorithms

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

Answer

B

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure? (Choose two.)

A.      You have direct access to the database node

B.      Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.

C.      Oracle Database Result Cache is enabled by default for all SQL statements

D.      Parallelism is not enabled by default

Answer

B,C

While creating a business model what advanced options you can enable or disable? (Choose three)

A.      Business Object Security Feature

B.      Analytic View Transparency View

C.      Autonomous Aggregate Cache

D.      Display private tables

E.       Analytic View Base Table Query Transformation

Answer

B,C,E

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.GRANT_SCHEMA

B.      ORDS_ADMIN.ENABLE_SCHEMA

C.      SQLDEV_ADMIN.GRANT_SCHEMA

D.      ORDS PRIV.ENABLE_SCHEMA

Answer

B

You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?

A.      Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database

B.      Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"

C.      Create a notification alert using DBMS_SNMP package

D.      Create an Oracle Cloud Infrastructure Alarm for Shutdown metric

Answer

B

What are three methods to load data into the Autonomous Database? (Choose three.)

A.      Oracle GoldenGate

B.      Oracle Data Pump

C.      RMAN Restore

D.      Transportable Tablespace

E.       SQL Loader

Answer

A,B,E

Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)

A.      Use SFTP to copy CSV files into Autonomous Database

B.      Use Oracle Zero Downtime Migration (ZDM)

C.      Use Recovery Manager (RMAN)

D.      Use GoldenGate

E.       Use Data Pump

Answer

B,D,E

What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?

A.      alter session set application_continuity=true

B.      alter database set application_continuity=true

C.      exec dbms_cloud_admin.enable_app_cont(" ");

D.      alter system set application_continuity=true

Answer

C

Which statement is FALSE regarding the auto scaling feature?

A.      Auto scaling is enabled by default and can be enabled or disabled at anytime

B.      For databases on dedicated Exadata infrastructure, the maximum: number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance

C.      The base number of OCPU cores allocated to a database is not guaranteed

Answer

C

In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?

A.      Oracle Machine Learning notebook

B.      Compartment quotas

C.      SQL Developer Web Console

D.      Resource Manager settings

Answer

B

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

A.      It cannot be done

B.      Connecting to the Cloud Infrastructure Command console via SSH wallet

C.      Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls

D.      Using Database Configuration Assistant (DBCA) on the database server

Answer

C

Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?

A.      CPU Utilization, Storage Utilization

B.      Transaction Count, Sessions, Running Statements

C.      Query Latency, User Calls, Execute Count

D.      IOPS, Storage Space Used By Tablespace, Apply and Transport Lag

Answer

D

A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data.

How does the developer connect to and interact with ADB from Python?

A.      The Oracle Client and the cx_Oracle interface for Python

B.      You can't use Python with ADB

C.      SQL Developer

D.      JAVA JDK

Answer

A

During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

A.      the Compartment of the Dedicated infrastructure as each compartment only runs one Dedicated environment

B.      the Listener endpoint where the Autonomous Database should register on

C.      the Client Credentials wallet which is used to connect to the Autonomous Database

D.      the container database in which the Autonomous instance should run

Answer

D

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).

How can they achieve this?

A.      Change the Automatic Maintenance Schedule to specify a Schedule but do not select any month, week or day

B.      Change the Automatic Maintenance Schedule to No Preference

C.      You cannot permanently disable scheduled Automatic Maintenance

D.      Change the Automatic Maintenance Schedule to None

Answer

C

Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?

A.      in a separate key vault external to the Exadata Infrastructure

B.      on the Exadata Infrastructure where Autonomous Database Dedicated is hosted

C.      inside the Autonomous Database wallet

D.      inside the backups of the container database

Answer

A

When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

A.      Schemas

B.      Tablespaces

C.      Reports

D.      Data

Answer

A,D

Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?

A.      Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure

B.      Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure

C.      Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database

D.      Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator

Answer

C

What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?

A.      Fleet Administrators are responsible for patching and backups of all container databases

B.      Fleet Administrators create, monitor and manage Autonomous Databases

C.      Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources

D.      Fleet Administrator defines and gains access to the ADMIN administrative user account for the database

Answer

C

Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?

A.      Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure

B.      Moving an Autonomous Database instance does not include its automatic backups

C.      Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non dependent) resources remain in their current compartments

D.      You do not need to have sufficient access permissions on the compartment that the resource is being moved to

Answer

C

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

A.      Under Core Infrastructure then Compute then Autonomous Exadata

B.      Under Database then Autonomous Transaction Processing then Autonomous Exadata

C.      Under Solutions and Platform then Platform Services then Autonomous Exadata

D.      Under Core Infrastructure then Autonomous Exadata

Answer

B

Which two statements are true about Data Insights?

A.      Data Insights is available with on-premises deployments of Oracle Database.

B.      You can search for Data Insights against a base table or business model

C.      Data Insights is an additional priced option

D.      You can retrieve previously executed Data Insights searches

Answer

B,D

Which two methods can you use to create database users and grant roles in Autonomous Database services?

A.      the DBMS CLOUD_ADMIN package

B.      SQL*Plus

C.      SQL Developer

D.      the Oracle Cloud Infrastructure service console

Answer

B,C

Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is Stopped.

Which statement is true?

A.      The standby database is also stopped.

B.      The standby database is terminated.

C.      Switchover is automatically initiated.

D.      Failover is automatically initiated.

Answer

D

Which three advanced options can you enable or disable while creating a business model?

A.      Autonomous Aggregate Cache

B.      Display private tables

C.      Analytic View Transparency Views

D.      Business Object Security Feature

E.       Analytic View Base Table Query Transformation

Answer

A,C,E

Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?

A.      Performance Hub

B.      OCI Metrics

C.      Logs

D.      RMAN

E.       Enterprise Manager Cloud Control

Answer

B,C,D

Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?

A.      Oracle Cloud Infrastructure Object Storage

B.      Amazon 53

C.      Oracle Cloud Infrastructure Object Storage Classic

D.      Google Cloud Storage

E.       Azure Blob Storage

Answer

A,C

Which statement is FALSE about setting up compartment quotas?

A.      You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions.

B.      Quotas set on a parent compartment override quotas set on child compartments.

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

D.      Compartment quotas cannot be set on the root compartment.

Answer

A

Which statement is FALSE about Oracle Data Safe?

A.      It evaluates user types, how users are authenticated, and the password policies assigned to each user.

B.      It supports only Autonomous Databases.

C.      It helps you assess the security of your cloud database configurations by analyzing database configurations.

D.      it helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary.

E.       it helps you evaluate risks to data, assess user security, monitor user activity, and address data security compliance requirements.

Answer

B

Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?

A.      Autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and include container database patching.

B.      Autonomous Exadata infrastructure maintenance takes place at least once each quarter.

C.      If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.

D.      You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.

Answer

B

Which three options are available to access data in an Autonomous JSON Database?

A.      NOSQL statements using Oracle SODA drivers

B.      REST API calls to the database (not enabled by default)

C.      Oracle JSON Developer tool downloaded from OTN

D.      Oracle Cloud infrastructure console using the

E.       JSON Online Developer tool

F.       Regular Oracle SQL statements using a connection through the listener

Answer

A,B,C

A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment.

What should they do to remove this bottleneck?

A.      Ask Support to migrate their setup to a node without noisy neighbors.

B.      Run the DBMS CLOUD. INCREASE THROUGHPUT procedure.

C.      Remove any non-JSON data from the database.

D.      Increase the number of OCPUS allocated to the database.

Answer

B

Which two of the following statements are correct?

A.      All of the capabilities of ODI Classic are available with ODI Web Edition.

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

C.      ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.

D.      ODI Web Edition is available only on Oracle Linux.

Answer

A,C

Which four file formats are supported when loading data from Cloud Storage?

A.      AVRO

B.      DDL

C.      DOC

D.      CSV

E.       Parquet

F.       JSON

 

Answer

A,D,E,F

Which three options do NOT change when enabling auto scaling?

A.      Parallelism settings

B.      Level of concurrency

C.      Amount of storage

D.      I/O resources

E.       Number of OCPUS displayed in the console

Answer

A,B,C

Which stage of the indexing pipeline divides text into tokens?

A.      LEXER

B.      SECTIONER

C.      FILTER

D.      TOKENIZER

Answer

A

In which four ways can Oracle Database optimally access data in Object Storage?

A.      scan avoidance using columnar pruning for columnar stores like parquet and orc

B.      scan avoidance using block skipping when reading parquet and orc files

C.      optimized data archive using hybrid partitioned tables

D.      scan avoidance using partitioned external tables

E.       scan avoidance using columnar pruning for.csv files

F.       optimized data archive using partitioned external tables

Answer

B,C,E

Your customer has upgraded their on-premises 11.2 Database to 12.2. During this migration, the database was migrated to a pluggable database and is now in production.

How should the customer unplug their database to migrate to Autonomous Database (ADB)?

A.      Unplug into an XML file so database files and XML file can be uploaded to object storage.

B.      Unplug into a PDB archive, which can be uploaded to object storage.

C.      Create a database link from the source database to the ADB environment and clone the PDB.

D.      Pluggable databases cannot be migrated to ADB using plug, unplug, or clone.

Answer

C

Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of OCPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.

Which statement is FALSE regarding the auto scaling feature?

A.      The base number of OCPU cores allocated to a database is not guaranteed.

B.      For databases on dedicated Exadata infrastructure. the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands.

C.      Auto scaling is enabled by default and can be enabled or disabled at any time.

D.      For databases on dedicated Exadata infrastructure. The maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.

Answer

A

Which statement is true about connecting a marketplace Oracle Cloud Infrastructure  (OCI) image to an

Autonomous Database on Shared Infrastructure?

A.      The marketplace OCI image can be used with an Always Free Autonomous Database account.

B.      The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.

C.      A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.

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

E.       The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.

Answer

A

A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data.

How does the developer connect to and interact with ADB from Python?

A.      using JDBC Driver

B.      using the Oracle Client and the ox_Oracle interface

C.      using the Oracle Client and the DBD-Oracle interface

D.      using SQL Developer

Answer

B

Which option should you use to create a graph with Graph Studio?

A.      Graph created by a special tool downloaded from oracle.com

B.      A graph license key

C.      Graph analytics algorithms

D.      NOSQL configuration

E.       Tables in an Autonomous Database instance

Answer

E

You need to create a new database by using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) with the following requirements:

   • Autonomous Transaction Processing

  • License Included

  • Shared Infrastructure

Which parameter would you NOT use?

A.      Db-type

B.      Is-defined

C.      Db-worked

D.      License-mode

Answer

A

Which command should you issue to enable application continuity on Oracle Autonomous Database on Shared Infrastructure?

A.      alter system set application_continuity=true

B.      alter database set application_continuity=true

C.      exec dbma_cloud admin.enable app_cont (‘’):

D.      alter session set application_continuity=true

Answer

C

Which two statements are true about using an Oracle Autonomous Database with private endpoints?

A.      An Autonomous Database with private endpoints can be accessed from the public Internet by adding your IP address to an Access Control List.

B.      A Network Security Group is required within your virtual cloud network before you can provision a Shared Autonomous Database to use private endpoints.

C.      Private endpoints can be configured when you clone an Autonomous Database on Shared Infrastructure that was initially created with public endpoints.

D.      You can configure private endpoints for an Always Free Autonomous Database.

Answer

B,C

Which statement is true about the use of Access Control Lists (ACLS) with an Autonomous Database on Shared Infrastructure?

A.      ACLS can only be used with private endpoints.

B.      When you restore a database. The existing ACLS are not overwritten by the restore.

C.      An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time.

D.      An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.

Answer

A

When cloning from a backup, what is the earliest timestamp of the backup allowed?

A.      1 hour

B.      2 hours

C.      24 hours

D.      30 minutes

Answer

B

Which two actions are available to perform when an Autonomous Database is stopped?

A.      Update License Type

B.      Change administrator password

C.      Update Network Access

D.      Start

Answer

A,C

Which is NOT needed to manage Oracle Autonomous Database with REST APIS?

A.      Fingerprint of the public key

B.      User's OCID

C.      Database ADMIN password

D.      Tenancy's OCID

Answer

B

While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?

A.      7 days

B.      60 days

C.      120 days

D.      15 days

Answer

C

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

A.      Files in Oracle Cloud Storage

B.      Backup files in block storage

C.      REST endpoints

D.      Local Files

E.       Files in AWS S3 Storage

Answer

A,D,E

Which two statements are true about accessing Autonomous Database Tools?

A.      Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpoint networking.

B.      Access to Database Actions is available for all users of Autonomous Database.

C.      SQL Developer Web is available exclusively on the Autonomous Database.

D.      Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.

E.       Oracle APEX can be accessed only from the Developer menu in the Service Console.

 

Answer

A,E

Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?

A.      Only ADW supports autoscaling

B.      Only ADW uses columnar compression by default.

C.      Only ATP supports automatic backups.

D.      Only ATP manages optimizer statistics.

Answer

B

You see a clock icon in the Status column on the SQL Monitoring tab of the Performance Hub.

What does it indicate?

A.      The SQL statement is queued.

B.      The SQL statement completed its execution.

C.      The SQL statement is executing

D.      The SQL statement did not complete due to an error.

Answer

A

You have a requirement to create an Autonomous Transaction Processing database that can support up to 300 concurrent statements per OCPU as well as parallelism.

Which service will you need to connect to?

A.      LOW

B.      TP

C.      TPURGENT

D.      MEDIUM

Answer

C

Which native data type is used to store spatial information?

A.      SDO_LOCATION

B.      GEO_JSON

C.      SDO_GEOMETRY

D.      SDO_RELATE

Answer

C

Which two license types does a customer need to benefit from Bring Your Own License (BYOL) when leveraging on- premises Enterprise Database licenses in Oracle Autonomous Database?

A.      Exadata

B.      Multitenant

C.      Active Data Guard

D.      Real Application Clusters (RAC). but only when scaling beyond 16 OCPUS

E.       Transparent Data Encryption (TDE)

Answer

B,D

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 Autonomous Database's Data Tools.

Which steps do you need to perform?

A.      Create a REST-enabled database user (with connect and object privileges) and grant the DWROLE role.

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

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

D.      Create a database user with the default privileges.

Answer

C



I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim
E-mail : s.m.sahal789@gmail.com
Thank you.

0 comments:

Post a Comment

If you have any doubts, please let me know. I will help you.