PL/SQL Programming

PL/SQL Programming

Professional Development

15 Qs

quiz-placeholder

Similar activities

SQL Database - Basic

SQL Database - Basic

Professional Development

10 Qs

SQL Programming Revision

SQL Programming Revision

Professional Development

20 Qs

JDBC_Questions1

JDBC_Questions1

Professional Development

18 Qs

Formulier verwerking PHP

Formulier verwerking PHP

Professional Development

16 Qs

BDA Unit Test II

BDA Unit Test II

Professional Development

20 Qs

PLSQL and Cursor Quiz

PLSQL and Cursor Quiz

Professional Development

10 Qs

PL/SQL Practice

PL/SQL Practice

Professional Development

15 Qs

Microsoft SQL Server

Microsoft SQL Server

12th Grade - Professional Development

10 Qs

PL/SQL Programming

PL/SQL Programming

Assessment

Quiz

Computers

Professional Development

Hard

Created by

Rondi Hidayat

Used 34+ times

FREE Resource

15 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

which valid identifier?

today

last_name

today's date

Number_of_days_in_February_this_year

Isleap$year

2.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Which valid variable declaration and initialization?

number_of_copies PLS_INTEGER;

PRINTER_NAME constant VARCHAR2(10);

deliver_to VARCHAR2(10):=Johnson;

by_when DATE:= CURRENT_DATE+1;

3.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

The %TYPE attribute:

Is used to declare a variable according to a database column definition

Is used to declare a variable according to a collection of columns in a database table or view

Is used to declare a variable according to the definition of another declared variable

Is prefixed with the database table and column name or the name of the declared variable

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You can use most SQL single-row functions such as number, character, conversion, and date single-row functions in PL/SQL expressions.

True

False

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When using the SELECT statement in PL/SQL, the INTO clause is required and queries can return one or more row.

True

False

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

There are three types of loops: basic, FOR, and WHILE.

True

False

7.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Identify situations in which you can use the %ROWTYPE attribute

When you are not sure about the structure of the underlying database table

When you want to retrieve an entire row from a table

When you want to declare a variable according to another previously declared variable or database column

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?