Question No. 1

Examine the SQL command: SQL> SELECT CUST_MARITAL_STATUS,MEDIAN(CUST_CREDIT_LIMIT) FROM SH.CUSTOMERS GROUP BY CUST_MARITAL_STATUS; Which statement is true about running this command where the table has columns cust_maritax._status3 (VARCHAR2) and cust_credit_limit (number) with 100k rows of non-null data?

AIt will return a customer's marital status and credit limit grouped by marital status

BIt will return an error.

CIt will return the marital status and credit limit of each customer.

DIt will return the median value of customer credit limit grouped by marital status.

Show Answer

Correct Answer: D

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.

Question No. 2

Which three types of permissions can be granted to a user to callaborate and access a workspace in Oracle Machine Learning Notebooks?

AGuest

BAdministrator

CViewer

DManager

EDeveloper

Show Answer

Correct Answer: C, D, E

The three types of permissions that can be granted to a user to collaborate and access a workspace in Oracle Machine Learning Notebooks are Viewer, Manager, and Developer1.

Viewer is a user role that allows users to view notebooks but not run or modify them1.

Manager is a user role that allows users to perform all the tasks of a Developer as well as manage other users' workspaces and permissions1.

Developer is a user role that allows users to create and run notebooks, run SQL statements, create SQL scripts, run Python scripts, create jobs to schedule and run notebooks, use example template notebooks, create and run AutoML experiments, and deploy models1.

Question No. 3

Which three Oracle Machine Learning (OML) components are available with Oracle Autonomous Database? (Choose three.)

AOracle Data Miner

BOML Notebooks

COML4SQL

DOML4R

EOML Services

Show Answer

Correct Answer: B, C, E

The three Oracle Machine Learning (OML) components that are available with Oracle Autonomous Database are OML Notebooks, OML4SQL, and OML Services2.

OML Notebooks are web-based interfaces for data analysis, data discovery, data visualization, and collaboration based on Apache Zeppelin notebook technology.They support SQL, PL/SQL, Python, R, and markdown interpreters on Oracle Autonomous Database2.

OML4SQL is a set of in-database machine learning algorithms and SQL functions that enable data exploration, data preparation, model building, evaluation, and deployment using SQL and PL/SQL on Oracle Autonomous Database2.

OML Services are RESTful web services that enable users to build, deploy, and manage machine learning models using REST APIs on Oracle Autonomous Database.They support native in-database models and ONNX-format models for classification, regression, and clustering2

Question No. 4

You want to segment your customer data for marketing reseach purposes and identify homogeneous groups to build supervised models. What should you use to achieve this?

ARegression

BClustering

CFeature Extraction

DClassification

Show Answer

Correct Answer: B

To segment your customer data for marketing research purposes and identify homogeneous groups to build supervised models, you should use clustering12.

Clustering is a type of unsupervised machine learning that groups data points based on their similarities in terms of features or attributes.Clustering can help discover the underlying structure of the data and reveal the natural segments or categories within it12.

Clustering can be useful for marketing research because it can help identify different types of customers based on their demographics, preferences, behaviors, or needs.Clustering can also help create customer profiles or personas that can be used to target specific segments with tailored marketing campaigns or offers12.

Clustering can also be used as a preliminary step for building supervised models, such as classification or regression.By using the cluster labels as an additional feature or a target variable, supervised models can learn from the cluster information and improve their accuracy or performance12.

Question No. 5

What is the first step for analyzing data that is external to Oracle Database with Oracle Machine Learning?