Database Management System Set 4

Learning Mode Previous Next

On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 4

Q1 | Primitive operations common to all record management system include

look-up

all of the options

sort

Q2 | Which of the following is not a relational database?

dbase iv

foxpro

reflex

4th dimension

Q3 | A top-to-bottom relationship among the items in a database is established by a

hierarchical schema

all of the options

network schema

relational schema

Q4 | Choose the RDBMS which supports full fledged client server application development

dbase v

ingress

oracle 7.1

foxpro 2.1

Q5 | The highest level in the hierarchy of data organization is called

data base

data record

data bank

data file

Q6 | The management information system (MIS) structure with one main computer system is called a

decentralized mis structure

centralized mis structure

hierarchical mis structure

distributed mis structure

Q7 | In the DBMS approach, application programs perform the

storage function

access control

all of the options

processing functions

Q8 | Which of the following is not true of the traditional approach to information processing

it is file oriented

it is inflexible

there is common sharing of data among the various applications

programs are dependent on the file

Q9 | Batch processing is appropriate if

only a few transactions are involved

none of the options

large computer system is available

only a small computer system is avilbale

Q10 | Large collection of files are called

sectors

database

fields

records

Q11 | A transparent DBMS

both can not hide sensitive information from users and keeps its logical structure hidden from users

keeps its physical structure hidden from users

can not hide sensitive information from users

keeps its logical structure hidden from users

Q12 | A file produced by a spreadsheet

none of the options

is generally stored on disk in an ascii text fromat

can be used as is by the dbms

both is generally stored on disk in an ascii text fromat and can be used as is by the dbms

Q13 | The model for a record management system might be

all of the options

a business form

handwritten list

a rolodex card file

Q14 | Database management systems are intended to

eliminate data redundancy

establish relationship among records in different files

manage file access and maintain data integrity

all of the options

Q15 | The language used application programs to request data from the DBMS is referred to as the

ddl

all of the options

dml

query language

Q16 | A set of programs that handle a firm's database responsibilities is called

database management system (dbms)

data management system (dms)

all of the options

database processing system (dbps)

Q17 | In a large DBMS

each subschema contains every field in the logical schema

each user can access every subschema

none of the options

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

Q18 | In a large DBMS

none of the options

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

each subschema contains every field in the logical schema

each user can access every subschema

Q19 | A Database Management System (DBMS) is

collection of interrelated data

collection of programs to access data

collection of data describing one particular enterprise

all of the above

Q20 | Which of the following is not a level of data abstraction?

physical level

critical level

logical level

view level

Q21 | Disadvantages of File systems to store data is:

data redundancy and inconsistency

difficulty in accessing data

data isolation

all of the above

Q22 | In an Entity-Relationship Diagram Rectangles represents

entity sets

attributes

database

tables

Q23 | Which of the following is not a Storage Manager Component?

transaction manager

logical manager

buffer manager

file manager

Q24 | Data Manipulation Language enables users to

retrieval of information stored in database

insertion of new information into the database

deletion of information from the database

all of the above

Q25 | Which of the following is not an Schema?

database schema

physical schema

critical schema

logical schema

Previous Next