SQL

Question 1

MySQL Command-Line Client

Answer 1

a text interface included in the MySQL Server download. MySQL Server returns an error code and description when an SQL statement is syntactically incorrect or the database cannot execute the statement.

Question 2

Tuple

Answer 2

ordered collection of elements encolsed in parentheses; (a, b, c)

Question 3

Types of Literals

Answer 3

Must be surrounded by single quotes or double quotes; ‘String’ or “String”

Question 4

Types of Keywords

Answer 4

Words with special meaning; SELECT, FROM, WHERE

Question 5

Data Definition Language (DDL)

Answer 5

a set of commands in a database that lets you CREATE, ALTER, or DROP structures like tables and databases.

Question 6

Data Query Language

Answer 6

a set of commands in a database that allows you to ask questions and get information from the data.
SELECT is used to retrieve info from tables

Question 7

Data Manipulation Language

Answer 7

a set of commands in a database that lets you work with the data itself—INSERT, UPDATE, or DELETE.

Question 8

Data Control Language

Answer 8

a set of commands in a database used to manage permissions—deciding who can access or modify data.

Question 9

Data Transaction Language

Answer 9

a set of commands in a database used to manage and control changes, ensuring that data stays accurate and consistent during multi-step operations, called transactions.

Question 10

CREATE TABLE

Answer 10

creates a new table by specifying the table name, column names, and column data types.

Question 11

DROP TABLE

Answer 11

deletes a table, along with all the table’s rows, from a database.

Question 12

ALTER TABLE

Answer 12

adds, deletes, or modifies column on an existing table