session 6

Which type of database stores data in tables with rows and columns?

• a) Relational Database
  

• b) Image Database
  

• c) File Storage System
  

• d) Web Browser

What does each row in a database table represent?

• a) A field
  

• b) A record
  

• c) A table
  

• d) A query

Which column in a table ensures each record is unique?

• a) Primary Key
  

• b) Foreign Key
  

• c) Normal Key
  

• d) Secondary Key

1. How would you select all columns from a table named "employees"?
   

• 1. a) SHOW * FROM employees;
     

• 1. b) SELECT ALL FROM employees;
     

• 1. c) SELECT * FROM employees;
     

• 1. d) FETCH * FROM employees;

Which SQL clause is used to sort query results in ascending order?

• a) SORT
  

• b) RANK

• c) GROUP BY
  

• d) ORDER BY ASC
  

1. Which SQL function is used to count the number of records in a table?
   

• 1. a) AVG()
     

• 1. b) SUM()
     

• 1. c) COUNT()
     

• 1. d) MAX()

What is the purpose of an Entity-Relationship Diagram (ERD)?

• a) To design web pages
  

• b) To visually represent database structure and relationships
  

• c) To create SQL queries automatically
  

• d) To encrypt sensitive data