Oracle Autonomous Database Cloud 2024 Professional - 1Z0-931-24 Exam Practice Test

A. 1524

B. 1523

C. 1526

D. 1521

E. 1522

A. Create a database user with the default privileges.

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

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

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

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

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

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

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

A. AIX

B. Linux

C. Windows

D. Solaris

A. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then

B. Find the Service Console for your Autonomous Database, then pick Administration, then Download

C. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB

D. Click the Compute section of the menu, then choose Instance Configurations, then Download

E. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet

A. Shared Exadata Infrastructure

B. Dedicated Exadata Infrastructure

C. Bare-metal on Oracle Cloud Infrastructure

D. VM on Oracle Cloud Infrastructure

E. Any Oracle Engineered System

A. OCPUs and storage can be scaled independently

B. Increasing OCPUs will automatically increase storage

C. Use auto scaling to increase storage

D. OCPUs and storage must remain in sync

A. Undo Management

B. Memory Usage

C. Index Storage

D. Backup Retention

E. Data Organization

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

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

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

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

A. 15

B. 120

C. 7

D. 60

A. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.

B. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.

C. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.

D. Data Sync can load your data in parallel in order to speed up the loading process.

A. The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database.

B. When you share the credential files with authorized users, mail the wallet password and the file in the same email.

C. Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database.

D. Place the credential files on a share drive that all users can use to connect to the database.

A. Regular Oracle SQL statements using a connection through the listener

B. NOSQL statements using Oracle SODA drivers

C. Oracle Cloud Infrastructure console using the JSON Online Developer tool

D. REST API calls to the database (not enabled by default)

E. Oracle JSON Developer tool downloaded from OTN

A. Autonomous Data Guard automatically reverts to the primary database when it becomes available again

B. The OCPU Count, Storage, Display Name, Database Name, Auto Scaling, Tags, and Licensing options have the same values as the primary

C. A new wallet is required to connect to the standby database

D. Autonomous Data Guard automatically creates a new standby database

E. Oracle Machine Learning Notebooks created in the primary database are available in the standby database