[Q47-Q65] Updated Oct-2023 Test Engine to Practice Test for 1z0-931-23 Exam Questions and Answers!

October 30, 2023 1z0-931-23, Oracle 0 Comments

[Q47-Q65] Updated Oct-2023 Test Engine to Practice Test for 1z0-931-23 Exam Questions and Answers!

Rate this post

Updated Oct-2023 Test Engine to Practice Test for 1z0-931-23 Exam Questions and Answers!

Oracle Autonomous Database Cloud 2023 Specialist Certification Sample Questions and Practice Exam

QUESTION 47
Which can be Scaled Independently of the number of CPUs In an Autonomous Database?

Parallelism

Storage

Concurency

Memory

Sessions

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846 Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:

QUESTION 48
Autonomous Database’s auto scaling feature allows your database to use up to three times the current base number of CPU 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?

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.

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

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.

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

QUESTION 49
When an administrator rotates the instance wallet for an Autonomous Database on Shared Infrastructure, what happens to the regional wallets used with that instance?

They continue to work

They revert to pending

They are also rotated

They become invalid

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

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbah/index.html#articletitle
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/index.html

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

RPO is adjustable, but RTO I always 5 minutes

RTO and RPO are adjustable through the OCI console

RTO and RPO are 0 minutes for manual failovers

RTO is 2 minutes for an automatic failover

RPO is 0 minutes for an automatic failover

QUESTION 52
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

As an alternative, the ADMIN can provide Web Access for a user, REST enable a user, with SQL commands. As the ADMIN user run the following code:
BEGIN
ORDS_ADMIN.ENABLE_SCHEMA(
.
.
);
COMMIT;
END;
/
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/sql-developer-web.html#GUID-4B404CE3-C832-4089-B37A-ADE1036C7EEA

QUESTION 53
Which are the two restrictions for an Always Free Autonomous Database?

supports only ATP as a workload type

maximum of two Always Free Databases per OCI tenancy

Oracle Application Express (APEX) not included

maximum of one OCPU per Database

QUESTION 54
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.

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-sql-statements.html#GUID-4861BA7F-F9FA-4909-8DC0-4F46AFF80706

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

Autonomous Transaction Processing only

ATP and ADW

Autonomous Data Warehouse only

Hybrid Columnar compression

QUESTION 56
What infrastructure does the Autonomous Database run on?

VM on Oracle Cloud Infrastructure

Bare-metal on Oracle Cloud Infrastructure

Exadata on Oracle Cloud Infrastructure

Any Oracle Engineered system

QUESTION 57
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.

QUESTION 58
Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to also see how changing an object affects other objects?

Data Insights

JSON

Catalog

Data Load

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

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

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

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

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

https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbddoverview.htm

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

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

Execute alter user MTHEO quota unlimited on tablespace DATA;

Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username = MTHEO’, V U tablespace_quota -> UNLIMITED’);

Execute alter tablespace DATA det quota = 10G;

QUESTION 61
You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:
* Autonomous Transaction Processing
* License Included
* Shared Infrastructure
Which parameter would you NOT use?

db-workload

is-dedicated

db-type

license-model

https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html

QUESTION 62
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?

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.

You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.

You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.

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.

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

QUESTION 64
Your customer wants to permanently disable scheduled maintenance on the Autonomous Database on Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?

Change the Automatic Maintenance Schedule to “No Preference”

You cannot permanently disable scheduled automatic maintenance

Change the Automatic Maintenance Schedule to “None”

Change the Automatic Maintenance Schedule to “Specify a Schedule,” but do not select any ^ month, week, or day

QUESTION 65
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

Loading …