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
Show Answer
172. The type of the datastrucure that is used in relational model is
  • Table
  • Tree
  • Node
  • none of the above
Show Answer
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
Show Answer
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
Show Answer
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
Show Answer
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
Show Answer
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
Show Answer
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
Show Answer
179. Which of the following is a valid key field.
  • Initials+family name
  • Student name
  • Car registration number
  • Streetname
Show Answer
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
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test