1Z0-760-Apex

Which clause must be used to generate a hierarchical query for the Tree combined?. GROUP BY clause. START WITH clause. START WITH .. CONNECT BY clause. START WITH .. GROUP BY clause.

Examine this message displayed by an application: Application "13549" Page "2" not found. Contact your application administrator. Technical Info (only visible for developers) 1. is_internal_error: true 2. apex_error_code; APEX.PAGE.NOT_FOUND 3. component.type: APEX APPLICATION PAGES 4. component.id: 13549000000002 5 error backtrace: What caused it. The page has a build option with status exclude. he page has Page Access Protection set to No URL Access. The page is set as public but an authorization scheme is set at the applicant. Deep linking is not enabled at the application level. • authorization scheme for which you do not have privilege.

You are required to have a Cards look and feel for a Classic Report. Which action does this?. Under Attributes, Template Options, select the Cards template. Under Attributes, select the Cards template. Under Region, select the Cards template. Under Region, Template Options, select the Cards template.

You must facilitate PL/SQL server-side access to first-time rendered page item without leaving the page. Which two options will independently satisfy this need?. Page render process. Dynamic action. Button click. JavaScript. Computation.

You have created a master detail page on the PROJECTS table using the create page wizard. Only application administrators are to be permitted to access the master detail page. What must you do to meet this requirement?. Set the Page Access Protection attribute as Arguments Must Have Checksum. Set the page Read Only component type as Rows returned and enter the required SQL query to check access. Set the page authorization scheme of Administration Rights. Set the page authentication as Administrator Only. Add a before header validation.

In which two cases can you use classic reports?. • To provide the download option. • To provide optimal reports on smartphones. • To provide options to save your customizations within the application. • To provide basic sort and search options. • To provide the customization option.

You must create an application from a spreadsheet and change the default application ID. There are no other applications on this APEX instance. Which two application IDs are valid for your application?. • 77777. • 101. • B101. • 4500. • A4G000. • 4000. • 000.

Which statement is true about creating master detail forms?. • Wizard generated master detail forms also automatically create validations for some columns. • A Drill Down master detail form can be created using the Create Application wizard. • A Stacked master detail form includes a single page master-detail utilizing side by side layout and report regions with modal edit windows. • A Side by Side master detail form cannot be created using an external data source.

Examine this page: Read Only condition specified for item P4_COMMENTS: Type: Never No other Read Only conditions are specified for any other components. Which statement is true?. • P4 COMMENTS will display as read only, when the value of application item AI_EDIT_MODE is NULL in the session state. • P4 COMMENTS will display as read only, when the value of application item AI_EDIT_MODE is N in the session state. • P4_NAME will display as read only, when the value of application item AI_EDIT_MODE is NULL in the session state. • P4_NAME will display as read only, when the value of application item AI_EDIT_MODE is N in in the session state.

Which two statements are true about REST Data Synchronization to a local table?. • When you configure data synchronization, if no synchronization step is defined, the REST Data Source will not be invoked. • You can add additional columns to a synchronized table. • If you clear synchronization settings, APEX components using the synchronization table will be reset to use the REST Service directly. • To use the Replace synchronization type, the Data Profile must have a primary key defined. • Data synchronization does not work if the table is not in sync with the Data Profile.

Your application includes a form page that does not display data as expected. You decide to review session state information while debugging the form. Which action helps do this?. • Add a debug flag to the application URL and rerun the page. • View page source information in your browser. • Click the Session button on the Runtime Developer toolbar. • Navigate to Page Designer and set the session state items to "Display Only" type.

You are developing a new APEX application requiring specific templates for the Interactive Report and Wizard regions. How can you accomplish this requirement?. • Create a new theme from the Repository. • Copy an existing theme, and then modify the region templates based on the requirements. • Run the application, execute Theme Roller, and select a style that meets the requirements. • Run the application, execute Quick Edit, and define the properties to meet the requirements.

Which statement is true about creating a Calendar in your APEX application?. • Ability to download events in PDF printable format is not supported. • Ability to render events titles on multiple lines is supported. • Ability to add tooltip on Month/Week/Day views is not supported. • Drag and drop is supported both for local data sources and on external data sources.

Which two statements are true about workspace in Oracle APEX?. • New schemas can be created and associated during workspace creation. • They can be associated only with one schema. • They are not associated with any schemas. • They can be associated with multiple schemas from different databases. • They can be associated with multiple schemas in the same database.

Which two statements are true about exporting an application?. • Report Subscriptions are not transferable to other workspaces. • Private Reports can be exported. • The Automations are included by default. • Developer Comments cannot be included in an application export. • Original IDs cannot be preserved in an application export.

Examine these statements: dept/audit name /nn age num emp / auditcols name/nn email / unique position/values manager, clerk, Engineer. dept /auditcols name / nn age num emp /audit name /nn email /unique postion /check manager, clerk, engineer. dept / audit name / nn agge num emp / auditcols name/ nn email / unique position / values manager, clerk, engineer. dept / auditcols name/nn age num.

You must generate an SQL insert statement for the DEPT table in Quick SQL. Which two statements will do that?. dept /insert 1 name. dept /insert name. dept/ insert 1 name. /insert 1 dept name. dept name /insert 1.

Examine this code used in Quick SQL: students name roll no num Quick SQL is using default settings. Which table creation script or other output is produced?. create table students ( id number not null constraint students_id_pk primary key, name varchar2 (255), roll varchar2 (255), no number ). Invalid column definition error message will be displayed. create table students ( id number not null constraint students_id_pk primary key, name varchar2 (255), “roll no” number );. create table students ( id number not null constraint students_id_pk primary key, name varchar2 (255), roll_no number );.

For which three options can Quick SQL generate scripts?. Function-based indices. Before insert triggers. Database jobs. Sequences // auto generate. Bitmap indices. Unique indices. Domain indices.

Which two statements are true about an end user customizing interactive reports?. • Mathematical computations can be added to columns. • Standard oracle functions cannot be added to columns. • From the Actions menu, multiple charts can be created for each interactive report. • A flashback query can be executed. • A break group of several columns cannot be created.

For which two events does a page item's session state get updated without further steps?. • When choosing a select list item value. • On page submit. • When pressing the Enter key. • When dynamic action with page items to submit are specified (possible). • On a button click.

You must prevent users from modifying any hidden item values using JavaScript. Which setting will do this?. • The Session State Protection property must be checksum Required User Level. • The Store value encrypted in session state property must be Yes. • The Read Only condition must be Always. • The Session State Protection property must be Checksum Required - Session Level. • The Session State Protection property must be checksum Required – Application Level. • The Value Protected property must be Yes.

In an application, an authorization scheme named Administration Rights is applied which hides component from unauthorized users. Which step ensures that the component is visible but read-only to unauthorized users?. Use Expression as the Read Only condition type. As the PL/SQL expression, use not APEX_AUTHORIZATION.IS_NOT_AUTHORIZED ('Administration Rights'). Use Expression as the Read Only condition type. As the PL/SQL expression, use APEX_AUTHORIZATION.IS_AUTHORIZED ('Administration Rights'). Use Expression as the Read Only condition type. As the PL/SQL expression, use not APEX_AUTHORIZATION.IS_AUTHORIZED ('Administration Rights'). Use Expression as the Read Only condition type. As the PL/SQL expression, use APEX_AUTHORIZATION.IS_NOT_AUTHORIZED ('Administration Rights').

Now you must extend the functionality of this form so that: If you select 'SALESMAN' from the select list for Job page item (P2_JOB), both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are displayed . If you select any other value from the select list for Job page item (P2_JOB), both the 'Hire date (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are hidden Which two steps must be performed to achieve this?. • Create a dynamic action on form load. • Specify a Client-side Condition of type Item = Value and enter SALESMAN for Value. • Create a dynamic action on P2_JOB. • Create a dynamic action on P2_JOB, P2 HIREDATE and P2_COMM. • Action on P2 HIREDATE and P2_COMM.

In a faceted search page, facets can display as different UI types. Which two facet item types are supported in the faceted search region?. • Date Picker. • Checkbox Group (Checkbox, Radio Group, Select List, Range, Search). • Range. • Popup LOV. • Switch.

Which two statements are true about Faceted Search pages?. • A facet's chart can be seen only in a non-modal dialog. • Facet groups can be created for data models having multiple flag columns. • Search results can be displayed in either report or cards view. • Multiple charts are not visible in the same region. • Facets are auto-discovered for pages built on views or SQL queries.

Clicking the Show Chart icon for a particular facet of the Employees Search faceted search Which is true about the Faceted Search page display when viewing the page?. •When a user clicks Show Chart for multiple facets, the corresponding chart for each facet is displayed in dashboard mode but the search results region is not displayed. •When a user clicks Show Chart for a particular facet, only the chart is displayed but the search results region is not displayed. • When a user clicks Show Chart for multiple facets, the corresponding chart for each facet is displayed in dashboard mode and the search results region is displayed. • been popup dialog and dashboard modes.

Which statement is true about using Live Template Options?. •Using Live Template Options, you can create a new theme style. • Using Live Template Options, you can alter a component's template options without refreshing the page. • Using Live Template Options, you can create a global template option. • Using Live Template Options, you can create template option groups.

A faceted search page was created based on the EMP table Examine the exhibit and view the Department and Commission facets on the left side of the page. The item names for these facets are P1 DEPARTMENT and P1_COMMISSION, respectively. The Commission must be shown only when the Department facet value is SALES. Which option will do this in Page Designer?. •Create a Dynamic Action on change of the P1_DEPARTMENT facet with Client-side condition as Item Value and enter the item as P1 DEPARTMENT and value as SALES. Then create a TRUE action to hide the P1 COMMISSION facet. • Set the attribute Zero Count Entries to Hide for the P1 COMMISSION facet. • Create a Dynamic Action on page load and set a True action to hide the P1_COMMISSION item when P1 DEPARTMENT = SALES. • In the P1 COMMISSION facet, select the Server-side Condition Type as Item = Value and enter the item as P1 DEPARTMENT and value as SALES. • In the P1 COMMISSION facet, under the Depending on attribute, select P1_DEPARTMENTal to and value as SALES.

In the Create Application Wizard, you clicked the Add Page button to create a Form page and also selected the Include Report check box. Which report is generated by default?. • Interactive Report. • Classic Report. • Interactive Grid. • Editable Interactive Grid Report.

Which three are valid process types of a Page Process?. Ajax Callback. Reset Pagination. Send E-Mail. Close Dialog. Set Value. Static Assignment • Execute JavaScript Code.

Which statement is true about branching pages in an application?. • A dialog page never branches to a normal page. • A dialog page can branch to another dialog page. • A branch is never conditional. • For a Redirect page branch type, the browser performs no additional request to show the page.

Which two statements are true about authentication schemes?. • Open Door Credentials authentication utilizes database schema accounts to authenticate users. • Two-factor authentication can be implemented in an APEX app. • Social Sign-In authentication requires that a database user exist in the local database. • LDAP Directory authentication utilizes database schema accounts to authenticate users. • When running custom authentication, APEX attempts to prevent inadvertent access to a stale session state.

An interactive report returns 10000 rows. You then perform these actions: 1. Set the Maximum Rows to Process attribute to 100. 2. Set the Maximum Rows Per Page attribute to 10000. 3. Rerun the report. Which is true?. • The report query processes 10000 rows. • The Rows per Page selector displays a maximum of 10000 rows. • The report query is limited to 100 rows. • A warning message is triggered and the report displays 10000 rows. •The report includes 10000 rows with a maximum of 100 rows displayed per page.

Which two statements are true regarding Interactive Reports?. • It is possible to restrict users from saving Private Reports by using the Authorization Scheme. (users can save public reports by authorization). • It is impossible to customize a label for the Search button. • It is impossible to specify an Authorization Scheme at the column level. • When creating an Interactive Report page using the create page wizard, it is possible to use User Interface Defaults defined for the table or view. • It is possible to specify an Alias for Public Reports.

An application includes a form on the EMPLOYEES table. You must limit the P5 MANAGER page item so users can select a single employee name EMP_NAME instead of employee ID EMP_ID. Examine this statement used for the List of Values definition: SELECT emp_name d, emp_id r from employees ORDER BY 1 Which three item types can be used to display P5_MANAGER?. • Select List. • Shuttle. • Radio Group. • Check Box. • Switch. • POP LOV.

Which two statements are true about Page Computations?. • It is used to assign a value to an identified page item when a page is submitted or displayed. • You can create an After Processing computation to assign a value to a page item. • You can assign a value to multiple page items in a single computation. • It is used to assign a value to an application item. • You cannot create a computation on other page for Page 0 (Global Page) item.

A classic report displays employees filtered by the department value stored in the :P1_DEPARTMENT item. You must create a dynamic action to refresh the report when the value of : P1 DEPARTMENT changes. Which two options are required for the refresh to work?. • The Partial Page Refresh report attribute must be enabled. • The Partial Page Refresh report attribute must be disabled. • The Fire on Initialization attribute must be enabled. • The Event Scope attribute must be set to Dynamic. • :P1 DEPARTMENT must be listed in the Page Items to Submit report attribute. • The Event Scope attribute must be set to static.

Which three are automatically managed by the Oracle APEX Application Development Service?. • Backups. • Data loading. • High availability. • Firmware patching. • User workspace creation. • Restore and recover operations. • Masking sensitive data.

Which two statements are true about low code applications built using Oracle APEX Application Development Service on OCI?. • They can be easily scaled up. • They provide great quality and consistency with low maintenance. • They include Oracle Machine Learning Zeppelin notebooks. • They can be used to evaluate and deploy predictive models. • They can be used for data mining. • They are used to build mobile apps only.

Which two statements are true about the Oracle APEX Application Development service?. • It supports Oracle Net Services (SQL*Net) connectivity. • It limits the number of applications to be deployed. • It includes Oracle Machine Learning (OML) Zeppelin notebook. •It provides a preconfigured middle tier with Oracle REST Data Services (ORDS) and SQL Developer Web. •The database and Oracle APEX that provides the Application Development service are both automatically patched and upgraded.

Which are two of the benefits of building a plugin?. • It improves code maintenance. • It improves code reusability. • It ensures compatibility with future APEX versions. • It improves code formatting. • It keeps the same visual style as the standard APEX Components.

Which two approaches can be used to create custom stored procedures in SQL Workshop?. • Using Procedure Builder. • Using SQL Scripts. • Using standalone SQL commands. • Generating DDL. • Using Data Workshop. • Using Quick SQL.

Which two statements are true about creating and using REST-enabled SQL Service References?. • When you export an application, by default, used REST-enabled SQL references are not added to the export file. • REST-enabled SQL Service References works with JSON over HTTP and HTTPS. • REST-enabled SQL Services are stored at the application level and therefore cannot be used by other applications in a workspace. • You can create a query on a REST-enabled SQL Service and can join it to a local table. • You can use REST-enabled SQL references for master detail forms.

You must create an application from an Excel file and use a blueprint to customize it. Which three options are true about the Application Blueprint?. • It provides a way to enable application features. • It creates underlying tables for the application. • It creates pages based on relevant JSON code. • It can be replaced with the definition from a previously generated application. • It stores the records from the Excel file within the blueprint. • It creates pages based on relevant XML code.

The Employees Interactive Grid Actions menu lacks an option to download the report as a PDF. A developer wants to: • Utilize native printing capability • Provide the PDF download option for the Employees Interactive Grid Which are two steps that are both required to do this?. • Configure print settings at the instance level and select the Native Printing option for Print Server. • Edit the Interactive Grid Download attribute and select the Administration Rights option for Authorization. • Edit application properties and select the Native Printing option for Print Server Type. • Configure print settings at the instance level and select the None option for Print Server. Edit the Interactive Grid attributes and turn on the Download option for Enable Users To.

You must implement authorization rights across an interactive grid. Which three interactive grid actions can be restricted by using an Authorization attribute?. • Deleting records. • Customizing the toolbar. • Customizing the report layout. • Saving a primary report. • Downloading the report. • Deleting the report. • Saving a public report.

Which two statements are true about creating and using pages in an APEX application?. • Deleting a page does not delete corresponding breadcrumbs, nor list entries. • Modal and non-modal dialog pages are supported only if the current application theme contains at least one page template of type Dialog Page. • You can copy a page only from the current application. • A user cannot interact with a non-modal dialog and content on the page. • Feature pages can be added only once per application.

An Interactive Report has the LINK COLUMN value under LINK set to Link To Custom Target. The pencil icon must be selectively displayed or hidden based on the value of any of the other columns. Which action does this?. • Use the LINK ATTRIBUTES field to set a custom CSS based on a column value. • Modify the SQL QUERY under SOURCE to hide or display the link based on a column value. • Set an expression in CONDITION TYPE based on a column value. • Use the AUTHORIZATION SCHEME and set a custom scheme based on a column value.

Which statement is true about Theme Style?. • You can only enable the Is Current attribute when the Theme Style has the Read Only attribute disabled. • When the Is Public attribute is disabled, end users can choose the Theme Style. • Developers can change the Theme Style in Theme Roller when the Read Only attribute is enabled but they must save as a different Theme Style. •Updating the new style in Theme Roller is always possible when the Is Public attribute is enabled.

There is a validation of type Item is numeric on the P1_SALARY item. When the page is submitted, this error message is displayed both in the notification and below the item. What will cause the validation error to appear only in the Notification area?. • Add JavaScript to the item. • Display Location : Inline in Notification I added it hASAN. • Remove P1 SALARY from the validation Associated Item. • to Yes on P1 SALARY.

Users must be able to easily filter information by: 1) Selecting options in each facet 2) Displaying a number of charts regarding these facets Which is the simplest approach to implement the requirement?. • Add a Faceted Search Report Page and add a chart for each facet. • Add an Interactive Report Page and add a chart for each facet. • Add a Faceted Search Report Page. • Add a Dashboard Page and add different types of items to filter data.

Activity Reporting, Feedback, and Access Control are some features that you can add to your application when you are creating it. How could you add one of these features to your existing application?. • On the Create Application page, check the feature or features you will need in your application. • On the application Home page, click create page and select feature to add the feature you will need in your application. • In page designer, navigate to regions and drag the feature component you will need in your application. • On the application Home page, click shared components and navigate to build options to enable the functionality you will need in your application.

You must create a single master detail page where users can select a row in the master grid is to update tje details grids Users must also interact with the master on the detail witchou leaving the page Witch type of master detail implementation should you use?. Side by side. Drill Down. Two customized interactive grids to manage the tables of view related. Stacket.

Which statement is true about creating applications for mobile devices?. • Universal Theme provides all the components necessary to build any type of business application user interface. • Oracle APEX does not provide forms optimized for mobile environments. • The responsive design provided by Universal Theme works well only on small screen devices such as smartphones and tablets. • You cannot customize the look and feel of an application with Universal Theme.

Which two statements are true about creating applications using Oracle APEX?. • Oracle APEX application pages share a common session state and authentication. • Once an application is created, you can modify the application attributes but cannot create additional pages. • Using the Create Application Wizard you can only create application based on existing tables. • When creating an application from a file, you can only load data to a new table but not to an existing table. • Each iteration of the Create Application Wizard saves an application blueprint which you can reuse.

You must add an end user and remove a developer user from an application workspace. What privilege is required to make this change?. • Workspace Administrator. • Workspace Contributor. • Workspace Developer. • Oracle Database Administrator.

An application was created using the Create Application wizard which enabled the Access Control Feature. Which two components are created when enabling the Access Control feature?. • The configuration page to enable Administrators to select default there. • The configuration page to enable end users to select various theme styles. • The configuration page to set access level of authenticated users. • The administrative page region with links to access control features. • The configuration page to set roles of workspace users.

You must create a single master detail page where users can select a grid to update the detail grids. Users must also interact with the master or the detail without leaving th Which type of master detail implementation should you use?. • Stacked. • Two customized interactive grids to manage the tables or views related. • Drill Down. • Side by Side.