(2023) 1Z0-931-22 Exam Dumps, Practice Test Questions BUNDLE PACK [Q42-Q64] : IT Certification Exam Braindumps : http://blog.braindumpsit.com

NO.42 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?

SQL Developer

JAVA JDK

You can’t use Python with ADB.

The Oracle Client and the cx_Oracle interface for Python

NO.43 Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

Parallelism is not enabled by default.

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

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

You have direct access to the database node.

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

Oracle Cloud Infrastructure Object Storage Classic

Oracle Cloud Infrastructure Object Storage

Google Cloud Storage

Amazon S3

Azure Blob Storage

NO.45 Which can be Scaled Independently of the number of CPUs In an Autonomous Database?

Parallelism

Storage

Concurency

Memory

Sessions

NO.46 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?

900

1800

2700

1500

NO.47 Your customer has upgraded their on premise 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)?

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

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

Unplug to an xml file so database files and xml file can be uploaded to object storage.

Unplug into a pdb archive which can be uploaded to object storage.

NO.48 Which native data type is used to store spatial information?

SDO_RELATE

SDO_GEOMETRY

SDO_LOCATION

GEO_JSON

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

DOC

AVRO

JSON

DDL

Dcsv

Parquet

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

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

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

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

Fleet Administrators create, monitor and manage Autonomous Databases.

NO.51 Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?

Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.

You can use the dbms_auto_index package to report on the automatic task and to set your preferences.

It is enabled by default.

You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.

The indexing feature is implemented as an automatic task that runs at a fixed interval.

NO.52 Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

through the Oracle Cloud Infrastructure service console

through SQL/Developer s

using DBMS_CLOUD_ADMIN package

through SQLPIus

NO.53 For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘DW’

Allow group ADB-Admins to manage autonomous-database in tenancy.

Allow group ADB-Admins to manage autonomous-database-family in tenancy.

Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘OLTP’

NO.54 Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints

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

Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.

You can configure Private Endpoints for an Always Free Autonomous Database

NO.55 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?

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.

Create a database user with the default privileges.

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

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

NO.56 Which statement is NOT correct when setting up compartment quotas?

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

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

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

Compartment quotas are set by Oracle.

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

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

ADB must be configured with NSG

ADB must be configured with Private endpoints

Cannot connect OCI Market image to shared ADB

NO.58 When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)

DBNAME_MEDIUM

DBNAME_HIGH

DBNAME_CONCURRENT

DBNAME_LOW

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

Scan partition tables

scan hybrid partition tables

prun column in parquet files

prun columns in csv files

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

Oracle Cloud Infrastructure Object Storage

Google Cloud Storage

Amazon S3

Oracle Cloud Infrastructure Object Storage Classic

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

Files in Oracle Cloud Storage

Backup files in block storage

Local Files

Files in AWS S3 Storage

REST endpoints

NO.62 Which statement is correct about managing and monitoring of Autonomous Database?

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

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

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

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

NO.63 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?

Release Update (RU)

Prior Release Update Revision (PRUR)

Prior Release Update (PRU)

Quarterly Bundle Patch (QBP)

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

Execute alter database for user MTHEO tablespace DATA quota = 10G;

Execute alter user MTHEO quota unlimited on tablespace DATA;

Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => ‘MTHEO’ , tablespace__quota => “UNLIMITED*);

Execute alter tablespace DATA set quota = 10G;