Skip to main content

1Z0-1105-22 Real Exam Questions

Oracle Cloud Data Management 2022 Foundations Associate

55 questions available · Page 1 of 6

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Multiple choice

Which three are prerequisites for using the MySQL Database Service? (Choose all correct answers)

  1. A

    You must create a tenancy and be able to sign in to it

  2. B

    You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.

  3. C

    You or your group must be granted the policies described in Mandatory Policies.

  4. D

    You must download the latest MySQL version from https://edelivery.oracle.com/ You must create a compartment to store your resources

Show answer and explanation

Correct answers: A, C, D

Question 2 Single choice

Which statement can be detected by monitoring of access to sensitive data?

  1. A

    SELECT SYSDATE from DUAL;

  2. B

    CREATE index emp_id_idx on EMPLOYEES(emp_id);

  3. C

    UPDATE quarter_reference set Q1='012022'

  4. D

    SELECT * from EMPLOYEES;

Show answer and explanation

Correct answer: D

Question 3 Multiple choice

Which two are key characteristics of Oracle Autonomous Database? (Choose all correct an-swers)

  1. A

    Oracle manages everything

  2. B

    Less automated

  3. C

    Higher cost

  4. D

    Customer manages everything

  5. E

    Lower cost

Show answer and explanation

Correct answers: A, E

Question 4 Single choice

Which statement is true about MySQL Database Service?

  1. A

    Its users are responsible for database and operating system patching tasks.

  2. B

    It supports MySQL Enterprise Edition version 5.7 with InnoDB Storage Engine.

  3. C

    It is a public cloud service built on MySQL Community Edition.

  4. D

    It is a fully managed Oracle Cloud Infrastructure (OCI) native service.

Show answer and explanation

Correct answer: D

Question 5 Single choice

Oracle & Automated Machine Learning (AutoML) has options for using in-database and opensource algorithms.

Which is an example of an in-database option?

  1. A

    Tuning of hyperparameter

  2. B

    Oracle Machine Learning for Python (OML4Py) APIs

  3. C

    REST Interface

  4. D

    Cognitive text

Show answer and explanation

Correct answer: B

Question 6 Single choice

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

  1. A

    API signing key, admin ID, user ID

  2. B

    signing key fingerprint, API signing key, tenancy OCID

  3. C

    user ID, tenancy ID, component ID

  4. D

    tenancy ID, passphrase, handshake key

Show answer and explanation

Correct answer: B

Question 7 Multiple choice

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

  1. A

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

  2. B

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

  3. C

    Provide for the fastest, most scalable converged SQL database.

  4. D

    Provide the best platform for warehouse workloads only.

Show answer and explanation

Correct answers: A, B

Question 8 Single choice

The DBA has determined that number of OCPU assigned to an Autonomous Database does not provide sufficient performance.

Which option does the DBA have in this case?

  1. A

    Open the database in OCI Console and increase the number of OCPU. No downtime required.

  2. B

    No downtime is required as number of OCPU can be increased from OCI console, but users have to be informed that they must not use any application for at least one hour.

  3. C

    Call Oracle Cloud Support and raise a request to increase number of OCPU. Expect a downtime of approximately one hour.

  4. D

    Plan for a one-hour downtime and increase the number of OCPU while database is of-fline.

Show answer and explanation

Correct answer: A

Question 9 Single choice

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

  1. A

    A DBA must enable ORDS first.

  2. B

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

  3. C

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

  4. D

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

  5. E

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

Show answer and explanation

Correct answer: D

Question 10 Single choice

Which security measure is implemented out-of-the-box, and is included if you are not using BYOL licensing with Exadata Cloud@Customer?

  1. A

    Audit Vault and Database Firewall

  2. B

    Oracle Native Network Encryption and TDE (Transparent Data Encryption)

  3. C

    Oracle Key Vault

  4. D

    Database Vault and Data Masking Pack

Show answer and explanation

Correct answer: B