Questions I need to review on quizzes

Question 1

statement: insert new data

Answer 1

INSERT INTO

Question 2

select entries where a column value is between two values

Answer 2

SELECT * FROM <table name> WHERE <col name> BETWEEN <val 1> AND <val 2>

Question 3

returns only different values

Answer 3

SELECT DISTINCT

Question 4

sorts result set

Answer 4

ORDER BY

Question 5

insert new record

Answer 5

INSERT INTO <table name> VALUES (<value * as many columns to fill>)

Question 6

insert new value in a specific column

Answer 6

INSERT INTO <table name> (<col name>) VALUES (<value>)</value>

Question 7

change column value from a specific column value

Answer 7

UPDATE <table name> SET <col name>=<new> WHERE <col name>=<old></old></new>

Question 8

delete where column is a specific value

Answer 8

DELETE FROM <table name> WHERE <col name> = <value></value>

Question 9

return number of records

Answer 9

SELECT COUNT(*) FROM <table name>

Question 10

limit the returned items to a number of columns

Answer 10

SELECT * FROM <table name> LIMIT <numer></numer>

Question 11

join that extracts data of matching rows from both tables

Answer 11

full outer join

Question 12

blob stands for

Answer 12

binary large object

Question 13

a cursor in sql is

Answer 13

read only

Question 14

data type used to store JSON objects

Answer 14

NVarchar

Question 15

update auto increment value of a table

Answer 15

ALTER TABLE <table name> AUTO_INCREMENT = <value></value>

Question 16

grab current time of the system

Answer 16

current_timestamp()