Explanation

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

• View notebooks. An Administrator can view notebooks in their own workspace or in workspaces where they have collaboration rights. However, an Administrator cannot run or modify notebooks1.
• Reassign workspaces to users. An Administrator can reassign workspaces from one user to another user in the User Data page. This can be useful when a user leaves the organization or changes roles2.
• Create, edit and delete OML users. An Administrator can create new OML user accounts and passwords, edit existing OML user information, and delete OML users in the User Management interface.

Explanation

https://oralytics.com/2021/03/15/oml4py-automl-an-example/

• Running this command will return the median value of customer credit limit grouped by marital status2.
• The MEDIAN function is an aggregate function that returns the middle value of a numeric column for each group or partition. If the number of values is even, it returns the average of the two middle values2.
• The GROUP BY clause is used to divide the rows of a table into groups that have the same values in the specified columns. The aggregate functions are applied to each group separately and the result is returned for each group3.

Explanation

Grant Workspace Permissions You can collaborate with other users in Oracle Machine Learning by granting permissions to access your workspace. Your workspace contains your projects and note-books. By granting different types of permissions such as Manager, Developer, and Viewer, you can allow another user to view your workspace and perform different tasks in your projects and note-books such as edit, create, update, delete, run, view notebooks and so on. For more information about the permission types, see About Workspace Permission Types. Caution: If you grant the per-mission type Manager or Developer, then the user can also drop tables, create tables, and run any scripts at any time on your account. The user with Viewer permission type can only view your note-books, and is not authorized to run or make any changes to your notebooks

• The correct sequence of creating items in Oracle Machine Learning Notebooks when setting up a new Autonomous Database instance is Workspace, OML User, Notebook, Jobs1.
• A workspace is a logical container for organizing and managing notebooks, jobs, and projects. A workspace can be shared by multiple users with different roles and permissions1.
• An OML user is a database user who has access to Oracle Machine Learning Notebooks. An administrator needs to create an OML username and password for each user in the Oracle Machine Learning User Management interface2.
• A notebook is a document that contains SQL, PL/SQL, Python, or R code, as well as text, images, charts, and graphs. A notebook can be used for data exploration, data visualization, data preparation, and machine learning3.
• A job is a scheduled execution of a notebook or a script. A job can run on a recurring schedule or on demand. A job can also send notifications to users via email or webhooks4.

Explanation

https://docs.oracle.com/en/database/oracle/machine-learning/oml4sql/21/mlsql/access-autonomous-database.html#GUID-8D6312CB-E330-4C22-9FDC-0F044173735D

• The data preparation step for analyzing data with Oracle Machine Learning involves various actions to transform the raw data into a suitable format for machine learning algorithms45.
• Some of the actions that would typically be performed during the data preparation step are:

Explanation

Oracle Machine Learning Notebooks is an Apache Zeppelin-based collaborative web-based inter-face that provides a development environment to create machine learning notebooks where you can perform data exploration and visualizations, data preparation and machine learning. https://docs.oracle.com/en/database/oracle/machine-learning/oml-notebooks/omlug/get-started-oracle-machine-learning.html

• A false statement regarding Oracle Machine Learning (OML) is that OML offerings need a separate data visualization tool for creating visualization56.
• OML does not need a separate data visualization tool for creating visualization because it provides various options for visualizing data and models within its offerings. For example, OML Notebooks support interactive charts and graphs using Plotly and Matplotlib libraries for Python and R. OML SQL also supports native SQL functions for creating histograms, scatter plots, box plots, and more

• The reason why a user with Developer permission is unable to create a job on an existing notebook that is shared is that the user requires the Create Job role1.
• The Create Job role is a database role that grants the privilege to create and manage jobs on Oracle Machine Learning Notebooks. This role is not granted by default to any user, including the ADMIN user. An administrator needs to explicitly grant this role to users who need to create jobs1

Explanation

https://blogs.oracle.com/machinelearning/post/introducing-oml-automl-user-interface https://www.oracle.com/a/tech/docs/technical-resources/oml-technical-brief.pdf

Explanation

Oracle Machine Learning Notebooks Increase data scientist and developer productivity and reduce their learning curve with familiar open source-based Apache Zeppelin notebook technology. Note-books support SQL, PL/SQL, Python, and markdown interpreters for Oracle Autonomous Database so users can work with their language of choice when developing models. View interactive product tour Oracle Machine Learning Notebooks with Autonomous Data Warehouse documentation Oracle Machine Learning Notebooks with Autonomous Transaction Processing documentation Oracle Ma-chine Learning Notebooks with Autonomous JSON Database documentation

Explanation

https://blogs.oracle.com/machinelearning/post/using-svd-for-dimensionality-reduction

Explanation

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

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/omlug/output-formats-supported-set-sqlformat.html

Explanation

https://docs.oracle.com/cd/F32587_01/dmcon/oracle-machine-learning-sql-concepts.pdf

Explanation

About Workspace Permission Types: Oracle Machine Learning allows three types of permissions. Depending on the permission type, you can allow the user to view or perform different tasks in your workspace, projects, and notebooks. The three types of permissions are listed in the following table along with the actions that are allowed. Permission Types || Actions based on permission > Manager: • Project: Create, update, delete. • Workspace: View only. • Notebooks: Create, update, run, delete, and schedule jobs. > Developer: • Project: View only. • Workspace: View only. • Notebooks: Create, update, run, and delete notebooks that a developer creates only. • Jobs: View and run jobs of shared notebooks only. A developer cannot create jobs for notebooks that are shared. > Viewer: • Project: View only. • Workspace: View only. • Notebooks: View only. • Jobs: View jobs and job runs of shared notebooks only.

Explanation

https://www.doag.org/formes/pubfiles/13151859/OE-DAC-Oracle-Machine-Learning-Overview-Whats-New-Customers-Apps_MLconcepts_Berger.pdf

Explanation

About Workspace Permission Types: Oracle Machine Learning allows three types of permissions. Depending on the permission type, you can allow the user to view or perform different tasks in your workspace, projects, and notebooks. The three types of permissions are listed in the following table along with the actions that are allowed. Permission Types || Actions based on permission > Manager: • Project: Create, update, delete. • Workspace: View only. • Notebooks: Create, update, run, delete, and schedule jobs. > Developer: • Project: View only. • Workspace: View only. • Notebooks: Cre-ate, update, run, and delete notebooks that a developer creates only. • Jobs: View and run jobs of shared notebooks only. A developer cannot create jobs for notebooks that are shared. > Viewer: • Project: View only. • Workspace: View only. • Notebooks: View only. • Jobs: View jobs and job runs of shared notebooks only.