PL/SQL Programming

Quiz
•
Computers
•
Professional Development
•
Hard
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
Similar Resources on Wayground
10 questions
SQL Tuning Tools

Quiz
•
Professional Development
12 questions
BIS - Database

Quiz
•
Professional Development
16 questions
AWS ACF Módulo 8 - Bancos de dados

Quiz
•
Professional Development
20 questions
PL SQL

Quiz
•
University - Professi...
10 questions
Fundamentos PL/SQL

Quiz
•
Professional Development
15 questions
Cloud Binary_Elastic_Beanstalk_

Quiz
•
Professional Development
19 questions
Basis Data Kelas XII

Quiz
•
Professional Development
10 questions
Big Data Analytics - Week 2 (Data storage)

Quiz
•
University - Professi...
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade