Curious about Actual Oracle Database (1Z0-770) Exam Questions?

Correct : B, C, D

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.

Correct : B

Oracle APEX provides several preconfigured authentication schemes that follow a standard behavior for authentication and session management. You can select a preconfigured authentication scheme from the gallery when you create an authentication scheme for your application. The preconfigured authentication schemes are:

Open Door Credentials: This scheme enables anyone to access your application using a built-in login page that captures a user name.

LDAP Directory: This scheme authenticates a user and password with an authentication request to a LDAP server.

HTTP Header Variable: This scheme authenticates users externally by storing the username in a HTTP Header variable set by the web server.

Social Sign-In: This scheme supports authentication with Google, Facebook, and other social networks that support OpenID Connector OAuth2 standards.

Oracle APEX Accounts: This scheme authenticates users against Oracle APEX user accounts that are created within and managed in the APEX user repository.

Custom Authentication: This scheme allows you to create a custom authentication scheme from scratch to have complete control over your authentication interface.

Database Accounts: This scheme authenticates users using database schema accounts.

Oracle Application Server Single Sign-On Server: This scheme delegates authentication to the Oracle AS Single Sign-On (SSO) Server.

SAML Sign-In: This scheme delegates authentication to the Security Assertion Markup Language (SAML) Sign In authentication scheme.

Correct : A, B, C

In Oracle APEX, you can choose from different authentication methods to establish a user's identity and control access to your application. Authentication may require a user to provide some type of credentials, such as a user name and password, or could involve the use of digital certificates or a secure key. Three of the authentication methods that you can choose in Oracle APEX are:

Custom Authentication Scheme: This method allows you to create your own authentication logic using PL/SQL code or an external web service. You can also customize the login page and session management for your application.

No Authentication (using DAD): This method adopts the current database user as the authenticated user. This approach can be used in combination with a mod_plsql Database Access Descriptor (DAD) configuration that uses basic authentication to set the database session user.

Built-in Authentication Scheme: This method allows you to use one of the preconfigured authentication schemes that ship with Oracle APEX, such as Open Door Credentials, LDAP Directory, Social Sign-In, and so on.

Correct : A, B, C

A calendar is a type of component that enables users to view and manage data based on dates. A calendar can display data in different views, such as monthly, weekly, daily, or list. Users can also interact with the calendar by creating, editing, or deleting events, or by using drag and drop functionality. Three of the features of a calendar in Oracle APEX are:

Next - Navigates to the next month. This feature allows users to move forward in time and see the events for the following month.

Previous - Navigates to the previous month. This feature allows users to move backward in time and see the events for the previous month.

Month, Week, Day - Displays a monthly, weekly and daily view. These features allow users to switch between different views of the calendar and see the events for a specific month, week, or day.

Correct : A, C

The generated SQL script creates two tables: DEPARTMENTS and EMPLOYEES, with the specified columns and data types. It does not insert any data into the tables, nor does it create any primary or foreign keys. The script only creates the tables and their columns. References:Creating a Desktop Database ApplicationandUsing SQL Workshop