Oracle Autonomous Database Cloud 2019 Specialist (1Z0-931) Free Practice Test

Question 1

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

A. Data Loading

B. Application User Creation

C. Database Upgrades

D. Backups

E. Firmware Patching

Correct Answer: C,D,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

On what infrastructure does the Autonomous Database run on?

A. Exadata on Oracle Cloud Infrastructure

B. VM on Oracle Cloud Infrastructure

C. Bare-metal on Oracle Cloud Infrastructure

D. Any Oracle Engineered system

Correct Answer: B

Question 3

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 TEST phase of the wizard a list is generated containing the records that would be rejected during import.

C. In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.

D. In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition.

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

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

A. Neither service ignores hints by default.

B. Autonomous Transaction Processing.

C. Autonomous Data Warehouse.

D. Both services ignore hints by default.

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

Which Java Database Connectivity (JDBC) thin client version supports the use of HTTP proxy settings that does NOT support TCP to connect to Autonomous Data Warehouse?

A. Any version

B. 12c Release 2 onwards

C. 17.4 onwards

D. 18.1 onwards

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

Which procedure within the DBMS_CLOUD package is used to load data?

A. COPY_DATA

B. PUT_OBJECT

C. LOAD_DATA

D. CREATE_EXTERNAL_TABLE

E. LIST_FILES

Correct Answer: A

Question 7

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

A. ALL_ANALYTIC_VIEW_DIM_CLASS

B. ALL_ANALYTIC_VIEW_KEYS

C. ALL_ANALYTIC_VIEW_LVLGRPS

D. ALL_ANALYTIC VIEW_ID _ATTRS

E. ALL_ANALYTIC_VIEW_PATH

Correct Answer: A,B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Autonomous Database Cloud 2019 Specialist (1Z0-931) Free Practice Test