SQL QUIZ

what is sql ?

• a spreadsheet application

• an encryption method used to secure database information

• a programming language utilized for creating, querying and updating relational database

what is the primary advantage of a database over spreadsheet ?

• data base offer higher security compared to spreadsheet

• multiple users can concurrently write queries to extract insights from data

• spreadsheets generally have higher capacity for storing data compared to database

what is the relational database?

• a database that establishes connections or relationship between tablels of data within the database

• a form of query utilized to retrieve data from a database

• a database that stores data in a single table

4. Which of the following best describes a database

• An electronic system designed to store and organize data

• A compilation of interconnected spreadsheets

• c. A collection of related databases

5. What is a table in a database

• a. An object within a database that stores data, typically organized into rows and columns

• b. A form of query used to retrieve data from a database

• c. An encryption technique employed to safeguard database information

6. How should table names be formatted?

• a. With all lowercase letters and underscores

• b. With all uppercase letters and spaces

• c. With all uppercase letters and underscores

• d. With all lowercase letters and spaces

6. What is a record in a table?

• a. A collection of related databases

• b. a collection of related fields

• c. A collection of related rows

• d. a collection of related tables

6. 7. What is a unique identifier in a table?

• a. A field that can have the same name as the table it is housed in

• b. A field that identifies a record so it can be distinguished from other records in the same table

• c. A field that lists all of the information about a single record

• d. A field that lists all of the names of the table’s records

What is a table in a database?

• a. A collection of related records

• b. A collection of related rows

• c. A collection of related fields

• d. A collection of related databases

Why is it better to have more tables in a database?

• a. It makes it easier to combine information about multiple subjects

• b. It makes it easier to query the database

• c. It makes it easier to see duplicate information

• d. It makes it easier to remember all the information