Oracle 1z0-931 Free Practice Questions

NEW QUESTION 1
Which is the correct subset of services offered via OCI-CLI (command line interface) for Autonomous Database (ABD) via calls made to the OCI API's?

• A. Create, Query, Update, List, Start
• B. Create, Query, List, Stop, Restore
• C. Create, Get, List, Stop, Restore
• D. Start, Delete, Update, Query, Stop

Answer: B

NEW QUESTION 2
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database?

• A. Data Pump creates the tablespaces used by your Autonomous Database.
• B. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
• C. Data Pump is faster to migrate database than using RMAN.
• D. Data Pump is platform independent - it can migrate Oracle Databases running on any platform.

Answer: AD

NEW QUESTION 3
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

• A. Autonomous Data Warehouse
• B. Neither service ignores hints by default
• C. Autonomous Transaction Processing
• D. Both services ignore hints by default

Answer: C

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

• A. On the Autonomous Database Console.
• B. SSH keys are not required In Oracle Cloud Infrastructure.
• C. SSH keys cannot be added from consol
• D. They have to be added using REST APIs only.
• E. Navigate to Identity, select Users panel on the console and select "Add Public Key".

Answer: C

NEW QUESTION 5
What two tasks can be executed from the service console for Autonomous Databases?

• A. Autonomous Databases monitoring for usage and query performance.
• B. Wizard to download connection wallet for connection from desktop tools.
• C. Creating and scaling of Autonomous Database service.
• D. Creating schemas.

Answer: CD

NEW QUESTION 6
What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database?

• A. CSV files copied to Autonomous Database block storage
• B. Data Pump
• C. Golden Gate
• D. Recovery Manager (RMAN)

Answer: AC

NEW QUESTION 7
Which two PL/SQL functions can be used to validate an analytic view?

• A. VALIDATE_ANALYTIC_VIEW
• B. VALIDATE_LEVELS
• C. VALIDATE_MEASURES
• D. VALIDATE_DIMENSION
• E. VALIDATE_HIERARCHY

Answer: AE

Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dwhsg/overview-analytic-views.html#GUID-6F

NEW QUESTION 8
Which two statements are true about the The Oracle Cloud Infrastructure (OCI)?

• A. Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region.
• B. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.
• C. A single fault domain can be associated with multiple regions and availability domains.
• D. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.

Answer: AC

NEW QUESTION 9
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

• A. TPPERFORMANT
• B. TPURGENT
• C. LOW
• D. MEDIUM
• E. HIGH

Answer: A

Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8

NEW QUESTION 10
What two methods can you use to define Machine Learning Users?

• A. Use DBMS_CLOUD_ADMIN package
• B. SQL/Developer
• C. Oracle Cloud Infrastructure Console
• D. Client tools

Answer: AC

NEW QUESTION 11
Which two are correct actions to take in order to Download the Autonomous Database Credentials?

• A. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
• B. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
• C. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
• D. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
• E. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.

Answer: CD

NEW QUESTION 12
Which three data dictionary views contain information about analytic view objects?

• A. ALL_ANALYTIC_VIEW_PATHS
• B. ALL_ANALYTIC_VIEW_DIM_CLASS
• C. ALL_ANALYTIC_VIEW_ID_ATTRS
• D. ALL_ANALYTIC_VIEW_LVLGRPS
• E. ALL_ANALYTIC_VIEW_KEYS

Answer: B

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

• A. SQL
• B. JSON
• C. ASCII
• D. XML
• E. TXT

Answer: B

NEW QUESTION 14
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?

• A. Unplug into a pdb archive which can be uploaded to object storage.B Create a database link from source database to the ADB environment and clone the PDB.
• B. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
• C. Unplug to an xml file so database files and xml file can be uploaded to object storage.

Answer: B

NEW QUESTION 15
Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure?

• A. Terraform
• B. Enterprise Manager
• C. REST API
• D. Dlocker

Answer: A

Explanation:
https://blogs.oracle.com/cloud-infrastructure/getting-started-with-the-resource-manager-on-oracle-cloud-infrastr

NEW QUESTION 16
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection?

• A. DBNAME_MEDIUM
• B. DBNAME_HIGH
• C. DBNAME_CONCURRENT
• D. DBNAME_LOW

Answer: B

NEW QUESTION 17
Which two system privileges does a user need to create analytic views?

• A. CREATE ATTRIBUTE DIMENSION
• B. CREATE ANALYTIC VIEW
• C. CREATE ANALYTIC MEASURE
• D. CREATE ANALYTIC LEVEL
• E. CREATE ANALYTIC HIERARCHY

Answer: BD

NEW QUESTION 18
Which two statements are true with regards to Oracle Data Sync?

• A. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
• B. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.
• C. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
• D. Data Sync can load your data in parallel in order to speed up the loading process.

Answer: D

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

• A. Connecting to the Cloud Infrastructure Command console via SSH wallet.
• B. It cannot be done.
• C. Using Database Configuration Assistant (DBCA) on the database server.
• D. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

Answer: A

NEW QUESTION 20
A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their
end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB instance for a switch back.
Which statement about the migration using Golden Gate is correct?

• A. The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB.
• B. Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB.
• C. Golden Gate on premise Is not certified with ADB because Golden Gate Cloud Service exists for this.
• D. Only the migration to ADB is possible from an on-premise installation of Golden Gate.
• E. The described scenario is correct, can be used for migration and fallback scenarios.

Answer: D

NEW QUESTION 21
Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database.
Which statement is true regarding the default configuration of the Autonomous Data Warehouse?

• A. Adding, removing, or modifying tablespaces is allowed.
• B. Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to.
• C. In Autonomous Data Warehouse direct access to the database node and the local file system is allowed.
• D. Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.

Answer: A

NEW QUESTION 22
What predefined user is created when an Autonomous Database (ADB) instance is created that you connect to in order to create other users and grant roles?

• A. SCOTT
• B. ADMIN
• C. SYS
• D. DWDEV

Answer: A

NEW QUESTION 23
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

• A. Autonomous Data Warehouse workloads are optimized for mixed workloads.
• B. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
• C. Data that Is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format Is columnar.
• D. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.

Answer: A

NEW QUESTION 24
......