All Weeks Introduction to Structured Query Language (SQL) Quiz Answers
In this course, you’ll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent), and creating a MySql Database. You’ll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you’ll learn to model many-to-many relationships like those needed to represent users, roles, and courses.
Introduction to Structured Query Language (SQL) Week 01 Quiz Answers
Quiz : SQL Queries
Q1. DBA stands for
- Database administrator
Q2. Structured Query Language (SQL) is used to (check all that apply)
- Delete data
- Insert data
- Create a table
- Run php
Q3. Which statement is the right syntax to make a new database using command line?
- CREATE people;
- MAKE DATASET people;
- MAKE people;
- CREATE DATABASE people;
Q4. “INSERT INTO” is the keyword used to insert data into tables.
Q5. Which keyword is used to add conditions to your query?
Q6. Which command is used to retrieve all records from the table?
- SELECT all FROM Users
- RETRIVE * FROM Users
- RETRIVE all FROM Users
- SELECT * FROM Users
Q7. Which keyword will cause the results of the query to be displayed in sorted order?
- GROUP BY
- ORDER BY
- None of these
Q8he LIMIT clause helps to narrow down the scope of the query.
Q9.A [_____] column allocates a string with a variable amount of space depending on the data length that is actually stored.
Q10. A column of type CHAR cannot be indexed.
Q11. Images, PDF, movies cannot be stored in a database.
Q12. Column of type TIMESTAMP stores the number of seconds from January 1, [_____] in the column.
Q13. A primary key can be set to null.
Q14. An UNSIGNED int can be a negative number.
Q15. Primary keys are used to distinguish rows within in a table. [_____] keys are used to reference the primary key from a different table.
Introduction to Structured Query Language (SQL) Week 02 Quiz Answers
Quiz : Database Models
Q1. What is the primary value add of relational databases over flat files?
- Ability to scan large amounts of data quickly
- Ability to execute PHP code within the file
- Ability to quickly convert data to HTML
- Ability to store data in a format that can be sent across a network
Q2. Which of the following is NOT a good rule to follow when developing a database model?
- Each “object” in the application should be modeled as one or more tables
- Use integers as primary keys
- Never repeat string data in more than one table in a data model
- Use a persons email address as their primary key
Q3. If our user interface (i.e. like iTunes) has repeated strings on one column of the UI, how should we model this properly in a database:
- We put the string in the first row it occurs and then put that row number in the column all of the rest of the rows where the string occurs
- We make a table that maps the strings in the column to numbers and then use those numbers in the column
- We put the string in the first row where it occurs and then NULL in all of the other rows
- Encode the entire row as JSON and store it in a TEXT column in the database
- We put the string in the last row where it occurs and put the number of that row in the column all of the rest of the rows where the string occurs
Q4. Which of the following is the label we give a column that the “outside world” uses to look up a particular row?
- Logical key
- Local key
- Foreign key
- Remote key
- Primary key
Q5. What is the label we give to a column that is an integer and used to point to a row in a different table?
- Local key
- Remote key
- Primary key
- Logical key
- Foreign key
Q6. What MySQL keyword is added to primary keys in a CREATE TABLE statement to indicate that the database is to provide a value for the column when records are inserted.
Q7. What is the SQL keyword that reconnects rows with foreign keys with the corresponding data in the table that the foreign key points to?
Q8. What happens when you JOIN two tables together without an ON clause?
- The rows of the left table are connected to the rows in the right table when their primary key matches
- The number of rows you get is the number of rows in the first table times the number of rows in the second table
- You get all of the rows of the left table in the JOIN and NULLs in all of the columns of the right table
- Leaving out the ON clause when joining two tables is an SQL syntax error
- You get no rows at all
Q9. What does an “ON DELETE CASCADE” clause imply in a foreign key constraint in a MySQL CREATE TABLE statement?
- When a row in the parent table is deleted all the rows in a child table that point to that row via a foreign key are deleted
- Whenever a row is deleted from the table, the other rows are scanned to insure that the logical key is unique and any duplicates are removed
- Whenever a row is deleted, it is moved into a table named “CASCADE”
- When rows in a child table are deleted, the primary key of the corresponding row in the parent table is set to NULL
Q10. Which of the following types of tables often are created without a primary key?
- Hash Map
Q11. When might one prefer the CHAR column type over VARCHAR?
- When the data needs to be searched using a LIKE clause
- When the data has widely varying lengths
- When the data is prose like a discussion comment versus a logical key
- When the data is relatively short and almost always present
Q12. What is the built-in MySQL function that gives you the current time in an SQL statement?
Q13. Which of the following indexes would be best for fast look up for exact key matches but not so good for prefix lookups or sorting?
Q14. Why is it a good idea to add “CONSTRAINT FOREIGN KEY” statements when creating database tables? (Check all that apply)
- So that database modeling tools know the relationships between tables
- So that MySql knows which columns are foreign keys and which columns are just integers
- So that you can specify default behaviors when records are deleted or updated
- So that prefix-based lookups perform well
Q15. When you add an index to a field in a database table, how are performance and storage affected?
- Read performance is faster, insert performance is slower and extra storage is required
- Read performance is the faster, insert performance is faster and extra storage is required
- Read performance is faster, insert performance is the same and no extra storage is required
- Read performance is the same, insert performance is faster and no extra storage is required
Introduction to Structured Query Language (SQL) Coursera Course Review:
In our experience, we suggest you enroll in the Introduction to Structured Query Language (SQL) Course and gain some new skills from Professionals completely free and we assure you will be worth it.
Introduction to Structured Query Language (SQL) course is available on Coursera for free, if you are stuck anywhere between quiz or graded assessment quiz, just visit Networking Funda to get Introduction to Structured Query Language (SQL) Coursera Quiz Answers.
I hope this Introduction to Structured Query Language (SQL) Coursera Quiz Answers would be useful for you to learn something new from this Course. If it helped you then don’t forget to bookmark our site for more Coursera Quiz Answers.
This course is intended for audiences of all experiences who are interested in learning about new skills in a business context; there are no prerequisite courses.
Get All Course Quiz Answers of Web Applications for Everybody Specialization
Building Database Applications in PHP Coursera Quiz Answers