FIle Structure and Organization Set 2
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 FIle Structure and Organization Set 2
Q1 | Which of the following schemas does define a view or views of the database forparticular users?
- Internal schema
- Conceptual schema
- Physical schema
- External schema
Q2 | Which of the following are the process of selecting the data storage and data accesscharacteristics of the database?
- Logical database design
- Physical database design
- Testing and performance tuning
- Evaluation and selecting
Q3 | Which of the following terms does refer to the correctness and completeness of the datain a database?
- Data security
- Data constraint
- Data independence
- Data integrity
Q4 | A table can be logically connected to another table by defining a
- Super key
- Candidate key
- Primary key
- Unique key
Q5 | If the state of the database no longer reflects a real state of the world that the databaseis supposed to capture, then such a state is called
- Consistent state
- Parallel state
- Durable state
- Inconsistent state
Q6 | Ensuring isolation property is the responsibility of the
- Recovery-management component of the DBMS
- Concurrency-control component of the DBMS
- Transaction-management component of the DBMS
- Buffer management component in DBMS
Q7 | A collection of related data.
- Information
- Valuable information
- Database
- Metadata
Q8 | DBMS is software.
- True
- False
- none
- all
Q9 | DBMS manages the interaction between __________ and database.
- Users
- Clients
- End Users
- Stake Holders
Q10 | Which of the following is not involved in DBMS?
- End Users
- Data
- Application Request
- HTML
Q11 | Database is generally __________
- System-centered
- User-centered
- Company-centered
- Data-centered
Q12 | A characteristic of an entity.
- Relation
- Attribute
- Parameter
- Constraint
Q13 | The restrictions placed on the data.
- Relation
- Attribute
- Parameter
- Constraint
Q14 | IMS stands for?
- Information Mastering System
- Instruction Management System
- Instruction Manipulating System
- Information Management System
Q15 | A model developed by Hammer and Mc Leod in 1981.
- SDM
- OODBM
- DDM
- RDM
Q16 | Object=_________+relationships.
- data
- attributes
- entity
- constraints
Q17 | Duplication of data at several places is called as _______________.
- Data Inconsistency
- Data Isolation
- Atomicity Problem
- Data Redundance
Q18 | Data Redundancy increases the cost of storing and retrieving data.
- False
- True
- none
- all
Q19 | Which of the information is not redundant.
- name
- mobile
- account-no
- address
Q20 | If in redundant file common fields are not matching then it results in _____________.
- Data Inconsistency
- Data Integrity Problem
- Data Isolation
- Data Redundancy
Q21 | It is difficult to access conventional file system than Database System.
- True
- False
- none
- all
Q22 | An ________ is a set of entities of the same type that share the same properties, orattributes.
- Entity set
- Attribute set
- Relation set
- Entity model
Q23 | Entity is a _________
- Object of relation
- Present working model
- Thing in real world
- Model of relation
Q24 | The descriptive property possessed by each entity set is _________
- Entity
- Attribute
- Relation
- Model
Q25 | The function that an entity plays in a relationship is called that entity’s _____________
- Participation
- Position
- Role
- Instance