PL/SQL Programming

PL/SQL Programming

Professional Development

15 Qs

quiz-placeholder

Similar activities

DataBase Quiz - CME Workshop

DataBase Quiz - CME Workshop

Professional Development

20 Qs

Basis Data Kelas XII

Basis Data Kelas XII

Professional Development

19 Qs

Big Data Analytics - Week 2 (Data storage)

Big Data Analytics - Week 2 (Data storage)

University - Professional Development

10 Qs

Databases Week 2 Review

Databases Week 2 Review

12th Grade - Professional Development

12 Qs

JDBC_Questions1

JDBC_Questions1

Professional Development

18 Qs

MySQL

MySQL

Professional Development

20 Qs

BIG DATA DAY 3 Quiz

BIG DATA DAY 3 Quiz

Professional Development

15 Qs

Database Foundations

Database Foundations

Professional Development

20 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?