SQL Flashcards

1
Q

DML

A

Data Manipulation Language

Defines the environment in which data can be managed and is used to work with the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

DDL

A

Data Definition Language

Enables database administrator to define schema components

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

SQL

A

Structured Query Language
User specifies what must be done without specifying how.
Declarative language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

SQL Engine

A

Executes all queries or data requests.

Part of DBMS software.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

ANSI

A

American National Standards Institute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

ISO

A

International Organization for Standardization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Query

A

SQL statement that must be executed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Alias

A

Alternate name given to a column or table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Cascading Order Sequence

A

Multilevel ordered sequence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly