What is the purpose of a trigger in PL/SQL?

To execute a block of code when a specific event occurs

Which one is not correct for PL/SQL architecture?

PL/SQL Engine can do DML operations if it is not complex

What is a PL/SQL cursor used for?

To handle queries that return multiple rows

How will you have PL/SQL?

It is already there in an Oracle DAtabase. So I don't need to do anything

What is Dynamic SQL used for in PL/SQL?

To execute SQL statements that are constructed at runtime

Which of these is not the reason to select PL/SQL as a programming language.

You can create perfect and user friendly screns with PL/SQL

studbud

Intro PLSQL

10 termsStudBud Administration9 plays

Imported from external platform

Flashcards10 cardsFPractice quizPHost liveL

Questions 10

Answers

1
Which one is not correct for PL/SQL?
You can create web applications with PL/SQL
PL/SQL is case sensitive
You can create dynamic sql queries with PL/SQL
You can use PL/SQL like an object oriented programming
2
What is the purpose of a trigger in PL/SQL?
To delete a table
To execute a block of code when a specific event occurs
To assign values to variables
To create a new user
3
How do you assign a value to a variable in PL/SQL?
value -> variable;
variable := value;
variable = value;
value = variable;
4
What does PL/SQL Stands For?
Programming Language of SQL
Programming Lifecycle of SQL
Plus SQL
Procedural Language of SQL
5
Which one is not correct for PL/SQL architecture?
PL/SQL Engine can do DML operations if it is not complex
PL/SQL Engine can optimizee your code if you wish
PL/SQL and SQL codes can be written together
There is a PL/SQL engine in the database
6
What is a PL/SQL cursor used for?
To declare a new table
To create a new database
To define a trigger
To handle queries that return multiple rows
7
How will you have PL/SQL?
With downloading the PL/SQL extension of Oracle Database
You need to donload and install PL/SQL software after downloading Oracle DB
It is already there in an Oracle DAtabase. So I don't need to do anything
8
What is Dynamic SQL used for in PL/SQL?
To declare cursors
To define packages
To execute SQL statements that are constructed at runtime
To create static queries
9
Which of the following is used to group related procedures, functions, and variables in PL/SQL?
Trigger
Cursor
Dynamic SQL
Package
10
Which of these is not the reason to select PL/SQL as a programming language.
Very fast on dealing the data in Oracle Database
You can create perfect and user friendly screns with PL/SQL
You can use SQL+ PL/SQL together as they are one language
There are great built-in packages to use for dealing with data in PL/SQL

Intro PLSQL Flashcards | StudBud