SQL And Database Flashcards

1
Q

What is a field?

A

A single type of data from a database table.

Downward column

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

What is a record?

A

A set of related field on a single entity within a database table

A sidewards row

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

What is a table?

A

A complete set of relayed records on the same topic/subject are stored in tables.

The whole big table

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

What is a primary key

A

A field that uniquely identifies a record in a table.

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

What is a foreign key

A

A primary key of one Table in another table linking the two together.

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

What is a database?

A

Databases are structured, persistent collections of data.

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

What is a relation database

A

They contain more than one table which are linked/joined together.

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

How do you insert data into an SQL table?

A
INSERT INTO  (field1, field2…)
VALUES (Value1, Value 2,)

Strings need to be put inside quotation marks when listing values

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

How to update an SQL table?

A

UPDATE Table name
SET Field name = Value, ,
WHERE =

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

How do you delete data in SQL

A

DELETE FROM table name

WHERE field name = condition

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

How to search on SQL?

A

SELECT field name
FROM table
WHERE field name = condition

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

How do you order by ascending or descending

A

ORDER BY field name ASC/DESC

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

Where commands

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