What is SQL used for?
SQL defines relational tables and retrieves information from the data they contain.
Study 3 SQL Fundamentals with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.
What is SQL used for?
SQL defines relational tables and retrieves information from the data they contain.
What are the basic parts of a relational table?
A table has named columns and rows. Each column has a data type suited to the values it stores.
What does a primary key do?
A primary key uniquely identifies each row. It can consist of one column or several columns.
What does the NOT NULL constraint require?
NOT NULL requires a column to have a value; it prevents missing values in that column.
What does the UNIQUE constraint prevent?
UNIQUE prevents duplicate values in the constrained column or columns.
How does a CHECK constraint protect data?
CHECK enforces a condition on values. For example, CHECK (price >= 0) prevents negative prices.
What do SELECT and FROM specify in a basic query?
SELECT names the columns to return, and FROM names the table to read. Use * to request all columns.
What does WHERE do in a query?
WHERE keeps only rows whose condition is true, such as rows with price < 25 AND in_stock > 0.
How should a query test for a NULL value?
NULL represents a missing or unknown value; it is not the same as zero or an empty string. Test it with IS NULL or IS NOT NULL.
What does the IN operator check?
IN matches a value against a list of alternatives, such as category IN ('Books', 'Games').
How does ORDER BY affect query results?
ORDER BY requests a result order. ASC is the default; DESC sorts in descending order. Without ORDER BY, row order is not guaranteed.
What does LIMIT do, and why pair it with ORDER BY?
LIMIT restricts the number of returned rows in many databases. Pair it with ORDER BY for a predictable selection.
A 14-question medium-difficulty quiz on Boolean algebra, logic gates, truth tables, and combinational circuits.
A focused set of flashcards covering Python variables, data types, expressions, control flow, functions, input, output, and common programming practices.
A structured guide to the main data structures, their operations, efficiency trade-offs, representations, and practical selection criteria.
Learn how computer memory stores and addresses information, how RAM and ROM differ, and how caches and the memory hierarchy balance speed, capacity, and cost.
A progressive guide to tree structure, binary-tree traversals, binary search tree operations, deletion, balancing, and the way tree height determines time and space costs.
A focused review of propositional logic, quantifiers, sets, relations, functions, and foundational proof methods in discrete mathematics for computer science.
Reviews how interrupts support event handling and multitasking, and how Linux system calls use the RISC-V `ecall` instruction and register conventions.
This quiz covers process management, context switching and scheduling, multitasking, traps and interrupts, and RISC-V privilege transitions.
A quiz on operating-system system calls, including privileged-operation requests, process creation and execution with fork, exec, and waitpid, and signal handling.