Practice Test: Question Set - 06
1. In an Entity-Relationship Diagram “Diamonds” represents
- (A) Attributes
- (B) Multi-valued
attributes
- (C) Weak
entity set
- (D) Relationship
sets
2. Which algebra is widely used in DBMS?
- (A) Relational
algebra
- (B) Arithmetic
algebra
- (C) Both
- (D) None
3. How many types of keys in Database Design?
- (A) Candidate
key
- (B) Primary
key
- (C) Foreign key
- (D) All of these
4. ________ is a classical approach to database design?
- (A) Left – Right
approach
- (B) Right – Left
approach
- (C) Top – Down
approach
- (D) Bottom – Up
approach
5. A database management system might consist of application programs and a software package called
- (A) FORTRAN
- (B) AUTOFLOW
- (C) BPL
- (D) TOTAL
6. When using a database management system, the first thing that you must do is to
- (A) Create a
database file
- (B) Activate
file editor
- (C) Load the
software into your micro-computer
- (D) Keep a
floppy disk in readiness
7. If a calculation is embedded in a form
- (A) The result
of the calculations are stored with the form
- (B) The
calculations are stored with the form
- (C) The result
of the calculations are printed in report
- (D) All of the
above
8. A multiple-form file management system
- (A) Lets you
define different forms for different operations
- (B) Lets you
create a look-up form with an associated read-only password to prevent access
by unauthorized users
- (C) Both (a) and
(b)
- (D) Allow you to
entry data in all the forms
9. The logical data structure with a one-to-many relationship is a:
- (A) Network
- (B) Tree
- (C) Chain
- (D) Relational
10. Administrate supervision of database activities is the responsibility of the
- (A) Database
administrator
- (B) DP Manager
- (C) DB
Manager
- (D) DP
administration
11. A scheme describes
- (A) Data
elements
- (B) Records
and files
- (C) Record
relationships
- (D) All
of the above
12. Data security threats include
- (A) Hardware
failure
- (B) Privacy
invasion
- (C) Fraudulent
manipulation of data
- (D) All of the
above
13. What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
- (A) DASD
- (B) FMS
- (C) EMMS
- (D) DBMS
14. The database administration function includes
- (A) Application
programming
- (B) Computer
operations management
- (C) Database
access planning
- (D) All of the
above
15. In SQL, which command is used to add a column/integrity constraint to a table
- (A) ADD COLUMN
- (B) INSERT
COLUMN
- (C) MODIFY TABLE
- (D) ALTER TABLE
Next Tests: