Introduction to Databases | Week 1
Course Name: Introduction to Databases
Course Link: Introduction to Databases
These are answers of Introduction to Databases Week 1 Quiz Answers Coursera
Knowledge check: Databases and data
Q1. What is a Database in computing?
- A collection of tables of data stored and accessed electronically.
- A collection of organized data stored and accessed electronically.
Answer: A collection of organized data stored and accessed electronically.
Q2. Which database model uses only tables to store data?
- Relational databases
- Flat Files databases
- NoSQL databases
Answer: Relational databases
These are answers of Introduction to Databases Week 1 Quiz Answers Coursera
Q3. Which of the following is a key advantage of organizing data in tables?
- To store a large amount of data
- To protect data
- To provide a clear view of data
Answer: To provide a clear view of data
Q4. The foreign key can be used to identify a specific record of data in a relational database.
- True
- False
Answer: False
These are answers of Introduction to Databases Week 1 Quiz Answers Coursera
Q5. Big data contains a wide variety of data, arriving in increasing volumes and at high velocity.
- False
- True
Answer: True
Knowledge check: SQL syntax review
Q1. What makes SQL a popular database language? Select all that apply.
- It is an easy programming language to understand and learn.
- It works with different relational database management systems.
- It is a portable programming language.
Answer: It is an easy programming language to understand and learn.
It works with different relational database management systems.
It is a portable programming language.
Q2. Which of the following commands belong to the SQL data manipulation language (DML)? Select all that apply.
- Select
- Create
- Update
- Insert
Answer: Select
Update
Insert
These are answers of Introduction to Databases Week 1 Quiz Answers Coursera
Q3. The SELECT command should be used to retrieve data from a database table.
- False
- True
Answer: True
Q4. Which SQL syntax should be used to create a student table?
- CREATE Student TABLE;
- CREATE TABLE Student;
Answer: CREATE TABLE Student;
These are answers of Introduction to Databases Week 1 Quiz Answers Coursera
Q5. Choose the correct syntax to create a college database in SQL.
- CREATE College DATABASE;
- CREATE DATABASE College;
Answer: CREATE DATABASE College;
Knowledge check: Database structure
Q1. What term is used to describe the complete information about one specific staff member in a college database that contains data about staff?
- Table
- Record
- Column
Answer: Record
Q2. What is the minimum number of tables that must be present in a relational database?
- Two tables
- Three tables
- One table
Answer: One table
These are answers of Introduction to Databases Week 1 Quiz Answers Coursera
Q3. What is the name of the attribute that is chosen in the database to uniquely identify each record in a table?
- Primary Key
- Secondary Key
- Foreign Key
Answer: Primary Key
Q4. Which attribute could be used as a primary key in the following customer table?
- Customer email address
- Customer first name
- Customer last name
Answer: Customer email address
These are answers of Introduction to Databases Week 1 Quiz Answers Coursera
Q5. Which of the following keys can you select as the primary key in a relational database? Select all that apply.
- Candidate Key
- Alternate key
- Composite Key
- Foreign Key
Answer: Candidate Key
Alternate key
Composite Key
Module quiz: Introduction to Databases
Q1. What is the most used database type in computing?
- NoSQL Database
- Relational Database
- Flat File Database
Answer: Relational Database
Q2. Which one of the following is an advantage of storing data in tables?
- Tables offer the ability to encrypt data.
- Tables let you store large amounts of data.
- Tables provide a simple and clear view of data
Answer: Tables provide a simple and clear view of data
These are answers of Introduction to Databases Week 1 Quiz Answers Coursera
Q3. In a bookshop database, the complete information about one specific book is referred to as a ______________.
- Table
- Record
- Column
Answer: Record
Q4. 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.
Answer: SQL requires very little coding skills to use.
SQL is a portable programming language.
SQL works with different relational database management systems.
These are answers of Introduction to Databases Week 1 Quiz Answers Coursera
Q5. Which SQL command is used to update data in a database table?
- EDIT command
- UPDATE command
- MODIFY command
Answer: UPDATE command
Q6. Which of the following database management systems uses the SQL language? Select all that apply.
- PostgreSQL
- Oracle
- MySQL
Answer: PostgreSQL
Oracle
MySQL
These are answers of Introduction to Databases Week 1 Quiz Answers Coursera
Q7. 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.
Answer: A candidate key can be used to uniquely identify rows in a table.
Q8. In the following student table, which attribute could be used as a primary key?
- Student last name
- Mobile number
- Student first name
Answer: Mobile number
These are answers of Introduction to Databases Week 1 Quiz Answers Coursera
Q9. ‘CREATE TABLE student;’ is the right syntax to create a student table in SQL.
- True
- False
Answer: True
Q10. Choose the right syntax to create a club database in SQL. Select all correct answers.
- CREATE DATABASE CLUB;
- create database club;
- create club database;
- CREATE CLUB DATABASE;
Answer: CREATE DATABASE CLUB;
create database club;
These are answers of Introduction to Databases Week 1 Quiz Answers Coursera
More Weeks of this course: Click Here
More Coursera Courses: http://progiez.com/coursera
