Basics

Question 1

field

Answer 1

column

Question 2

record

Answer 2

row

Question 3

Data Definition Language (DDL)

Answer 3

allow you to create or modify your database structure

Question 4

Data Manipulation Language (DML)

Answer 4

used to manipulate data stored inside your database

Question 5

Data Query Language (DQL)

Answer 5

used for querying or selecting a subset of data from a database

Question 6

Data Control Language (DCL)

Answer 6

used for controlling access to data within a database, commonly used for granting user privileges

Question 7

Transaction Control Commands

Answer 7

used for managing groups of statements as a unit of work

Question 8

varchar

Answer 8

variable number of characters

Question 9

char

Answer 9

fixed length characters

Question 10

decimal

Answer 10

decimal numbers

Question 11

int

Answer 11

integer values

Question 12

date

Answer 12

date data type

Question 13

table creation syntax (basic)

Answer 13

CREATE TABLE [tableName]
( [field1] [data-type],
[field2] [data-type]);

Question 14

insert data into table (basic)

Answer 14

INSERT INTO [TABLE tableName]

VALUES (‘Value1’, ‘Value2’, …);

Question 15

simple SQL query

Answer 15

SELECT [selection] FROM [TABLE name]

Question 16

asdfasdf

Answer 16

asdfasdf