Introduction to Relational Databases (RDBMS) Quiz Answer

Introduction to Relational Databases (RDBMS) Week 01 Quiz Answer

Graded Quiz 01: Fundamental Relational Database Concepts

Q1. Data can be classified by the level and rigidity of its structure. Which data type is often stored in NoSQL databases?

• Structured data
• Regulated data
• Semi-structured data
• Unstructured data

Q2. Which of the following is a type of Information models?

• Hierarchical
• Root
• Tree
• Organization

Q3. True or False – In an Entity-Relationship diagram, attributes are connected to multiple entities.

• True
• False

Q4. When creating a table from an ERD, the entity becomes the table. What do the attributes become?

• Cells
• All of the above
• Columns
• Rows

Q5. Which data type only holds 1 bit of information; a 0 or a 1?

• LOB
• Boolean
• Binary string
• XML

Graded Quiz 02: Introducing Relational Database Products

Q1. What role does database replication play in a distributed database architecture?

• High availability
• Improved performance
• Disaster recovery
• All of the above

Q2. Which of the three main classes of database users are more likely to use Object Relational Mapping (ORM) in their workloads?

• Data Engineers
• Data Scientists
• Application Developers
• Database Administrators

Q3. MySQL supports multiple storage engines. Which of the following supported storage engines use table-level locking?

• InnoDB
• NDB
• MyISAM
• None of the above

Q4. PostgreSQL is an object-relational database management system. What does the object part mean for PostgreSQL?

• Database management
• Supports inheritance and overloading
• Uses Postgres source code
• Supports high availability and scalability

Q5. A Relation is a table made up of columns and rows. Columns are attributes or fields. What are rows?

• Data values
• Struct
• Tuples
• None of the above

Introduction to Relational Databases (RDBMS) Week 02 Quiz Answer

Graded Quiz 01: Creating Tables and Loading Data

Q1. Which of the following four steps for loading data with the Load Data utility involves authenticating to the storage?

• Define
• Finalize
• Target
• Source

Q2. You create a new table in the COR38310 schema and name it Engineers. What is the fully qualified name for this table?

• COR38310/Engineers
• Engineers
• Engineers.COR38310
• COR38310.Engineers

Q3. Multiple file formats are supported by most databases. Which of the following common formats includes CSV files? 1

• Non-delimited ASCII (ASC)
• Delimited ASCII (DEL)
• JavaScript Object Notation (JSON)
• PC Integration exchange (PC/IXF)

Q4. True or False – The Primary Key uniquely identifies each row in a table.

• True
• False

Q5. What are DML statements sometimes referred to as?

• Modifier
• CREATE
• UPDATE
• CRUD

Graded Quiz 02: Designing Keys, Indexes, and Constraints

Q1. What clause of the CREATE TABLE statement do you use to create a primary key?

• PRIMARY KEY
• REFERENCES
• CONSTRAINT
• ALTER TABLE

Q2. What do you create that automatically creates an index?

• Table
• Foreign key
• None of the above
• Primary key

Q3. Which of the following constraints identifies each tuple (or row) in a table?

• Check constraint
• Entity integrity constraint
• Domain constraint
• Positive constraint

Q4. True or False: All relational databases use the concept of instances.

• True
• False

Q5. What are the requirements that a table must meet to be in first normal form (1NF)? 1 point

• The table must already be in third normal form (3NF) and second normal form (2NF).
• Each table must contain no more than three columns.
• The table must have a Primary Key.
• Each row must be unique, and each cell must contain only a single value.

Introduction to Relational Databases (RDBMS) Week 03 Quiz Answer

Graded Quiz 01: MySQL

Q1. In MySQL Workbench, which page in the UI do you use to inspect the objects in your database?

• Visual Data Editor
• Object Browser
• Administration
• Schemas

Q2. When creating a MySQL database using phpMyAdmin, at which point in the process do you select the encoding method for the data?

• When you name the new database.
• When you add tables to the database.
• When you are shown a summary of the structure of the new table.
• When you define the columns in the table.

Q3. Which methods of populating MySQL database tables is best for small amounts of data? Select two answers

• Manually enter the rows using the phpMyAdmin interface.
• Insert the rows from a data file.
• Restore the rows from a backup.
• Run SQL INSERT statements to enter the rows.

Q4. When comparing primary keys to foreign keys, which of the following statements only describe foreign keys?

• Must be unique within the table.
• Are always indexed.
• Are related to a unique primary key.
• Cannot contain nulls.

Q5. Which tool should you use if you want to administer MySQL from a graphical web interface?

• MySQL Workbench
• mysqladmin
• mysql
• phpMyAdmin

Graded Quiz 02: PostgreSQL

Q1. Which tool can you use to both design and create a Postgres database?

• psql
• Query Tool
• ERD Tool
• pgAdmin

Q2. When using the pgAdmin Restore command, which of the following items are recreated in the database?

• Data
• Data types
• Tables
• Passwords

Q3. What is a main difference between regular views and materialized views?

• Regular views are saved for future use.
• Regular views can improve performance.
• Regular views are often stored in memory.
• You can insert, update, or delete data in regular views.

Q4. When creating a new table in a database using pgAdmin, on which tab of the Create Table dialog box do you specify data types?

• Constraints
• Columns
• Parameters
• General

Q5. What SQL statement do you use to define a view in PostgreSQL?

• CREATE VIEW
• JOIN
• VIEW
• SELECT

Get all Course Quiz Answers of IBM Data Warehouse Engineer Professional Certificate

Introduction to Data Engineering Coursera Quiz Answers

Introduction to Relational Databases (RDBMS) Quiz Answers

Databases and SQL for Data Science with Python Quiz Answers

Hands-on Introduction to Linux Commands and Shell Scripting Quiz Answers

Relational Database Administration (DBA) Quiz Answers

ETL and Data Pipelines with Shell, Airflow and Kafka Quiz Answers

Getting Started with Data Warehousing and BI Analytics Quiz Answers