CIS 3400 Database Systems Final
Exam Questions and Answers |
Professor Verified Answers | Graded
A+
SQL - CORRECT ANSWERS is a domain-specific programming language designed for
managing and communicating with data held in a relational database management system
SQL is used for: - CORRECT ANSWERS -creating databases
-adding, modifying and deleting database structures
-inserting, deleting and modifying records in databases
-querying databases
Data Definition Language (DDL) - CORRECT ANSWERS used to create and modify the
structure of the database
example: CREATE ALTER or DROP
Data Manipulation Language (DML) - CORRECT ANSWERS used to insert, modify, delete
and retrieve data
example: INSERT INTO UPDATE or DELETE
Data Retrieval Language (DRL) - CORRECT ANSWERS used to query or retrieve data from
a database
example: SELECT
Data Control Language (DCL) - CORRECT ANSWERS used for data access control
, Transaction Control Language - CORRECT ANSWERS used for managing database
transactions
Keywords - CORRECT ANSWERS These have a very specific meaning in the language. The
statement must have at least one. These often define the operation that is performed
Identifiers - CORRECT ANSWERS These refer to the names of the tables and columns that
are called or manipulated
Null Value - CORRECT ANSWERS is a marker for data that has not been entered or is
missing, unknown, or inapplicable
Not Null Constraint - CORRECT ANSWERS is only a column constraint and not a table
constraint; if you don't specify a _____, the column will accept null values by default
Unique Constraint - CORRECT ANSWERS forces each value of a column or table to be
unique
Check Constraint - CORRECT ANSWERS allows for limiting a particular column based on a
particular value rules
These include:
minimum or maximum value
specified value
range of values
ALTER table - CORRECT ANSWERS provides the ability to:
-add/drop a column
-alter a column's data type
Exam Questions and Answers |
Professor Verified Answers | Graded
A+
SQL - CORRECT ANSWERS is a domain-specific programming language designed for
managing and communicating with data held in a relational database management system
SQL is used for: - CORRECT ANSWERS -creating databases
-adding, modifying and deleting database structures
-inserting, deleting and modifying records in databases
-querying databases
Data Definition Language (DDL) - CORRECT ANSWERS used to create and modify the
structure of the database
example: CREATE ALTER or DROP
Data Manipulation Language (DML) - CORRECT ANSWERS used to insert, modify, delete
and retrieve data
example: INSERT INTO UPDATE or DELETE
Data Retrieval Language (DRL) - CORRECT ANSWERS used to query or retrieve data from
a database
example: SELECT
Data Control Language (DCL) - CORRECT ANSWERS used for data access control
, Transaction Control Language - CORRECT ANSWERS used for managing database
transactions
Keywords - CORRECT ANSWERS These have a very specific meaning in the language. The
statement must have at least one. These often define the operation that is performed
Identifiers - CORRECT ANSWERS These refer to the names of the tables and columns that
are called or manipulated
Null Value - CORRECT ANSWERS is a marker for data that has not been entered or is
missing, unknown, or inapplicable
Not Null Constraint - CORRECT ANSWERS is only a column constraint and not a table
constraint; if you don't specify a _____, the column will accept null values by default
Unique Constraint - CORRECT ANSWERS forces each value of a column or table to be
unique
Check Constraint - CORRECT ANSWERS allows for limiting a particular column based on a
particular value rules
These include:
minimum or maximum value
specified value
range of values
ALTER table - CORRECT ANSWERS provides the ability to:
-add/drop a column
-alter a column's data type
