logo image

Database Systems – CSE 3153

A database is an organized collection of ________ related data.
A) logically
B) physically
C) loosely
D) badly
A
One disadvantage of file processing systems is:
A) reduced data duplication.
B) program-data independence.
C) limited data sharing.
D) enforcement of integrity constraints.
C
Loss of metadata integrity is often a result of:
A) poor design.
B) unplanned and uncontrolled duplication of data.
C) decreased programmer productivity.
D) a large volume of file i/o.
B
The external schema contains a subset of the conceptual schema relevant to a particular group of users.
T/F
TRUE
All of the following are primary purposes of a database management system (DBMS) EXCEPT:
A) creating data.
B) updating data.
C) storing data.
D) providing an integrated development environment.
D
The total quiz points for a student for an entire semester is a(n) ________ attribute.
A) derived
B) mixed
C) stored
D) addressed
A
A relationship between the instances of a single entity type is called a(n) ________ relationship.
A) ternary
B) primary
C) binary
D) unary
D
The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.
A) semi-specialization
B) total specialization
C) partial specialization
D) total convergence
B
Physical database design decisions must be made carefully because of impacts on:
A) data accessibility.
B) response times.
C) security.
D) all of the above.
D
A domain definition consists of the following components EXCEPT:
A) domain name.
B) data type.
C) integrity constraints.
D) size.
C
Which of the following are not anomalies that can be caused by redundancies in tables?
A) Insertion
B) Deletion
C) Modification
D) Retrieval
D
When transforming a one-to-one relationship, a new relation is always created.
T/F
FALSE
All of the following are common denormalization opportunities EXCEPT:
A) two entities with a one-to-one relationship.
B) a one-to-many relationship.
C) a many-to-many relationship with non key attributes.
D) reference data.
B
A file organization that uses hashing to map a key into a location in an index where there is a pointer to the actual data record matching the hash key is called a:
A) hashed file organization.
B) hash key.
C) multi-indexed file organization.
D) hash index table.
D

Need essay sample on "Database Systems – CSE 3153"? We will write a custom essay sample specifically for you for only $ 13.90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy

We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy