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
See also  Introduction to Databases | Week 4

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

See also  Introduction to Databases | Week 5

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.
See also  Introduction to Databases | Week 2

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


These are answers of Introduction to Databases Week 1 Quiz Answers Coursera