Database Concepts by Skillup all Exam Answers

- Advertisement -

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
- Advertisement -

Related Articles

Stay Connected

4,682FansLike
9,800FollowersFollow
155FollowersFollow
596SubscribersSubscribe

Latest Articles

- Advertisement -