6.3.2 Module 6 Quiz – Introduction to Relational Databases and SQL Exam Answers

6.3.2 Module 6 Quiz – Introduction to Relational Databases and SQL Exam Answers Full 100% | Data Analytics Essentials 2023 2024

This is 6.3.2 Module 6 Quiz – Introduction to Relational Databases and SQL Exam Answers Full 100%  in 2023 and 2024. It is also module 6 quiz answers in the Cisco NetAcad SkillsForAll Data Analytics Essentials course. Our experts have verified all the answers with explanations to get the 100%.

1. What is a flat file database?

   • a database that stores records in a single file with no hierarchical structure
   • a database that requires SQL to store, manipulate, and retrieve data
   • a database that is used to store large amounts of complex data
   • a database that stores data in a sheet using a hierarchical tabular format of columns and rows
     

     Answers Explanation & Hints:

2. Which commonly used SQL statement is necessary to retrieve data from one or more tables in a database?

   • TRUNCATE
   • SELECT
   • INSERT
   • CREATE
     

     Answers Explanation & Hints: The SELECT statement is the most used SQL statement and is necessary when you need to retrieve data from one or more tables in a database.

3. Which SQL statement is used to filter data in a database?

   • WHERE
   • FROM
   • ORDER BY
   • DISTINCT
     

     Answers Explanation & Hints: The WHERE statement is a conditional statement used to filter the returned results.

4. What is used to show how the tables in a database are related to one another?

   • CSV
   • DDL
   • ERD
   • DML
     

     Answers Explanation & Hints: An Entity Relationship Diagram (ERD) shows how database tables are related to one another.

5. In the SQL statement ” SELECT genre FROM movies” what is specified by “genre”?

   • the column
   • the table
   • the folder
   • the database
     

     Answers Explanation & Hints: The SELECT statement identifies the column in a table from which data is requested. In this example, the data in the “genre” column of the “movies” table is requested.

6. Which structure in a table represents an individual record contained in the database?

   • foreign key
   • row
   • relationship
   • column
     

     Answers Explanation & Hints: In a relational database table, each row represents an individual record and the attributes associated with that record.

7. What is represented by the comma-separated list of items following the SELECT command in this example? SELECT movieID, title

   • aliases
   • records
   • table names
   • columns (attributes)
     

     Answers Explanation & Hints: The SELECT command is followed by a list of the columns (attributes) that will be read and returned from the database table. The values contained in the movieID and title fields will be returned in this example.

8. Which three elements of a relational database are defined in the schema? (Choose 3.)

   • attributes
   • SQL keywords
   • aliases
   • tables
   • relationships
     

     Answers Explanation & Hints: A schema is a formal description that describes the structure of the database and contains information about tables, attributes, and relationships.