ch6

Question 1

define portion of database that a particular owner owns. dependent on a catalog

Answer 1

CREATE SCEHMA

Question 2

defines a new table and columns. needs a schema to put it in

Answer 2

CREATE TABLE

Question 3

defines logical table from other views

Answer 3

CREATE VIEW

Question 4

delete a table

Answer 4

DROP TABLE Tablename

Question 5

modify columns of existing table

Answer 5

ALTER TABLE

Question 6

CREATE TABLE syntax

Answer 6

CREATE TABLE
(cols data_type [NOT NULL]
CONSTRAINT Table_PK PRIMARY KEY (col_name)

Question 7

insert row into db

Answer 7

INSERT INTO (cols) TableName VALUES (data, data…)

Question 8

delete database contents

Answer 8

DELETE FROM TableName WHERE condition

Question 9

modify database contents

Answer 9

UPDATE TableName SET condition WHERE condition

Question 10

make an index

Answer 10

CREATE INDEX IndexName ON TableName (ColName)

Question 11

SELECT syntax

Answer 11

SELECT (cols) FROM TableName WHERE condition

Question 12

select only unique rows

Answer 12

use SELECT DISTINCT

Question 13

alias in oracle

Answer 13

use AS, used to rename cols into better names