ISM 4212 FSU Final Exam | UPDATED Questions with
100% Verified Answers
Q1: Data Definition Language (DDL)
A: Commands used to define a database, including
creating, altering, and dropping tables and
establishing constraints
Q2: Data Manipulation Language (DML)
A: Commands that maintain and query a database
(Insert, update, delete, select)
Q3: Data Control Language (DCL)
A: Commands that control a database, including
administering privileges and committing data
Q4: Referential Integrity
A: Constraint that states that foreign key values of a
table must match primary key values of a related
table
Q5: ALTER command
A: Add one or multiple columns after creating a
table
Example: ALTER TABLE supplier ADD
(supplier_name char(50), city_char(45));
Q6: Drop Table Statement
A: allows you to remove tables
Example: DROP TABLE CUSTOMER_T
Q7: DELETE Statement
A: removes rows from a table
Examples
Delete certain rows
DELETE FROM CUSTOMER_T WHERE
CUSTOMERSTATE = 'HI';
Delete all rows: DELETE FROM CUSTOMER_T
Q8: SELECT Statement
A: List the columns you want data for (i.e. that
should be returned to query)
, Example
Select columnName From tableName
use the wildcard (called star) * after SELECT to
get everything (all rows, all columns) in table
SELECT DISTINCT returns only distinct values
Q9: FROM Statement
A: Indicates the table(s) from which data will be
obtained
Q10: WHERE statement
A: Indicate the conditions under which a row will
be included in the result; used to narrow or filter
results
Format
SELECT columnName FROM tableName WHERE
condition
Example
SELECT LastName FROM employee WHERE
EmplID = 1002
Q11: AND and OR Statements
A: Used to filter based on more than one condition
Example
SELECT * FROM Customers WHERE
Country='Germany' AND City='Berlin'
Q12: COUNT Statement
A: Use the COUNT function to find totals
Example
SELECT COUNT(*) FROM order WHERE orderID
= 1004
Q13: JOIN statement
A: An operation that causes two or more tables
with a common field to be combined into a
single table or view
Q14: INNER/NATURAL JOIN
100% Verified Answers
Q1: Data Definition Language (DDL)
A: Commands used to define a database, including
creating, altering, and dropping tables and
establishing constraints
Q2: Data Manipulation Language (DML)
A: Commands that maintain and query a database
(Insert, update, delete, select)
Q3: Data Control Language (DCL)
A: Commands that control a database, including
administering privileges and committing data
Q4: Referential Integrity
A: Constraint that states that foreign key values of a
table must match primary key values of a related
table
Q5: ALTER command
A: Add one or multiple columns after creating a
table
Example: ALTER TABLE supplier ADD
(supplier_name char(50), city_char(45));
Q6: Drop Table Statement
A: allows you to remove tables
Example: DROP TABLE CUSTOMER_T
Q7: DELETE Statement
A: removes rows from a table
Examples
Delete certain rows
DELETE FROM CUSTOMER_T WHERE
CUSTOMERSTATE = 'HI';
Delete all rows: DELETE FROM CUSTOMER_T
Q8: SELECT Statement
A: List the columns you want data for (i.e. that
should be returned to query)
, Example
Select columnName From tableName
use the wildcard (called star) * after SELECT to
get everything (all rows, all columns) in table
SELECT DISTINCT returns only distinct values
Q9: FROM Statement
A: Indicates the table(s) from which data will be
obtained
Q10: WHERE statement
A: Indicate the conditions under which a row will
be included in the result; used to narrow or filter
results
Format
SELECT columnName FROM tableName WHERE
condition
Example
SELECT LastName FROM employee WHERE
EmplID = 1002
Q11: AND and OR Statements
A: Used to filter based on more than one condition
Example
SELECT * FROM Customers WHERE
Country='Germany' AND City='Berlin'
Q12: COUNT Statement
A: Use the COUNT function to find totals
Example
SELECT COUNT(*) FROM order WHERE orderID
= 1004
Q13: JOIN statement
A: An operation that causes two or more tables
with a common field to be combined into a
single table or view
Q14: INNER/NATURAL JOIN
