Database Concepts by Skillup all Exam Answers
Exam – 3 Questions
Question 1: SQL is short for,
- Structured Questions Lists
- Structured Query Lists
- Structured Query Language
- Structured Quests Language
Question 2: SQL is a relational database. (T/F)
- True
- False
Question 3: SQL is useful for which of the following technology areas. Select all that apply.
- Artificial Intelligence
- Data visualization
- Machine Learning
- Business Intelligence
Module 2.2 Exam – 8 Questions
Question 1: Which of the following is NOT a SQL Database
- Microsoft SQL
- Oracle and RDB
- DB2
- Excel
Question 2: In what format is data structured in a SQL Database?
- JSON Objects
- Text files
- XML
- Tables
Question 3: A table can more than one Primary Key. T/F
- True
- False
Question 4: A Primary Key is defined as,
- Values that uniquely identify each row in the table.
- Values that identify a unique value
- Used to identify a row in a table
- Used to identify a column in a table
- Constrains the ability to query a database
Question 5: A Foreign Key is defined as,
- A foreign key links two databases together
- A foreign key
- A foreign key is a column or combination of columns that is used to establish and enforce a link between the data in two tables
- A key that is located in the Parent Table
Question 6: One-to-one relationships between data,
- have only one relationship to many databases.
- have only one relationship to many tables.
- have only one relationship to many records.
- have only one record on either side of the relationship.
Question 7: Which of the following is a numeric data type.
- HH:MM:SS – 23:59:30
- 1,2,3,4…256
- YYY-MM-DD – 2020-06-10
- -2,147,483,648
- March 15, 1909
Question 8: Which of the following are NoSQL databases.
- Microsoft Access
- MongoDB
- Apache CouchDB
- Excel
- Fox Pro
- CosmosDB
- Amazon DynamoDB
Module 2.3 Exam – 5 Questions
Question 1: Which SQL Statement selects the correct database.
- USE [database name]
- SELECT [database name]
- ORDER [database name]
- USE and SELECT [database name]
Question 2: The key syntax for listing the results in descending order in an ORDER BY statement is?
- ORDER BY Country, ASC
- ORDER BY Country, DESCEND
- ORDER BY Country, DESC
- ORDER BY DESC Country
Question 3: The AVG() function returns what value?
- Average value in numeric column
- Sum of the average value in a table
- Average values in all columns
- Average values in all tuples
Question 4: A _______ Join returns all records from the right table, and the matched records from the left table.
- Inner Join
- Outer Join
- Left Join
- Right Join
- Full Join
Question 5: In todays AI world, which development environment is most widely used?
- Pandas
- R
- Python
- C#
Final Exam – 20 Questions
Question 1: Sequel is short for:
- Systems Query Language
- A continuing story
- Structured Query Language
- Structured Questions Language
Question 2: Which of the following are NOT a relational databases.
- SQL Server and Access
- Word
- DB2 and Informix Dynamic Server
- Oracle and RDB
- PowerBi
Question 3: A _______ represents the name of the relation with its attributes.
- Tuple
- Relation Schema
- Relation Key
- Relation instance
Question 4: The word used to specify rules for the data in a table is?
- Attributes
- Tuples
- Foreign Key
- Contraints
Question 5: A single row in a table, which contains a single record is called a?
- Foreign Key
- Tuples
- Primary Key
- Cardinality
Question 6: A table typically has a column or combination of columns that contain values that uniquely identify each row in the table. These values are called?
- Foreign Keys
- Tuples
- Primary Keys
- Main Keys
- Attributes
Question 7: A column or combination of columns that is used to establish and enforce a link between the data in two tables is called a?
- Foreign Keys
- Tuples
- Primary Keys
- Main Keys
- Attributes
Question 8: In this table which column/columns would be consdiered the Primary Keys? Select the correct answer.
- Column A
- Column A and B
- Column D
- Column A and C
- Column A and C
Question 9: When both tables have only one record on either side of the relationship, this is called a,
- 1:1 relationship
- 1:Many relationship
- Many:Many relationship
- 1:2 relationship
Question 10: Database relationships are?
- Associations between tuples
- Associations between columns
- Associations between tables
- Associations between constraints
Question 11: In MS SQL, the image above represents what type of relationship?
- 1 to 1
- Many to Many
- 1 to Several
- 1 to Many
Question 12: What is the SQL statement so obtain all of the columns from a table called VendorTable.
- GET * FROM VendorTable;
- SELECT * FROM VendorTable;
- SELECT ALL FROM VendorTable;
- OBTAIN * FROM VendorTable;
Question 13: The ORDER BY keyword is used to,
- Order all results
- Order results according to table name
- Order results only from selected columns
- Order results-sets in ascending or descending order
Question 14: How would you write the SQL statement to order in descending order?
- ORDER BY column1, column2, DESC;
- ORDER BY column1, column2;
- ORDER BY column1, column2, ASC/DESC;
- DESC ORDER BY column1, column2;
Question 15: To find the number of customers in each country, you could use which SQL statement?
- ORDER BY
- SELECT FROM
- GROUP FROM
- COUNT
Question 16: Using a table called “Products”, what data would be returned using the following SQL Statement, SELECT COUNT(ProductID) FROM Products;
- The number up tuples in the table
- The number of columns in the ProductID table
- The sum of the number of records with a ProductID in the Products table
- The number of records with a ProductID in the Products table
Question 17: A _____ Join returns all records from the right table, and the matched records from the left table.
- Right Join
- Left Join
- Inner Join
- Full Join
Question 18: Using an INNER JOIN on Table A and B would produce which result?
- Option 2
Question 19: The most common method for using Python is to combine Python with,
- R
- SQL
- C#
- Pandas
Question 20: Which of the following formats could Python use to access a dataset?
- .csv
- .elxs
- .xml
- HTML
- All of the above
