Oracle Oracle Certifications 1Z0-1096-22 Questions & Answers

• Question 11:

  Which three SQL commands are restricted in an Autonomous Database?

  A. Alter Table

  B. Alter Profile

  C. Alter Tablespace

  D. Create Table

  E. Create Tablespace

  Correct Answer: BCE

• Question 12:

  What are three key features of Oracle Machine Learning Notebooks?

  A. They enable job scheduling of notebooks on a recurring schedule.

  B. They enable access to in database implementation of machine learning algorithms.

  C. They support SQL, PL/SQL, JavaScript, and PHP scripting languages.

  D. They support integration with Oracle Data Miner-ID

  E. They provide a collaborative notebook interface on Oracle Autonomous Database.

  Correct Answer: ACD

• Question 13:

  Which task is NOT required by an Administrator when adding a new user to Oracle Machine Leamina (OML) Notebooks?

  A. Issue grant commands on the database to allow access to the tables associated with the user's Oracle Machine Learning Notebooks.

  B. Create an OML username and password for the user in the Oracle Machine Learning Management User Interface.

  C. Add the user's full name and email ID in the Oracle Machine Learning Management User Interface.

  D. Provide the user with an Autonomous Data Warehouse client wallet for remote authentication.

  Correct Answer: C

• Question 14:

  Which four actions would typically be performed during the data preparation step for analyzingdata with Oracle Machine Learning?

  A. performing feature engineering, such as creating derived variables

  B. numeric data normalization

  C. data collection from various sources

  D. missing value replacement

  E. building a machine learning model

  F. binning of numeric data

  Correct Answer: ABCD

• Question 15:

  Two users at different locations are collaborating on a project by editing the same notebook. Which type of notebook should they use for collaboration?

  A. Shared Notebook

  B. Example notebook

  C. Personal Notebook

  D. Public Notebook

  Correct Answer: B

• Question 16:

  Which feature of Oracle Machine Learning Notebooks should you use for data analysis, data discovery, data visualization, and collaboration on Oracle Autonomous Database?

  A. Workspace

  B. Notebook

  C. Job

  D. Project

  Correct Answer: B

• Question 17:

  Which two templates are supported while saving a notebook?

  A. Shared

  B. Example

  C. Public

  D. Personal

  Correct Answer: AD

  Explanation: https://docs.oracle.com/en/database/oracle/machine-learning/oml- notebooks/omlug/notebooks-templates.html

• Question 18:

  Which three types of templates are available in Oracle Machine Learning Notebooks?

  A. Personal templates

  B. Public templates

  C. Example templates

  D. Shared templates

  E. Custom templates

  Correct Answer: ACD

  Explanation: https://docs.oracle.com/en/database/oracle/machine-learning/oml- notebooks/omlug/use-library-collaborate-users.html#GUID-F468F691-2B8B-4427-B517- 5F149AA57239

• Question 19:

  Which four statements are true about Oracle Machine Learning on Oracle Autonomous Database?

  A. It provides a development environment to build models and score data.

  B. It provides a collaborative web-based notebook interface.

  C. It is deployed with Oracle Data Miner.

  D. It enables data analytics, data discovery, and data visualizations.

  E. It includes parallelized in-database algorithms.

  F. It provides an interface to monitor a database.

  Correct Answer: ABDE

• Question 20:

  Examine the output:

  

  A. SET SQLFORMAT FIXED

  B. SET SQLFORMAT ANSICONSOLE

  C. SET SQLFORMAT LOADER

  D. SET SQLFORMAT DELIMITED

  Correct Answer: C