New 2024 1z0-1096-23 Dumps for Oracle Database Certified Exam Questions & Answer [Q17-Q32]

Rate this post

New 2024 1z0-1096-23 Dumps for Oracle Database Certified Exam Questions and Answer

Realistic Verified 1z0-1096-23 exam dumps Q&As – 1z0-1096-23 Free Update

Oracle 1z0-1096-23 Exam Syllabus Topics:

Topic	Details
Topic 1	Creating SQL Scripts and Running SQL Commands in Oracle Machine Learning Introduction to Oracle Machine Learning (OML) and Oracle Autonomous Cloud Platform
Topic 2	Notebooks in Oracle Machine Learning Work with AutoML using AutoML UI and OML4Py
Topic 3	Manage workspaces and workspace permissions Collaborating Using Templates in Oracle Machine Learning
Topic 4	Access the Oracle Machine Learning Home page in Autonomous Data Warehouse Share a notebook by using Oracle Machine Learning templates
Topic 5	Describe jobs in Oracle Machine Learning Administering Oracle Machine Learning
Topic 6	Identify the restrictions on SQL commands and database options Creating Workspace and Projects in Oracle Machine Learning
Topic 7	Describe the components and features of OML Create a new project and workspace in Oracle Machine Learning
Topic 8	Describe templates in Oracle Machine Learning Create user accounts for Oracle Machine Learning
Topic 9	Describe personal, shared, and example templates Explain the workflow for managing Oracle Machine Learning
Topic 10	Working with Jobs in Oracle Machine Learning Describe administering Oracle Machine Learning
Topic 11	Describe a typical workflow for analyzing data with Oracle Machine Learning Create select forms and check-box forms in Notebooks

NO.17 You are creating a job that should run a notebook every hour. You want to make sure that the job does not run repeatedly if there are more than five consecutive failures to run the job. Which option should you set while creating the job?

Minimum Failure Allowed

Timeout in Minutes

Maximum Failure Allowed

Maximum Number of Runs

NO.18 You are using Oracle Machine Learning with Autonomous Database for the first time. After creating an Autonomous Database, what is the next step that you have to perform?

Connect to the Database

Create an OML user

Create an ML notebook

Create a compartment

NO.19 When running which type of code must you use %script in Oracle Machine Learning Note-books?

SQL script

JSON script

PL/SQL script

JavaScript

NO.20 You have developed a notebook in an Autonomous Database (ADB) and you need to share the notebook with your colleague to run on a different ADB instance. How should you enable your colleague to work with this notebook?

Export the notebook in .json format and have your colleague import this notebook.

Save the notebook as a shared template.

Save the notebook in the .csv format and have your colleague import this notebook.

Make the notebook public.

NO.21 Which three SQL commands are restricted in an Autonomous Database?

Alter Table

Alter Tablespace

Create Table

Alter Profile

Create Tablespace

NO.22 Which two Oracle Cloud services are Integrated with Oracle Machine Learning? (Choose two.)

Oracle Analytics Cloud

Oracle GoldenGate

Oracle Stream Analytics

Oracle Autonomous Database

NO.23 Which three statements are true about Oracle Machine Learning Notebooks? (Choose three.)

It provides a web-based interface for data analysis.

It is used for data preparation and exploration.

It is used to access machine learning algorithms.

It is used to create low-code applications.

It is used to manage and monitor database objects.

NO.24 Which is a FALSE statement regarding Oracle Machine Learning (OML)?

OML provides integration with open source Python and R statistical analysis functions.

OML provides scalable statistical functions though OML4Py and OML4R.

OML offerings need a separate data visualization tool for creating visualization.

OML provides univariate and multivariate statistics.

NO.25 You have created a notebook and want to run the notebook on a periodic schedule. How should you achieve this?

You can create a job and schedule it to run a specific notebook.

You cannot run the notebook on the scheduled time.

You need to contact the database administrator to configure the notebook to run at a particular time.

You have to login as the admin user and schedule a job to run the notebook.

NO.26 Which three actions can be performed by an Administrator in Oracle Machine Learning (OML) Notebooks?
(Choose three.)

Create, run and delete notebooks.

View notebooks.

Create and run jobs.

Reassign workspaces to users.

Create, edit and delete OML users.

NO.27 (PICq21) Examine the output: <PIC>

SET SQLFORMAT ANSICONSOLE

SET SQLFORMAT DELIMITED

SET SQLFORMAT FIXED

SET SQLFORMAT LOADER

NO.28 You want to analyze the spike in sales during weekends in India (Saturday and Sunday) and also perform a similar analysis for weekends in Dubai (Friday and Saturday). You will be re-using these notebooks in similar situations over time. You do not want to share them with other users. Which template should you use?

Shared

Personal

Example

Public

NO.29 Which three statements are true about unsupervised machine learning? (Choose three.)

There is no previously known result to guide the algorithm in building the model.

It can be used as a preliminary step for supervised algorithms.

It uses unlabeled data.

It analyzes cases where the target value is already known.

NO.30 Which output formats are supported by the SET SQLFORMAT command? (Choose three.)

TXT

HTML
(Correct)