1Z0-1105-22 Online Practice Questions and Answers

What is NOT a workload that can be selected when provisioning an Autonomous Database?

A. Data Warehouse

B. MySQL

C. APEX

D. JSON

What is a prerequisite of running APEX on an Autonomous Database?

A. A DBA must enable ORDS first.

B. APEX can simply be installed by downloading the executable from OTN.

C. APEX can only be used when selecting APEX as a workload when provisioning an Au- tonomous Database.

D. An Autonomous Database with the workload type Data Warehouse, Transaction Pro- cessing, JSON or APEX.

E. A DBA must create APEX admin and APEX users first before starting APEX from Oracle Cloud Infrastructure Console.

Which two are objectives of Oracle's Data Management strategy? (Choose all correct answers)

A. Offer multiple integration points for 3rd party databases that work better for mixed and analytic workloads.

B. Automate everything for developers, data analysts, DBAs and data scientists.

C. Provide for the fastest, most scalable converged SQL database.

D. Provide the best platform for warehouse workloads only.

What are two main benefits of Oracle APEX? (Choose all correct answers)

A. Rapidly develop, customize, and deliver secure applications

B. Store data in PL/SQL objects

C. Faster development time using hand coding

D. Less productivity compared to hand coding

E. Develop responsive web apps

What is the FINAL release supporting the non-CDB architecture?

A. Oracle Database 23c

B. Oracle Database 21c

C. Oracle Database 18c

D. Oracle Database 19c

What information is required to connect to the NoSQL Database Cloud Service?

A. API signing key, admin ID, user ID

B. signing key fingerprint, API signing key, tenancy OCID

C. user ID, tenancy ID, component ID

D. tenancy ID, passphrase, handshake key

What are two characteristics of Oracle SQLcl (SQL Developer Command Line)? (Choose all correct answers)

A. Tracks database schema changes

B. Creates isolated development environments

C. Available in the OCI Cloud Shell by default D. Ability to execute SQL batch files

Where should you store unstructured, high volume data sets of unknown value for best price/performance?

A. OCI Data Flow

B. OCI Object Storage

C. OCI Data Catalog

D. OCI GoldenGate

What is a main feature of APEX's low code platform?

A. Use graphical interfaces and configuration for building web applications

B. Simplified core-based licensing

C. Limited productivity

D. Build scalable web apps for MongoDB

E. Use traditional computer programming paradigms

Which tool is provided to support Continuous Integration/Continuous Deliver (CI/CD) work- flows?

A. Database Actions (including real time SQL monitor)

B. ADB console (including Performance Hub)

C. SQLcl (including Liquibase)

D. SQL Developer (including ADB wallet)