Database Management System Set 4
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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