Chapt 4 (Intro to SQL) Flashcards

1
Q

Considered one of the major reasons for the commercial success of relational databases

A

SQL language

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

The origin of SQL is relational predicate calculus called _____

A

tuple calculus

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

tuple calculus was proposed initially as the language ________

A

square

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

SQL comes from the word

A

Sequel

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

SQL is now popularly known as

A

Structured Query Language

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

is an informal or practical rendering of the relational data model with syntax

A

SQL

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

Main SQL command for data definition

A

create statement

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

Identified by a schema name

Includes an authorization identifier and descriptors for each element

A

SQL Schema

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

Schema elements

A

Tables, constraints, views, domains, and other constructs

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

Named collection of schemas in an SQL environment

A

Catalog

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

Relation and its tuples are actually created and stored as a _____ by the DBMS

A

file

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