W3. SQL Intro Flashcards
Q: What does SQL stand for?
A: Structured Query Language.
Q: What is SQL primarily used for?
A: Accessing and manipulating databases.
Q: Name three actions SQL can perform on a database.
A: SQL can retrieve data, insert records, and delete records from a database.
Q: Can SQL be used to create new databases and tables?
A: Yes, SQL can create new databases and tables.
Q: What types of permissions can SQL set in a database?
A: Permissions on tables, procedures, and views.
Q: Is SQL the same across all databases?
A: No, there are different versions, but they all support major commands like SELECT, UPDATE, DELETE, and INSERT.
Q: What additional components are needed to display SQL data on a website?
A: An RDBMS (e.g., MySQL), server-side scripting (e.g., PHP), and HTML/CSS for styling.
Q: What does RDBMS stand for?
A: Relational Database Management System.
Q: Name some examples of RDBMS.
A: MS SQL Server, IBM DB2, Oracle, MySQL, Microsoft Access.
Q: In an RDBMS, where is data stored?
A: In database objects called tables.
Q: What is a table in SQL?
A: A collection of related data entries consisting of columns and rows.
Q: What is a field in an SQL table?
A: A column designed to maintain specific information about each record in the table.
Q: Define a record in SQL.
A: Also known as a row, it is an individual entry in a table.
Q: What is a column in SQL?
A: A vertical entity in a table containing all data for a specific field.
Q: Provide an example SQL command to retrieve all data from a table called “Customers.”
A: SELECT * FROM Customers;
