Home > Artificial Intelligence > Quizzes > Artificial Intelligence Fundamentals: Database Concepts Practice Test
Artificial Intelligence Fundamentals: Database Concepts Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 100% Most missed: “A Foreign Key is defined as,”
Artificial Intelligence Fundamentals: Database Concepts Practice Test
Time left 00:00
25 Questions

1. Database relationships are?
2. One-to-one relationships between data,
3. The key syntax for listing the results in descending order in an ORDER BY statement is?
4. Which of the following are NoSQL databases.
5. A _____ Join returns all records from the right table, and the matched records from the left table.
6. When both tables have only one record on either side of the relationship, this is called a,
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?
8. A single row in a table, which contains a single record is called a?
9. The most common method for using Python is to combine Python with,
10. Which of the following are NOT a relational databases.
11. The word used to specify rules for the data in a table is?
12. Which of the following formats could Python use to access a dataset?
13. In todays AI world, which development environment is most widely used?
14. In this table which column/columns would be consdiered the Primary Keys? Select the correct answer.
15. To find the number of customers in each country, you could use which SQL statement?
16. How would you write the SQL statement to order in descending order?
17. A _______ Join returns all records from the right table, and the matched records from the left table.
18. SQL is useful for which of the following technology areas. Select all that apply.
19. Which SQL Statement selects the correct database.
20. A _______ represents the name of the relation with its attributes.
21. Which of the following is NOT a SQL Database
22. The ORDER BY keyword is used to,
23. In what format is data structured in a SQL Database?
24. 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?
25. A Primary Key is defined as,