Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Physical database design decisions must be made carefully because of impacts on: a ) data accessibility b ) response times c ) security d )

Physical database design decisions must be made carefully because of impacts on:
a) data accessibility
b) response times
c) security
d) all of them
e) none of them
2- An attribute (or attributes) that uniquely identifies each row in a relation is called a:
a) column
b) foreign key
c) primary key
d) duplicate key
e) none of them
3- The relational data model consists of which component(s)?
a) data structure
b) data manipulation
c) data integrity
d) all of them
e) none of them
4- An attribute in a relation serving as the primary key of another relation is called a:
a) link attribute
b) foreign attribute
c) foreign key
d) link key
e) none of them
S- A primary key that consists of more than one attribute is called:
a) foreign
b) composite
c) multivalued
d) cardinal
e) none of them
6- Which of the following are properties of relations in a well-designed database?
a) each attribute has a unique name
b) no two rows in a relation are identical
c) there are no multivalued attributes in a relation
d) all of them
e) none of them
7- The states that no primary key attribute may be null.
a) entity integrity constraint
b) referential integrity rule
c) partial specialization rule
d) range domain rule
e) none of them
8- A rule stating that each foreign key value must match a primary key value in the other relation is called:
a) referential integrity constraint
b) key match rule
c) entity key group rule
d) foreign/primary match rule
e) none of them
9. In the SQL language, the statement is used to make table definitions.
a) create session
b) create table
c) create index
d) select
e) from
10- Which of the following are anomalies that can be caused by redundancies in tables?
a) insertion
b) deletion
c) modification
d) all of them
e) none of them
11-A relation that contains minimal redundancy and allows easy use is considered to be:
a) clean
b) complete
c) complex
d) simple
e) well-structured
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Accidental Data Scientist

Authors: Amy Affelt

1st Edition

1573877077, 9781573877077

More Books

Students also viewed these Databases questions

Question

How can assertiveness help you cope with anger? Critical T hinking

Answered: 1 week ago

Question

Where is the electron transport chain located

Answered: 1 week ago

Question

9.7 List and briefly discuss four management development methods.

Answered: 1 week ago