Independence Day Special - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: spcl70

Note! 1z0-931 has been withdrawn. The new exam code is 1z0-931-23

1z0-931 Practice Exam Questions with Answers Oracle Autonomous Database Cloud 2019 Specialist Certification

Question # 6

Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)

A.

Backups

B.

Firmware Patching

C.

Data Loading

D.

Database Upgrades

E.

Application User Creation

Full Access
Question # 7

Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location, running datapump export and running a datapump import.

Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading? (Choose three.)

A.

SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps.

B.

SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage.

C.

SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running.

D.

SQL Developer can only export/move/import files using datapump from databases running on Linux systems.

Full Access
Question # 8

Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?

A.

In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database.

B.

The Oracle Client Credential file is downloaded as a ZIP file.

C.

The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.

D.

You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.

Full Access
Question # 9

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

A.

Autonomous Transaction Processing.

B.

Autonomous Data Warehouse.

C.

Neither service ignores hints by default.

D.

Both services ignore hints by default.

Full Access
Question # 10

What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.)

A.

Golden Gate

B.

Recovery Manager (RMAN)

C.

CSV files copied to Autonomous Database block storage

D.

Data Pump

Full Access