SQL and Database Fundamentals Flashcards
6 cards from real Data and Analytics practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 SQL and Database Fundamentals flashcards as text
Which SQL command permanently removes a table and its data from the database?
Answer: DROP
DROP TABLE removes the entire table definition and all its data permanently from the database.
What is the difference between UNION and UNION ALL in SQL?
Answer: UNION removes duplicates; UNION ALL keeps all rows
UNION removes duplicate rows from the combined result, while UNION ALL retains all rows including duplicates.
Which type of database is best suited for storing unstructured or semi-structured data?
Answer: NoSQL
NoSQL databases like MongoDB or Cassandra are designed to handle unstructured, semi-structured, and rapidly changing data models.
What does ACID stand for in database transactions?
Answer: Atomicity, Consistency, Isolation, Durability
ACID properties (Atomicity, Consistency, Isolation, Durability) guarantee reliable database transaction processing.
What is a stored procedure in SQL?
Answer: A precompiled set of SQL statements stored in the database
A stored procedure is a precompiled, named block of SQL code stored in the database that can be executed on demand.
Which SQL clause specifies the condition for filtering rows in a SELECT statement?
Answer: WHERE
The WHERE clause filters individual rows based on a specified condition before any grouping or aggregation occurs.