Structured Query Language (SQL)

Question 1

Fundamental SQL Functionality for RDBMS,

Answer 1

CRUD data, Create/Manage databases, Design/Create DB Tables, Perform admin tasks (security, user management, import/export, backup)

Question 2

SQL, a universal language?

Answer 2

SQL implementation my vary between RDBMS.

Question 3

SQL, a Hybrid Language

Answer 3

Data Query Language (DQL), Data Definition Language (DDL), Data Control Language (DCL), Data Manipulation Language (DML)

Question 4

DQL

Answer 4

Data Query Language. Get data that’s already stored

Question 5

DDL

Answer 5

Data Definition Language. Define the schema of a DB and its data

Question 6

DCL

Answer 6

Data Control Language. Create permissions which control a user’s access to the data

Question 7

DML

Answer 7

Data Manipulation Language. Insert, update, and delete data

Question 8

Query

Answer 8

Set of instructions, tells the RDBMS what information to retrieve. Strategic parsing from the data within a table(s)

Question 9

mySQL login

Answer 9

mysql -u root -p