最新的Oracle 1Z0-931-25免費考試真題

問題1

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

A. Create a notification alert using DBMS_SNMP package

B. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric

C. Add a 'BEFORE SHUTDOWN ON DATABASE' trigger within the database

D. Create a rule for the Oracle Cloud Infrastructure Event for 'Autonomous Database STOP END'

正確答案: D

說明：（僅 Fast2test 成員可見）

問題2

In which four ways can Oracle Database optimally access data in Object Storage? (Choose four.)

A. Optimized data archive using partitioned external tables

B. Scan avoidance using partitioned external tables

C. Scan avoidance using block skipping when reading parquet and orc files

D. Scan avoidance using columnar pruning for columnar stores like parquet and orc

E. Optimized data archive using hybrid partitioned tables

F. Scan avoidance using columnar pruning for .csv files

正確答案: A,B,D,E

說明：（僅 Fast2test 成員可見）

問題3

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

A. Execute ALTER TABLESPACE DATA SET QUOTA = 10G;

B. Execute ALTER USER MTHEO QUOTA UNLIMITED ON TABLESPACE DATA;

C. Execute ALTER DATABASE FOR USER MTHEO TABLESPACE DATA QUOTA = 10G;

D. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(username => 'MTHEO', tablespace_quota => 'UNLIMITED');

正確答案: B

說明：（僅 Fast2test 成員可見）

問題4

Which two statements are true regarding active transactions when scaling OCPUs in an Autonomous Database? (Choose two.)

A. Scaling can happen while there are active transactions in the database

B. Active transactions are paused

C. Active transactions continue running unaffected

D. Active transactions are terminated and rolled back

正確答案: A,C

說明：（僅 Fast2test 成員可見）

問題5

DBSRV1 is an Autonomous Database with the display name PRODDB. You plan to take manual backups of this database periodically. What must be the name of the bucket that will be used to store manual backups?

A. backup_proddb

B. backup_dbsrv1

C. BACKUP_DBSRV1

D. BACKUP_PRODDB

正確答案: C

說明：（僅 Fast2test 成員可見）

問題6

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

A. IOPS, Storage used by tablespace, Apply and Transport Lag

B. Transaction Count, Running Statements, Sessions

C. Query Latency, User Calls, Execute Count

D. CPU Utilization, Storage Utilization

正確答案: A

說明：（僅 Fast2test 成員可見）

問題7

To whom, and in which order, are dedicated Exadata Infrastructure resources provisioned?

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

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

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

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

正確答案: D

說明：（僅 Fast2test 成員可見）

問題8

Which native data type is used to store spatial information?

A. SDO_GEOMETRY

B. SDO_RELATE

C. GEO_JSON

D. SDO_LOCATION

正確答案: A

說明：（僅 Fast2test 成員可見）

問題9

Which statement is true when the Autonomous Database has auto scaling enabled?

A. Increases the number of sessions available to the database

B. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload

C. Scales the PGA and SGA size when needed for the workload

D. Database concurrency is scaled up when needed by the workload

正確答案: B

說明：（僅 Fast2test 成員可見）

最新的Oracle Autonomous Database Cloud 2025 Professional - 1Z0-931-25免費考試真題

聯系我們

站內鏈接

最新更新