DBMS 2

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/7

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

8 Terms

1
New cards

Subquery

Is a SQL query nested inside another query

2
New cards

Single-row subquery

Returns one row

3
New cards

Multi-row Subquery

Returns multiple rows - use IN, ANY, ALL

4
New cards

Multi-column subquery

Returns multiple columns - used with IN or EXISTS

5
New cards

Correlated Subquery

Subquery that depends on outer query, runs once for every row

6
New cards

SQL Views

A virtual table based on a SQL SELECT query. Doesn’t store data itself but presents data from one or more tables

7
New cards

Simplifies complex queries, Enhances Security (hide sensitive columns), Makes code reusable and maintainable

Benefits of Views

8
New cards

Stored Procedure

Is a named collection of SQL statements that you can call and reuse.