lecture 6

Question 1

what is SQL Database

Answer 1

it is a database where we store the data in columns and we call a group of columns a table and these tables can have relations ship between them

Question 2

one of these is not a relation ship between the SQL tables
1- one to one
2- many to many
3- one to many
4- many to one
5- all of them are relation ship
6- non of them is relation ship

Answer 2

4-many to one

Question 3

in one to one relation we can replace the relation with a field in the table

Answer 3

true we can do it is optional to do it in a field or in a table

Question 4

in one to many relation the table connect to many tables

Answer 4

false it mean each table has many records on that specific table like categroy can have many products so when we store that in the table we store the category id in the product table and the category here can be assigned by more than one product

Question 5

can primary key and forign key be diplucated

Answer 5

the primary key must be unique for each row while the forign key can be diplucated

Question 6

the primary key and forign key can’t be the same for a row

Answer 6

false there is no problem in being the same for a row

Question 7

a table can only have one forign key or no forign key at all

Answer 7

false it can have more than one

Question 8

one of these is not a NOSQL database ?
1- wide column database
2- document database
3- column orianted database
4- sql lite database

Answer 8

4-sql lite database

Question 9

firestorm and mongodb are ?

Answer 9

nosql document database

Question 10

Casandra and HBase are example of ?

Answer 10

nosql wide column or (column orianted ) database

Question 11

one of these is a graph data base ?
1-redis
2-neo4j
3- casandra
4-dgraph

Answer 11

2-neo4j and 4-dgraph