Chapter 6: Fundamentals of SQL

Question 1

creates a database schema

Answer 1

create schema authorization

Question 2

creates a new table in the user’s database schema

Answer 2

create table

Question 3

ensures that a column will not have null values

Answer 3

not null

Question 4

ensures that a column will not have duplicate values

Answer 4

unique

Question 5

defines a primary key for a table

Answer 5

primary key

Question 6

defines a foreign key for a table

Answer 6

foreign key

Question 7

defines a default value for a column (when no value is given)

Answer 7

default

Question 8

validates data in an attribute

Answer 8

check

Question 9

creates an index for a table

Answer 9

create index

Question 10

creates a dynamic subset of rows and columns from one or more tables

Answer 10

create view

Question 11

modifies a table’s definition (adds, modifies, or deletes attributes or consrtraints)

Answer 11

alter table

Question 12

creates a new table based on a query in the user’s database schema

Answer 12

create table as

Question 13

permanently deletes a table (and its data)

Answer 13

drop table

Question 14

permanently deletes an index

Answer 14

drop index

Question 15

permanently deletes a view

Answer 15

drop view

Question 16

insert row(s) into a table

Answer 16

insert

Question 17

selects attributes from rows in one or more tables or views

Answer 17

select

Question 18

restricts the selection of rows based on a conditional expression

Answer 18

where

Question 19

groups the selected rows based on one or more attributes

Answer 19

group by

Question 20

restricts the selection of grouped rows based on a condition

Answer 20

having

Question 21

orders the selected rows based on one or more attributes

Answer 21

order by

Question 22

modifies an attribute’s value in one or more table’s rows

Answer 22

update

Question 23

deletes one or more rows from a table

Answer 23

delete

Question 24

permanently saves data changes

Answer 24

commit

Question 25

restores data to its original values

Answer 25

rollback

Question 26

checks whether an attribute value is within a range

Answer 26

between

Question 27

checks whether an attribute value is null

Answer 27

is null

Question 28

checks whether an attribute value matches a given string pattern

Answer 28

like

Question 29

checks whether a subquery returns any rows

Answer 29

exists

Question 30

limits values to unique values

Answer 30

distinct

Question 31

returns the number of rows with non=null values for a given column

Answer 31

count

Question 32

returns the minimum attribute value found in a given column

Answer 32

MIN

Question 33

returns the maximum attribute value found in a given column

Answer 33

max

Question 34

returns the sum of all values for a given column

Answer 34

sum

Question 35

returns the average of all values for a given column

Answer 35

avg

Question 36

an alternate name given to a column or table in any SQL statement

Answer 36

alias