Solved MCQ on Fundamental of DBMS set-9

This set of multiple choice question on fundamental of database management system -DBMS includes MCQ questions about introduction of Database Model, characteristic of a relational database and the architecture of a database system.

1) Which of the following is not a characteristic of a relational database model? A. Table B. Tree like structure C. Complex logical relationship D. Records

2) Field is otherwise called as ……… of the record A. data item B. data type C. value D. variable

12) When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n) …….. A. transitive dependency B. insertion anomaly C. referential integrity constraint D. normal form

19) The way a particular application views the data from the database that the application uses is a A. module B. relational model C. schema D. sub schema

20) ……. is a condition specified on a database schema and restricts the data that can be stored in an instance of the database. A. Key Constraint B. Check Constraint C. Foreign key constraint D. integrity constraint

Shuseel Baral is a web programmer and the founder of InfoTechSite has over 8 years of experience in software development, internet, SEO, blogging and marketing digital products and services is passionate about exceeding your expectations.