Printable Quiz: DATA BASE MANAGEMENT SYSTEM 2(TTA) http://www.proprofs.com/quiz-school/printquiz.php?title=data-base-ma...

DATA BASE MANAGEMENT SYSTEM 2(TTA)

..INSTRUCTIONS
1.NUMBER OF QUESTIONS 22
2.HAS A TIME LIMIT OF 20 MINUTES
3.HAS A PASS MARKS OF 30%
4.QUESTIONS PER PAGE 1
5.EACH QUESTIONS HAS 1 MARKS
6.NEGATIVE MARKING FOR EACH QUESTIONS 0.25
7.WILL ALLOW TO YOU GO BACK ,SKIP AND CHANGE YOUR ANSWERS
8.WILL ALLOW TO YOU PRINT OUT YOUR RESULT AND CERTIFICATE
9.WILL ALLOW TO YOU PRINT OUT YOURS RESPONSE SHEET WITH CORRECT ANSWER KEY AND EXPLANATION
10.WE WILL PROVIDE YOURS RESULT,CERTIFICATE AND YOUR RESPONSE SHEET TO YOURS EMAIL ID AT END OF ONLINE
TEST

.
.

Max Time Al lowed: 15 mi n

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

B. any from these

C. DDL

D. Query language

Q.2) Which of the following is not a relational database?

A. Foxpro

B. Foxpro

C. 4th Dimension

D. dbase IV

Q.3) Large collection of fields are called

A. fields

B. database

C. fields

D. sectors

Q.4) 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. data manipulation language

B. report writer

C. transaction log

D. equerry language

Q.5) A transparent DBMS

A. keeps its logical structure hidden from users

B. can not hide sensitive information from users

C. all of these

D. keeps its physical structure hidden from users

Q.6) 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

1 of 4 9/14/2016 11:49 AM
Printable Quiz: DATA BASE MANAGEMENT SYSTEM 2(TTA) http://www.proprofs.com/quiz-school/printquiz.php?title=data-base-ma...

Q.7) A command that lets you change one or more fields in a record is
A. insert

B. none of these

C. Modify Information

D. look-up

Q.8) A form defined

A. the width of each field

B. where data is placed on the screen

C. both

D. none

Q.9) In a large DBMS

A. each sub schema contains every field in the logical schema

B. each user can access every sub schema

C. each user can "see" only a small part of the entire database

D. none of these

Q.10) A file produced by a spreadsheet

A. both

B. A file produced by a spreadsheet

C. non

D. can be used as it is by the DBMS

Q.11) Which is the make given to the database management system which is able to handle full text
data,image data,audio and v ideo?
A. graphics media

B. hypertext

C. multimedia

D. full media

Q.12) What is the language used by most of DBMSs for helping their users to access data
A. SQL

B. Query languag

C. 4GL

D. High level language

Q.13) A set of programs that handle a firm's database reponsibilities is called

A. database management system

B. all of these

C. data management system

D. database processing system

Q.14) The relational database environment has all of the following components except
A. users

B. database

C. query languages

D. separate files

Q.15) The highest level in the hierarchy of data organization is called

A. data base

B. data bank

C. data record

D. data file

Q.16) A record management system

A. can be used to extract information stored in a computer file

B. can handle many files of information at a time

C. always uses a list as its mode

D. all of these

2 of 4 9/14/2016 11:49 AM
Printable Quiz: DATA BASE MANAGEMENT SYSTEM 2(TTA) http://www.proprofs.com/quiz-school/printquiz.php?title=data-base-ma...

Q.17) .Information can be transferred between the DBMS and a

A. graphics program

B. spreadsheet program

C. word processor program

D. all of these

Q.18) Choose the RDBMS which supports full fledged client serv er application dev elopment
A. Oracle 7.1

B. Ingress

C. dbase IV

D. Foxpro 2.1

Q.19) Which of the following fields in a student file can be used as a primary key?
A. GPA

B. Major

C. Social Security Number

D. class

Q.20) The model for a record management system might be

A. hand written list

B. a business form

C. all of these

D. a Rolodex card file

Q.21) If a piece of data is stored in two places in the database,then

A. both,storage space is wasted and changing the data in one spot will cause data inconsistency

B. storage space is wasted

C. it can be more easily accessed

D. changing the data in one spot will cause data inconsistency

Q.22) Which of the following is not an advantage of the database approach

A. Elimination of data redundancy

B. all of these

C. Ability of associate deleted data

D. increased security

Q.23) . The most open source DBMS

A. MySQL

B. Microsoft SQL Server

C. Microsoft Access

D. Oracle

Q.24) Primitive operations common to all record management system include

A. look-up

B. all of above
all of above
all of these
C. print

D. sort

Q.25) In the DBMS approach, application programs perform the

A. storage function

B. all of these

C. processing functions

D. access control

3 of 4 9/14/2016 11:49 AM
Printable Quiz: DATA BASE MANAGEMENT SYSTEM 2(TTA) http://www.proprofs.com/quiz-school/printquiz.php?title=data-base-ma...

Answer Key
Q.1) DML
Q.2) dbase IV
Q.3) database
Q.4) transaction log
Q.5) keeps its physical structure hidden from users
Q.6) is the recorded history of operations performed on a file
Q.7) Modify Information
Q.8) where data is placed on the screen
Q.9) each user can "see" only a small part of the entire database
Q.10) A file produced by a spreadsheet
Q.11) multimedia
Q.12) SQL
Q.13) all of these
Q.14) separate files
Q.15) data base
Q.16) can be used to extract information stored in a computer file
Q.17) all of these
Q.18) dbase IV
Q.19) Social Security Number
Q.20) all of these
Q.21) both,storage space is wasted and changing the data in one spot will cause data inconsistency
Q.22) all of these
Q.23) MySQL
Q.24) look-up
Q.25) processing functions

4 of 4 9/14/2016 11:49 AM