DATABASE Final Exam Reviewer [TERMS]

LETSS GO!!😊

YOU CAN DO IT!!😊

The ______ clause is used in DML statement to specify variable(s) that will hold the value(s) that SQL returns from the SELECT clause.

INTO

The _________ cursors are defined by the PL/SQL programmer.

EXPLICIT

The ______ is a Boolean attribute that evaluates to TRUE if the most recent SQL statement did not return even one row.

SQL%NOTFOUND

The _____ statement selects rows from one table to update and/or insert into another table.

MERGE

The _____ is an integer value that represents the number of rows affected by the most recent SQL statement.

SQL%ROWCOUNT

An integer value that represents the number of rows affected by the most recent SQL.

Group of answer choices

SQL%NUMROW

SQL%ROWCOUNT

SQL%COUNT

SQL%COUNTROW

SQL%ROWCOUNT

The DDL and _______ SQL statements cannot be used directly in PL/SQL.

DCL

The memory area allocated by Oracle server to store the SQL statement and the data that it uses in known as __________.

IMPLICIT CURSOR

The memory area allocated by Oracle server to store the SQL statement and the data that it uses in known as:

Group of answer choices

View

Cursor

Implicit Cursor

Explicit Cursor

Implicit Cursor

Which DML statement make changes to the database?

Group of answer choices

All the options

UPDATE

INSERT

DELETE

All the options

Which SQL statements cannot be used directly in PL/SQL?

Group of answer choices

TCL

DML

DDL, DCL

DML, TCL

DDL, DCL

The ______ are automatically declared variables that allow you to evaluate what happened when a cursor was last used.

Group of answer choices

Cursor attributes

Implicit attributes

Explicit attributes

Attributes

Cursor attributes

The ______ is the symbol used for the assignment operator.

Group of answer choices

=

:=

:=

The use of CASE statement to test conditions such as <, >, >=, <= is know as:

Group of answer choices

Conditional CASE Expression

Equality CASE statement

Non-equality CASE statement

Searched CASE statement

Searched CASE statement

A _______ is an expression with a TRUE or FALSE value that is used to make a decision.

Group of answer choices

Conditional statement

Condition

Nested-if

ELSE

Condition

The type of loop where the statement inside the loop must execute at least once.

BASIC LOOP

A ________ is used in order to come out of from the outer loop within an inner loop.

EXIT

The ______ is a Boolean attribute that evaluates to True if the most recent SQL statement returned at least one row.

SQL%FOUND

The _________ SQL Rule: queries must return only one row.

SINGLE ROW

You can change the logical flow of statements within the PL/SQL block by using:

Group of answer choices

Subprograms

Looping statements

Control structures

Conditional statements

Control structures

In for loop, counter variable is declared _______.

IMPLICITLY

dl link for m1s3 reference:https://feu.instructure.com/courses/98146/files/25247978/download?wrap=1

Refer to M1S3-code reference#1, what is missing in the creation of the implicit cursor inside the loop body? _______

VCTR

The _______cursor are automatically defined by Oracle.

IMPLICIT

The _______ are used to change the logical flow of statements within the PL/SQL block.

Group of answer choices

Control Structures

Conditional statement

Looping statement

CASE statement

Control Structures

The use of INTO clause in PL/SQL select statement is to specify the name of: ____________.

Group of answer choices

TABLE

VIEW

CURSOR

VARIABLE

VARIABLE

Use the ______ loop when the statement inside the loop must execute at least once.

BASIC

The DML statement: INSERT, DELETE, ________ make changes to the database.

UPDATE

The _______ statement selects rows from one table to update and/or insert into another table.

Group of answer choices

DML

COMBINE

SELECT, INSERT, UPDATE

MERGE

MERGE

The _______ is an expression that returns true, false, or null.

Group of answer choices

CASE STATEMENT

CONDITION

Counter variable

IF STATEMENT

CONDITION

The use of INTO clause in PL/SQL select statement is to specify the name of ________.

VARIABLES

The INTO clause occurs between the _______ and FROM clauses.

SELECT

The INTO clause occurs between the SELECT and _______ clauses.

FROM

The ______ are automatically declared variables that allow you to evaluate what happened when a cursor was last used.

CURSOR ATTRIBUTES

A ________ allows us to declare a variable as a record based on a particular table's structure.

%ROWTYPE

Each ________ is consists of a WHEN clause, which specifies an exception name.

HANDLER

The exception section begins with the keyword _______.

EXCEPTION

When an exception is raised, control immediately shifts to the _______ and the appropriate handler in the exception section is executed.

EXCEPTION SECTION

PL/SQL records contain one or more components/fields of any _______ or composite type.

SCALAR

In trapping a user-defined exception, these steps must be followed: DECLARE -> RAISE -> __________.

Group of answer choices

Not in the options

Exception Handling

Reference

Identify Exception

Reference

Code that defines the recovery actions to be performed when execution-time errors occur.

EXCEPTION HANDLER

The _______ is an optional exception-handling clause that traps any exceptions that have not been explicitly handled.

OTHERS

TYPE and ________ are composite structures.

RECORDS

The term ________ in exceptions is the same as handling any error by including corresponding exception handler.

TRAP

Error in PL/SQL is known as ____________.

EXCEPTION

The ________ clause is used in user-defined exception to tell the compiler to associate an exception name with a specific Oracle error

Group of answer choices

RAISE_APPLICATION_ERROR

PRAGMA EXCEPTION_INIT

Not in the options

SQLCODE, SQLERRM

PRAGMA EXCEPTION_INIT

Each exception handler is consists of a _____ clause, which specifies an exception name.

WHEN

You must include the FOR UPDATE clause in the cursor query so that the rows are locked on _____.

OPEN

The RAISE statement can be used to raise either user-defined or ________ exception.

Group of answer choices

NON-PREDEFINED

PREDEFINED

PREDEFINED

You can use the ________________ procedure to return user-defined error messages from stored subprograms.

Group of answer choices

PRAGMA EXCEPTION_INIT

SQLCODE

RAISE_APPLICATION_ERROR

SQLERRM

RAISE_APPLICATION_ERROR

Start with the _____ keyword to define a user-defined record structure.

TYPE

In explicit cursor operations, the set of rows returned by a multiple-row query is called ________.

Group of answer choices

Active set

Record set

Active Cursor

Cursor

Active set

What are/is the type of exception can be raised using the RAISE statement?

Group of answer choices

Pre-defined, User-defined

User-defined

NON-PREDEFINED

Non-predefined, User-defined

Pre-defined, Non-predefined

Pre-defined, User-defined

The ___________ and ___________ are the two types of Oracle Server Errors.

Group of answer choices

Predefined, Non-predefined

Implicit, Explicit

Predefined, Non-predefined

In non-predefined exception, you must reference the ________ within a WHEN clause in the exception-handling section.

Group of answer choices

Oracle associated error#

Declared exception name

Exception name

All the options are possible

Declared exception name

Each exception handler is consists of a _____ clause, which specifies an exception name.

Group of answer choices

WHEN

IF

Not in the options

CONDITION

WHEN

In exception section, the WHEN clause if followed by _______.

EXCEPTION NAME

You must include the ________ clause in the cursor query so that the rows are locked on OPEN.

FOR UPDATE

If you omit the ______ keyword, then the Oracle server waits indefinitely until the rows are available.

NOWAIT

The ______ returns character data containing the message associated with the error number.

Group of answer choices

SQLCODE

SQLERRM

SQLERRM

Oracle server errors that has name

PREDEFINED

The _______________ is used in non-predefined exception to tell the compiler to associate an exception name with a specific Oracle error

Group of answer choices

PRAGMA EXCEPTION INIT

EXCEPTION INIT

PRAGMA EXCEPTION_INIT

EXCEPTION_INIT

PRAGMA EXCEPTION_INIT

The oracle error number, at the PRAGMA EXCEPTION_INIT function, starts with _____.

Group of answer choices

0

1

UNDERSCORE

HYPEN

HYPEN

What is the first step in handing non-predefined exception?

Group of answer choices

Exception name declaration

Pragma declaration

Exception name declaration

The RAISE_APPLICATION_ERROR can be used in:

Group of answer choices

Executable and Exception section

Executable section

Exception section

Declaration and Exception section

Executable and Exception section

PL/SQL records contain one or more components/fields of any SCALAR or ______ type.

COMPOSITE

Trying to duplicate a primary key value is an example of:

Group of answer choices

Data error

System error

User-action error

Other error

User-action error

The __________ clause is used in conjunction with the FOR UPDATE clause to refer to the most recently fetched row in an explicit cursor.

WHERE CURRENT OF

The declared non-predefined exception is raised ____________.

Group of answer choices

IMPLICITLY

EXPLICITLY

IMPLICITLY

The __________ keyword is used in user-defined exception for error notification.

RAISE

The ___________ contains the exceptions handlers.

EXCEPTION SECTION

Handle named exceptions whenever possible, instead of using ______ in exception handlers.

OTHERS

Always add ________ whenever there is a possibility of an error occurring.

EXCEPTION HANDLER

The following statements are examples of ________________.

Entering an expiration date that has passed

Selecting more than one row into a single variable

Receiving "no rows returned" from a select statement

EXCEPTION

How many number of exception handlers can be included in the exception section?

Group of answer choices

1 OR MORE

3

2

1

1 OR MORE

Two methods for raising an exception: Implicit, ________.

EXPLICIT

The ________ clause is used in non-predefined exception to tell the compiler to associate an exception name with a specific Oracle error

Group of answer choices

PRAGMA EXCEPTION_INIT

RAISE_APPLICATION_ERROR

SQLERRM

SQLCODE

PRAGMA EXCEPTION_INIT

What is the first parameter of the PRAGMA EXCEPTION_INIT function?

Group of answer choices

Oracle error number

EXCEPTION NAME

EXCEPTION NAME

The RAISE statement can be used to raise either ________ or predefined exception.

Group of answer choices

NON-PREDEFINED

USER-DEFINED

USER-DEFINED

The NO_DATA_FOUND is an example of:

Group of answer choices

Predefined exception

Non-predefined exception

Predefined exception

The NO_DATA_FOUND is a _______ exception.

Group of answer choices

PREDEFINED

USER-DEFINED

NON-PREDEFINED

PREDEFINED

In anonymous block, DECLARE states "this is the start of a block". In Procedure, ____________ states "this is the start of a subprogram".

CREATE PROCEDURE

The executable section of the procedure body requires a minimum of _____ statement.

ONE

The _____ are named PL/SQL blocks that are compiled and stored in the database.

SUBPROGRAM

The _______ is added to CREATE PROCEDURE clause to overwrite an existing procedure.

OR REPLACE

Which parameter mode can be assigned a default value?

IN

OUT

IN OUT

Group of answer choices

OUT

IN OUT

IN

IN

The purpose of the OR REPLACE clause is to ______ an existing procedure.

OVERWRITE

A function can be called as a part of:

Group of answer choices

PL/SL expression

Not in the options

SQL statement

SQL statement, PL/SQL expression

SQL statement, PL/SQL expression

In PL/SQL ___________, the function identifier acts like a variable whose value depends on the parameters passed to it.

EXPRESSIONS

In PL/SQL ___________, the function identifier acts like a variable whose value depends on the parameters passed to it.

Group of answer choices

EXPRESSION

PARAMETER

STATEMENT

SELECT

EXPRESSION

The functions used in SQL statements cannot use OUT or _____ modes.

IN OUT

What is the symbol used for association operator?

Group of answer choices

>=

=

=>

>>

=>

Using an _______ parameter mode, you can pass a value into a procedure that can be updated within the procedure.

Group of answer choices

OUT

IN OUT

All the options

IN

IN OUT

Which type of parameter passing uses an association operator?

Group of answer choices

Positional

Combination

Named

IN OUT

Named

Subprograms are named PL/SQL blocks that are compiled and stored in the _______.

DATABASE

A function can be called as a part of:

Group of answer choices

SQL statement

Both options

PL/SL expression

Both options

A function must have a _______ clause in the header and at least one RETURN statement in the executable section.

RETURN

Functions return only a single value, and the value is returned through a ______ statement.

RETURN

The operator => is called _______.

Group of answer choices

Association operator

Reference operator

Referencing operator

Associate operator

Association operator

The type of parameter that is declared in procedure heading is called ________.

Group of answer choices

FORMAL

ACTUAL