CIS 3365 Midterm Exam Questions
and Answers All Correct
The most useful feature of PL/SQL blocks is that let a designer create code that can be
named, stored, and executed by the DBMS. - Answer-True
The SQL aggregate function that gives the number of rows containing non null values
for a given column is ____. - Answer-COUNT
A view is a virtual table based on a SELECT query. - Answer-True
Which SQL format would be best used for a small, numeric, data type? - Answer-
SMALLINT
The special operator used to check whether a subquery returns any rows is ___. -
Answer-EXISTS
Triggers can only be used to update table values. - Answer-False
BEFORE means before the changes are made in memory but after the changes are
permanently saved to disk. - Answer-False
One of the major advantages of stored procedures is that they can be used to
encapsulate and represent business transactions. - Answer-True
Stored procedures must have at least one argument. - Answer-False
A sequence is not associated with a table and can be dropped from a database with a
DROP SEQUENCE command. - Answer-True
A statement level trigger is assumed if a designer omits the FOR EACH ROW
keywords. - Answer-True
Automating business procedures and automatically maintaining data integrity
consistency are trivial in a modern business environment. - Answer-False
A row level trigger is assumed if we omit the FOR EACH ROW keywords and a
statement level trigger required the use of the FOR EACH ROW keyword. - Answer-
False
, Just like database triggers, stored procedures are stored in the database. - Answer-
True
An explicit cursor must return two or more rows. - Answer-False
A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the
occurrence of a given data manipulation event. - Answer-True
A persistent stored module is stored and executed on the database client machine. -
Answer-False
_____ relates to the activities that make the database execute transactions more
efficiently in terms of storage and access speed. - Answer-Performance tuning
A(n) _____ enables a database administrator to describe schema components. -
Answer-Data definition language (DDL)
In the context of data models, an entity is a person, place, thing, or event about which
data will be collected and stored. - Answer-True
Within the database environment, a data model represents data structures with the
purpose of supporting a specific problem domain. - Answer-True
A data warehouse can store data derived from many sources. - Answer-True
In an SQL based relational database, each table is dependent on every other table. -
Answer-False
The only way to access the data in a database is through the DBMS. - Answer-True
The DBMS reveals much of the database's internal complexity to the application
programs and users. - Answer-False
A noun in a business rule translates to a(n) _____ in the data model. - Answer-Entity
Data and information are essentially the same thing. - Answer-False
____ exists when different versions of the same data appear in different places. -
Answer-Data inconsistency
The response of the DBMS to a query is the ___________ - Answer-Query result set
_____ data exist in a format that does not lend itself to processing that yields
information. - Answer-Unstructured
and Answers All Correct
The most useful feature of PL/SQL blocks is that let a designer create code that can be
named, stored, and executed by the DBMS. - Answer-True
The SQL aggregate function that gives the number of rows containing non null values
for a given column is ____. - Answer-COUNT
A view is a virtual table based on a SELECT query. - Answer-True
Which SQL format would be best used for a small, numeric, data type? - Answer-
SMALLINT
The special operator used to check whether a subquery returns any rows is ___. -
Answer-EXISTS
Triggers can only be used to update table values. - Answer-False
BEFORE means before the changes are made in memory but after the changes are
permanently saved to disk. - Answer-False
One of the major advantages of stored procedures is that they can be used to
encapsulate and represent business transactions. - Answer-True
Stored procedures must have at least one argument. - Answer-False
A sequence is not associated with a table and can be dropped from a database with a
DROP SEQUENCE command. - Answer-True
A statement level trigger is assumed if a designer omits the FOR EACH ROW
keywords. - Answer-True
Automating business procedures and automatically maintaining data integrity
consistency are trivial in a modern business environment. - Answer-False
A row level trigger is assumed if we omit the FOR EACH ROW keywords and a
statement level trigger required the use of the FOR EACH ROW keyword. - Answer-
False
, Just like database triggers, stored procedures are stored in the database. - Answer-
True
An explicit cursor must return two or more rows. - Answer-False
A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the
occurrence of a given data manipulation event. - Answer-True
A persistent stored module is stored and executed on the database client machine. -
Answer-False
_____ relates to the activities that make the database execute transactions more
efficiently in terms of storage and access speed. - Answer-Performance tuning
A(n) _____ enables a database administrator to describe schema components. -
Answer-Data definition language (DDL)
In the context of data models, an entity is a person, place, thing, or event about which
data will be collected and stored. - Answer-True
Within the database environment, a data model represents data structures with the
purpose of supporting a specific problem domain. - Answer-True
A data warehouse can store data derived from many sources. - Answer-True
In an SQL based relational database, each table is dependent on every other table. -
Answer-False
The only way to access the data in a database is through the DBMS. - Answer-True
The DBMS reveals much of the database's internal complexity to the application
programs and users. - Answer-False
A noun in a business rule translates to a(n) _____ in the data model. - Answer-Entity
Data and information are essentially the same thing. - Answer-False
____ exists when different versions of the same data appear in different places. -
Answer-Data inconsistency
The response of the DBMS to a query is the ___________ - Answer-Query result set
_____ data exist in a format that does not lend itself to processing that yields
information. - Answer-Unstructured
