Module quiz: Introduction to Databases Quiz Answers
In this article i am gone to share Coursera Course: Introduction to Databases for Back-End Development by Meta Week 1 | Module quiz: Introduction to Databases Quiz Answers with you..
Also visit: Final graded quiz: Intro to databases Quiz Answers
Module quiz: Introduction to Databases Quiz Answers
Question 1)
What is the most used database type in computing?
- NoSQL Database
- Flat File Database
- Relational Database
Question 2)
Which one of the following is an advantage of storing data in tables?
- Tables let you store large amounts of data.
- Tables provide a simple and clear view of data
- Tables offer the ability to encrypt data.
Question 3)
In a bookshop database, the complete information about one specific book is referred to as a ______________.
- Record
- Column
- Table
Question 4)
What makes SQL a very popular database language? Select all that apply.
- SQL requires very little coding skills to use.
- SQL is a portable programming language.
- SQL works with different relational database management systems.
Question 5)
Which SQL command is used to update data in a database table?
- EDIT command
- UPDATE command
- MODIFY command
Question 6)
Which of the following database management systems uses the SQL language? Select all that apply.
- PostgreSQL
- MySQL
- Oracle
Question 7)
What is the importance of a candidate key in a database?
- A candidate key can be used to drop a table.
- A candidate key can be used to uniquely identify rows in a table.
- A candidate key can be used to encrypt data in a table.
Question 8)
In the following student table, which attribute could be used as a primary key?
Student first name | Student last name | Mobile number |
Carl | Merlo | 07445532123 |
Mark | Nero | 07456532327 |
- Student first name
- Student last name
- Mobile number
Question 9)
‘CREATE TABLE student;’ is the right syntax to create a student table in SQL.
- True
- False
Question 10)
Choose the right syntax to create a club database in SQL. Select all correct answers.
- create club database;
- CREATE CLUB DATABASE;
- CREATE DATABASE CLUB;
- create database club;