Font size
Worksheetskiemtra
Total questions: 149
Worksheet time: 1hrs 14mins
The DBMS acts as an interface between what two components of an enterprise-class database system?
Database application and the database
Data and the database
The user and the database application
Database application and SQL
Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
IDMS
DB2
dBase-II
R:base
The following are components of a database except ________ .
user data
metadata
reports
indexes
An application where only one user accesses the database at a given time is an example of a(n) ________ .
single-user database application
multiuser database application
e-commerce database application
data mining database application
An on-line commercial site such as Amazon.com is an example of a(n) ________ .
single-user database application
multiuser database application
e-commerce database application
data mining database application
Which of the following products was the first to implement true relational algebra in a PC DBMS?
. IDMS
Oracle
dBase-II
R:base
SQL stands for ________ .
Structured Query Language
Sequential Query Language
Structured Question Language
Sequential Question Language
Because it contains a description of its own structure, a database is considered to be ________ .
described
metadata compatible
self-describing
an application program
The following are functions of a DBMS except ________
creating and processing forms
creating databases
processing data
administrating databases
Helping people keep track of things is the purpose of a(n) ________
database
table
instance
relationship
Which of the following products implemented the CODASYL DBTG model?
IDMS
DB2
dBase-II
R:base
An Enterprise Resource Planning application is an example of a(n) ________ .
single-user database application
multiuser database application
e-commerce database application
data mining database application
A DBMS that combines a DBMS and an application generator is ________ .
Microsoft's SQL Server
Microsoft's Access
IBM's DB2
Oracle Corporation's Oracle
You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .
user data.
metadata
A report
indexes
Which of the following is not considered to be a basic element of an enterprise-class database system?
Users
Database applications
DBMS
COBOL programs
The DBMS that is most difficult to use is ________ .
Microsoft's SQL Server
Microsoft's Access
IBM's DB2
Oracle Corporation's Oracle
Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
A domain constraint
A range constraint
An intrarelation constraint
An interrelation constraint
In a 1:N relationship, the foreign key is placed in:
either table without specifying parent and child tables
the parent table.
the child table.
either the parent table or the child table.
Which of the following column properties specifies whether or not cells in a column must contain a data value?
Null status
Data type
Default value
Data constraints
A primary key should be defined as:
NULL
NOT NULL.
Either of the above can be used.
None of the above are correct.
Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
Null status
Data type
Default value
Data constraints
Which of the following situation requires the use of ID-dependent entities?
Association relationships only
Multivalued attributes only
Archetype/instance relationships only
All of the above use ID dependent entities
A foreign key is:
a column containing the primary key of another table.
used to define data types
used to define null status.
all of the above are above correct.
Which of the following columns is(are) are required in a table?
A foreign key
An alternate key
A primary key
A surrogate key.
In a 1:1 relationship, the foreign key is placed in:
either table without specifying parent and child tables.
the parent table.
the child table.
either the parent table or the child table.
Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
Null status
Data type
Default value
Data constraints
The identifier of an entity will become the ________ of the new table.
foreign key
main attribute
primary key
identity key
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
A domain constraint
A range constraint
An intrarelation constraint
An interrelation constraint
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
primary key.
foreign key.
composite key
surrogate key.
Which is not true about surrogate keys?
They are short.
They are fixed
They have meaning to the user.
They are numeric.
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Two
Three
Four
Six
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
MUST COVER
MUST NOT
. Both of the above.
None of the above is correct.
Each entity is represented as a(n):
tuple.
table.
attribute.
file.
For every relationship, how many possible sets of minimum cardinalities are there?
Two
Three
Four
Six
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
the primary key
any alternate key
a surrogate key
a foreign key
Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
Null status
Data type
Default value
Data constraints
. If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
All fields are stored in one relation.
All fields are stored in two relations
All fields are stored in three relations.
All fields are stored in four relations.
Selecting a data type involves which of the following?
Maximize storage space
Represent most values
Improve data integrity
All of the above.
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
VARCHAR2
CHAR
LONG
NUMBER
If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
All fields are stored in one relation.
All fields are stored in two relations.
All fields are stored in three relations.
All fields are stored in four relations.
Which of the following is an advantage of partitioning?
Complexity
Inconsistent access speed
Extra space
Security
The blocking factor is:
a group of fields stored in adjacent memory.
the number of physical records per page.
attributes grouped together by the same primary key.
attributes grouped together by the same secondary key.
Which of the following improves a query's processing time?
Write complex queries
Combine a table with itself
Query one query within another
Use compatible data types.
Which of the following are integrity controls that a DBMS may support?
Assume a default value in a field unless a user enters a value for that field.
Limit the set of permissible values that a field may assume.
Limit the use of null values in some fields.
All of the above.
Which of the following is not a factor to consider when switching from small to large block size?
The length of all of the fields in a table row.
The number of columns
Block contention
Random row access speed
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
VARCHAR2
CHAR
LONG
NUMBER
A secondary key is which of the following?
Nonunique key
Primary key
Useful for denormalization decisions
Determines the tablespace required
The fastest read/write time and most efficient data storage of any disk array type is:
RAID-0.
RAID-1
RAID-2.
RAID-3.
A rule of thumb for choosing indexes for a relational database includes which of the following?
Indexes are more useful on smaller tables
Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
Do not specify a unique index for the primary key of each table.
Be careful indexing attributes that have null values.
Sequential retrieval on a primary key for sequential file storage has which of the following features?
Very fast
Moderately fast
Slow
Impractical
A multidimensional database model is used most often in which of the following models?
Data warehouse
Relational
Hierarchical
Network
Which of the following database activities allow for the actual retrieval and use of a database?
Enterprise modeling
Logical database design
Physical database design and definition
Database implementation
The three-schema components include all, but:
internal schema.
conceptual schema.
programming schema.
programming schema.
Which is not a type of data management technology?
Relational
Rational
Object-oriented
Dimensional
Which is not a relevant feature of CASE tools?
The ability to help draw data models using entity-relationship notations
The ability to generate code
An information repository
Access to a DB via the Internet
The first step in database development is which of the following?
Enterprise data modeling
Logical database design
Physical database design and definition
Database Implementation
Which of the following database activities determines the entities, attributes, and relationships of data?
Conceptual data modeling
Logical database design
Physical database design and definition
Database implementation
The use of packaged data models can offer which of the following benefits?
Reduce implementation time and costs
Higher quality models
Both A and B
Neither A nor B.
The Enterprise tier of the three-tiered database architecture includes:
managing the data.
managing the User-system interface.
processing HTTP protocol.
processing scripting tasks
An entity type is which of the following?
A major category of data about people, place, and things
The various departments of an organization
The application software
The business processes the support the mission of an organization
Strategic Planning factors do not include which of the following?
Organizational goals
Critical success factors
Information engineering
Problem areas
CASE tools do not include which of the following features?
Help to draw data models
Help to generate code
Help to manage people
Create an information repository
In enterprise data modeling, which is incorrect?
You review current systems.
You implement the new database.
You describe the data needed at a very high level of abstraction.
You plan one or more database development projects
Which of the following database activities require a specific knowledge of a DBMS?
Enterprise modeling
Conceptual data modeling
Logical database design
Physical database design and definition
User views are included as part of which schema?
Internal
Conceptual
External
None of the above.
Whose role is it to determine the requirements and design for a database?
Database analysts
Database administrators
Both A and B.
Neither A or B.
Which of the following indicates the maximum number of entities that can be involved in a relationship?
Minimum cardinality
Maximum cardinality
ERD
Greater Entity Count (GEC)
Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?
Weak entity
Strong entity
ID-dependent entity
ID- independent entity
In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
parent
child
instance
subtype
Which type of entity represents an actual occurrence of an associated generalized entity?
Supertype entity
Subtype entity
Archetype entity
Instance entity
A recursive relationship is a relationship between an entity and ________ .
itself
a subtype entity
an archetype entity
an instance entity
Which of the following indicates the minimum number of entities that must be involved in a relationship?
Minimum cardinality
Maximum cardinality
ERD
Greater Entity Count (GEC)
Which of the following refers to something that can be identified in the users' work environment, something that the users want to track?
Entity
Attribute
Identifier
Relationship
In which of the following is a single-entity instance of one type related to many entity instances of another type?
One-to-One Relationship
One-to-Many Relationship
Many-to-Many Relationship
Composite Relationship
Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?
Weak entity
Strong entity
ID-dependent entity
ID-independent entity
Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
Supertype entity
Subtype entity
Archetype entity
Instance entity
An attribute that names or identifies entity instances is a(n):
entity.
attribute.
identifier.
relationship.
Properties that describe the characteristics of entities are called:
entities.
attributes.
identifiers.
relationships.
In which of the following can many entity instances of one type be related to many entity instances of another type?
One-to-One Relationship
One-to-Many Relationship
Many-to-Many Relationship
Composite Relationship
Entities of a given type are grouped into a(n):
database.
entity class.
attribute.
ERD.
Which of the following is NOT a basic element of all versions of the E-R model?
Entities
Attributes
Relationships
Primary keys
In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?
One-to-One Relationship
One-to-Many Relationship
Many-to-Many Relationship
Composite Relationship
Entities can be associated with one another in which of the following?
. Entities
Attributes
Identifiers
Relationships
Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?
Supertype entity
Subtype entity
Archetype entity
Instance entity
Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?
Supertype entity
Subtype entity
Archetype entity
Instance entity
In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.
parent
child
instance
subtype
An action assertion must include which of the following?
Anchor object
Action
Corresponding object
All of the above.
An oval represents which of the following in an EER?
Attribute
Entity
. Optional One
Relationship
Inheritance is which of the following?
When a supertype entity inherits values of the subtype attribute
When a subtype entity inherits values of the supertype attribute
When a supertype entity inherits values of another supertype attribute
When a subtype entity inherits values of another subtype attribute
When an entity instance must be a member of only one subtype, it is which of the following?
Disjoint with total specialization
Disjoint with partial specialization
Overlap with total specialization
Overlap with partial specialization
A supertype/subtype hierarchy is which of the following?
Each subtype has only one attribute
Each supertype has only one attribute.
Each subtype has only one supertype.
Each supertype has only one subtype.
A rectangle represents which of the following in an EER?
Attribute
Entity
Optional One
Relationship
Which one of the following symbols is not used in an ERD?
Rectangle
Oval
. Diamond
Circle
Specialization is which of the following processes?
Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
Defining one or more supertypes of the subtype and forming supertype/subtype relationships.
Defining one or more supertypes of the subtype and not forming supertype/subtype relationships.
Which of the following statements concerning business rules is true?
It should be complex.
. It should not be convertible to computer code.
It may include restrictions.
All of the above.
A supertype/subtype hierarchy has which of the following features?
Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
Attributes are assigned at the highest logical level.
Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
Attributes are assigned at the lowest logical level.
A subtype discriminator is which of the following?
An attribute of the supertype whose values determine the subtype
An attribute of the subtype whose values determine the supertype
. An attribute of the supertype whose values determine the supertype
An attribute of the subtype whose values determine the subtype
When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
Disjoint with total specialization
Disjoint with partial specialization
Overlap with total specialization
Overlap with partial specializations
A subtype entity name should be which of the following?
A singular noun
Specific to the organization
Concise
All of the above
Use of a supertype/subtype relationship is necessary when which of the following exists?
An instance of a subtype participates in a relationship that is unique to that subtype.
An instance of a subtype participates in a relationship that is the same as the other subtypes.
Attributes apply to all of the instances of an entity type.
No attributes apply to any of the instances of an entity type.
Which of the following is not one of the three ways to classify an action assertion?
Condition
Integrity Control
Authorization
Enabler
Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
A → B.
A → C.
A → (B,C)
(B,C) → A.
The different classes of relations created by the technique for preventing modification anomalies are called:
normal forms.
referential integrity constraints.
functional dependencies.
None of the above is correct.
A relation is in this form if it is in BCNF and has no multivalued dependencies:
second normal form.
third normal form.
fourth normal form.
domain/key normal form.
. Row is synonymous with the term:
record.
relation.
column.
field.
The primary key is selected from the:
composite keys.
determinants.
candidate keys.
foreign keys.
Which of the following is a group of one or more attributes that uniquely identifies a row?
Key
Determinant
Tuple
Relation
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
transitive dependency.
insertion anomaly.
referential integrity constraint.
normal form.
A relation is considered a:
Column.
one-dimensional table.
two-dimensional table.
three-dimensional table.
In the relational model, relationships between relations or tables are created by using:
composite keys.
determinants.
candidate keys.
foreign keys.
A functional dependency is a relationship between or among:
tables.
rows.
relations.
attributes.
Table is synonymous with the term:
record.
relation.
column.
field.
Which of the following is not a restriction for a table to be a relation?
The cells of the table must contain a single value.
All of the entries in any column must be of the same kind
The columns must be ordered.
No two rows in a table may be identical.
For some relations, changing the data can have undesirable consequences called:
referential integrity constraints.
modification anomalies
normal forms.
. transitive dependencies.
. A key:
must always be composed of two or more columns.
can only be one column.
identifies a row.
identifies a column.
An attribute is a(n):
column of a table.
two dimensional table.
row of a table
key of a table.
A relation in this form is free of all modification anomalies.
First normal form
Second normal form
Third normal form
Domain/key normal form
If attributes A and B determine attribute C, then it is also true that:
A → C.
B → C.
(A,B) is a composite determinant.
C is a determinant.
A tuple is a(n):
column of a table.
two dimensional table.
row of a table
key of a table.
If attribute A determines both attributes B and C, then it is also true that:
A → B.
B → A.
C → A
(B,C) → A.
One solution to the multivalued dependency constraint problem is to:
split the relation into two relations, each with a single theme.
change the theme.
create a new theme.
add a composite key.
A data warehouse uses:
partial operational data.
historical operational data.
future operational data.
health care data.
Metadata enables database designers and users to do all of the following except:
sample data.
understand what data exist.
what the fine distinctions are between similar data items.
what the data mean
Duplicate data often results in loss of data integrity because:
the data formats may be inconsistent.
data values may not agree.
Both A & B
Neither A & B.
Legacy data is which of the following?
Data contained in a newly-installed system
Data rejected during the installation of a new system
Data contained in a file system
Data contained by a system used prior to the installation of a new system
A database management system (DBMS) is a:
hardware system used to create, maintain, and provide controlled access to a database
hardware system used to create, maintain, and provide uncontrolled access to a database.
software system used to create, maintain, and provide controlled access to a database.
software system used to create, maintain, and provide uncontrolled access to a database.
A database application can perform which of the following activities?
Add records
Read records
Update records
All of the above.
An enterprise data model is:
a graphical model that shows the high-level entities for an organization.
a graphical model that shows all entities for an organization.
a non-graphical model that shows the high-level entities for an organization.
a non-graphical model that shows the all entities for an organization.
A shared database should:
be accurate and available.
provide for backup and recovery.
be secure.
All of the above.
. Data administrators are responsible for:
physical database design.
managing technical issues in the database environment.
overall management of data resources in an organization.
writing application programs.
Which of the following types of databases are the most common?
Personal
Workgroup
Department
Enterprise
. Which of the following is true for a relational database?
Data is represented by tables.
It is difficult to access data.
Complex programs have to be written for simple queries.
All of the above.
Some advantages of the database approach include all, but:
minimal data redundancy.
improved data consistency.
improved data sharing.
program-data dependency.
An enterprise database is which of the following?
A database designed to support only users external to an organization
A database designed to support an entire organization
A database designed to support a relatively small group
A database designed to support a single PC
Structured data may include which of the following?
Photo image
Video clip
Dates
An extranet is which of the following?
The use of Internet protocols with limited access to company data by the company's customers and suppliers.
The use of Internet protocols with unlimited access to company data by the company's customers and suppliers.
The use of Internet protocols with limited access to company data by people within an organization.
The use of Internet protocols with unlimited access to company data by people within an organization
You can add a row using SQL in a database with which of the following?
ADD
CREATE
INSERT
MAKE
The command to remove rows from a table 'CUSTOMER' is:
REMOVE FROM CUSTOMER ...
DROP FROM CUSTOMER .
DELETE FROM CUSTOMER WHERE ...
UPDATE FROM CUSTOMER ...
The SQL WHERE clause:
limits the column data that are returned.
limits the row data are returned.
Both A and B are correct.
Neither A nor B are correct.
Which of the following is the original purpose of SQL?
To specify the syntax and semantics of SQL data definition language
To specify the syntax and semantics of SQL manipulation language
. To define the data structures
All of the above.
The wildcard in a WHERE clause is useful when?
An exact match is necessary in a SELECT statement.
An exact match is not possible in a SELECT statement
An exact match is necessary in a CREATE statement.
An exact match is not possible in a CREATE statement.
. A view is which of the following?
A virtual table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands
The command to eliminate a table from a database is:
REMOVE TABLE CUSTOMER;
DROP TABLE CUSTOMER;
DELETE TABLE CUSTOMER;
UPDATE TABLE CUSTOMER;
ON UPDATE CASCADE ensures which of the following?
Normalization
Data Integrity
Materialized Views
All of the above.
SQL data definition commands make up a(n) ________ .
DDL
DML
HTML
Which of the following is valid SQL for an Index?
CREATE INDEX ID;
CHANGE INDEX ID;
ADD INDEX ID;
REMOVE INDEX ID;
The SQL keyword(s) ________ is used with wildcards.
LIKE only
IN only
NOT IN only
IN and NOT IN
Which of the following is the correct order of keywords for SQL SELECT statements?
SELECT, FROM, WHERE
FROM, WHERE, SELECT
WHERE, FROM,SELEC
SELECT,WHERE,FROM
A subquery in an SQL SELECT statement is enclosed in:
. braces -- {...}.
CAPITAL LETTERS
parenthesis -- (...) .
brackets -- [...].
