Multiple Choice Questions
Introduction To Database Systems
Set 1
- Database Management System
- Database Master System
- Database Management Structure
- None of the above
- Data
- Modules
- Programs
- None of the above
- Cloud Storage
- Data System
- File Management System
- None of the above
- Primary key
- Secondary key
- Foreign key
- A and B
- User’s application programs
- User’s system programs
- User’s system database
- None of the above
- Database Definition Level
- Data Definition Language
- Data Device Latency
- None of the above
- Data independence
- Centralized control of data
- Both A and B
- None of the above
- Data is dependent on programs
- Data redundancy increases
- Data is integrated and can be accessed by multiple programs
- None of the above
- HLL
- DML
- DDL
- None of the above
- Query languages and utilities
- DML and query language
- Data dictionary and transaction log
- None of the above
Set 2
1. A The infological model B The entity-relational model C The binary model D None of these E All of the above Answer: A 2. Which design is both software and hardware independent? A Conceptual B Physical C Logical D Both A and B E None of these Answer: A 3. The Object-based data models are used to define the abstraction __________ level: A Only physical B Physical and conceptual C Both A and B D Conceptual and view E None of the above Answer: D 4. A schema is A Record Relationship B Data Elements C Record and files D Both A and B E All of the above Answer: E 5. An abstraction concept for building composite objects from their component objects is known as A Aggregation B Normalization C Generalization D Specialization Answer: A 6. The DBMS is used for what? A Eliminate data redundancy B Maintain data integrity C Establish relationships among different files D Both A and B E All of the above 7. Which type of information is used by the top-level managers? A Operational information B Strategic information C Both A and B D Technical information E All of the above Answer: B 8. Identify the package that does not belong to DBMS. A Ingress B Unify C IDMS D All are DBMS packages Answer: D 9. A collection of objects that use a common structure and a common behavior is known as A Object B Entity C Class D Both A and B E All of the above Answer: C 10. The data dictionary tells_________to the DBMS: A What files are in the database B What these files contain C What attributes are possessed by the data D All of the above E None of the above Answer: D 11. A relationship among students and courses is A M:M relationship B 1:M relationship C 1:1 relationship D None of these Answer: A 12. The Database has all of the mentioned components except A Users B Database administrator C Database D Separate files E None of the above Answer: D 13. The key used for cost-effective data input is A Employee motivation B Validity checks C Validation D OCR equipment E All of the above Answer: A 14. Complex entities can be formed by the following operation: A SUM B Union C Collection D Aggregation E Both A and C Answer: D 15. Which belongs to metadata? A Data dictionary B Table C E-R diagram D View of a database E None of the above Answer: A 16. Periodically adding, changing, and deleting file records is known as A Renewing B Upgrading C Restructuring D Updating E Both A and B Answer: D 17. The Primitive operations usually applied to all record management systems are A Look-up B Sort C Print D All of the above E None of these Answer: A 18. Administrative supervision of a database is the responsibility of A DP Administrator B DP Manager C DB Manager D Database Administrator E None of these Answer: DMore MCQs Of Database Systems
- Database Models MCQs in DBMS
- Relational Database Model MCQs in DBMS
- SQL (Structured Query Language) MCQs in DBMS
- Database Design MCQs in DBMS
- Database Management System Architecture MCQs in DBMS
- Storage and File Structure MCQs in DBMS
- Query Processing and Optimization MCQs in DBMS
- Database Transaction Management MCQs in DBMS
- Database Security and Authorization MCQs in DBMS
- Backup and Recovery MCQs in DBMS
- Distributed Databases MCQs in DBMS
- SET 1: database design mcqs (database design mcqs )
- SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
- SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
- SET 4: database systems mcqs (database systems mcqs)
- SET 5: dbms mcqs (dbms mcqs )
- SET 6: dbms mcqs with answers (dbms mcqs with answers)
- SET 7: solved mcqs of dbms (solved mcqs of dbms)
- SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
- SET 9: relational database management system mcqs(relational database management system mcqs)
- SET 10: solved mcqs of database management system(solved mcqs of database management system)
- SET 11: basic database mcqs pdf (basic database mcqs pdf)
- SET 12: relational database management system mcqs (relational database management system mcqs )
- SET 13: database mcqs online test (database mcqs online test)
- SET 14: database interview questions mcqs (database interview questions mcqs)
- SET 15: database developer mcqs (database developer mcqs)
- SET 16: database Repeated mcqs (database Repeated mcqs)
- SET 17: Database mcqs PPSC (Database mcqs PPSC)
- SET 18: Database mcqs FPSC (Database mcqs FPSC)
- SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)
