DBMS Final Exam: Questions & Verified Solutions
A is a column or set of columns that uniquely identifies each row in a table.
Right Ans - primary key
A is additional documentation that is often used to further explain keys and
columns in the physical database. Right Ans - table diagram
represents an association between two or more entities. Right Ans -
relationships
Advantages of Relational(Multiple-Table) Databases are all the following
except:
Less redundancy
Data integrity
Normally a single file
Avoidance of inconsistency Right Ans - Normally a single file
The of the table diagram contains the tables name and the short name.
Right Ans - first row
Words that have a special meaning in the Oracle database and in the SQL
programming language are called . Right Ans - reserved words
What is the one value found at the intersection of a row and a column?
Right Ans - field
The is derived from business specifications, and its intended goal is to create a
clear picture of the information that will be stored in a future database.
Right Ans - entity relationship model
A is a simple structure where data is organized and stored. Right Ans -
table
The is the unique identifier for each row. Right Ans - primary key
A conceptual model is important to a business because of all the following
except:
,Forms a sound basis for physical database design.
Describes the exact information needs of the business.
Ignores regulations and laws of governing industry.
Facilitates discussion. Right Ans - Ignores regulations and laws of
governing industry
A is an attribute that describes the information in the table. Right Ans -
column
A UID is a combination of attributes. Right Ans - composite
A is additional documentation that is often used to further explain keys and
columns in the physical database. Right Ans - table diagram
What is the one value found at the intersection of a row and a column?
Right Ans - field
A is a column or combination of columns in one table that refers to a primary
key in the same table or another table. Right Ans - foreign key
A is a column that refers to a primary key column in another table. Right
Ans - foreign key
The relational model has provided the basis for numerous database design
methodologies.
True
False Right Ans - True
A is a subset of the Cartesian product of a list of domains characterized by a
name; the technical term for table or file. Right Ans - relation
A is a technical term for row or record. Right Ans - tuple
In the properties of a table the sequence of rows is significant.
True
False Right Ans - False
, The relational data model was introduced by in 1970. Right Ans - C.F. Codd
The standard database access language is:
English
Standard query logic (SQL)
C#
Structured Query Language (SQL) Right Ans - Structured Query Language
(SQL)
A is a set of acceptable values that a column is allowed to contain. Right
Ans - domain
Each value in the domain is indivisible as far as the relational model is
concerned is called
relation
atomic value
record
degree Right Ans - atomic value
Name one advantage of a Flat File database. Right Ans - Easy to extract
information
In a table there are duplicate rows.
True
False Right Ans - False
An is a logical unit of database storage space allocation made up of contiguous
data blocks. Right Ans - extent
Data storage is one of the essential tasks of the database; what is an example
of a physical structure? Right Ans - control files
The actual database and the DBMS software are distributed from various sites
that are connected by a computer network is called?
A is a column or set of columns that uniquely identifies each row in a table.
Right Ans - primary key
A is additional documentation that is often used to further explain keys and
columns in the physical database. Right Ans - table diagram
represents an association between two or more entities. Right Ans -
relationships
Advantages of Relational(Multiple-Table) Databases are all the following
except:
Less redundancy
Data integrity
Normally a single file
Avoidance of inconsistency Right Ans - Normally a single file
The of the table diagram contains the tables name and the short name.
Right Ans - first row
Words that have a special meaning in the Oracle database and in the SQL
programming language are called . Right Ans - reserved words
What is the one value found at the intersection of a row and a column?
Right Ans - field
The is derived from business specifications, and its intended goal is to create a
clear picture of the information that will be stored in a future database.
Right Ans - entity relationship model
A is a simple structure where data is organized and stored. Right Ans -
table
The is the unique identifier for each row. Right Ans - primary key
A conceptual model is important to a business because of all the following
except:
,Forms a sound basis for physical database design.
Describes the exact information needs of the business.
Ignores regulations and laws of governing industry.
Facilitates discussion. Right Ans - Ignores regulations and laws of
governing industry
A is an attribute that describes the information in the table. Right Ans -
column
A UID is a combination of attributes. Right Ans - composite
A is additional documentation that is often used to further explain keys and
columns in the physical database. Right Ans - table diagram
What is the one value found at the intersection of a row and a column?
Right Ans - field
A is a column or combination of columns in one table that refers to a primary
key in the same table or another table. Right Ans - foreign key
A is a column that refers to a primary key column in another table. Right
Ans - foreign key
The relational model has provided the basis for numerous database design
methodologies.
True
False Right Ans - True
A is a subset of the Cartesian product of a list of domains characterized by a
name; the technical term for table or file. Right Ans - relation
A is a technical term for row or record. Right Ans - tuple
In the properties of a table the sequence of rows is significant.
True
False Right Ans - False
, The relational data model was introduced by in 1970. Right Ans - C.F. Codd
The standard database access language is:
English
Standard query logic (SQL)
C#
Structured Query Language (SQL) Right Ans - Structured Query Language
(SQL)
A is a set of acceptable values that a column is allowed to contain. Right
Ans - domain
Each value in the domain is indivisible as far as the relational model is
concerned is called
relation
atomic value
record
degree Right Ans - atomic value
Name one advantage of a Flat File database. Right Ans - Easy to extract
information
In a table there are duplicate rows.
True
False Right Ans - False
An is a logical unit of database storage space allocation made up of contiguous
data blocks. Right Ans - extent
Data storage is one of the essential tasks of the database; what is an example
of a physical structure? Right Ans - control files
The actual database and the DBMS software are distributed from various sites
that are connected by a computer network is called?
