SQL

Question 1

What does SQL stand for and what is its primary purpose?

Answer 1

Structured Query Language - the programming language used to communicate with databases and operate on them

Question 2

List the 6 categories of SQL commands based on database operations.

Answer 2

1. Database Design-Construction, 2. Data Manipulation, 3. Reporting (querying), 4. Data Control, 5. Transaction Control, 6. Miscellaneous Commands

Question 3

Categorize these SQL operations: Creating tables, SELECT queries, user permissions, BEGIN/COMMIT, INSERT statements, DROP database.

Answer 3

Database Design-Construction: Creating tables, DROP database. Data Manipulation: INSERT statements. Reporting: SELECT queries. Data Control: user permissions. Transaction Control: BEGIN/COMMIT

Question 4

What is the command to connect to MySQL from the command line and what do the parameters mean?

Answer 4

mysql -u user_name -p. Where -u specifies the username and -p prompts for password authentication

Question 5

Explain the relationship between SQL and databases. Can you use databases without SQL?

Answer 5

SQL is the standard language for communicating with relational databases. While some NoSQL databases use different query languages, SQL is essential for relational database operations - you cannot effectively operate relational databases without it