3. Database Basics – Test Yourself

Please find the answers at the end of the test.

Q1. What best describes a database?

  1. It stores files
  2. It is a store for a collection of related data
  3. It is an application that stores data
  4. It is a complex spreadsheet

Q2. What is a database made up of?

  1. Tables, sets and columns
  2. Tables, files and columns
  3. Tables, rows and columns
  4. Spreadsheets, rows and columns

Q3. What does DBMS stand for?

  1. Database Main System
  2. Data Base Mean System
  3. Data Management System
  4. Database Management System

Q4. What best describes a DBMS?

  1. It is an application used to create other applications 
  2. It is a software system that allows the management of databases
  3. It designs your database
  4. It manages application systems

Q5. Which of these are DBMSs?

  1. MySql
  2. Oracle
  3. PostgreSQL
  4. Microsoft SQL Server

Q6. What does the “R” in RDBMS stand for?

  1. Related
  2. Relational
  3. Refactor
  4. Reformatted

Q7. What 2 ways is SQL pronounced in the IT World?

  1. Sequel
  2. Sequin
  3. Ess-que-ell
  4. Ess-qui-nell

Q8. What makes tables relational? 

  1. They have key columns that are related to other tables’ columns
  2. They have similar data in other tables
  3. They have related data sets in other tables
  4. They have data types connected to each other

Q9. Where does a database table get its name from?

  1. Its “table like” structure, being a bit like a spreadsheet
  2. Its originator’s name
  3. A developer’s  coding format
  4. Its ability to build a hatched format

Q10. What two main things is a table made up of?

  1. Rows and columns
  2. Rows and data types
  3. Columns and data types
  4. Data types and Operators

Q11. How do we store data in a table?

  1. As a column
  2. As a row
  3. As a data type
  4. As a data set

Q12. What is a row made up of?

  1. Records 
  2. Operators
  3. Columns
  4. Keys

Q13. What uniquely identifies a row?

  1. A primary key
  2. A data type 
  3. A date 
  4. A VARCHAR

Q14. How else might a row also be known as?

  1. A line 
  2. A result
  3. A data type
  4. A record

Q15. What is a column also known as?

  1. A field
  2. A VARCHAR
  3. A data type
  4. A key 

Q16. What restricts the type of information a column holds?

  1. The key
  2. Its name
  3. Its data type
  4. Its age

Q17. What best describes a Data Type?

  1. It determines what type of data can be stored in a column
  2. It allows different data to be stored in cells
  3. It determines what type of data can be stored in a row
  4. It uniquely defines a row

Q18. Which one of the following shows all the correct common Data Types?

  1. ANT, DEC,  VARCHAR, DATE, TIMESTAMP
  2. INTEGER, NUMBER, STRING, DTE, TIMESTAMP
  3. INT, DECIMAL, VARCHAR, DATE, TIMESTAMP
  4. INT, DEC, VAR, DTE, TIMESTAMP

Q19. What does VARCHAR stand for?

  1. Variable length character
  2. Variety Character
  3. Variable length content
  4. Varied length character

Q20. What can a VARCHAR cell hold?

  1. An integer
  2. A decimal
  3. Text
  4. A date

Q21. What does INT stand for?

  1. Integration
  2. Invariable
  3. Inter numerable
  4. Integer

Q22. What best describes a Primary Key?

  1. It uniquely identifies each column in a table
  2. It allows columns to have the same value
  3. It allows rows to have the same value
  4. It uniquely identifies each row in a table

Q23. How many Primary Keys can you have in a table?

  1. Any number
  2. 2
  3. 1
  4. 99

Q24. Which of the following data types can a Primary Key hold?

  1. INT
  2. NULL
  3. VARCHAR
  4. DATE

Q25. How many columns does a Primary Key have?

  1. 1
  2. 99
  3. None
  4. As many as it takes to make a row unique

ANSWERS:

Q1. What best describes a database?

  1. It stores files
  2. It is a store for a collection of related data
  3. It is an application that stores data
  4. It is a complex spreadsheet

Answer:

2

Q2. What is a database made up of?

  1. Tables, sets and columns
  2. Tables, files and columns
  3. Tables, rows and columns
  4. Spreadsheets, rows and columns

Answer:

3 

Q3. What does DBMS stand for?

  1. Database Main System
  2. Data Base Mean System
  3. Data Management System
  4. Database Management System

Answer:

4 

Q4. What best describes a DBMS?

  1. It is an application used to create other applications 
  2. It is a software system that allows the management of databases
  3. It designs your database
  4. It manages application systems

Answer:

2

Q5. Which of these are DBMSs?

  1. MySql
  2. Oracle
  3. PostgreSQL
  4. Microsoft SQL Server

Answer:

All of them

Q6. What does the “R” in RDBMS stand for?

  1. Related
  2. Relational
  3. Refactor
  4. Reformatted

Answer:

2 

Q7. What 2 ways is SQL pronounced in the IT World?

  1. Sequel
  2. Sequin
  3. Ess-que-ell
  4. Ess-qui-nell

Answer:

1 and 3

Q8. What makes tables relational? 

  1. They have key columns that are related to other tables’ columns
  2. They have similar data in other tables
  3. They have related data sets in other tables
  4. They have data types connected to each other

Answer:

1

Q9. Where does a database table get its name from?

  1. Its “table like” structure, being a bit like a spreadsheet
  2. Its originator’s name
  3. A developer’s  coding format
  4. Its ability to build a hatched format

Answer:

1 

Q10. What two main things is a table made up of?

  1. Rows and columns
  2. Rows and data types
  3. Columns and data types
  4. Data types and Operators

Answer:

1 

Q11. How do we store data in a table?

  1. As a column
  2. As a row
  3. As a data type
  4. As a data set

Answer:

2

Q12. What is a row made up of?

  1. Records 
  2. Operators
  3. Columns
  4. Keys

Answer:

3 

Q13. What uniquely identifies a row?

  1. A primary key
  2. A data type 
  3. A date 
  4. A VARCHAR

Answer:

1 

Q14. How else might a row also be known as?

  1. A line 
  2. A result
  3. A data type
  4. A record

Answer:

4 

Q15. What is a column also known as?

  1. A field
  2. A VARCHAR
  3. A data type
  4. A key 

Answer:

1 

Q16. What restricts the type of information a column holds?

  1. The key
  2. Its name
  3. Its data type
  4. Its age

Answer:

3

Q17. What best describes a Data Type?

  1. It determines what type of data can be stored in a column
  2. It allows different data to be stored in cells
  3. It determines what type of data can be stored in a row
  4. It uniquely defines a row

Answer:

1

Q18. Which one of the following shows all the correct common Data Types?

  1. ANT, DEC,  VARCHAR, DATE, TIMESTAMP
  2. INTEGER, NUMBER, STRING, DTE, TIMESTAMP
  3. INT, DECIMAL, VARCHAR, DATE, TIMESTAMP
  4. INT, DEC, VAR, DTE, TIMESTAMP

Answer:

3 

Q19. What does VARCHAR stand for?

  1. Variable length character
  2. Variety Character
  3. Variable length content
  4. Varied length character

Answer:

1 

Q20. What can a VARCHAR cell hold?

  1. An integer
  2. A decimal
  3. Text
  4. A date

Answer:

3 

Q21. What does INT stand for?

  1. Integration
  2. Invariable
  3. Inter numerable
  4. Integer

Answer:

4 

Q22. What best describes a Primary Key?

  1. It uniquely identifies each column in a table
  2. It allows columns to have the same value
  3. It allows rows to have the same value
  4. It uniquely identifies each row in a table

Answer:

4

Q23. How many Primary Keys can you have in a table?

  1. Any number
  2. 2
  3. 1
  4. 99

Answer:

3 

Q24. Which of the following data types can a Primary Key hold?

  1. INT
  2. NULL
  3. VARCHAR
  4. DATE

Answer:

1, 3 and 4 

Q25. How many columns does a Primary Key have?

  1. 1
  2. 99
  3. None
  4. As many as it takes to make a row unique

Answer:

4 

Return To Lesson ⇒ 3. Database Basics