Which query will output the table contents when the value of the character field
P_CODE is alphabetically less than 1558-QW1?
a. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT
WHERE P_CODE <‘1558-QW1’;
b. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT
WHERE P_CODE = [1558-QW1]
c. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT
WHERE P_CODE = (1558-QW1)
d. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT
WHERE P_CODE = {1558-QW1}
The conceptual design step that identifies ER modules and validates insert, update, and
delete rules is ____.
a. database analysis and requirements
b. ER modeling and normalization
c. data-model verification
d. distributed database design
A ____ should be a derived attribute.
a. person’s name
b. person’s age
c. person’s social security number
d. person’s phone number
The “____” characteristic of a primary key states the following:
The PK must uniquely identify each entity instance. A primary key must be able to
guarantee unique values. It cannot contain nulls.
a. unique values
b. nonintelligent
c. preferably single-attribute
d. security complaint
In the ERD, cardinality is indicated using the ____ notation.
a. (max, min)
b. (min, max)
c. [min … max]
d. {min|max}
A ____ lock allows concurrent transactions to access different rows of the same table.
a. database-level
b. table-level
c. page-level
d. row-level
A manager and a programmer usually have the same view of the same data.
“What are the requirements of the current system’s end users?”is a question asked
during the ____ phase of the SDLC.
a. planning
b. analysis
c. implementation
d. maintenance
Assume you are using the UNION operator to combine the results from two tables with
identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains
10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and
Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table.
How many records are returned when using the UNION operator?
a. 7
b. 10
c. 15
d. 17
The ANSI has defined standards that govern SQL database transactions. Transaction
support is provided by two SQL statements: ____ and ROLLBACK.
a. RETRIEVE
b. ASSIGN
c. UPDATE
d. COMMIT
In the ____ category, the cloud service provider offers the capability to build and
deploy consumer-created applications using the provider’s cloud infrastructure.
a. API as a Service (AaaS)
b. Infrastructure as a Service (IaaS)
c. Software as a Service (SaaS)
d. Platform as a Service (PaaS)
When you define a table’s primary key, the DBMS automatically creates a(n) ____
index on the primary key column(s) you declared.
a. key
b. incomplete
c. unique
d. primary
A ____ attribute can have only one value.
a. composite
b. simple
c. single-valued
d. multivalued
A(n) ____ entity is composed of the primary keys of each of the entities to be
connected.
a. associative
b. recursive
c. unary
d. binary
____ management is designed to limit access to the database.
a. Authorization
b. User access
c. View
d. DBMS utility
There are 12 rules that define a(n) ____.
a. data warehouse
b. multidimensional cube
c. OLAP tool
d. star schema
A(n) ____ is the equivalent of a field in a file system.
a. attribute
b. entity
c. relationship
d. constraint
The database initial study phase of the DBLC involves ____.
a. defining objectives
b. introducing changes
c. testing the database
d. installing the DBMS
A(n) ____ data dictionary is not updated automatically and usually requires a batch
process to be run.
a. active
b. passive
c. static
d. dynamic
A ____ lock locks the entire table preventing access to any row by a transaction while
another transaction is using the table.
a. database-level
b. table-level
c. page-level
d. row-level
A ____ key can be described as a superkey without unnecessary attributes, that is, a
minimal superkey.
a. secondary
b. candidate
c. primary
d. foreign
The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and
the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the
VENDOR table where the values of V_CODE match is ____.
a. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,
V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <>
VENDOR.V_CODE;
b. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,
V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE =
VENDOR.V_CODE;
c. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,
V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <=
VENDOR.V_CODE;
d. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,
V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE =>
VENDOR.V_CODE;
The M:N relationship between STUDENT and CLASS must be divided into two 1:M
relationships through the use of the ENROLL entity; the ENROLL entity is ____.
a. weak
b. strong
c. optional
d. mandatory
A(n) ____ database supports a relatively small number of users (usually fewer than 50)
or a specific department within an organization.
a. desktop
b. workgroup
c. enterprise
d. transactional
A ____ lock prevents the use of any tables in the database from one transaction while
another transaction is being processed.
a. database-level
b. table-level
c. page-level
d. row-level
A ____ is any key that uniquely identifies each row.
a. superkey
b. special
c. selective
d. candidate
The ____ rule requires that all copies of data fragments be identical.
a. shared fragment
b. mutual consistency
c. horizontal fragmentation
d. replication
The implementation and loading phase of the DBLC involves ____.
a. defining objectives
b. introducing changes
c. testing the database
d. installing the DBMS
Installing the DBMS, creating the database, and loading or converting the data are part
of the ____ phase of the DBLC.
a. database initial study
b. database design
c. implementation and loading
d. testing and evaluation
MySQL is an example of a(n) ____.
a. hierarchical model
b. file system data model
c. relational data model
d. XML data model
A(n) ____ is a logical grouping of several data files that store data with similar
characteristics.
a. procedure cache
b. file group
c. data files
d. extends
A distributed database is composed of several parts known as database ____.
a. sections
b. fragments
c. partitions
d. parts
Data is captured from the OLTP system and placed on the ____ on a near-real time
basis.
a. decision support system
b. portal
c. data warehouse
d. dashboard
The system will perform best when its hardware and software resources are
____________________.
In a natural join, the column on which the join was made occurs twice in the new table.
A(n) ____________________ process is based on repetition of processes and
procedures.
The label “stateless system” indicates that, at any given time, a Web server knows the
status of the clients communicating with it.
A(n) ____________________ order sequence is a multilevel ordered sequence that can
be created easily by listing several attributes, separated by commas, after the ORDER
BY clause.
The __________________________________________________ scenario is typical
of most mainframe and midrange server computer DBMSs.
Historically, a manual file system was composed of a system of file folders and filing
cabinets.
___________________________________ is a special language used to represent and
manipulate data elements in a textual format.
The COUNT function is designed to tally the number of non-null “values” of an
attribute, and is often used in conjunction with the DISTINCT clause.
Discuss some considerations when designing a database.
Relational models view the data as part of a table or collection of tables in which all key
values must be identified.
A fully distributed DBMS must perform all the functions of a centralized DBMS, and it
must handle all necessary functions imposed by the distribution of data and processing.
In the detailed systems design phase, the designer starts the design of the system’s
processes.
____________________ is the real power behind the relational database, allowing the
use of independent tables linked by common attributes.
The database description, known as the distributed ____________________ schema, is
the common database schema used by local TPs to translate user requests into
subqueries (remote requests) that will be processed by different DPs.
Relationships operate only in one direction.
The ____________________ function compares an attribute or expression with a series
of values and returns an associated value or a default value if no match is found.