ISDS 402 FINAL EXAM QUESTIONS

• | Page

ISDS 402 FINAL EXAM QUESTIONS

WELL ANSWERED TO PAS S

Question: What is DDL?

Correct answer: Data Definition Language, CREATE,

ALTER, DROP

Question: What is DML?

Correct answer: Data manipulation language refers to the

four basic operations that can and must be performed on

data stored in any DBMS: data retrieval, data update,

insertion of new records, and deletion of existing records

Question: What happens when you drop a table in SQL?

Correct answer: you also drop all of its data

Question: When removing tables, where should you

always start?

Correct answer: many side, due to referential integrity

Question: What is the SQL ALTER TABLE statement?

• | Page

Correct answer: The SQL command used to change the

structure of a database table, DDL

Question: What are the uses of DML?

Correct answer: query database and modify data in the

tables

Question: What is Method 1 of inserting data?

Correct answer: Use both names and values of columns

Question: What is Method 2 of inserting data?

Correct answer: use only columns values but not column

names

Question: What does the SELECT clause do?

Correct answer: specifies which columns are to be listed

in the query results

Question: What does the FROM clause do?

• | Page

Correct answer: Specifies the table containing the column

listed in the select clause

Question: What does the WHERE clause do?

Correct answer: specifies which rows are to be listed in

the query results

Question: What is the symbol for all?

Correct answer: * star

Question: What does SELECT DISTINCT do?

Correct answer: specifies that the statement is going to be

a query that returns unique values in the specified column(s)

Question: What does the ORDER BY clause do?

Correct answer: It simply takes the result of a SQL query

and orders them by one or more specified attributes, automatically orders by ASC, can specify DESC

• | Page

Question: What are the three options for the SQL

WHERE clause?

Correct answer: compound clauses with logical operators

(AND, OR, NOT), Ranges using IN or NOT IN or BETWEEN, Wildcards

Question: What is the SQL UPDATE statement?

Correct answer: used to make changes to existing records

within a table, e.g., UPDATE usedcars SET price=29995.00 WHERE year='2014'

Question: What is the SQL DELETE statement?

Correct answer: used to remove records from a table, e.g.,

DELETE FROM usedcars WHERE year='2014'

Question: What does the SQL Wildcard underscore (___)

represent?

Correct answer: Represents single unspecified character

(including a space) in a specific position in the character string