[Jun 19, 2022] Updates Up to 365 days On Valid 1Z0-931-21 Braindumps [Q42-Q65]

NEW QUESTION 42
Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE?

Oracle Data Safe only supports Autonomous Databases.

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

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

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

NEW QUESTION 43
Which two options are available to restore an Oracle Autonomous Database?

Select the backup from which restore needs to be done.

Specify the point in time (timestamp) to restore.

Select the snapshot of the backup.

Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.

Specify the archived custom image.

NEW QUESTION 44
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;

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

It cannot be done.

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

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

Connecting to the Cloud Infrastructure Command console via SSH wallet.

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

User’s OCID

Tenancy’s OCID

Database ADMIN password

Fingerprint of the public key

NEW QUESTION 47
Which option is not available to pick ( no.of days ) when configuring the backup retention for Oracle Container Database.

120

60

15

7

NEW QUESTION 48
A Business Analyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst.
When restoring/cloning the ADB, you must select a backup which is atleast___ hours/minutes old.

24 hrs

2 hrs

5 min

1 day

NEW QUESTION 49
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?

Undo Management

Index Storage

Memory Usage

Data Organization

Backup Retention

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

Data Pump Export File

Avro

Parquet

Text

JSON

Microsoft SQL Server (.mdf)

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

On the Autonomous Database Console.

SSH keys are not required in Oracle Cloud Infrastructure.

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

Navigate to Identity, select Users panel on the console and select “Add Public Key”.

NEW QUESTION 52
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

Users have OS access to the database machine.

Users can customize the maintenance schedule.

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

Users have SYS privileges in the database.

Users can customize the OS stack and add additional packages

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

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

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

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

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

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

NEW QUESTION 54
Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE?

Oracle Data Safe only supports Autonomous Databases.

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

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

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

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

SQLDEV_ADMIN.GRANT_SCHEMA

ORDS_ADMIN.ENABLE_SCHEMA

ORDS_ADMIN.GRANT_SCHEMA

ORDS_PRIV.ENABLE_SCHEMA

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

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

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

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

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

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

NEW QUESTION 57
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.

The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.

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

The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.

The target table will be created in Autonomous Database if it does not already exist.

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

When you restore a database, the existing ACLs are not overwritten by the restore.

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

ACLs can only be used with private endpoints.

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

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

Oracle GoldenGate

Transportable Tablespace

RMAN Restore

Oracle Data Pump

SQL*Loader

NEW QUESTION 60
Which stage of the indexing pipeline divides text into tokens?

SECTIONER

FILTER

Otokenizer

LEXER

NEW QUESTION 61
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.

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

2 hours

30 minutes

1 hours

24 hours

NEW QUESTION 63
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

NEW QUESTION 64
Which two methods can you use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure

service console

SQL Developer

the DBMS_CLOUD_ADMIN package

SQL *Plus

NEW QUESTION 65
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?

Current settings for ACLs are cloned.

Clone can be in a different region.

All OML notebooks are cloned.

All underlying data for OML notebooks is cloned.

All resource management rules are cloned.

Leave a Reply Cancel reply