PL PGSQL

PL PGSQL

University

34 Qs

quiz-placeholder

Similar activities

IT security - 3

IT security - 3

9th Grade - University

30 Qs

Quiz#8: Elements of Film Form

Quiz#8: Elements of Film Form

University

31 Qs

Comptia Port Numbers

Comptia Port Numbers

University

34 Qs

INI011_2023

INI011_2023

University

30 Qs

Lesson 5 - Software Quality Assurance

Lesson 5 - Software Quality Assurance

University

30 Qs

CS 1400 Final Review

CS 1400 Final Review

University

31 Qs

CS 1: Big Idea #3 Practice

CS 1: Big Idea #3 Practice

9th Grade - University

32 Qs

Prueba de IP Addressing y Subnetting

Prueba de IP Addressing y Subnetting

University

30 Qs

PL PGSQL

PL PGSQL

Assessment

Quiz

Computers

University

Practice Problem

Easy

Created by

Riddhish Thakore

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

34 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

A stored procedure in SQL is a___________

Block of functions
Group of Transact-SQL statements compiled into a single execution plan.
Group of distinct SQL statements.
None of the mentioned

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Temporary stored procedures are stored in _________ database.

Master
Model
User specific
Temp

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

Procedures
Triggers
Functions
None of the mentioned

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Triggers are supported in

Delete
Update
Views
All of the mentioned

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What are the after triggers?

Triggers generated after a particular operation
These triggers run after an insert, update or delete on a table
These triggers run after an insert, views, update or delete on a table
All of the mentioned

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which loop construct is used in PL/pgSQL for iterating over a range of values?

WHILE loop
FOR loop
DO loop
LOOP loop

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following is an PostgreSQL-supported trigger?

BEFORE
INSTEAD OF
AFTER
all of above

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Computers