SQL

1. The relational data model uses a collection of _____________ , and includes the __________ and __________which allow for defining the schema and manipulating data respectively (fill in multiple blanks)

2.There is no difference between a relational database system and a set of related spreadsheets. (True/False)

3.Query languages are object-oriented, non-procedural languages. (T/F)

4. A table may have no more than 3 primary keys.(TRYE/FALSE)

5. Database Management Systems? (Select all that apply)

Are used by organizations of varying sizes and levels of operational complexity.

All use the Entity-Relationship model.

Offer advantages over a file-processing system among others by offering easier setup of atomic transactions, data-consistency and security.

6.The new specialized databases that were developed for data analysis: (single choice)

Are usually small and optimized for use by mobile devices

Often use novel distributed-data storage

Require high end specialized hardware

Have been championed by mostly tech giants of the 1980s and 1990s such as Microsoft, Oracle an Apple