Modern Database Management Study Set 2

Computing

Quiz 4 :

Logical Database Design and the Relational Model

Quiz 4 :

Logical Database Design and the Relational Model

Question Type
search
arrow
Data is represented in the form of:
Free
Multiple Choice
Answer:

Answer:

B

Tags
Choose question tag
close menu
arrow
A domain definition consists of all of the following components EXCEPT:
Free
Multiple Choice
Answer:

Answer:

C

Tags
Choose question tag
close menu
arrow
In the figure below, Customer_ID in the CUSTOMER Table is which type of key? img
Free
Multiple Choice
Answer:

Answer:

B

Tags
Choose question tag
close menu
arrow
An attribute (or attributes) that uniquely identifies each row in a relation is called a:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A two-dimensional table of data sometimes is called a:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which of the following is NOT a reason to create an instance of a relational schema with sample data?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A primary key that consists of more than one attribute is called a:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A primary key whose value is unique across all relations is called a(n):
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The entity integrity rule states that:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The ________ states that no primary key attribute may be null.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In the SQL language, the ________ statement is used to make table definitions.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which of the following are properties of relations?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
All of the following are the main goals of normalization EXCEPT:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A form of database design which maps conceptual requirements is called:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which of the following violates the atomic property of relations?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
When all multivalued attributes have been removed from a relation, it is said to be in:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In the figure below, the primary key for "Order Line" is which type of key? img
Multiple Choice
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 101