Data types, structures, schemas, relational versus non-relational databases, data warehouses and file formats.
40 cards · basic cards · AI-written, checked twice. Edit anything.
- What is an integer data type?
Show answer
A numeric data type representing whole numbers without decimal points, positive or negative.- What is a float or double data type?
Show answer
A numeric data type that stores decimal values with a specified precision for fractional numbers.- What is a string data type?
Show answer
A sequence of characters used to store text, enclosed in quotes in most programming contexts.- What is a boolean data type?
Show answer
A data type with only two possible values, true or false, used for logical operations and conditions.- What does NULL represent in a database?
Show answer
The absence of a value or an unknown value in a database field.- What is a date-time data type?
Show answer
A data type that stores calendar dates and time values, often with formats like YYYY-MM-DD HH:MM:SS.- What is an array data structure?
Show answer
An ordered collection of elements stored in contiguous memory, accessed by numeric index.- What is a linked list data structure?
Show answer
A sequence of nodes where each node contains data and a pointer to the next node.- What is a tree data structure?
Show answer
A hierarchical structure with a root node and child nodes forming parent-child relationships without cycles.- What is a graph data structure?
Show answer
A collection of nodes (vertices) connected by edges, where edges can be directed or undirected.- What is a stack data structure?
Show answer
A Last-In-First-Out (LIFO) collection where insertion and deletion occur only at the top.- What is a queue data structure?
Show answer
A First-In-First-Out (FIFO) collection where insertion occurs at the rear and deletion at the front.- What is a database schema?
Show answer
The structure of a database that defines tables, columns, data types, relationships, and constraints.- What is database normalization?
Show answer
The process of organizing tables to reduce redundancy and improve data integrity by following normal forms.- What is database denormalization?
Show answer
The intentional introduction of redundant data to a normalized schema to improve query performance.
FlashKeepers