DBMS

Q. The candidate key which identifies the tuples in a relation uniquely is ?
 a) super key 
b) Primary key 
c) Foreign key 
d) none of the above

Q. Back up and restore is preferred for

a) All files and data together 
b) System data areas only
c) Selected file system components 
d) Disk image for recovery

Q. The term bit is short for:
A. megabyte.
B. binary language.
C. binary digit.
D. binary number.

Q. A string of eight 0s and 1s is called a:
A. megabyte.
B. byte.
C. kilobyte.
D. gigabyte.

Q. What is a 'tuple'?

A. An attribute attached to a record.
B.Another name for a table in an RDBMS.
C. A row or record in a database table.
D. Another name for the key linking different tables in a database

Q. A____________ is approximately one billion bytes.

A. kilobyte

B. bit

C. gigabyte

D. megabyte

Q. The advantages of Standard Query Language (SQL) include which of the following in relation to GIS databases?
A.It is simple and easy to understand.
B.It is good at handling geographical concepts.
C.It is widely used.
D.It uses a pseudo-English style of questioning

Q.The relational database environment has all of the following components except

a. users

b. separate files

c. database

d. query languages

e. database

Q.Database management systems are intended to 

a. eliminate data redundancy

b. establish relationship among records in different files

c. manage file access

d. maintain data integrity

e. all of the above 

Q.One approach to standardization storing of data?

a. MIS

b. structured programming

c. CODASYL specification

d. none of the above

Q.The language used application programs to request data from the DBMS is 

referred to as the

a. DML

b. DDL

c. DCL

d. CGI

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

a. data bank

b. data base

c. data file

d. data record

Q.Choose the RDBMS which supports full fledged client server application development

a. dBase V

b. Oracle 7.1

c. FoxPro 2.1

d. Ingress

Q.Report generators are used to 

a. store data input by a user

b. retrieve information from files

c. answer queries

d. both b and c

Q.A form defined 

a. where data is placed on the screen

b. the width of each field

c. both a and b

d. none of the above

Q.A top-to-bottom relationship among the items in a database is established by 

a. hierarchical schema

b. network schema

c. relational schema

d. all of the above

Q.The management information system (MIS) structure with one main computer 

system is called a

a. hierarchical MIS structure

b. distributed MIS structure

c. centralized MIS structure

d. decentralized MIS structure