Past Exam Flashcards
_____ is the result of revealing the meaning of raw
facts
a. End-user data
b. An encoded sample
c. An encrypted bit
d. Information
Information
_____ is the body of information and facts about a specific subject
a. Validation
b. A format
c. Knowledge
d. A database
Knowledge
Which of the following refers to the situation where different versions of the same data are stored at different places because they weren’t updated consistently?
a. Data query
b. Data integrity
c. Data dictionary
d. Data redundancy
Data redundancy
A workgroup database is a (n) _____ database
a. single-user
b. multiuser
c. desktop
d. distributed
multiuser
A (n) _____ database is used by an organization and supports many users across many departments
a. desktop
b. workgroup
c. enterprise
d. transactional
enterprise
A (n) _____ is anything about which data are to be collected and stored
a. attribute
b. entity
c. relationship
d. constraint
entity
A (n) _____ is bidirectional.
a. attribute
b. entity
c. relationship
d. constraint
relationship
A (n) _____ is a restriction placed on the data
a. attribute
b. entity
c. relationship
d. constraint
constraint
In the _____ model, the basic logical structure is represented as an upside-down tree
a. hierarchical
b. network
c. relational
d. entity relationship
hierarchical
A (n) _____ enables a database administrator to describe schema components
a. extensible markup language (XML)
b. data definition language (DDL)
c. unified modeling language (UML)
d. query language
data definition language (DDL)
In the relational model, _____ are important because they are used to ensure that each row in a table is uniquely identifiable
a. relations
b. keys
c. indexes
d. logical structures
keys
A _____ is any key that uniquely identifies each row
a. superkey
b. special key
c. foreign key
d. candidate key
superkey
A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes
a. secondary
b. candidate
c. primary
d. foreign
candidate
A _____ is the primary key of one table that has been placed into another table to create a common attribute
a. superkey
b. composite primary key
c. candidate key
d. foreign key
foreign key
A _____ key is defined as a key that is used strictly for data retrieval purposes
a. lookup
b. foreign
c. candidate
d. secondary
secondary
The CUSTOMER table’s primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of _____ integrity
a. entity
b. referential
c. relational
d. null
entity
The entity relationship diagram (ERD) represents the _____ database as viewed by the end user
a. condensed
b. physical
c. logical
d. conceptual
conceptual
Ideally, an entity identifier is composed of _____ attribute(s)
a. one
b. two
c. three
d. six
one
A _____ attribute is one that cannot be subdivided
a. composite
b. simple
c. single-valued
d. multivalued
simple
Knowing the minimum and maximum number of _____ occurrences is very helpful at the application software level
a. object
b. attribute
c. data
d. entity
entity
Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B
a. determines
b. derives from
c. controls
d. owns
determines
A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in _____
a. 1NF
b. 2NF
c. 3NF
d. 4NF
1NF
The SQL command that allows a user to permanently save data changes is _____
a. INSERT
b. SELECT
c. COMMIT
d. UPDATE
COMMIT
The special operator used to check whether an attribute value is within a range of values is _____
a. BETWEEN
b. NULL
c. LIKE
d. IN
BETWEEN
The _____ command is used to restore the database to its previous condition
a. ROWCOUNT
b. BACKUP
c. COMMIT
d. ROLLBACK
ROLLBACK
Which is a feature of a correlated subquery?
a. The inner subquery executes first.
b. The outer subquery initiates the process of execution in a subquery.
c. The inner subquery initiates the process of execution in a subquery.
d. The outer subquery executes independent of the inner subquery
The outer subquery initiates the process of execution in a subquery
The SQL aggregate function that gives the number of rows containing non-null values for a given column is _____
a. COUNT
b. MIN
c. MAX
d. SUM
COUNT
Which command would be used to delete the table row where the P_CODE is ‘BRT-345’?
a. DELETE FROM PRODUCT WHERE P_CODE = ‘BRT-345’;
b. REMOVE FROM PRODUCT WHERE P_CODE = ‘BRT-345’;
c. ERASE FROM PRODUCT WHERE P_CODE = ‘BRT-345’;
d. ROLLBACK FROM PRODUCT WHERE P_CODE = ‘BRT-345’;
DELETE FROM PRODUCT WHERE P_CODE = ‘BRT-345’;
The special operator used to check whether a subquery returns any rows is _____
a. BETWEEN
b. EXISTS
c. LIKE
d. IN
EXISTS
The SQL data manipulation command HAVING:
a. restricts the selection of rows based on a conditional expression.
b. restricts the selection of grouped rows based on a condition.
c. modifies an attribute’s values in one or more table’s rows.
d. groups the selected rows based on one or more attributes.
restricts the selection of grouped rows based on a condition
