SQL and Database Basics Flashcards
7 cards from real Online Coding Lessons practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 SQL and Database Basics flashcards as text
What does SQL stand for?
Answer: Structured Query Language
SQL stands for Structured Query Language, which is used to communicate with and manipulate databases.
Which SQL command is used to retrieve data from a database table?
Answer: SELECT
The SELECT command is the standard SQL statement used to query and retrieve data from one or more tables.
What keyword is used in SQL to filter rows returned by a SELECT query?
Answer: WHERE
The WHERE clause is used to specify conditions that rows must meet to be included in the query results.
Which SQL command adds a new row of data to a table?
Answer: INSERT INTO
INSERT INTO is the SQL command used to add new records (rows) into a database table.
In a database table, what is a primary key?
Answer: A column that uniquely identifies each row
A primary key is a column (or combination of columns) whose values uniquely identify every row in a table.
Which SQL command is used to remove rows from a table?
Answer: DELETE
The DELETE statement removes one or more rows from a table based on an optional WHERE condition.
What does the ORDER BY clause do in a SQL query?
Answer: Sorts the result set by one or more columns
ORDER BY sorts the rows in the result set in ascending (ASC) or descending (DESC) order based on specified columns.