Electrical Online Test 9

Electrical Online Test 9

1) One of the first phases of a new database project that involves critical areas, expensive hardware or software within the organization is called ___________.

a. analysis phase
b. feasibility study
c. Investigation stage
d. System design
Ans. b. feasibility study

2) Which component of the database management system (DBMS) most affects the ability to handle large problems (scalability)?

a. Data storage subsystem
b. Database engine
c. query processor
d. Security sub system
Ans. b. Database engine

3) DBMS Stands for

a. Database marginal system
b. Directory Based Memory Standard
c. Data Base Management System
d. Dual Bus Mask Storage
Ans. c. Data Base Management System

Electrical Online Test 9

4) In a data base, each row is called as a

a. Horizontal data
b. record
c. Information
d. None of these
Ans. b. record

5) Which command can be used to change or edit the database file

a. Edit
b. Browse
c. Replace
d. All of these
Ans. d. All of these

6) Which of the following is true of a network structure

a. It is a physical representation of the data
b. It allows a many-to -many relationship
c. It is conceptually simple
d. It will be dominant database of the future
Ans. b. It allows a many-to -many relationship

7) Each column of a table may have values of

a. Different types
b. Same type
c. Varied or same type
d. none of the above
Ans. b. Same type

Electrical Online Test 9

8) Which of the following is a problem in file management system?

a. difficult to update
b. Lack of data independence
c. data redundancy
d. All of above
Ans. d. All of above

9) All the rows in a table are

a. same
b. May or may not same
c. different
d. All of above
Ans. c. different

10) One data dictionary software package is called

a. DB/DC dictionary
b. TOTAL
c. ACCESS
d. DATA PACK
Ans. a. DB/DC dictionary

11) SQL stands for

a. standard quality literature
b. structured query language
c. standard query language
d. Standard query linguistics
Ans. b. structured query language

Electrical Online Test 9

12) Which of the following are the elements of a database

a. data
b. Relations
c. Constraint and schema
d. All of these
Ans. d. All of these

13) A DBMS enables you to

a. Store Information
b. Modify Information
c. Extract Information
d. All of above
Ans. d. All of above

14) The function of a database is

a. to check all input data
b. To check all spelling
c. To collect and organize input data
d. to output data
Ans. c. To collect and organize input data

15) Meta data is

a. Small amount of data
b. data about data
c. Redundant data
d. None of these
Ans. b. data about data

16) 4GL stands for

a. Four general languages
b. Fourth generation languages
c. Forty General Languages
d. none
Ans. b. Fourth generation languages

Electrical Online Test 9

17) The ascending order of a data hierarchy is

a. bit-byte-record-field-file-database
b. byte-bit-field-record-file-database
c. bit-byte-field-record-file-database
d. bit-byte-file-record-field-database
Ans. c. bit-byte-field-record-file-database

18) Software that defines a database, stores the data, supports a query language, produces reports and creates data entry screens is a:

a. data dictionary
b. database management system (DBMS)
c. decision support system
d. relational database
Ans. b. database management system (DBMS)

19) The modern database report writer

a. A career path that focuses on creating, managing and supporting the reports generated from databases
b. Provide limited control over how information is displayed and reported.
c. provides the tools for database designer to display information in the desired
d. Provides the tools for the database administrator to monitor and report on database use and activity
Ans. c. provides the tools for database designer to display information in the desired

Electrical Online Test 9

20) The separation of the data definition from the program is known as

a. data dictionary
b. data independence
c. data integrity
d. referential integrity
Ans. b. data independence

21) In the client/server model, the data base

a. is downloaded to the client upon request
b. is shared by both client and server
c. Resides on the client side
d. Resides on the server side
Ans. d. Resides on the server side

22) the traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of ‘database’ system?

a. Hierarchical
b. Network
c. Object oriented
d. Relational database
Ans. a. Hierarchical

Electrical Online Test 9

23) the database designing that consists of multiple tables that are linked together through matching data stored in each table is called a:

a. hierarchical database
b. Network database
c. object oriented database
d. relational database
Ans. d. relational database

24) What is the main limitation of Hierarchical Databases?

a. Limited capacity (unable to hold much data)
b. Limited flexibility in accessing data
c. Overhead associated with maintaining indexes
d. Performance of the database is poor
Ans. b. Limited flexibility in accessing data

25) An abstract data type is used to:

a. link data from remote databases
b. Prevent users from getting to database security information
c. Provide a conceptual view of the data so it is easier to understand
d. Store complex data structure to represent the properties of objects
Ans. d. Store complex data structure to represent the properties of objects

Electrical Online Test 9