ch6-ppt

Question 1

DDL

Answer 1

data definition language. DEFINE database. create tables and constraints

Question 2

DML

Answer 2

data manipulation language. MAINTAIN and QUERY database

Question 3

DCL

Answer 3

data control language. CONTROL a database, administer previledges

Question 4

CREATE SCHEMA

Answer 4

defines portion of database owned by particular owner

Question 5

CREATE TABLE

Answer 5

define new table and columns

Question 6

CREATE VIEW

Answer 6

define logical table from one of more tables or views

Question 7

ALTER TABLE

Answer 7

cahnge column specifications

Question 8

INSERT INTO

Answer 8

populate table. can also be used to copy and paste table using a SELECT statement

Question 9

UPDATE

Answer 9

modify all rows with a condition

Question 10

SELECT statement basic clauses

Answer 10

1- SELECT
2- FROM
3- WHERE

Question 11

WHERE

Answer 11

conditional operator. answers which rows will be included in the result

Question 12

LIKE

Answer 12

use only for wildcard conditionals

Question 13

wildcards

Answer 13

• (any sequence at beg or end)
  ? (any character)

use LIKE conditional

Question 14

BETWEEN date usage

Answer 14

surround dates with pound signs #

Question 15

expressions

Answer 15

AS statements used to rename colums in the resulting query.

Question 16

aggregate functions

Answer 16

1-COUNT()
2-MIN/MAX()
3-AVG()
4-SUM()

Question 17

ORDER BY

Answer 17

last element in SELECT statement. organize in abc order. use DESC for descending.

Question 18

GROUP BY

Answer 18

summary row for each unique GROUP

Question 19

HAVING

Answer 19

quality groups by a conditional