MySQL

Question 1

MySQL is a

Answer 1

relational database management system (RDBMS)

Question 2

SQL is a database language for

Answer 2

• creating database and table structures
• performing data manipulation and administration
• querying the database to extract useful information

Question 3

SQL is a

Answer 3

nonprocedural language

Question 4

what does SQL is a nonprocedural language mean

Answer 4

the user specifies what must be done, but not how.
where the data is stored isn’t important, only the specified relations + relationships matter

Question 5

t/f: all relational DBMS software supports SQL

Answer 5

true

Question 6

different SQL DBMS software

Answer 6

• oracle
• mySQL
• MS SQL Server
• DB2
• MS Access

Question 7

many database vendors have developed

Answer 7

extensions

Question 8

extensions

Answer 8

• basic, simple vocab of < 100 ‘words’
• different dialects w minor differences

Question 9

categories of SQL commands

Answer 9

Data Definition Language (DDL) and Data Manipulation Language (DML)

Question 10

DDL

Answer 10

commands that define a database
- includes creating, altering, dropping tables and stored procedures, and establishing constraints

Question 11

examples of DDL commands

Answer 11

CREATE TABLE, set PRIMARY KEY

Question 12

DML

Answer 12

commands that are used to manipulate data and extract information

Question 13

examples of DML commands

Answer 13

select, update, insert, delete

Question 14

mySQL data types

Answer 14

numeric, date and time, string

Question 15

primary numeric types

Answer 15

tinyint, smallint, mediumint, int, bigint, decimal(M, D)

Question 16

primary date and time types

Answer 16

date and datetime

Question 17

format of datetime

Answer 17

YYYY-MM-DD HH:MM:SS

Question 18

invalid dates and times are converted to

Answer 18

zero values 0000-00-00

Question 19

built-in date and time functions

Answer 19

now(), curdate(), datediff(), intervaldate(), time(), day(), year(), month()

Question 20

primary string types

Answer 20

char(n), varchar(n), blob, text, enum

Question 21

values that exceed n characters in length are

Answer 21

truncated

Question 22

blob

Answer 22

used for large binary strings of data

Question 23

text

Answer 23

large character strings of data

Question 24

enum

Answer 24

string object with value chosen from list of permitted values that is specified at table creation

Question 25

primary DML commands

Answer 25

data retrieval ('standard' queries) and action queries

Question 26

standard query ex

Answer 26

select

Question 27

action queries

Answer 27

insert, update, delete

Question 28

SQL statements are case

Answer 28

insensitive

Question 29

enclose non-numeric values (string, date/time) in

Answer 29

single quotation marks

Question 30

general SELECT format

Answer 30

select [distinct | all] (* | column1[AS new_name] [..] } from table_name [alias] [where conditions] [group by column_list] [having condition] [order by column_list]

Question 31

{} and [], which is required

Answer 31

{}, [] is optional

Question 32

insert statement format

Answer 32

insert into tablename(column1, column2) values(value1, value2)

Question 33

update statement format

Answer 33

update tablename set column1=value1, column2=value2 where criteria

Question 34

delete statement format

Answer 34

delete from table where criteria