DBMS Final With verified Solutions
A is a column or set of columns that uniquely identifies each row in a table. - ANSW-
primary key
A is additional documentation that is often used to further explain keys and columns in
the physical database. - ANSW- table diagram
represents an association between two or more entities. - ANSW- relationships
Advantages of Relational(Multiple-Table) Databases are all the following except:
Less redundancy
Data integrity
Normally a single file
Avoidance of inconsistency - ANSW- Normally a single file
The of the table diagram contains the tables name and the short name. - ANSW- first
row
Words that have a special meaning in the Oracle database and in the SQL
programming language are called . - ANSW- reserved words
What is the one value found at the intersection of a row and a column? - ANSW- 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. - ANSW- entity
relationship model
A is a simple structure where data is organized and stored. - ANSW- table
The is the unique identifier for each row. - ANSW- 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. - ANSW- Ignores regulations and laws of governing industry
A is an attribute that describes the information in the table. - ANSW- column
A UID is a combination of attributes. - ANSW- composite
,A is additional documentation that is often used to further explain keys and columns in
the physical database. - ANSW- table diagram
What is the one value found at the intersection of a row and a column? - ANSW- 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. - ANSW- foreign key
A is a column that refers to a primary key column in another table. - ANSW- foreign key
The relational model has provided the basis for numerous database design
methodologies.
True
False - ANSW- 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. - ANSW- relation
A is a technical term for row or record. - ANSW- tuple
In the properties of a table the sequence of rows is significant.
True
False - ANSW- False
The relational data model was introduced by in 1970. - ANSW- C.F. Codd
The standard database access language is:
English
Standard query logic (SQL)
C#
Structured Query Language (SQL) - ANSW- Structured Query Language (SQL)
A is a set of acceptable values that a column is allowed to contain. - ANSW- domain
Each value in the domain is indivisible as far as the relational model is concerned is
called
relation
atomic value
record
degree - ANSW- atomic value
, Name one advantage of a Flat File database. - ANSW- Easy to extract information
In a table there are duplicate rows.
True
False - ANSW- False
An is a logical unit of database storage space allocation made up of contiguous data
blocks. - ANSW- extent
Data storage is one of the essential tasks of the database; what is an example of a
physical structure? - ANSW- 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 - ANSW- distributed database system
A database management system which supports multiple users concurrently is called?
single-user database system
object-oriented data model
multiuser database system
ObjectStore - ANSW- multiuser database system
The type of data models that preceded the relational model.
basic models
traditional models
object-oriented data model
first model - ANSW- traditional models
What is an example of a well-known DBMS? - ANSW- Oracle
A database management system type which supports one user at a time is called?
object-oriented data model
multiuser database system
single-user database system
single serve - ANSW- single-user database system
A is a column or set of columns that uniquely identifies each row in a table. - ANSW-
primary key
A is additional documentation that is often used to further explain keys and columns in
the physical database. - ANSW- table diagram
represents an association between two or more entities. - ANSW- relationships
Advantages of Relational(Multiple-Table) Databases are all the following except:
Less redundancy
Data integrity
Normally a single file
Avoidance of inconsistency - ANSW- Normally a single file
The of the table diagram contains the tables name and the short name. - ANSW- first
row
Words that have a special meaning in the Oracle database and in the SQL
programming language are called . - ANSW- reserved words
What is the one value found at the intersection of a row and a column? - ANSW- 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. - ANSW- entity
relationship model
A is a simple structure where data is organized and stored. - ANSW- table
The is the unique identifier for each row. - ANSW- 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. - ANSW- Ignores regulations and laws of governing industry
A is an attribute that describes the information in the table. - ANSW- column
A UID is a combination of attributes. - ANSW- composite
,A is additional documentation that is often used to further explain keys and columns in
the physical database. - ANSW- table diagram
What is the one value found at the intersection of a row and a column? - ANSW- 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. - ANSW- foreign key
A is a column that refers to a primary key column in another table. - ANSW- foreign key
The relational model has provided the basis for numerous database design
methodologies.
True
False - ANSW- 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. - ANSW- relation
A is a technical term for row or record. - ANSW- tuple
In the properties of a table the sequence of rows is significant.
True
False - ANSW- False
The relational data model was introduced by in 1970. - ANSW- C.F. Codd
The standard database access language is:
English
Standard query logic (SQL)
C#
Structured Query Language (SQL) - ANSW- Structured Query Language (SQL)
A is a set of acceptable values that a column is allowed to contain. - ANSW- domain
Each value in the domain is indivisible as far as the relational model is concerned is
called
relation
atomic value
record
degree - ANSW- atomic value
, Name one advantage of a Flat File database. - ANSW- Easy to extract information
In a table there are duplicate rows.
True
False - ANSW- False
An is a logical unit of database storage space allocation made up of contiguous data
blocks. - ANSW- extent
Data storage is one of the essential tasks of the database; what is an example of a
physical structure? - ANSW- 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 - ANSW- distributed database system
A database management system which supports multiple users concurrently is called?
single-user database system
object-oriented data model
multiuser database system
ObjectStore - ANSW- multiuser database system
The type of data models that preceded the relational model.
basic models
traditional models
object-oriented data model
first model - ANSW- traditional models
What is an example of a well-known DBMS? - ANSW- Oracle
A database management system type which supports one user at a time is called?
object-oriented data model
multiuser database system
single-user database system
single serve - ANSW- single-user database system
