1Z0-931-24問題集、Oracle実際の試験問題

質問 1

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

A. CREATE ANALYTIC VIEW

B. CREATE ANALYTIC MEASURE

C. CREATE ATTRIBUTE DIMENSION

D. CREATE ANALYTIC LEVEL

E. CREATE ANALYTIC HIERARCHY

正解: A,C

解説: (PassTest メンバーにのみ表示されます)

質問 2

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 only be set during the creation of an Autonomous Database on Shared Infrastructure.

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

正解: B

質問 3

What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)

A. Data Pump is faster to migrate database than using RMAN.

B. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.

C. Data Pump creates the tablespaces used by your Autonomous Database.

D. Data Pump is platform independent - it can migrate Oracle Databases running on any platform.

正解: B,D

解説: (PassTest メンバーにのみ表示されます)

質問 4

When exporting a notebook, what type of file is created?

A. ASCII

B. XML

C. TXT

D. JSON

E. SQL

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 5

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

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

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

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

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

正解: B

質問 6

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

A. 30 days

B. One Year

C. 7 days

D. 90 days

E. 60 days

正解: E

質問 7

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
* Licence Tracluded
* Shared Infrastructure
Which parameter would you NOT use?

A. is-dedicaced

B. db-type

C. db-workload

D. licence-model

正解: B

質問 8

What can you do with graphs? (Choose two)

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

B. 3-D modeling

C. Facial recognition

D. Product recommendations

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 9

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

A. Amazon S3

B. Google Cloud Storage

C. Oracle Cloud Infrastructure Object Storage Classic

D. Oracle Cloud Infrastructure Object Storage

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 10

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 OCI compute instance can be used with an Always-Free Autonomous Database account.

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

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

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

正解: B

質問 11

What two methods can you use to define Machine Learning Users? (Choose two.)

A. Oracle Cloud Infrastructure Console

B. SQL/Developer

C. Client tools

D. Use DBMS_CLOUD_ADMIN package

正解: B,C

解説: (PassTest メンバーにのみ表示されます)

質問 12

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

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

B. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);

C. Execute alter tablespace DATA set quota = 10G;

D. Execute alter user MTHEO quota unlimited on tablespace DATA;

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 13

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. Data Insight

C. Catalog

D. JSON

正解: C

解説: (PassTest メンバーにのみ表示されます)

Oracle Autonomous Database Cloud 2024 Professional - 1Z0-931-24 模擬練習