Implementation(databases) Flashcards

1
Q

How are two tables linked

A

The foreign key of one table is linked to primary key of the other

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

What is referential integrity

A

all of the foreign keys in a table must link to a primary key in a related table

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

What does the select statement do

A

Selects data from the database

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

What does the order by statement do

A

sorts the results of an SQL query in ascending or descending order

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

How can we select more than one option in the where statement

A

Using the AND operation

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

How can we select on or the other option in the where statement

A

Using the or operation

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

What is the INSERT INTO statement used for

A

to insert a record into a table

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

What is the UPDATE statement used for

A

to update a record in a table

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

What is the DELETE statement used for

A

To delete a record from a table

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

What is an equi join

A

Used to join matching columns of related tables in the output

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