wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Database

Total questions: 192

Worksheet time: 2hrs 36mins

Name
Class
Date
1.

is a combination of SQL along with the procedural features of programming languages.

a)

PL/SQL

b)

SQL

c)

SQL *PLUS

d)

Standard Query Language

2.

who developed PL/SQL

a)

Oracle Corporation

b)

Linux

c)

MySQL

d)

Microsoft

3.

what year enhances the capabilities of SQL

a)

1978

b)

1980s

c)

1990s

d)

2001

4.

One of the Three key programming languages embedded in the Oracle Database, along with SQL itself and Java

a)

PL/SQL

b)

Python

c)

C#

d)

Ruby

5.

PL/SQL is a

a)

programming language

b)

robust language

c)

strongly typed language

d)

case sensitive language

6.

What year Oracle Database developed PL/SQL?

a)

late 1980s

b)

before 1990s

c)

late 1990s

d)

late 1970s

7.

In late 1980s as ____________ for SQL and the Oracle relational database.

a)

procedural extension language

b)

programming language

c)

procedures extensible language

d)

procedural extensive language

8.

Notable Facts of PL/SQL

a)

is a completely portable, high-performance transaction-processing language

b)

provides a built-in, interpreted and OS independent programming environment.

c)

directly be called from the command-line SQL*Plus interface.

d)

is tightly integrated with SQL

e)

It offers extensive error checking.

9.

Notable Facts of PL/SQL

a)

Direct call can also be made from external programming language calls to database

b)

directly be called from the command-line SQL*Plus interface

c)

provides a built-in, interpreted and OS independent programming environment

d)

completely portable, high-performance transaction-processing language

e)

tightly integrated with SQL

10.

Notable Facts: completely portable, high-performance transaction-processing language

a)

True

b)

False

11.

Notable Facts: provides a built-in, interpreted and OS independent programming environment

a)

True

b)

False

12.

Notable Facts: directly be called from the command-line SQL*Plus interface

a)

True

b)

False

13.

Notable Facts: extensive error checking

a)

True

b)

False

14.

Notable Facts: tightly integrated with SQL

a)

True

b)

False

15.

Notable Facts: numerous data types

a)

True

b)

False

16.

Features of PL/SQL: structured programming through functions and procedures

a)

True

b)

False

17.

Features of PL/SQL: object-oriented programming

a)

True

b)

False

18.

Features of PL/SQL: the development of web applications and server pages

a)

True

b)

False

19.

Features of PL/SQL.

a)

tightly integrated with SQL

b)

extensive error checking

c)

numerous data types

d)

variety of programming structures

e)

made from external programming language calls to database

20.

Features of PL/SQL: tightly integrated with SQL

a)

True

b)

False

21.

Features of PL/SQL: extensive error checking

a)

True

b)

False

22.

Features of PL/SQL: numerous data types

a)

True

b)

False

23.

Features of PL/SQL: variety of programming structures

a)

True

b)

False

24.

SQL is the ____________________________

a)

standard database language

b)

structure database language

c)

procedures database language

d)

procedural database language

25.

PL/SQL is strongly integrated with SQL

a)

True

b)

False

26.

PL/SQL supports both static and dynamic SQL

a)

True

b)

False

27.

Dynamic SQL supports DML operations and transaction control from PL/SQL block

a)

True

b)

False

28.

Static SQL supports DML operations and transaction control from PL/SQL block

a)

True

b)

False

29.

Dynamic SQL, SQL allows embedding DDL statements in PL/SQL blocks

a)

True

b)

False

30.

Static SQL, SQL allows embedding DDL statements in PL/SQL blocks

a)

True

b)

False

31.

________ SQL supports DML operations and transaction control from PL/SQL block

a)

Static

b)

Dynamic

c)

TCL

d)

DDL

32.

PL/SQL Advantages: PL/SQL allows sending an entire block of statements to the database at one time. This reduces network traffic and provides high performance for the applications

a)

True

b)

False

33.

PL/SQL Advantages: PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database

a)

True

b)

False

34.

PL/SQL Advantages: PL/SQL saves time on design and debugging by strong features, such as exception handling, encapsulation, data hiding, and object-oriented data types

a)

True

b)

False

35.

PL/SQL Advantages: Applications written in PL/SQL are fully portable

a)

True

b)

False

36.

PL/SQL Advantages: PL/SQL provides high security level

a)

True

b)

False

37.

PL/SQL Advantages: PL/SQL provides access to predefined SQL packages

a)

True

b)

False

38.

PL/SQL Advantages: PL/SQL provides support for Object-Oriented Programming

a)

True

b)

False

39.

PL/SQL Advantages: PL/SQL provides support for developing Web Applications and Server Pages

a)

True

b)

False

40.

PL/SQL Advantages: It supports the development of web applications and server pages

a)

True

b)

False

41.

PL/SQL Advantages: It supports object-oriented programming

a)

True

b)

False

42.

block-structured language

a)

this means that the PL/SQL programs are divided and written in logical blocks of code

b)

This section starts with the keyword DECLARE. It is an optional section and defines all variables, cursors, subprograms, and other elements to be used in the program.

c)

This section is enclosed between the keywords BEGIN and END and it is a mandatory section. It consists of the executable PL/SQL statements of the program. It should have at least one executable line of code, which may be just a NULL command to indicate that nothing should be executed.

d)

This section starts with the keyword EXCEPTION. This optional section contains exception(s) that handle errors in the program.

43.

this means that the PL/SQL programs are divided and written in logical blocks of code

a)

block-structured

b)

Declarations

c)

Executable Commands

d)

Exception Handling

44.

This section starts with the keyword DECLARE. It is an optional section and defines all variables, cursors, subprograms, and other elements to be used in the program.

a)

Declarations

b)

Executable Commands

c)

Exception Handling

45.

This section is enclosed between the keywords BEGIN and END and it is a mandatory section. It consists of the executable PL/SQL statements of the program. It should have at least one executable line of code, which may be just a NULL command to indicate that nothing should be executed

a)

Declarations

b)

Executable Commands

c)

Exception Handling

46.

This section starts with the keyword EXCEPTION. This optional section contains exception(s) that handle errors in the program

a)

Declarations

b)

Executable Commands

c)

Exception Handling

47.

Optional section(s)

a)

Declarations

b)

Executable Commands

c)

Exception Handling

48.

line signals the end of the PL/SQL block

a)

END;

b)

BEGIN

c)

DECLARE

d)

EXCEPTION

49.

you may need to type ___ at the beginning of the first blank line after the last line of the code

a)

/

b)

;

c)

:

d)

//

50.

Identifiers are: constants, variables, exceptions, procedures, cursors, and reserved words

a)

True

b)

False

51.

Identifier consist of a letter

a)

True

b)

False

52.

Identifier consists of letter optionally followed by more letters, numerals, dollar signs, underscores, and number signs and should not exceed 30 characters

a)

True

b)

False

53.

Identifier consists of letter optionally followed by more letters, numerals, dollar signs, underscores, and number signs and should not exceed 30 characters

a)

more letters

b)

numerals

c)

dollar signs

d)

underscores

e)

underline

54.

Identifier should not exceed ___ characters

a)

30

b)

25

c)

20

d)

50

55.

identifiers are not case-sensitive

a)

True

b)

False

56.

identifiers are case-sensitive

a)

True

b)

False

57.

you can use integer or _______ to represent a numeric value

a)

INTEGER

b)

INTERGER

c)

Integer

d)

InTeGer

58.

You cannot use a reserved keyword as an identifier

a)

True

b)

False

59.

A delimiter is a ______ with a special meaning

a)

special

b)

number

c)

letter

d)

capital letter

60.

A _________ is a symbol with a special meaning

a)

delimiter

b)

number

c)

letter

d)

capital letter

61.

Delimiter: +, -, *, /

a)

Addition, subtraction/negation, multiplication, division

b)

Attribute indicator

c)

Character string delimiter

d)

Component selector

62.

Delimiter: %

a)

Addition, subtraction/negation, multiplication, division

b)

Attribute indicator

c)

Character string delimiter

d)

Component selector

63.

Delimiter: '

a)

Expression or list delimiter

b)

Host variable indicator

c)

Character string delimiter

d)

Component selector

64.

Delimiter: .

a)

Expression or list delimiter

b)

Host variable indicator

c)

Item separator

d)

Component selector

65.

Delimiter: (,)

a)

Expression or list delimiter

b)

Host variable indicator

c)

Item separator

d)

Quoted identifier delimiter

66.

Delimiter: :

a)

Relational operator

b)

Host variable indicator

c)

Item separator

d)

Quoted identifier delimiter

67.

Delimiter: ,

a)

Relational operator

b)

Remote access indicator

c)

Item separator

d)

Quoted identifier delimiter

68.

Delimiter: "

a)

Relational operator

b)

Remote access indicator

c)

Statement terminator

d)

Quoted identifier delimiter

69.

Delimiter: =

a)

Relational operator

b)

Remote access indicator

c)

Statement terminator

d)

Assignment operator

70.

Delimiter: @

a)

Association operator

b)

Remote access indicator

c)

Statement terminator

d)

Assignment operator

71.

Delimiter: ;

a)

Concatenation operator

b)

Remote access indicator

c)

Statement terminator

d)

Assignment operator

72.

Delimiter: :=

a)

Concatenation operator

b)

Remote access indicator

c)

Statement terminator

d)

Assignment operator

73.

Delimiter: =>

a)

Association operator

b)

Remote access indicator

c)

Statement terminator

d)

Concatenation operator

74.

Delimiter: ||

a)

Multi-line comment delimiter (begin and end)

b)

Concatenation operator

c)

Exponentiation operator

d)

Label delimiter (begin and end)

75.

Delimiter: **

a)

Multi-line comment delimiter (begin and end)

b)

Single-line comment indicator

c)

Exponentiation operator

d)

Label delimiter (begin and end)

76.

Delimiter: <<, >>

a)

Multi-line comment delimiter (begin and end)

b)

Single-line comment indicator

c)

Range operator

d)

Label delimiter (begin and end)

77.

Delimiter: /*, */

a)

Multi-line comment delimiter (begin and end)

b)

Single-line comment indicator

c)

Range operator

d)

Relational operators

78.

Delimiter: --

a)

Different versions of NOT EQUAL

b)

Single-line comment indicator

c)

Range operator

d)

Relational operators

79.

Delimiter: ..

a)

Different versions of NOT EQUAL

b)

Single-line comment indicator

c)

Range operator

d)

Relational operators

80.

Delimiter: <, >, <=, >=

a)

Different versions of NOT EQUAL

b)

Single-line comment indicator

c)

Range operator

d)

Relational operators

81.

Delimiter: <>, '=, ~=, ^=

a)

Different versions of NOT EQUAL

b)

Single-line comment indicator

c)

Range operator

d)

Relational operators

82.

Program ______ are explanatory statements that can be included in the PL/SQL code that you write and helps anyone reading its source code

a)

Comments

b)

Variables

c)

Syntax

d)

Keywords

83.

All programming languages allow some form of comments.

a)

True

b)

False

84.

All characters available _______ any comment are ignored by the PL/SQL compiler

a)

inside

b)

outside

c)

at the begginning

d)

at the end

85.

The PL/SQL single-line comments start with the delimiter ________

a)

--

b)

++

c)

==

d)

||

86.

multi-line comments are enclosed by _______

a)

/* */

b)

/** */

c)

<!-- -->

d)

//

87.

A PL/SQL unit:

a)

PL/SQL block

b)

Function

c)

Package

d)

Package body

e)

Structure

88.

A PL/SQL unit:

a)

Procedure

b)

Language

c)

Type

d)

Type body

e)

Trigger

89.

The PL/SQL variables, constants and parameters must have a valid data type

a)

True

b)

False

90.

Data Types: Scalar

a)

Single values with no internal components, such as a NUMBER, DATE, or BOOLEAN.

b)

Pointers to large objects that are stored separately from other data items, such as text, graphic images, video clips, and sound waveforms.

c)

Data items that have internal components that can be accessed individually. For example, collections and records.

d)

Pointers to other data items.

91.

Data Types: Large Object (LOB)

a)

Single values with no internal components, such as a NUMBER, DATE, or BOOLEAN.

b)

Pointers to large objects that are stored separately from other data items, such as text, graphic images, video clips, and sound waveforms.

c)

Data items that have internal components that can be accessed individually. For example, collections and records.

d)

Pointers to other data items.

92.

Data Types: Composite

a)

Single values with no internal components, such as a NUMBER, DATE, or BOOLEAN.

b)

Pointers to large objects that are stored separately from other data items, such as text, graphic images, video clips, and sound waveforms.

c)

Data items that have internal components that can be accessed individually. For example, collections and records.

d)

Pointers to other data items.

93.

Data Types: Reference

a)

Single values with no internal components, such as a NUMBER, DATE, or BOOLEAN.

b)

Pointers to large objects that are stored separately from other data items, such as text, graphic images, video clips, and sound waveforms.

c)

Data items that have internal components that can be accessed individually. For example, collections and records.

d)

Pointers to other data items.

94.

Scalar Data Types and Sub-types: Numeric

a)

Numeric values on which arithmetic operations are performed

b)

Alphanumeric values that represent single characters or strings of characters

c)

Logical values on which logical operations are performed

d)

Dates and times

95.

Scalar Data Types and Sub-types: Character

a)

Numeric values on which arithmetic operations are performed

b)

Alphanumeric values that represent single characters or strings of characters

c)

Logical values on which logical operations are performed

d)

Dates and times

96.

Scalar Data Types and Sub-types: Boolean

a)

Numeric values on which arithmetic operations are performed

b)

Alphanumeric values that represent single characters or strings of characters

c)

Logical values on which logical operations are performed

d)

Dates and times

97.

Scalar Data Types and Sub-types: Datetime

a)

Numeric values on which arithmetic operations are performed

b)

Alphanumeric values that represent single characters or strings of characters

c)

Logical values on which logical operations are performed

d)

Dates and times

98.

PL/SQL provides _________ of data types

a)

subtypes

b)

interger

c)

boolean

d)

numeric

99.

PL/SQL Numeric Data Types and Subtypes: PLS_INTEGER

a)

Signed integer in range -2,147,483,648 through 2,147,483,647, represented in 32 bits

b)

Single-precision IEEE 754-format floating-point number

c)

Double-precision IEEE 754-format floating-point number

d)

Fixed-point or floating-point number with absolute value in range 1E-130 to (but not including) 1.0E126. A NUMBER variable can also represent 0

100.

PL/SQL Numeric Data Types and Subtypes: BINARY_INTEGER

a)

Signed integer in range -2,147,483,648 through 2,147,483,647, represented in 32 bits

b)

Single-precision IEEE 754-format floating-point number

c)

Double-precision IEEE 754-format floating-point number

d)

Fixed-point or floating-point number with absolute value in range 1E-130 to (but not including) 1.0E126. A NUMBER variable can also represent 0

101.

PL/SQL Numeric Data Types and Subtypes: BINARY_FLOAT

a)

ANSI specific fixed-point type with maximum precision of 38 decimal digits

b)

Single-precision IEEE 754-format floating-point number

c)

Double-precision IEEE 754-format floating-point number

d)

Fixed-point or floating-point number with absolute value in range 1E-130 to (but not including) 1.0E126. A NUMBER variable can also represent 0

102.

PL/SQL Numeric Data Types and Subtypes: BINARY_DOUBLE

a)

ANSI specific fixed-point type with maximum precision of 38 decimal digits

b)

IBM specific fixed-point type with maximum precision of 38 decimal digits

c)

Double-precision IEEE 754-format floating-point number

d)

Fixed-point or floating-point number with absolute value in range 1E-130 to (but not including) 1.0E126. A NUMBER variable can also represent 0

103.

PL/SQL Numeric Data Types and Subtypes: NUMBER(prec, scale)

a)

ANSI specific fixed-point type with maximum precision of 38 decimal digits

b)

IBM specific fixed-point type with maximum precision of 38 decimal digits

c)

Double-precision IEEE 754-format floating-point number

d)

Fixed-point or floating-point number with absolute value in range 1E-130 to (but not including) 1.0E126. A NUMBER variable can also represent 0

104.

PL/SQL Numeric Data Types and Subtypes: DEC(prec, scale)

a)

ANSI specific fixed-point type with maximum precision of 38 decimal digits

b)

IBM specific fixed-point type with maximum precision of 38 decimal digits

c)

Floating type with maximum precision of 38 decimal digits

d)

ANSI specific floating-point type with maximum precision of 126 binary digits (approximately 38 decimal digits)

105.

PL/SQL Numeric Data Types and Subtypes: DECIMAL(prec, scale)

a)

ANSI and IBM specific floating-point type with maximum precision of 126 binary digits (approximately 38 decimal digits)

b)

IBM specific fixed-point type with maximum precision of 38 decimal digits

c)

Floating type with maximum precision of 38 decimal digits

d)

ANSI specific floating-point type with maximum precision of 126 binary digits (approximately 38 decimal digits)

106.

PL/SQL Numeric Data Types and Subtypes: NUMERIC(pre, secale)

a)

ANSI and IBM specific floating-point type with maximum precision of 126 binary digits (approximately 38 decimal digits)

b)

ANSI specific integer type with maximum precision of 38 decimal digits

c)

Floating type with maximum precision of 38 decimal digits

d)

ANSI specific floating-point type with maximum precision of 126 binary digits (approximately 38 decimal digits)

107.

PL/SQL Numeric Data Types and Subtypes: DOUBLE PRECISION

a)

ANSI and IBM specific floating-point type with maximum precision of 126 binary digits (approximately 38 decimal digits)

b)

ANSI specific integer type with maximum precision of 38 decimal digits

c)

ANSI and IBM specific integer type with maximum precision of 38 decimal digits

d)

ANSI specific floating-point type with maximum precision of 126 binary digits (approximately 38 decimal digits)

108.

PL/SQL Numeric Data Types and Subtypes: FLOAT

a)

ANSI and IBM specific floating-point type with maximum precision of 126 binary digits (approximately 38 decimal digits)

b)

ANSI specific integer type with maximum precision of 38 decimal digits

c)

ANSI and IBM specific integer type with maximum precision of 38 decimal digits

d)

Floating-point type with maximum precision of 63 binary digits (approximately 18 decimal digits)

109.

PL/SQL Numeric Data Types and Subtypes: INT

a)

ANSI and IBM specific floating-point type with maximum precision of 126 binary digits (approximately 38 decimal digits)

b)

ANSI specific integer type with maximum precision of 38 decimal digits

c)

ANSI and IBM specific integer type with maximum precision of 38 decimal digits

d)

Floating-point type with maximum precision of 63 binary digits (approximately 18 decimal digits)

110.

PL/SQL Numeric Data Types and Subtypes: INTEGER

a)

ANSI and IBM specific floating-point type with maximum precision of 126 binary digits (approximately 38 decimal digits)

b)

ANSI specific integer type with maximum precision of 38 decimal digits

c)

ANSI and IBM specific integer type with maximum precision of 38 decimal digits

d)

Floating-point type with maximum precision of 63 binary digits (approximately 18 decimal digits)

111.

PL/SQL Numeric Data Types and Subtypes: SMALLINT

a)

ANSI and IBM specific floating-point type with maximum precision of 126 binary digits (approximately 38 decimal digits)

b)

Floating type with maximum precision of 38 decimal digits

c)

ANSI and IBM specific integer type with maximum precision of 38 decimal digits

d)

Floating-point type with maximum precision of 63 binary digits (approximately 18 decimal digits)

112.

PL/SQL Numeric Data Types and Subtypes: REAL

a)

ANSI and IBM specific floating-point type with maximum precision of 126 binary digits (approximately 38 decimal digits)

b)

Floating type with maximum precision of 38 decimal digits

c)

ANSI and IBM specific integer type with maximum precision of 38 decimal digits

d)

Floating-point type with maximum precision of 63 binary digits (approximately 18 decimal digits)

113.

PL/SQL Character Data Types and Subtypes: CHAR

a)

Fixed-length character string with maximum size of 32,767 bytes

b)

Variable-length character string with maximum size of 32,767 bytes

c)

Variable-length binary or byte string with maximum size of 32,767 bytes, not interpreted by PL/SQL

d)

Fixed-length national character string with maximum size of 32,767 bytes

114.

PL/SQL Character Data Types and Subtypes: VARCHAR2

a)

Variable-length national character string with maximum size of 32,767 bytes

b)

Variable-length character string with maximum size of 32,767 bytes

c)

Variable-length binary or byte string with maximum size of 32,767 bytes, not interpreted by PL/SQL

d)

Fixed-length national character string with maximum size of 32,767 bytes

115.

PL/SQL Character Data Types and Subtypes: RAW

a)

Variable-length national character string with maximum size of 32,767 bytes

b)

Variable-length character string with maximum size of 32,760 bytes

c)

Variable-length binary or byte string with maximum size of 32,767 bytes, not interpreted by PL/SQL

d)

Fixed-length national character string with maximum size of 32,767 bytes

116.

PL/SQL Character Data Types and Subtypes: NCHAR

a)

Variable-length national character string with maximum size of 32,767 bytes

b)

Variable-length character string with maximum size of 32,760 bytes

c)

Variable-length binary or byte string with maximum size of 32,760 bytes, not interpreted by PL/SQL

d)

Fixed-length national character string with maximum size of 32,767 bytes

117.

PL/SQL Character Data Types and Subtypes: NVARCHAR2

a)

Variable-length national character string with maximum size of 32,767 bytes

b)

Variable-length character string with maximum size of 32,760 bytes

c)

Variable-length binary or byte string with maximum size of 32,760 bytes, not interpreted by PL/SQL

d)

Physical row identifier, the address of a row in an ordinary table

118.

PL/SQL Character Data Types and Subtypes: LONG

a)

Universal row identifier (physical, logical, or foreign row identifier)

b)

Variable-length character string with maximum size of 32,760 bytes

c)

Variable-length binary or byte string with maximum size of 32,760 bytes, not interpreted by PL/SQL

d)

Physical row identifier, the address of a row in an ordinary table

119.

PL/SQL Character Data Types and Subtypes: LONG RAW

a)

Universal row identifier (physical, logical, or foreign row identifier)

b)

Variable-length character string with maximum size of 32,760 bytes

c)

Variable-length binary or byte string with maximum size of 32,760 bytes, not interpreted by PL/SQL

d)

Physical row identifier, the address of a row in an ordinary table

120.

PL/SQL Character Data Types and Subtypes: ROWID

a)

Universal row identifier (physical, logical, or foreign row identifier)

b)

Variable-length character string with maximum size of 32,760 bytes

c)

Variable-length binary or byte string with maximum size of 32,760 bytes, not interpreted by PL/SQL

d)

Physical row identifier, the address of a row in an ordinary table

121.

PL/SQL Character Data Types and Subtypes: UROWID

a)

Universal row identifier (physical, logical, or foreign row identifier)

b)

Variable-length character string with maximum size of 32,760 bytes

c)

Variable-length binary or byte string with maximum size of 32,760 bytes, not interpreted by PL/SQL

d)

Physical row identifier, the address of a row in an ordinary table

122.

The _____________ data type stores logical values that are used in logical operations

a)

boolean

b)

numeric

c)

character

d)

datetime

123.

The logical values are the Boolean values TRUE and FALSE and the value NULL

a)

True

b)

False

124.

The _________ datatype is used to store fixed-length datetimes

a)

boolean

b)

date

c)

numeric

d)

character

125.

Valid dates range from _________ to ____________.

a)

January 1, 4712 BC & December 31, 9999 AD

b)

February 14, 3012 BC & December 30, 9999 AD

c)

January 5, 4712 BC & December 29, 9999 AD

d)

January 18, 4712 BC & December 18, 9999 AD

126.

PL/SQL Datetime and Interval Types: YEAR

a)

-4712 to 9999

b)

01 to 12

c)

01 to 31

d)

00 to 23

e)

00 to 59

127.

PL/SQL Datetime and Interval Types: MONTH

a)

Found in the dynamic performance view V$TIMEZONE_NAMES

b)

01 to 12

c)

01 to 31

d)

00 to 23

e)

00 to 59

128.

PL/SQL Datetime and Interval Types: DAY

a)

Found in the dynamic performance view V$TIMEZONE_NAMES

b)

01 to 12

c)

01 to 31

d)

00 to 23

e)

00 to 59

129.

PL/SQL Datetime and Interval Types: HOUR

a)

Found in the dynamic performance view V$TIMEZONE_NAMES

b)

01 to 12

c)

01 to 31

d)

00 to 23

e)

00 to 59

130.

PL/SQL Datetime and Interval Types: MINUTE

a)

Found in the dynamic performance view V$TIMEZONE_NAMES

b)

01 to 12

c)

01 to 31

d)

00 to 23

e)

00 to 59

131.

PL/SQL Datetime and Interval Types: SECOND

a)

00 to 59.9

b)

01 to 12

c)

01 to 31

d)

00 to 59

e)

-12 to 14

132.

PL/SQL Datetime and Interval Types: TIMEZONE_HOUR

a)

00 to 59.9

b)

01 to 12

c)

01 to 31

d)

00 to 59

e)

-12 to 14

133.

PL/SQL Datetime and Interval Types: TIMEZONE_MINUTE

a)

00 to 59.9

b)

01 to 12

c)

01 to 31

d)

00 to 59

e)

-12 to 14

134.

PL/SQL Datetime and Interval Types: TIMEZONE_REGION

a)

00 to 59.9

b)

01 to 12

c)

Found in the dynamic performance view V$TIMEZONE_NAMES

d)

00 to 59

e)

-12 to 14

135.

PL/SQL Datetime and Interval Types: TIMEZONE_ABBR

a)

00 to 59.9

b)

01 to 12

c)

Found in the dynamic performance view V$TIMEZONE_NAMES

d)

00 to 59

e)

-12 to 14

136.

Large Object (LOB) data types refer to large data items such as _____ ,_____ , _____ , and _____

a)

text

b)

graphic images

c)

video clips

d)

sound waveforms

e)

noise

137.

__________ data types allow efficient, random, piecewise access to this data

a)

Large Object (LOB)

b)

Character

c)

Numeric

d)

Boolean

138.

PL/SQL Large Object (LOB) Data Types: BFILE

a)

Used to store large binary objects in operating system files outside the database.

b)

Used to store large binary objects in the database.

c)

Used to store large blocks of character data in the database.

139.

PL/SQL Large Object (LOB) Data Types: BLOB

a)

Used to store large binary objects in operating system files outside the database.

b)

Used to store large binary objects in the database.

c)

Used to store large blocks of character data in the database.

140.

PL/SQL Large Object (LOB) Data Types: CLOB

a)

Used to store large binary objects in operating system files outside the database.

b)

Used to store large binary objects in the database.

c)

Used to store large blocks of character data in the database.

141.

PL/SQL variables must be declared in the declaration section or in a package as a global variable

a)

True

b)

False

142.

PL/SQL variables must be declared in the ________ or in a package as a global variable

a)

declaration section

b)

executable commands

c)

exception handling

143.

you can do so during the declaration, using either of the:

a)

DEFAULT keyword & assignment operator

b)

%Type attribute & assignment operator

c)

DEFAULT keyword & relational operator

d)

indicator attribute & relational operator

144.

You can also specify that a variable should not have a NULL value using the _______ constraint

a)

NOT NULL

b)

NUMERABLE

c)

PRIMARY KEY

d)

FOREIGN KEY

145.

Variables declared in an inner block and not accessible to outer blocks

a)

Local variables

b)

Global variables

146.

Variables declared in the outermost block or a package

a)

Local variables

b)

Global variables

147.

You can use the __________ statement of SQL to assign values to PL/SQL variables

a)

SELECT INTO

b)

INSERT

c)

UNION

d)

FUNCTION

148.

Adds two operands

a)

+

b)

-

c)

*

d)

/

e)

**

149.

Subtracts second operand from the first

a)

+

b)

-

c)

*

d)

/

e)

**

150.

Multiplies both operands

a)

+

b)

-

c)

*

d)

/

e)

**

151.

Divides numerator by de-numerator

a)

+

b)

-

c)

*

d)

/

e)

**

152.

Exponentiation operator, raises one operand to the power of other

a)

+

b)

-

c)

*

d)

/

e)

**

153.

Checks if the values of two operands are equal or not, if yes then condition becomes true.

a)

=

b)

!=

c)

>

d)

<

e)

>=

154.

Checks if the values of two operands are equal or not, if values are not equal then condition becomes true.

a)

!=

b)

<>

c)

~=

d)

!()

155.

Checks if the value of left operand is greater than the value of right operand, if yes then condition becomes true.

a)

=

b)

<=

c)

>

d)

<

e)

>=

156.

Checks if the value of left operand is less than the value of right operand, if yes then condition becomes true.

a)

=

b)

<=

c)

>

d)

<

e)

>=

157.

Checks if the value of left operand is greater than or equal to the value of right operand, if yes then condition becomes true.

a)

=

b)

<=

c)

>

d)

<

e)

>=

158.

Checks if the value of left operand is less than or equal to the value of right operand, if yes then condition becomes true.

a)

=

b)

<=

c)

>

d)

<

e)

>=

159.

operator compares a character, string, or CLOB value to a pattern and returns TRUE if the value matches the pattern and FALSE if it does not.

a)

LIKE

b)

BETWEEN

c)

IN

d)

IS NULL

160.

operator tests whether a value lies in a specified range

a)

LIKE

b)

BETWEEN

c)

IN

d)

IS NULL

161.

operator tests set membership

a)

LIKE

b)

BETWEEN

c)

IN

d)

IS NULL

162.

returns the BOOLEAN value

a)

LIKE

b)

BETWEEN

c)

IN

d)

IS NULL

163.

If both the operands are true then condition becomes true.

a)

AND

b)

OR

c)

NOT

164.

If any of the two operands is true then condition becomes true.

a)

AND

b)

OR

c)

NOT

165.

If a condition is true then Logical NOT operator will make it false.

a)

AND

b)

OR

c)

NOT

166.

Operator __________ determines the grouping of terms in an expression

a)

precedence

b)

presedence

c)

precedense

d)

presidense

167.

OPERATOR PRECEDENCE: First

a)

exponentiation **

b)

identity, negation +, -

c)

multiplication, division *, /

d)

addition, subtraction, concatenation +, -, ||

168.

OPERATOR PRECEDENCE: Second

a)

exponentiation **

b)

identity, negation +, -

c)

multiplication, division *, /

d)

addition, subtraction, concatenation +, -, ||

169.

OPERATOR PRECEDENCE: Third

a)

exponentiation **

b)

identity, negation +, -

c)

multiplication, division *, /

d)

addition, subtraction, concatenation +, -, ||

170.

OPERATOR PRECEDENCE: Fourth

a)

exponentiation **

b)

identity, negation +, -

c)

multiplication, division *, /

d)

addition, subtraction, concatenation +, -, ||

171.

COMPARISON PRECEDENCE: First

a)

logical negation NOT

b)

conjunction AND

c)

inclusion OR

172.

COMPARISON PRECEDENCE: Second

a)

logical negation NOT

b)

conjunction AND

c)

inclusion OR

173.

COMPARISON PRECEDENCE: Third

a)

logical negation NOT

b)

conjunction AND

c)

inclusion OR

174.

A _________ is a program unit/module that performs a particular task

a)

subprogram

b)

calling program

c)

mainprogram

d)

call program

175.

These subprograms are combined to form larger programs. This is basically called the ___________

a)

subprogram

b)

calling program

c)

mainprogram

d)

Modular design

176.

A subprogram can be invoked by another subprogram or program which is called the ____________

a)

subprogram

b)

calling program

c)

mainprogram

d)

Modular design

177.

A subprogram can be created:

a)

At the schema level

b)

Inside a package

c)

Inside a PL/SQL block

d)

set of parameters

178.

At the schema level, subprogram is a ____________

a)

standalone subprogram

b)

calling program

c)

mainprogram

d)

Modular design

179.

A subprogram created inside a package is a _________

a)

packaged subprogram

b)

calling program

c)

mainprogram

d)

Modular design

180.

These subprograms return a single value; mainly used to compute and return a value

a)

Functions

b)

Procedures

c)

Parameters

d)

Exception

181.

These subprograms do not return a value directly; mainly used to perform an action.

a)

Functions

b)

Procedures

c)

Parameters

d)

Exception

182.

parameter lets you pass a value to the subprogram

a)

IN

b)

OUT

c)

IN OUT

183.

It is a read-only parameter

a)

IN

b)

OUT

c)

IN OUT

184.

It is the default mode of parameter passing. Parameters are passed by reference

a)

IN

b)

OUT

c)

IN OUT

185.

The actual parameter must be variable and it is passed by value

a)

IN

b)

OUT

c)

IN OUT

186.

parameter returns a value to the calling program

a)

IN

b)

OUT

c)

IN OUT

187.

You can change its value and reference the value after assigning it

a)

IN

b)

OUT

c)

IN OUT

188.

parameter passes an initial value to a subprogram and returns an updated value to the caller

a)

IN

b)

OUT

c)

IN OUT

189.

It can be assigned a value and the value can be read

a)

IN

b)

OUT

c)

IN OUT

190.

Actual parameter is passed by value

a)

IN

b)

OUT

c)

IN OUT

191.

A _______ is same as a procedure except that it returns a value

a)

function

b)

index

c)

parameter

d)

view

192.

A called function performs the defined task and when its return statement is executed or when the _________ is reached, it returns the program control back to the main program

a)

last end statement

b)

beginning statement

c)

last letter of statement

d)

last number of statement

Similar Resources on Wayground

АКТ Сессия Темiрлан

188 questions

АКТ Сессия Темiрлан

quiz

Worksheet

•

University