Free Oracle 1Z0-931-24 Exam Dumps Questions & Answers

When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

• A.  Storage in TB cannot be larger than the number of OCPUs.
• B.  OCPUs and storage must remain in sync.
• C.  Increasing OCPUs will automatically increase storage.
• D.  OCPUs and storage can be scaled independently.

Given the steps:
1. Create Oracle Machine Learning User
2. Create projects
3. Create workspaces
4. Create Notebooks
5. Run SQL Scripts
Which two steps are out of order when working with Oracle Machine learning? (Choose two.)

• A.  Run SQL Scripts
• B.  Create workspaces
• C.  Create projects
• D.  Create Notebooks
• E.  Create Oracle Machine Learning User

Which of these database features is NOT part of the Autonomous Database?

• A.  Real Application Clusters (RAC)
• B.  Java in the Database
• C.  Online Indexing
• D.  Flashback Database

Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?

• A.  Data formats supported include: text, csv, json, avro and parquet
• B.  Data can be uploaded from several cloud storage sources including 53, Azure, Google Cloud and Oracle Object Storage
• C.  Data can be loaded from a remote database using Database Links (DBLinks)
• D.  Data can be loaded from a local data source
• E.  You must first manually create your database credentials using dms_cloud.create_credentia before accessing your Oracle Object Storage Bucket

In which four ways can Oracle Database optimally access data in Object Storage?

• A.  scan avoidance using partitioned external tables
• B.  scan avoidance using columnar pruning for columnar stores like parquet and orc
• C.  optimized data archive using partitioned external tables
• D.  scan avoidance using columnar pruning for .csv files
• E.  optimized data archive using hybrid partitioned tables
• F.  scan avoidance using block skipping when reading parquet and ore files