20 Questions
Which type of database stores data in a plain text file and cannot contain multiple tables?
Flat file database
Which type of database organizes data in a tree structure, with one parent for each record and optional nodes forming sub-trees?
Hierarchical database
Which operation combines distinct fields from multiple tables that have the same set of attributes and data types?
Union operation
Which of the following is NOT a data model that can be accommodated by NoSQL databases?
Relational
Which term refers to a system of data stored in raw format, containing all enterprise data as well as derived information?
Data lake
What is the term used for a sequence of characters in programming?
String
Which type of database is an alternative to traditional relational databases and can accommodate a wide variety of data models?
Key-value database
What is the term used to describe a system of data stored in raw format, containing all enterprise data as well as information derived from data during reporting, transactions, or other activities?
Data lake
Which term refers to numbers where the decimal point can float because there is no fixed number of digits before and after the decimal point?
Floating point numbers
Which type of database stores complex data and relationships between data directly without using inter-table relations?
Object database
What type of database model organizes data in a tree structure, with one parent for each record and optional nodes forming sub-trees?
Hierarchical database
Which operation creates a result table that includes all of the attributes from two tables, where each row of the second table is added to each row of the first table?
Product operation
_______ is an alternative to traditional relational databases in which data is placed in tables that are carefully designed before the database is built.
NoSQL databases
_______ is a system of data stored in raw format. It is usually a single store of all enterprise data as well as information derived from data during reporting, transactions, or other activities.
Data lake
Also called a ________, alphanumeric data, text-based only.
character string
A single value of either TRUE or FALSE is called a ________.
Boolean
Numbers where the decimal point can float because there is no fixed number of digits before and after the decimal point. AKA: real numbers
floating point numbers
______ is the process of planning, organizing, and managing resources to achieve specific project goals.
Project management
The ______ phase involves defining the project scope, objectives, and deliverables.
Initiation
The ______ phase involves executing the project plan and managing resources.
Implementation
Test your knowledge of database types with this quiz! Learn about distributed databases, flat file databases, and hierarchical databases.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free