DBMS FINAL EXAM QUESTIONS AND
ANSWERS
A is a column or set of columns that uniquely identifies each row in a table. - Correct
Answers -primary key
A is additional documentation that is often used to further explain keys and columns in
the physical database. - Correct Answers -table diagram
represents an association between two or more entities. - Correct Answers -
relationships
Advantages of Relational(Multiple-Table) Databases are all the following except:
Less redundancy
Data integrity
Normally a single file
Avoidance of inconsistency - Correct Answers -Normally a single file
The of the table diagram contains the tables name and the short name. - Correct
Answers -first row
Words that have a special meaning in the Oracle database and in the SQL
programming language are called . - Correct Answers -reserved words
What is the one value found at the intersection of a row and a column? - Correct
Answers -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. - Correct Answers -
entity relationship model
A is a simple structure where data is organized and stored. - Correct Answers -table
The is the unique identifier for each row. - Correct Answers -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. - Correct Answers -Ignores regulations and laws of governing
industry
A is an attribute that describes the information in the table. - Correct Answers -column
A UID is a combination of attributes. - Correct Answers -composite
A is additional documentation that is often used to further explain keys and columns in
the physical database. - Correct Answers -table diagram
What is the one value found at the intersection of a row and a column? - Correct
Answers -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. - Correct Answers -foreign key
A thing or object in the real world with an independent existence that can be
differentiated from other objects is called a(n) __________________. - Correct Answers
-entity
__________ occurs when you delete a record that may contain attributes that shouldn't
be deleted. - Correct Answers -deletion anomaly
_______________ is used when you need to obtain information based on two related
tables. - Correct Answers -JOIN
A is a column that refers to a primary key column in another table. - Correct Answers -
foreign key
The relational model has provided the basis for numerous database design
methodologies.
True
False - Correct Answers -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. - Correct Answers -relation
A is a technical term for row or record. - Correct Answers -tuple
In the properties of a table the sequence of rows is significant.
True
False - Correct Answers -False
, The relational data model was introduced by in 1970. - Correct Answers -C.F. Codd
The standard database access language is:
English
Standard query logic (SQL)
C#
Structured Query Language (SQL) - Correct Answers -Structured Query Language
(SQL)
A is a set of acceptable values that a column is allowed to contain. - Correct Answers -
domain
Each value in the domain is indivisible as far as the relational model is concerned is
called
relation
atomic value
record
degree - Correct Answers -atomic value
Name one advantage of a Flat File database. - Correct Answers -Easy to extract
information
In a table there are duplicate rows.
True
False - Correct Answers -False
An is a logical unit of database storage space allocation made up of contiguous data
blocks. - Correct Answers -extent
Data storage is one of the essential tasks of the database; what is an example of a
physical structure? - Correct Answers -control files
The actual database and the DBMS software are distributed from various sites that are
connected by a computer network is called?
centralized database system
object-oriented data model
distributed database system
traditional models - Correct Answers -distributed database system
A database management system which supports multiple users concurrently is called?
ANSWERS
A is a column or set of columns that uniquely identifies each row in a table. - Correct
Answers -primary key
A is additional documentation that is often used to further explain keys and columns in
the physical database. - Correct Answers -table diagram
represents an association between two or more entities. - Correct Answers -
relationships
Advantages of Relational(Multiple-Table) Databases are all the following except:
Less redundancy
Data integrity
Normally a single file
Avoidance of inconsistency - Correct Answers -Normally a single file
The of the table diagram contains the tables name and the short name. - Correct
Answers -first row
Words that have a special meaning in the Oracle database and in the SQL
programming language are called . - Correct Answers -reserved words
What is the one value found at the intersection of a row and a column? - Correct
Answers -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. - Correct Answers -
entity relationship model
A is a simple structure where data is organized and stored. - Correct Answers -table
The is the unique identifier for each row. - Correct Answers -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. - Correct Answers -Ignores regulations and laws of governing
industry
A is an attribute that describes the information in the table. - Correct Answers -column
A UID is a combination of attributes. - Correct Answers -composite
A is additional documentation that is often used to further explain keys and columns in
the physical database. - Correct Answers -table diagram
What is the one value found at the intersection of a row and a column? - Correct
Answers -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. - Correct Answers -foreign key
A thing or object in the real world with an independent existence that can be
differentiated from other objects is called a(n) __________________. - Correct Answers
-entity
__________ occurs when you delete a record that may contain attributes that shouldn't
be deleted. - Correct Answers -deletion anomaly
_______________ is used when you need to obtain information based on two related
tables. - Correct Answers -JOIN
A is a column that refers to a primary key column in another table. - Correct Answers -
foreign key
The relational model has provided the basis for numerous database design
methodologies.
True
False - Correct Answers -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. - Correct Answers -relation
A is a technical term for row or record. - Correct Answers -tuple
In the properties of a table the sequence of rows is significant.
True
False - Correct Answers -False
, The relational data model was introduced by in 1970. - Correct Answers -C.F. Codd
The standard database access language is:
English
Standard query logic (SQL)
C#
Structured Query Language (SQL) - Correct Answers -Structured Query Language
(SQL)
A is a set of acceptable values that a column is allowed to contain. - Correct Answers -
domain
Each value in the domain is indivisible as far as the relational model is concerned is
called
relation
atomic value
record
degree - Correct Answers -atomic value
Name one advantage of a Flat File database. - Correct Answers -Easy to extract
information
In a table there are duplicate rows.
True
False - Correct Answers -False
An is a logical unit of database storage space allocation made up of contiguous data
blocks. - Correct Answers -extent
Data storage is one of the essential tasks of the database; what is an example of a
physical structure? - Correct Answers -control files
The actual database and the DBMS software are distributed from various sites that are
connected by a computer network is called?
centralized database system
object-oriented data model
distributed database system
traditional models - Correct Answers -distributed database system
A database management system which supports multiple users concurrently is called?
