Free Demo Questions For 1z0-931 Exam With Valid 1z0-931 Dumps PDF - Realexamdumps.com
                               O   r  a  c  l  e    1z0-931 Dumps PDF
Oracle Autonomous Database Cloud 2019 Specialist
For More Info:
https://www.realexamdumps.com/oracle/1z0-931-practice-test.html
Oracle - 1z0-931
Question #:1
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?
A.  Run SQL Scripts
B.  Create Notebooks
C.  Create workspaces
D.  Create projects
E.  Create Oracle Machine Learning User
Answer: A D
Question #:2
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?
A.  Scaling cannot happen while there are active transactions in the database.
B.  Active transactions are terminated and rolled back.
C.  Active transactions are paused.
D.  Active transactions continue running unaffected.
Answer: A
Question #:3
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
A.  Autonomous Data Warehouse
B.  
1 of 4
Oracle - 1z0-931
B.  Neither service ignores hints by default
C.  Autonomous Transaction Processing
D.  Both services ignore hints by default
Answer: C
Question #:4
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: A C
Question #:5
In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?
A.  In the TEST phase, a temporary table will be populated with the records before inserting them in the
destination table.
B.  In the Column Definition Phase, the system cross-references with the file-contents and shows the
conflicts with the definition.
C.  In the TEST phase of the wizard, a subset of accepted records are displayed based on your definition.
D.  In the TEST phase of the wizard a list is generated containing the records that would be rejected during
import.
Answer: C
Question #:6
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.
2 of 4
Oracle - 1z0-931
A.  
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
Question #:7
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
Question #:8
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 console. They have to be added using REST APIs only.
D.  Navigate to Identity, select Users panel on the console and select "Add Public Key".
Answer: C
Question #:9
Which two statements are true when running DBMS_CLOUD.COPY_DATA?
A.  valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
B.  The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
C.  The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object
3 of 4
Oracle - 1z0-931
Store.
D.  The target table will be created in Autonomous Database if it does not already exist.
E.  The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure
finishes successfully.
Answer: B D
Question #:10
The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some
specific demands like tablespace names, usernames and init.ora parameters. The decision was made to adhere
to the suggested migration method using an instant client and the datapump version that was suggested (and
came with it).
Which statement is true about the migration of the application's database success?
A.  The tablespace names will result in a blocking error during datapump import because of ADB
limitations.
B.  The migration can be technically a success but the 3-rd party vendor needs to support the result.
C.  The migration can be a success, both technically and functional due to datapump enhancements.
D.  The suggested datapump version will create an alias for non-standard tablespace names so the migration
is successful.
Answer: D
4 of 4