SQL Commands

Question 1

Alter Table

Answer 1

Adds new column or deletes column or index

Question 2

Add

Answer 2

Adds a new column to the table

Question 3

Drop Column

Answer 3

Deletes the column

Question 4

Create Index # on Column

Answer 4

Creates an index on the table

Question 5

Select

Answer 5

Retrieves and sorts information

Question 6

Insert Into

Answer 6

Add a row to the table

Question 7

Update, Set

Answer 7

Change the value of a column

Question 8

What is a Procedure

Answer 8

Stored SQL code to be used later

Question 9

select *

Answer 9

select any

Question 10

select gender
, count (*)
from Employee
group by Gender

Answer 10

Shows the amount of men and women (shows the amount of people for each classification of genders)

Question 11

CONCAT

Answer 11

Adds two or more strings together

Question 12

distinct

Answer 12

prevents duplicates from being displayed in the query.

Question 13

where

Answer 13

filter records displayed that meet a certain condition

Question 14

or requires how many sides to be true

Answer 14

1

Question 15

and requires how many sides to be true

Answer 15

both sides

Question 16

IN

Answer 16

multiple or statements, returns all values separated by a comma.

Question 17

between

Answer 17

selects values within a given range

Question 18

union

Answer 18

combine results of 2 select statements with the same number of columns

Question 19

Except

Answer 19

Exclude in first query if it happens as well in the second query

Question 20

Intersect

Answer 20

Include queries from ONLY both rows

Question 21

’%’

Answer 21

Return arbitrary amount of results

Question 22

‘_’

Answer 22

Return only a single character

Question 23

cross join

Answer 23

comparing each row of the first table with each one of the second table.

Question 24

into

Answer 24

combine two completely different table result sets. Both tables need to be accessable
use Student16
go

select * from LobsterFarm.dbo.employee

Question 25

drop table if exists

Answer 25

delete a table from the database (unrecoverable if there is no backup, there is no confirmation message)

Question 26

go

Answer 26

indicates that prior commands are ready to be executed

Question 27

with

Answer 27

allows you to give a subquery block a name

Question 28

insert

Answer 28

insert new records into the table

Question 29

update

Answer 29

modify existing data

Question 30

delete

Answer 30

delete existing records