304 North Cardinal St.
Dorchester Center, MA 02124
Data is one of the most critical assets of any business. Data needs a database to store and process data quickly. SQL is a language used for a database to query data.
In this introductory course, you’ll learn the basics of the SQL language and the relational databases. You’ll start by learning about the relational model and relational model concepts and constraints. By the end of this course, you will have learned and used the five basic SQL statements, some advanced SQL syntax, and join statements.
This isn’t your typical textbook introduction. You’re not just learning through lectures. At the end of each module there are assignments, hands-on exercises, review questions, and also a final exam. Successfully completing this course earns you a certificate. So let’s get started!
Module 1 – SQL and Relational Databases 101
Question: What is a Database?
Question: Advantages of the relational model include:
Question: In an Entity-Relationship diagram, the Entity Name maps to the Table name, the attributes map to the …
Module 2 – Relational Model Constraints and Data Objects
Question: Which of the following statements is true?
Question: Which Relational Constraint prevents duplicate values in a table?
Question: The Semantic Integrity Constraint defines the relationships between tables. (T/F)
Module 3 – Data Definition Language (DDL) and Data Manipulation Language (DML)
Question: The Primary Key of a relational table uniquely identifies each _____ in a table.
Question: The INSERT statement cannot be used to insert multiple rows in a single statement. (T/F)
Question: The SELECT statement is called a Query, and the output we get from executing the query is called a Result Set.
Module 4 – Advanced DDL and DML
Question: You want to select an author’s name from a table, but you only remember the author’s last name starts with the letter B, which string pattern can you use?
Question: In a SELECT statement, which SQL clause controls how the result set is displayed?
Question: Which SELECT statement eliminates duplicates in the result set?
Module 5 – Working with multiple tables
Question: An INNER JOIN returns only the rows that match. (T/F)
Question: A LEFT OUTER JOIN displays all the rows from the right table, and combines matching rows from the left table. (T/F)
Question: When using an OUTER JOIN, you must explicitly state that you want either a LEFT JOIN or a RIGHT JOIN. (T/F)
Question: The 5 basic SQL commands are…
Question: The blueprint of any database system is the …
Question: Attributes help clarify relationship diagrams (T/F)
Question: A table containing one or more foreign keys is called a Parent table. (T/F)
Question: The Referential Integrity Constraint ensures the validity of the data using a combination of Primary Keys and Foreign Keys.
Question: What are the basic categories of the SQL language based on functionality?
Question: The CREATE TABLE statement is a….
Question: When using the UPDATE statement, if you do not specify the WHERE clause, all the rows in the table are updated.
Question: You want to select a list of books whose number of pages is between 100 and 200 . Select the correct query from the following options.
Question: What is the default sorting mode of the ORDER BY clause?
Question: Which of the following can be used in a SELECT statement to restrict a result set?
Question: The HAVING clause works only with the GROUP BY clause. (T/F)
Question: Which of the following are valid types of OUTER JOIN?
Question: A FULL JOIN returns only the rows that match. (T/F)
Question: To combine tables in relational databases , we use:
Question: >> True or False: Semantic integrity ensures that data entered into a row reflects an allowable value for that row.
Question: Which of the following statements are correct about databases :
Question: Which of the following statements are correct about primary keys
Question: The ____________ keyword is used to eliminate duplicate tuples from the result set of an SQL query.
Question: Select the correct statements about the join operator
We hope you know the correct answers to SQL and Relational Databases 101 If Queslers helped you to find out the correct answers then make sure to bookmark our site for more Course Quiz Answers.
If the options are not the same then make sure to let us know by leaving it in the comments below.
In our experience, we suggest you enroll in this and gain some new skills from Professionals completely free and we assure you will be worth it.
This course is available on Cognitive Class for free, if you are stuck anywhere between quiz or graded assessment quiz, just visit Queslers to get all Quiz Answers and Coding Solutions.
More Courses Quiz Answers >>