Electrical Online Test 31

Category –EE Online Test

Telegram-Join Us On Telegram

Attempt Free Electrical Online Test 31 Here. Read The Important Electrical MCQ From Below.

1) The language used application programs to request data from the DBMS is referred to as the

a. DML
b. DDL
c. Query language
d. Any from these
Ans. a. DML

2) A transparent DBMS

a. Can not hide sensitive information from users
b. keeps its logical structure hidden from users
c. Keeps its physical structure hidden from users
d. All of these
Ans. c. Keeps its physical structure hidden from users

3) Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

a. report writer
b. equerry language
c. Data manipulation language
d. transaction log
Ans. d. transaction log

4) A command that lets you change one or more fields in a record is

a. insert
b. Modify Information
c. look-up
d. None of these
Ans. b. Modify Information

5) A form defined

a. Where data is placed on the screen
b. the width of each field
c. Both
d. None
Ans. a. Where data is placed on the screen

Electrical Online Test 31

6) Information can be transferred between the DBMS and a

a. Spreadsheet program
b. word processor program
c. Graphics program
d. All of these
Ans. d. All of these

7) A record management system

a. can handle many files of information at a time
b. can be used to extract information stored in a computer file
c. always uses a list as its mode
d. All of these
Ans. c. always uses a list as its mode

8) Which of the following fields in a student file can be used as a primary key?

a. Class
b. Social Security Number
c. GPA
d. Major
Ans. b. Social Security Number

9) The relational database environment has all of the following components except

a. users
b. Separate files
c. Database
d. Query languages
Ans. b. Separate files

10) What is the language used by most of DBMSs for helping their users to access data

a. High level language
b. SQL
c. Query languag
d. 4GL
Ans. b. SQL

Electrical Online Test 31

11) A set of programs that handle a firm’s database reponsibilities is called

a. database management system
b. Database processing system
c. Data management system
d. all of these
Ans. d. all of these

12) Large collection of fields are called

a. fields
b. fields
c. Database
d. Sectors
Ans. c. Database

13) A audit trail

a. is used to make back up copies
b. is the recorded history of operations performed on a file
c. can be used to restore lost information
d. None of these
Ans. b. is the recorded history of operations performed on a file

14) Which of the following is not a relational database?

a. dbase IV
b. 4th Dimension
c. Foxpro
d. Foxpro
Ans. a. dbase IV

15) The model for a record management system might be

a. Hand written list
b. a Rolodex card file
c. A business form
d. All of these
Ans. d. All of these

Electrical Online Test 31

16) In a large DBMS

a. each user can “see” only a small part of the entire database
b. each sub schema contains every field in the logical schema
c. each user can access every sub schema
d. None of these
Ans. a. each user can “see” only a small part of the entire database

17) Primitive operations common to all record management system include

a. Print
b. Sort
c. look-up
d. All of above
Ans. c. look-up

Electrical Online Test 31

18) A file produced by a spreadsheet

a. A file produced by a spreadsheet
b. Can be used as it is by the DBMS
c. Both
d. None
Ans. a. A file produced by a spreadsheet

19) Which is the make given to the database management system which is able to handle full text data,image data, audio and video?

a. full media
b. graphics media
c. Multimedia
d. Hypertext
Ans. c. Multimedia

20) Which of the following is not an advantage of the database approach

a. Elimination of data redundancy
b. Ability of associate deleted data
c. increased security
d. All of these
Ans. d. All of these

Electrical Online Test 31

21) Choose the RDBMS which supports full fledged client server application development

a. dbase IV
b. Oracle 7.1
c. Foxpro 2.1
d. Ingress
Ans. a. dbase IV

22) The most open source DBMS

a. Microsoft SQL Server
b. Microsoft Access
c. MySQL
d. Oracle
Ans. c. MySQL

Electrical Online Test 31

23) If a piece of data is stored in two places in the database,then

a. Storage space is wasted
b. Changing the data in one spot will cause data inconsistency
c. It can be more easily accessed
d. Both, storage space is wasted and changing the data in one spot will cause data inconsistency
Ans. d. Both, storage space is wasted and changing the data in one spot will cause data inconsistency

24) In the DBMS approach, application programs perform the

a. Storage function
b. Processing functions
c. Access control
d. All of these
Ans. b. Processing functions

25) The highest level in the hierarchy of data organization is called

a. data bank
b. Data base
c. Data file
d. Data record
Ans. b. Data base

Electrical Online Test 31