Artificial Intelligence Foundations Course 2 Exams answers – SkillUp

Leave a Comment / AI Exam

Here in this post you will find all the answers of Artificial Intelligence Foundations Course 2 Exams – SkillUp.

You can join this program by visiting official site of futureskills: https://futureskillsnasscom.edcast.com/

Direct course link, Enroll Now! Artificial Intelligence Foundations Course by SkillUp

artificial intelligence foundations course 2 exams answers-skillup

Program Outline: (All Exams answers links)

Let’s start with Course 2: Database Concepts which is a part of Artificial Intelligence Foundation Exams – SkillUp

Course 2: Database Concepts

Artificial Intelligence Foundations Course 2 Exams answers – SkillUp

Module 2.1 Exam – 3 Questions

Question 1. SQL is short for,

  • Structured Questions Lists
  • Structured Query Lists
  • Structured Query Language 
  • Structured Quests Language

Answer: Structured Query Language 

Question 2. SQL is a relational database. (T/F)

  • True
  • False

Answer: True

Question 3. SQL is useful for which of the following technology areas. Select all that apply.

  • Artificial Intelligence
  • Data visualization
  • Machine Learning
  • Business Intelligence

Answer: All options

Module 2.2 Exam – 8 Questions

Question 1. Which of the following is NOT a SQL Database

  • Microsoft SQL
  • Oracle and RDB
  • DB2
  • Excel 

Answer: Excel 

Question 2. In what format is data structured in a SQL Database?

  • JSON Objects
  • Text files
  • XML
  • Tables 

Answer: Tables 

Question 3. A table can more than one Primary Key. T/F

  • True
  • False

Answer: True

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

Answer: Values that uniquely identify each row in the table. 

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

Answer: 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  

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. 

Answer: 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

Answer: 1,2,3,4…256

-2,147,483,648

Question 8. Which of the following are NoSQL databases.

  • Microsoft Access
  • MongoDB
  • Apache CouchDB
  • Excel
  • Fox Pro
  • CosmosDB
  • Amazon DynamoDB

Answer: MongoDB, Apache CouchDB, 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]

Answer: USE [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

Answer: ORDER BY Country, DESC 

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

Answer: Average value in numeric column 

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

Answer: Right Join  

Question 5. In todays AI world, which development environment is most widely used?

  • Pandas
  • R
  • Python 
  • C#

Answer: Python 

Final Exam – 20 Questions

Artificial Intelligence Foundations Course 2 Exams answers – SkillUp

artificial intelligence foundations course 2 exams answers-skillup

Question 1. Sequel is short for:

  • Systems Query Language
  • A continuing story
  • Structured Query Language 
  • Structured Questions Language

Answer: Structured Query 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

Answer: Word, PowerBi

Question 3. A _______ represents the name of the relation with its attributes.

  • Tuple
  • Relation Schema 
  • Relation Key
  • Relation instance

Answer: Relation Schema 

Question 4. The word used to specify rules for the data in a table is?

  • Attributes
  • Tuples
  • Foreign Key
  • Contraints 

Answer: Contraints 

Question 5. A single row in a table, which contains a single record is called a?

  • Foreign Key
  • Tuples 
  • Primary Key
  • Cardinality

Answer: Tuples 

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

Answer: Primary Keys 

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

Answer: Foreign Keys 

Question 8.

ABCDE
ProductIDVendorIDLeadRankAvgPriceUnitLastPrice
12145.00042.000
245737.00037.000
3321854.00050.000
6061247.00047.000
456197536.00042.000

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

Answer: Column A and B 

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

Answer: 1:1 relationship 

Question 10. Database relationships are?

  • Associations between tuples
  • Associations between columns
  • Associations between tables 
  • Associations between constraints

Answer: Associations between tables 

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 

Answer: 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;

Answer: SELECT * 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 

Answer: 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;

Answer: ORDER BY column1, column2, DESC; 

Question 15. To find the number of customers in each country, you could use which SQL statement?

  • ORDER BY
  • SELECT FROM
  • GROUP FROM 
  • COUNT

Answer: GROUP FROM 

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 

Answer: 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

Answer: Right Join  

Question 18. Using an INNER JOIN on Table A and B would produce which result?

Answer: Option 2

Question 19. The most common method for using Python is to combine Python with,

  • R
  • SQL
  • C#
  • Pandas 

Answer: Pandas 

Question 20. Which of the following formats could Python use to access a dataset?

  • .csv
  • .elxs
  • .xml
  • HTML
  • All of the above

Answer: All of the above

For more, Checkout! Artificial Intelligence Foundations Exams answers – SkillUp

The above question set contains all the correct answers. But in any case, you find any typographical, grammatical or any other error then kindly inform us.

Thanks in advance.

For discussion about any question, join the below comment section. And get the solution of your query. Also, try to share your thoughts about the topics covered in this particular quiz.

Related Posts

Leave a Comment

Your email address will not be published. Required fields are marked *