INFS 346 Exam 3 Questions With Correct
Answers
SQL - CORRECT ANSWER✔✔-used to create the database; add, modify,
| | | | | | | | | |
and delete database structures; and insert, delete and modify records in
| | | | | | | | | |
the database
| |
data definition language - CORRECT ANSWER✔✔-statements used to
| | | | | | | |
create and modify the structure of the database; enables the
| | | | | | | | | |
implementation of the relational schema (and other additional
| | | | | | | |
structures, such as indexes and other constraints) as an actual database
| | | | | | | | | |
data manipulation language - CORRECT ANSWER✔✔-statements used
| | | | | | |
to manipulate data within the database
| | | | |
data control language - CORRECT ANSWER✔✔-statements that facilitate
| | | | | | |
the process of data access control
| | | | | |
transaction control language - CORRECT ANSWER✔✔-statements used
| | | | | | |
to manage database transactions
| | |
, SQL data types - CORRECT ANSWER✔✔-CHAR, VARCHAR, INT,
| | | | | | | |
NUMERIC, DATE |
SQL syntax - CORRECT ANSWER✔✔-semicolon at the end of a
| | | | | | | | | |
statement, not case-sensitive, can be written as one long line of text
| | | | | | | | | | |
view - CORRECT ANSWER✔✔-a mechanism in SQL that allows the
| | | | | | | | | |
structure of a query to be saved in the RDBMS| | | | | | | | |
set operators - CORRECT ANSWER✔✔-union, intersect, and difference;
| | | | | | | |
used to combine the results of two or more SELECT statements that are
| | | | | | | | | | | | |
union compatible |
delete restrict - CORRECT ANSWER✔✔-option does not allow a record
| | | | | | | | | |
to be deleted if its primary key value is referred to by a foreign key value
| | | | | | | | | | | | | | |
delete cascade - CORRECT ANSWER✔✔-option allows a record to be
| | | | | | | | | |
deleted if its primary key value is referred to by a foreign key value;
| | | | | | | | | | | | | |
however, all the records whose foreign key value refers to the primary
| | | | | | | | | | | |
key value of the record being deleted will also be deleted
| | | | | | | | | |
delete set-to-null - CORRECT ANSWER✔✔-allows a record to be deleted
| | | | | | | | | |
if its primary key value is referred to by a foreign key value of a record in
| | | | | | | | | | | | | | | | |
Answers
SQL - CORRECT ANSWER✔✔-used to create the database; add, modify,
| | | | | | | | | |
and delete database structures; and insert, delete and modify records in
| | | | | | | | | |
the database
| |
data definition language - CORRECT ANSWER✔✔-statements used to
| | | | | | | |
create and modify the structure of the database; enables the
| | | | | | | | | |
implementation of the relational schema (and other additional
| | | | | | | |
structures, such as indexes and other constraints) as an actual database
| | | | | | | | | |
data manipulation language - CORRECT ANSWER✔✔-statements used
| | | | | | |
to manipulate data within the database
| | | | |
data control language - CORRECT ANSWER✔✔-statements that facilitate
| | | | | | |
the process of data access control
| | | | | |
transaction control language - CORRECT ANSWER✔✔-statements used
| | | | | | |
to manage database transactions
| | |
, SQL data types - CORRECT ANSWER✔✔-CHAR, VARCHAR, INT,
| | | | | | | |
NUMERIC, DATE |
SQL syntax - CORRECT ANSWER✔✔-semicolon at the end of a
| | | | | | | | | |
statement, not case-sensitive, can be written as one long line of text
| | | | | | | | | | |
view - CORRECT ANSWER✔✔-a mechanism in SQL that allows the
| | | | | | | | | |
structure of a query to be saved in the RDBMS| | | | | | | | |
set operators - CORRECT ANSWER✔✔-union, intersect, and difference;
| | | | | | | |
used to combine the results of two or more SELECT statements that are
| | | | | | | | | | | | |
union compatible |
delete restrict - CORRECT ANSWER✔✔-option does not allow a record
| | | | | | | | | |
to be deleted if its primary key value is referred to by a foreign key value
| | | | | | | | | | | | | | |
delete cascade - CORRECT ANSWER✔✔-option allows a record to be
| | | | | | | | | |
deleted if its primary key value is referred to by a foreign key value;
| | | | | | | | | | | | | |
however, all the records whose foreign key value refers to the primary
| | | | | | | | | | | |
key value of the record being deleted will also be deleted
| | | | | | | | | |
delete set-to-null - CORRECT ANSWER✔✔-allows a record to be deleted
| | | | | | | | | |
if its primary key value is referred to by a foreign key value of a record in
| | | | | | | | | | | | | | | | |
