INSY 3304 CHAPTER 7 QUESTIONS AND ANSWERS 100% CORRECT

INSY 3304 CHAPTER 7 QUESTIONS AND
ANSWERS 100% CORRECT
Data Definiton Language (DDL) - ANSWER-The DBMS language component used to
create, alter and destroy databases and database objects

i.e. schemas, tables, views, sequences, catalogs, indexes, and aliases.

Data Manipulation Language (DML) - ANSWER-SQL commands that changes
database content, including data element creations, updates, insertions, and deletions

what type of language is SQL - ANSWER-a Nonprocedural language with basic
command vocabulary set of less than 100 words

What statement is used to create a database schema - ANSWER-CREATE DATABASE

what statement is used to create a new table in the user's database schema -
ANSWER-CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
);

what statement is used to modify a table's definition which includes adding, modifying
and deleting constraints - ANSWER-ALTER TABLE

what statement is used to delete a table and its data - ANSWER-DROP TABLE

what statement is used to insert rows into a table - ANSWER-INSERT


what is used with SELECT to return mathematical summaries on columns - ANSWER-
Aggregate Functions

what are all the Aggregate Functions statements? - ANSWER-COUNT, MIN, MAX,
SUM, AVG


what statement groups the selected rows based on one or more attributes? - ANSWER-
GROUP BY