Title: Default for CSC211_SEP2020
Course: Introduction to Database Management Systems

Q: Which of the following is NOT a disadvantage of the file-based approach?
- Security Problems
- Data isolation
- Integrity problems
- Asynchronous access
A: Asynchronous access

Q: Data redundancy leads to following problems
- Inconsistency in data format
- The same information being kept in several different places (files)
- Data consistency
- Meaningless data
A: Data consistency

Q: The database approach is a new approach in managing large amounts of organizational information.
- True
- False
A: True

Q: The following are properties of databases except?
- A database is logical
- A database is coherent and internally consistent
- Each data item is stored in a table
- A combination of fields makes up a table
A: Each data item is stored in a table

Q: A database system is referred to as metadata because it not only contains the database itself, but also self-describing which defines and describes the data and relationships between tables in the database.
- True
- False
A: False

Q: Which of the following are benefits of databases?
- Insulation between program and data
- Data independence
- Data sharing
- All the above
A: All the above

Q: A database tool is a piece of general-purpose software, which enables its user to carry out any valid operation
- True
- False
A: True

Q: The following are features of the file-based system except?
- The files themselves maintain relationships between the data
- Users must know the physical structure of a data file in order to use it
- Users must know the logical structure of a data file in order to use it
- Users must have been granted access to the file in order to use it.
A: The files themselves maintain relationships between the data

Q: _____ means the ability of a user to access the required data without being concerned with its detailed characteristics or the structure of the way it is stored
A: data independence

Q: The _____ contains a definition of the logical and physical structures of the data, separate from both the data itself and the users which access it.
A: database schema

Q: The only contact a user can have with the database is through an external schema.
- True
- False
A: True

Q: The _____ is a model for a database system which provides full logical and physical data independence.
A: ANSI/SPARC

Q: Which of the following are well-known record-based logical data models?
- Relational data models
- Network data models
- Hierarchical data models
- All the above
A: All the above

Q: _____________ provide concepts for presenting data in ways that are close to the way people perceive data
- High-level Conceptual Data Models
- Relational data models
- Hierarchical data models
- None of the above
A: High-level Conceptual Data Models

Q: Which of the following does NOT describe data modelling?
- High-level
- Logical
- Abstract design
- Conceptual design
A: Logical

Q: Which of the following is the third step in the process of database design?
- Data expression
- Database design
- Data modelling
- None of the above
A: Database design

Q: Which of the following is considered to have the highest level of abstraction?
- Conceptual models
- Internal models
- External models
- Physical models
A: External models

Q: Various library database systems use the same machine-readable cataloguing (MARC) format to support library record data exchange. This could be considered as an example of a _____________ database system?
- Homogeneous distributed database systems
- Heterogeneous distributed database systems
- Distributed database systems
- Centralized database systems
A: Heterogeneous distributed database systems

Q: The database design and its implementation are considered as one of the factors that determine performance?
- True
- False
A: True

Q: A ______________ interview people and record their stated requirements in writing, and then to examine those requirements to produce a model of them which could be computerized.
- system analyst
- system designer
- system developer
- system initiator
A: system analyst

Q: The _____________ is the equivalent of the system specification output within the waterfall model
- Data Requirements
- Conceptual Data Model
- Logical Schema
- Initial Schema
A: Conceptual Data Model

Q: The _______________ is the equivalent of the logical schema output within the database model
- Statement of requirements
- System specification
- Design document
- Initial system
A: Design document

Q: The waterfall model can be used as a basis for the database model based on which of the following?
A: We can use the three-schema architecture We can separate the development of a database None of the above All the above

Q: _____ is someone who accesses an existing application program to perform daily tasks.
A: application user

Q: Sophisticated users are do not use the application program provided in the system
- True
- False
A: True

Q: A _____ is one person or a group of people in an organization responsible for authorizing access to the database
A: database administrator / database administrators

Q: A _____ shows the process as a strict sequence of steps where the output of one step is the input to the next and all of one step must be completed before moving onto the next
A: waterfall model

Q: A(n) _____ is an object in the real world with an independent existence that can be differentiated from other objects
A: entity

Q: Which of the following is not a characteristic of a kernel?
- They are the building blocks of a database
- The primary key may be simple or composite
- The primary key is not a foreign key
- The primary key maybe null
A: The primary key maybe null

Q: _____ are used to connect two kernels together
A: dependent entities

Q: A _________________ is represented by an oval with a name inside
- Attribute
- Entity
- Table
- Field
A: Attribute

Q: Which of the following is a key that is unique and minimal?
- Composite key
- Primary key
- Candidate key
- Secondary key
A: Candidate key

Q: ___________ exists if the primary key of the related entity does not contain a primary key component of the parent entity.
- Strong relationship
- Identifying relationship
- Non-identifying relationship
- None of the above
A: Non-identifying relationship

Q: An employee has different start dates for different projects. What kind of a relationship is shown?
- 1:1
- M:N
- 1:M
- All the above
A: M:N

Q: Which of the following would be considered a property of a relation?
- Each value in the relation is atomic
- Each relation has a name, different from that of any other
- Each attribute of the relation has a name,
- All the above
A: All the above

Q: Which of the following would NOT be considered as atomic?
- HP
- 20-27
- 62.4738
- 20th Century
A: 20-27

Q: A foreign key must reference a candidate key, that candidate key could be an attribute of the same relation is a _____ relationship
A: recursive

Q: A _____ is the original sets of atomic values used to model data
A: domain

Q: The degree is the number of attribute values in a table
- True
- False
A: False

Q: The rules that force DBMSs to check that data satisfies the semantics are known as ______________.
- Business rules
- Constraints
- Cardinality
- Integrity
A: Constraints