ISDS 3003 LSU QUESTIONS AND ANSWERS
Regarding Big Data, what does the term NoSQL really mean?
A. Non-Blocking Query Language
B. Nonrelational Database
C. No SQL used
D. Notational Query Language
E. NortonOS Query Language
Nonrelational Database
What role does the Web browser play in a Web database application?
A. Bug-reporting System
B. Web user interface
C. Microchip accelerator
D. Back-end Database Management System
E. Hardware support
Web user interface
A relational database is ________.
A. a library of queries and data files for querying
B. a self-describing collection of related tables
C. a set of applications and the data sets for those applications
D. a set of metadata
E. a collection of forms and reports that support a given purpose
a self-describing collection of related tables
Which of the following would not be an example of database metadata?
A. Names of tables in a database
B. Queries against records in the database tables
C. Properties of tables in a database
D. Names of columns in a database and their associated tables
E. Properties of columns
Queries against records in the database tables
The creation of a database and its tables is a function of which component of the
database system?
,A. Web server
B. Database
C. DBMS
D. Application
E. Users
DBMS
Which of the following problems associated with storing data in a list is avoided by
storing data in a relational database?
A. Lack of necessary bandwidth
B. CPU processing inefficiencies
C. Incorrect data typing
D. Running out of memory storage
E. Duplication of data items
Duplication of data items
Given the below functional dependency,
MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage)
which of the following statements is not known to be true?
A. MedicineCode is a candidate key of the relation MEDICINE (MedicineName,
ShelfLife, Manufacturer, Dosage).
B. MedicineCode is a determinant.
C. MedicineName is a determinant.
D. Manufacturer is functionally dependent on MedicineCode.
E. ShelfLife is functionally dependent on MedicineCode.
MedicineName is a determinant.
A rule that requires that the values in a foreign key must have a matching value in the
primary key to which the foreign key corresponds is called ________.
A. a functional dependency
B. synchronization
C. a key matching constraint
D. a referential integrity constraint
E. normalization
a referential integrity constraint
, A key that contains more than one attribute is called a(n) ________.
A. n-key
B. complex key
C. composite key
D. candidate key
E. multi-key
composite key
In the normalization process, if you find that every determinant in a relation is a
candidate key then you have determined that ________.
A. referential integrity constraints concerning the relation need to be established
B. the relation needs to have foreign keys added in order to be correctly linked to other
relations
C. the relation needs to be broken into two or more new relations
D. the relation is well formed
E. surrogate keys in the relation may not be correctly linked to other relations
the relation is well formed
Which of the following functional dependency diagrams accurately represents the
following situation:
• A campus has many buildings.
• Each building has a unique name.
• Each building has many rooms.
• All rooms in any given building are numbered sequentially starting at "101."
• Each room has a certain capacity, although many rooms in the same building or
different buildings may have the same capacity.
• Each room is assigned to a single department.
• A department may have many rooms in one or more buildings, each with the same or
different capacities.
A. RoomNumber → (BuildingName, Department, Capacity)
B. (BuildingName, RoomNumber) → (Capacity, Department)
C. (Department, Capacity) → (BuildingName, RoomNumber)
D. (BuildingName, Capacity) → (Department, RoomNumber)
E. BuildingName → (RoomNumber, Capacity, Department)
(BuildingName, RoomNumber) → (Capacity, Department)
During the normalization process, the remedy for a relation that is not well formed is to
________.
Regarding Big Data, what does the term NoSQL really mean?
A. Non-Blocking Query Language
B. Nonrelational Database
C. No SQL used
D. Notational Query Language
E. NortonOS Query Language
Nonrelational Database
What role does the Web browser play in a Web database application?
A. Bug-reporting System
B. Web user interface
C. Microchip accelerator
D. Back-end Database Management System
E. Hardware support
Web user interface
A relational database is ________.
A. a library of queries and data files for querying
B. a self-describing collection of related tables
C. a set of applications and the data sets for those applications
D. a set of metadata
E. a collection of forms and reports that support a given purpose
a self-describing collection of related tables
Which of the following would not be an example of database metadata?
A. Names of tables in a database
B. Queries against records in the database tables
C. Properties of tables in a database
D. Names of columns in a database and their associated tables
E. Properties of columns
Queries against records in the database tables
The creation of a database and its tables is a function of which component of the
database system?
,A. Web server
B. Database
C. DBMS
D. Application
E. Users
DBMS
Which of the following problems associated with storing data in a list is avoided by
storing data in a relational database?
A. Lack of necessary bandwidth
B. CPU processing inefficiencies
C. Incorrect data typing
D. Running out of memory storage
E. Duplication of data items
Duplication of data items
Given the below functional dependency,
MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage)
which of the following statements is not known to be true?
A. MedicineCode is a candidate key of the relation MEDICINE (MedicineName,
ShelfLife, Manufacturer, Dosage).
B. MedicineCode is a determinant.
C. MedicineName is a determinant.
D. Manufacturer is functionally dependent on MedicineCode.
E. ShelfLife is functionally dependent on MedicineCode.
MedicineName is a determinant.
A rule that requires that the values in a foreign key must have a matching value in the
primary key to which the foreign key corresponds is called ________.
A. a functional dependency
B. synchronization
C. a key matching constraint
D. a referential integrity constraint
E. normalization
a referential integrity constraint
, A key that contains more than one attribute is called a(n) ________.
A. n-key
B. complex key
C. composite key
D. candidate key
E. multi-key
composite key
In the normalization process, if you find that every determinant in a relation is a
candidate key then you have determined that ________.
A. referential integrity constraints concerning the relation need to be established
B. the relation needs to have foreign keys added in order to be correctly linked to other
relations
C. the relation needs to be broken into two or more new relations
D. the relation is well formed
E. surrogate keys in the relation may not be correctly linked to other relations
the relation is well formed
Which of the following functional dependency diagrams accurately represents the
following situation:
• A campus has many buildings.
• Each building has a unique name.
• Each building has many rooms.
• All rooms in any given building are numbered sequentially starting at "101."
• Each room has a certain capacity, although many rooms in the same building or
different buildings may have the same capacity.
• Each room is assigned to a single department.
• A department may have many rooms in one or more buildings, each with the same or
different capacities.
A. RoomNumber → (BuildingName, Department, Capacity)
B. (BuildingName, RoomNumber) → (Capacity, Department)
C. (Department, Capacity) → (BuildingName, RoomNumber)
D. (BuildingName, Capacity) → (Department, RoomNumber)
E. BuildingName → (RoomNumber, Capacity, Department)
(BuildingName, RoomNumber) → (Capacity, Department)
During the normalization process, the remedy for a relation that is not well formed is to
________.
