[Nov 16, 2024] 1Z0-770 Test Engine files, 1Z0-770 Dumps PDF [Q43-Q68]

Share

[Nov 16, 2024] 1Z0-770 Test Engine files, 1Z0-770 Dumps PDF

Latest Oracle 1Z0-770 PDF and Dumps (2024) Free Exam Questions Answers

NEW QUESTION # 43
Which two statements are true about REST Data Source Synchronization?

  • A. If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.
  • B. The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties
  • C. You cannot trigger Data Synchronization on a regular schedule using a scheduler job.
  • D. If the local table is not in sync with the Data Profile, Data Synchronization continues to work for columns present in both the table and the Data Profile.
  • E. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.

Answer: D,E

Explanation:
Explanation
REST Data Source Synchronization is a feature that enables developers to automatically sync the contents of a local table with the data from an external REST service. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema, which allows APEX to create a DBMS_SCHEDULER job for each scheduled synchronization task. If the local table is not in sync with the Data Profile, which defines the columns and data types of the REST service response, Data Synchronization continues to work for columns present in both the table and the Data Profile (other columns are ignored). However, APEX generates SQL DDL statements to sync table columns back to the Data Profile, which can be added to the application as supporting objects. Verified References: Managing Data Synchronization - Oracle Help Center, Synchronize Data from REST Services to Local Table - Oracle Blogs


NEW QUESTION # 44
What three are the building blocks of Approvals Component?

  • A. Task Details Page
  • B. Automations
  • C. Task Definition
  • D. Unified Task List

Answer: A,C,D

Explanation:
Explanation
The Approvals Component is Oracle APEX's new offering as part of the 22.1 Release. It allows seamless management of approvals across APEX Applications. Approvals are commonly used in business situations involving Expense Reimbursements, Leave Requests, Purchase Requisitions, On-boarding of Employees to name a few. The Approvals Component provides the following building blocks for the approvals functionality:
Task Definition: A shared component for configuring task parameters, participants, and actions. A task definition defines the template for creating tasks based on a specific type of approval request, such as Leave Approval or Purchase Requisition. A task definition specifies the data source, display attributes, potential owners, business administrators, and available actions for the tasks.
Task Details Page: A page that shows task details, which can include metadata, history, comments, and actions. A task details page allows users to view and take action on a specific task, such as approve, reject, reassign, or escalate. A task details page can be created using the Create Page Wizard or the Quick SQL tool in APEX.
Unified Task List: A page type in the Create Page Wizard, used to create a summary of a user's tasks that functions like an inbox. A unified task list allows users to see and manage all their tasks in one place. Users can filter, sort, search, claim, release, or open tasks from the unified task list.


NEW QUESTION # 45
Examine this code entered in Quick SQL:
emp_salary
name vc255
salary num
commission yn/check TRUE, FALSE
Which statement is true about the commission yn column?

  • A. It will restrict acceptable values to TRUE or FALSE.
  • B. It will restrict acceptable values to Y or N.
  • C. It will default to TRUE.
  • D. It will default to FALSE.

Answer: A

Explanation:
Explanation
The commission yn column will restrict acceptable values to TRUE or FALSE because of the /check modifier in the column name. This modifier adds a check constraint to the column based on the values specified after it.
The yn suffix indicates that the column is of type VARCHAR2(1). The other options are incorrect because they do not reflect the effect of the /check modifier or the yn suffix. Verified References: Using Quick SQLAbout Quick SQL Shorthand Syntax


NEW QUESTION # 46
The APEX engine uses which component as a key for tracking each user's session state?

  • A. APEX_USER
  • B. HTTP_USER
  • C. APP_USER
  • D. LDAP_USER

Answer: C

Explanation:
Explanation
APP_USER is a built-in substitution string in Oracle APEX that stores the user name of the current user session. The APEX engine uses APP_USER as one component of a key for tracking each user's session state.
As a user navigates from page to page, the APEX engine sets the value of APP_USER to identify the user. The APEX engine also uses APP_USER to perform security checks and conditional processing. You can reference APP_USER using different syntax depending on the context, such as SQL, PL/SQL, or static text.


NEW QUESTION # 47
Which of the following options in the Developer Toolbar enables you to customize the look and feel of the application?

  • A. Debug
  • B. Session
  • C. Customize
  • D. Quick Edit

Answer: C

Explanation:
Explanation
The Developer Toolbar is a component that appears at the bottom of every page in an Oracle APEX application when running in development mode. The Developer Toolbar provides quick access to various features and tools for developing and debugging an application. One of the options in the Developer Toolbar that enables developers to customize the look and feel of the application is Customize.
Customize: This option opens the Theme Roller tool that allows developers to modify the theme style of the application by changing colors, fonts, sizes, borders, shadows, and more. Developers can also create new theme styles or switch between existing ones using this option.


NEW QUESTION # 48
Which two statements are true about REST Data Sources?

  • A. AREST Data Source can contain one or many Operations which are the references toa concrete external web service
  • B. Oracle APEX supports the REST Enabled SQL Query REST Data Source type
  • C. Oracle APEX doesn't provide direct integration of REST Data Sources in interactivereports
  • D. REST Data Sources doesn't support any authentication

Answer: A,B

Explanation:
Explanation
A REST Data Source is a logical representation of an external web service in Oracle APEX. It can contain one or many Operations, which are the references to a concrete external web service endpoint. Oracle APEX supports three types of REST Data Sources: REST Enabled SQL Query, Web Source Module, and Generic REST Data Source. Oracle APEX provides direct integration of REST Data Sources in interactive reports and grids, as well as other components. REST Data Sources can support various authentication methods, such as Basic, OAuth2, or Custom. References: [Understanding REST Data Sources] and [Creating a REST Data Source]


NEW QUESTION # 49
Select two features of a Smart Filters Page.

  • A. Each filter represents the text entered by the end user in the search field
  • B. Consists of a single search field with filters at the top of the page and a report at the bottom
  • C. Each filter displays as a suggestion chip with a single count of how often the specific suggestion value occurs.
  • D. Consists of filters at the left side and report on the right side of the page

Answer: B,C

Explanation:
Explanation
A smart filters page is a type of component that features a single search field at the top of the page and a search results report (classic report, cards, map, or calendar) at the bottom. A smart filters page behaves similarly to faceted search, but it features a more space efficient layout. Two of the features of a smart filters page are:
Consists of a single search field with filters at the top of the page and a report at the bottom. This feature provides a simple and compact user interface that allows users to enter text in the search field and see suggested filters based on their input. Users can also see and modify applied filters at any time.
Each filter displays as a suggestion chip with a single count of how often the specific suggestion value occurs. This feature provides useful information to users about how many records match each filter value. Users can also choose between different types of suggestions, such as dynamic, static, or SQL query.


NEW QUESTION # 50
Which three of the following statements are TRUE about Faceted Search?

  • A. The facets are displayed on the left and upper part of the screen
  • B. The right side of the page features a Search Results region, which can display as a classic report or a cards report.
  • C. After the end user changes a facet, the results, dependent facets, and occurrence counts refresh immediately.
  • D. You can create only 5 facets per page

Answer: A,B,C

Explanation:
Explanation
A faceted search is a type of component that enables users to filter information easily and intuitively by selecting the options in each facet. A faceted search consists of a faceted search region and a search results region. The faceted search region displays on the left and upper part of the screen and shows possible values and occurrence counts for each facet. The search results region displays on the right side of the screen and shows the data that matches the selected facet values. The search results region can display as either a classic report or a cards report. Three of the statements that are true about faceted search are:
After the end user changes a facet, the results, dependent facets, and occurrence counts refresh immediately. This feature provides instant feedback to the user and allows them to refine their search criteria without reloading the page.
The right side of the page features a Search Results region, which can display as a classic report or a cards report. A classic report displays data in a tabular format with columns and rows. A cards report displays data in a grid of cards with images and text.
The facets are displayed on the left and upper part of the screen. This layout provides a clear separation between the facets and the results and allows users to see and access all the facets without scrolling.


NEW QUESTION # 51
Choose from the below options the actions that can be performed when a button is clicked.

  • A. Redirect to a page in the same application
  • B. All of them
  • C. Submit Page
  • D. Redirect to a URL
  • E. Redirect to a page in a different application

Answer: B

Explanation:
Explanation
A button is a component that performs an action when clicked by the user. A button can have different types, styles, icons, and labels. A button can also have different behaviors, such as submitting the page, redirecting to another page or URL, or doing nothing. A button can perform any of the following actions when clicked:
Redirect to a page in the same application: This action redirects the user to another page within the same APEX application. You can specify the target page number and optionally set some attributes, such as clear cache, request, and item values.
Redirect to a page in a different application: This action redirects the user to another page in a different APEX application. You can specify the target application ID and page number and optionally set some attributes, such as clear cache, request, and item values.
Redirect
to a URL: This action redirects the user to a custom URL that you specify. You can use any valid URL format, such as http://, https://, mailto:, or javascript:.
Submit Page: This action submits the current page to the server and performs any validations, computations, processes, or branches that are defined for the page. You can also specify a request value for the button that can be used to conditionally execute some components.
Defined by Dynamic Action: This action does not submit the page or redirect to another page. Instead, the button's behavior is defined by a dynamic action thatis associated with the button. A dynamic action is a declarative way of defining client-side behavior based on user actions or events.


NEW QUESTION # 52
Which two statements are true about creating and using dynamic actions?

  • A. Once you create a dynamic action, you cannot add additional true actions.
  • B. If no client-side condition is defined, true actions will not fire.
  • C. You can execute JavaScript code by creating a dynamic action.
  • D. If a client-side condition is defined, the true action will fire when the condition is met, and the false action will fire when it is not

Answer: C,D

Explanation:
Explanation
Dynamic actions are a declarative way to define client-side behavior without writing JavaScript code. You can create dynamic actions on an item, button, or region of a page by specifying the event, condition, affected elements, action, and other properties. Some of the statements that are true about creating and using dynamic actions are:
You can execute JavaScript code by creating a dynamic action. One of the supported action types is Execute JavaScript Code, which allows you to enter custom JavaScript code to run when the dynamic action fires.
If a client-side condition is defined, the true action will fire when the condition is met, and the false action will fire when it is not. You can define a client-side condition for a dynamic action to control when it should fire based on an expression or value. You can also define different actions for the true and false branches of the condition. You can add additional true actions to a dynamic action by clicking the Add True Action button in the Property Editor. If no client-side condition is defined, true actions will fire when the event occurs. Verified References: [Oracle Application Express 18: Creating Dynamic Actions], [Dynamic Action Enhancements in APEX 21.1 - Oracle Blogs]


NEW QUESTION # 53
Which two statements that are TRUE about charts in Interactive grid?

  • A. Once the chart is created, it cannot be reconfigured.
  • B. To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter
  • C. You can create multiple charts at a time in an interactive grid
  • D. Once a chart is created, you can switch the view between Grid and Chart view.

Answer: B,D

Explanation:
Explanation
You can create a chart in an interactive grid by selecting Chart in the Actions menu. You can only create one chart at a time in an interactive grid. To create a second chart, you have to reconfigure or delete the existing chart1. To remove a chart, you can click the Remove Chart icon (X) adjacent to the chart filter12. Once a chart is created, you can switch the view between Grid and Chart by clicking the toggle that appears at the top of the interactive grid


NEW QUESTION # 54
Choose the three types of page items that can be placed on a page.

  • A. Global variable
  • B. Date Picker
  • C. Checkbox
  • D. Select List

Answer: B,C,D

Explanation:
Explanation
A page item is a component that is part of an HTML form and can accept user input or display output. There are many types of page items that can be placed on a page in APEX, such as text fields, text areas, radio groups, checkboxes, date pickers, select lists, popup LOVs, shuttles, and so on. Each type of page item has different properties and attributes that affect its appearance and functionality. Three of the types of page items that can be placed on a page are:
Checkbox: A checkbox is a page item that displays one or more options that can be selected or deselected by the user. A checkbox can have either static values or dynamic values based on a list of values (LOV). A checkbox can also have different display styles, such as pill button or switch.
Date Picker: A date picker is a page item that displays a text field with an icon that opens a calendar popup when clicked. A date picker allows users to enter or select a date value in a specific format. A date picker can also have different attributes, such as minimum or maximum date, display format, or time picker.
Select List: A select list is a page item that displays a drop-down list of options that can be selected by the user. A select list can have either static values or dynamic values based on a list of values (LOV). A select list can also have different attributes, such as multiple selection, null value display text, or cascading LOV.


NEW QUESTION # 55
Select the three ways in which you can create a Form in APEX.

  • A. Using Shared Components
  • B. Using the Create Page wizard
  • C. Create a Form region in Page Designer
  • D. Using the Create Application Wizard

Answer: B,C,D

Explanation:
Explanation
A form is a type of component that is part of an HTML form and can accept user input or display output.
There are many types of forms that can be created in APEX, such as forms on tables, forms on procedures, forms on web sources, and so on. Each type of form has different properties and attributes that affect its appearance and functionality. Three of the ways in which you can create a form in APEX are:
Using the Create Page wizard: This method allows you to create a new page with a form component using a guided wizard. You can choose from different types of forms, such as report with form, editable interactive grid, single page master detail, two page master detail, form on table, form on procedure, and so on. You can also specify various options for your form, such as data source, display style, validations, processes, and branches.
Create a Form region in Page Designer: This method allows you to create a complex form region that includes multiple form items and processes on an existing page. You can use the Create Form Region wizard in Page Designer to create a form region based on a table, view, procedure, web source module, or SQL query. You can also customize your form region by adding or modifying items, buttons, validations, computations, processes, and dynamic actions.
Using the Create Application Wizard: This method allows you to create a new application that contains one or more forms using a guided wizard. You can choose from different types of applications, such as database application, web source application, blueprint application, or from scratch application. You can also specify various options for your application and forms, such as name, icon, theme style, features, data source, navigation menu entry, and so on.


NEW QUESTION # 56
While migrating apps, once the database objects are created in the target environment, you canload the data using which of the components?

  • A. Data Workshop
  • B. Quick SQL
  • C. Data Generator
  • D. App Builder

Answer: A

Explanation:
Explanation
Data Workshop is a feature in Oracle APEX that enables you to load and unload data to and from the database.
You can use Data Workshop to copy data between Oracle databases or between an Oracle database and external files. Data copying is accomplished by exporting and importing data, and by unloading and loading data. While migrating apps, once the database objects are created in the target environment, you can load the data using Data Workshop by following these steps:
Access Data Workshop by clicking Utilities and then Data Workshop in SQL Workshop.
Click Load Data.
Select a data source type, such as Text File (CSV), XML File (XML), Copy & Paste (Spreadsheet), or Object Store Reference (Autonomous Database only).
Specify a file name or location for your data source.
Select a table name for your data destination.
Map your data columns to your table columns.
Review your data load settings and click Load Data.


NEW QUESTION # 57
Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?

  • A. On the remote Oracle Database, install ORDS 19.x or later.
  • B. Create a database link to the remote Oracle Database in the local APEX Schema.
  • C. Install Oracle APEX in the remote Oracle Database.
  • D. REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.

Answer: A,D

Explanation:
Explanation
The REST-enabled SQL feature in Oracle APEX allows developers to execute SQL statements and PL/SQL blocks on a remote Oracle Database by using REST services. The prerequisites to use this feature are:
On the remote Oracle Database, install ORDS 19.x or later.
REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
Create a REST Data Source with REST Enabled SQL as the REST Data Source Type in Oracle APEX.
Create an Authorization Scheme based on the REST Data Source in Oracle APEX. You do not need to create a database link to the remote Oracle Database or install Oracle APEX in the remote Oracle Database to use this feature. Verified References: [Using REST Enabled SQL - Oracle Help Center],
[REST Enabled SQL Service - Oracle Help Center]


NEW QUESTION # 58
Which three of the following are use cases of Automations?

  • A. Monitoring log tables and raising an alert when there is an issue
  • B. Sending email alerts at a particular time of the week
  • C. Deleting a database record based on an end user's request
  • D. Approving specific requests

Answer: A,B,D

Explanation:
Explanation
Automations are a sequential set of PL/SQL actions that are triggered by query results. They are used to monitor data and then perform the appropriate action2. Some use cases of automations are:
Monitoring log tables and raising an alert when there is an issue. For example, an automation can query a log table for any errors and send an email notification to the administrator if any errors are found2.
Approving specific requests. For example, an automation can query a table for any pending requests and approve them automatically based on some criteria2.
Sending email alerts at a particular time of the week. For example, an automation can query a table for any overdue tasks and send a reminder email to the assignees every Monday2.
Deleting a database record based on an end user's request is not a use case of automations, as it does not involve querying data and triggering actions based on the query results. This can be achieved by using a PL/SQL process or a dynamic action on the page where the user requests the deletion34.


NEW QUESTION # 59
What three are the result of the following QuickSQL shorthand notation do?
departments /insert 4
name /nn
location
country

  • A. Inserts 4 rows of random data into the departments table
  • B. Create the departments table with 3 columns
  • C. Creates an id column as a primary key
  • D. Create the departments table with 4 columns

Answer: A,C,D

Explanation:
Explanation
The QuickSQL shorthand notation departments /insert 4 name /nn location country will do the following:
Create the departments table with 4 columns: The first word in the notation is the table name, followed by a slash and the number of rows to insert. The subsequent words are the column names, separated by spaces. QuickSQL will generate a SQL script to create the table with the specified columns and data types.
Creates an id column as a primary key: QuickSQL will automatically add an id column as a primary key to the table, unless the /no_pk modifier is used. The idcolumn will be of type NUMBER and will use an identity constraint to generate unique values.
Inserts 4 rows of random data into the departments table: QuickSQL will use the /insert modifier to insert random data into the table, based on the column names and data types. The number after the modifier indicates how many rows to insert.
The other option is incorrect because:
Create the departments table with 3 columns: This is not what the notation will do. The notation will create the table with 4 columns, not 3.
Verified References: [Using Quick SQL] [About Quick SQL Shorthand Syntax]


NEW QUESTION # 60
What are the three key features of Universal Theme?

  • A. Responsive Design
  • B. Versatile UI Components
  • C. Support for single theme
  • D. Easy Customization

Answer: A,B,D

Explanation:
Explanation
Universal Theme has many features that make it an ideal user interface for Oracle APEX applications. Three of the key features of Universal Theme are:
Versatile UI Components: Universal Theme provides a rich set of UI components that can be used to create interactive and engaging applications. Some of the UI components include cards, lists, charts, calendars, maps, timelines, accordions, tabs, modals, alerts, and more.
Responsive Design: Universal Theme adapts to different screen sizes and devices using CSS media queries and grid layout. It ensures that the applications look good and work well on any device, from desktops to tablets to smartphones.
Easy Customization: Universal Theme allows developers to customize the appearance and behavior of their applications using template options and theme styles. Template options enable developers to apply different styles to components on a page without writing custom code. Theme styles enable developers to change the overall look and feel of the application by choosing from a variety of pre-built styles or creating their own.


NEW QUESTION # 61
There is a validation of type Item is numeric on the P1_SALARY item. When the page is submitted, this or message is displayed both in the notification and below the item: What will cause the validation error to appear only in the Notification area?

  • A. Removing P1_SALARY from the validation Associated Item
  • B. Setting Display Location to Inline in Notification
  • C. Setting the value Required to Yes on P1_SALARY

Answer: A

Explanation:
Explanation
A validation is a rule that checks the data entered by end users before processing it. A validation of type Item is numeric checks if a page item value is a valid number. When the page is submitted, if the validation fails, an error message is displayed both in the notification area (atthe top of the page) and below the item (next to the item label). To cause the validation error to appear only in the notification area, you need to remove P1_SALARY from the validation Associated Item attribute. The Associated Item attribute specifies which page item is associated with the validation and where to display the error message if the validation fails.
Setting the value Required to Yes on P1_SALARY or setting Display Location to Inline in Notification will not affect the validation error display. Verified References: [Creating Validations - Oracle Help Center],
[Validation Attributes - Oracle Help Center]


NEW QUESTION # 62
You can apply an authorization scheme for which three of the following components?

  • A. An entire application
  • B. A session
  • C. A page
  • D. Specific control such as region,item or button

Answer: A,C,D

Explanation:
Explanation
You can apply an authorization scheme for the following components in APEX:
A specific control such as a region, item, or button. You can select an authorization scheme from the Authorization Scheme list on the attributes page of the control. This will control the rendering and processing of the control based on the user privileges12.
A page. You can select an authorization scheme from the Authorization Scheme list on the Security page of the page definition. This will control the access to the page based on the user privileges12.
An entire application. You can select an authorization scheme from the Authorization Scheme list on the Security Attributes page of the application definition. This will control the access to the entire application based on the user privileges12.
You cannot apply an authorization scheme for a session, as a session is not a component in APEX. A session is a stateful connection between a browser and the APEX engine that persists across multiple requests and responses3. You can control session security by using session state protection, session expiration, and session isolation4.


NEW QUESTION # 63
Select the three types of Card Layout you can create in APEX.

  • A. Grid
  • B. Horizontal(Row)
  • C. Vertical(Column)
  • D. Float

Answer: A,B,D

Explanation:
Explanation
You can create two types of card layout in APEX: Float and Grid. Float layout displays cards in a single row that wraps to the next row when the available space is filled. Grid layout displays cards in a fixed number of columns that can be responsive to the screen size1. Vertical and Horizontal are not valid card layout types in APEX.


NEW QUESTION # 64
You can create an APEX workspace and build APEX apps on which of the following platforms?

  • A. Oracle Autonomous Cloud
  • B. Microsoft Azure
  • C. Amazon RDS
  • D. Oracle XE
  • E. All of the above

Answer: E

Explanation:
Explanation
You can create an APEX workspace and build APEX apps on any of the following platforms:
Oracle Autonomous Cloud: This is a cloud platform that provides various services such as Autonomous Database, Oracle Cloud Infrastructure, and Oracle APEX Application Development. You can create an APEX workspace and build APEX apps on an Autonomous Database instance or an APEX Service instance.
Oracle XE: This is a free edition of Oracle Database that supports up to 12 GB of user data. You can install Oracle XE on your local machine and use it to create an APEX workspace and build APEX apps.
Amazon RDS: This is a cloud service that provides managed relational databases. You can create an APEX workspace and build APEX apps on an Amazon RDS for Oracle instance that supports Oracle APEX.
Microsoft Azure: This is a cloud platform that provides various services such as virtual machines, storage, and networking. You can create an APEX workspace and build APEX apps on a Microsoft Azure VM that runs Oracle Database and Oracle APEX.
Verified References: Oracle Autonomous CloudOracle XEAmazon RDSMicrosoft Azure


NEW QUESTION # 65
You must use a Static Content region type to display messages about the employees of the month. Employee names are stored in the P1 ENAME page item. Which text, when placed in Source, will display the message correctly?

  • A. Join me in congratulating v('P1_ENAME') as the new employee of the month!
  • B. Join me in congratulating :P1 ENAME as the new employee of the month!
  • C. Join me in congratulating &P1 ENAME, as the new employee of the month!

Answer: C

Explanation:
Explanation
A Static Content region type is used to display static text or HTML content on a page. To display messages about the employees of the month, you can use a Static Content region type with substitution variables that reference page items. Substitution variables are enclosed in ampersands (&) and can be used to dynamically replace text with values from page items or application items. The correct text to display the message is "Join me in congratulating &P1_ENAME, as the new employee of the month!" The other options are incorrect because they use either colons (:) or v() function, which are not valid ways to reference page items in Static Content regions. Verified References: [Creating Static Content Regions - Oracle Help Center], [Understanding Substitution Strings - Oracle Help Center]


NEW QUESTION # 66
Which two statements are true about creating and managing an APEX Workspace?

  • A. A workspace can be associated with only one schema.
  • B. During workspace creation, you can associate the workspace with an existing databaseschema.
  • C. A workspace enables multiple users to work within the same Oracle APEX installation.
  • D. You can create only two workspaces in an APEX Service(APEX Application Development)instance.
  • E. New schemas cannot be created during workspace creation.

Answer: B,C

Explanation:
Explanation
A workspace is a logical work area that enables multiple users to work within the same Oracle APEX installation while keeping their objects, data, and applications private. Creating and managing an APEX workspace involves the following statements:
During workspace creation, you can associate the workspace with an existing database schema or create a new schema for the workspace. A schema is a collection of database objects such as tables, views, indexes, etc. that belong to a user.
A workspace enables multiple users to work within the same Oracle APEX installation. Each user can have a different role and privilege in the workspace, such as workspace administrator, developer, or end user.
A workspace can be associated with one or more schemas. You can add or remove schemas from a workspace after it is created.
You can create as many workspaces as you need in an APEX Service (APEX Application Development) instance. There is no limit on the number of workspaces per instance.
Verified References: Managing WorkspacesAbout Workspaces


NEW QUESTION # 67
You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page?

  • A. Add Users
  • B. Create Authorization schemes
  • C. Assign roles to users
  • D. Create new application roles

Answer: A,C

Explanation:
Explanation
The Access Control feature pages are a set of pages that allow developers to implement role-based access control for an application. The Access Control feature pages consist of four pages: Administration, Users, Roles, and Role Assignments. The Administration page allows administrators to perform various tasks related to managing users and roles, such as:
Add Users: Administrators can add new users to the application by entering their username, email address, password, status, etc.
Assign roles to users: Administrators can assign one or more roles to users by selecting them from a list of available roles.
Edit Users: Administrators can edit user details such as username, email address, password, status, etc.
Delete Users: Administrators can delete users from the application by selecting them from a list of existing users.
Lock/Unlock Users: Administrators can lock or unlock users by changing their status from active to locked or vice versa. You cannot create authorization schemes or create new application roles using the Administration page. You can create authorization schemes by using Shared Components > Security > Authorization Schemes. You can create new application roles by using Shared Components > Security > Access Control > Roles. Verified References: [Using Access Control - Oracle Help Center], [Creating an Administration Page - Oracle Help Center]


NEW QUESTION # 68
......

Pass Your Oracle Database 1Z0-770 Exam on Nov 16, 2024 with 144 Questions: https://www.passleader.top/Oracle/1Z0-770-exam-braindumps.html

1Z0-770 Free Exam Study Guide! (Updated 144 Questions): https://drive.google.com/open?id=1vsrzMDpfv4S436vyDf9sy642AfdFgFRG