DBMS MCQ Question and Answer
DBMS MCQ Question and Answer
171. In which of the model(s) strictly require the relationships be predefined
- Network model
- Hierarchial model
- Relational model
- none
172. The type of the datastrucure that is used in relational model is
- Table
- Tree
- Node
- none of the above
173. The data in the database that cannot be removed by other process until and unless it is requested is
- Persistent data
- Transient data
- In consistent data
- none
174. Data integrity in a relational database requires that
1.)it is not permitted to delete a record from a secondary table if there is corresponding record in the primary table
2.)no key can be null
3.)the key in a record must be unique
4.)a foreign key must match an existing record in the primary table
- 1 only
- 2 only
- 2,3,4
- 1,2,3 and 4
175. Which of the following statements is true?
- A database must contain two or more tables
- A database must contain two data tables
- A database must contain at least one data table
- A database must contain one data table
176. A COMPLEX KEY FIELD is one which
- Is capable of storing more than one data type in it
- Ensures that there cannot be more than one record in a table with the same key field values
- Is made up of more than one field
- Is a numerical data type
177. Data Validation is
- The practice of ensuring that only valid data is input into a database
- The practice of running a check on existing data to confirm that there is no invalid data
- A separate program that checks existing data for errors
- A process of filtering out invalid data on a weekly or monthly basis
178. A field is
- can store any type of data at any time
- capable of storing many facts
- the smallest amount of data DBMS can store
- either true or false
179. Which of the following is a valid key field.
- Initials+family name
- Student name
- Car registration number
- Streetname
180. Which of the following is a valid database.
1.A telephone directory
2.The northern college record system
3.box of flowers
4.none
- 2 only
- 1 and 2
- 2 and 3
- 4