DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q171
In which of the model(s) strictly require the relationships be predefined
  • A Network model
  • B Hierarchial model
  • C Relational model
  • D none
Answer: Option C
Q172
The type of the datastrucure that is used in relational model is
  • A Table
  • B Tree
  • C Node
  • D none of the above
Answer: Option A
Q173
The data in the database that cannot be removed by other process until and unless it is requested is
  • A Persistent data
  • B Transient data
  • C In consistent data
  • D none
Answer: Option A
Q174
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
  • A 1 only
  • B 2 only
  • C 2,3,4
  • D 1,2,3 and 4
Answer: Option D
Q175
Which of the following statements is true?
  • A A database must contain two or more tables
  • B A database must contain two data tables
  • C A database must contain at least one data table
  • D A database must contain one data table
Answer: Option C
Q176
A COMPLEX KEY FIELD is one which
  • A Is capable of storing more than one data type in it
  • B Ensures that there cannot be more than one record in a table with the same key field values
  • C Is made up of more than one field
  • D Is a numerical data type
Answer: Option C
Q177
Data Validation is
  • A The practice of ensuring that only valid data is input into a database
  • B The practice of running a check on existing data to confirm that there is no invalid data
  • C A separate program that checks existing data for errors
  • D A process of filtering out invalid data on a weekly or monthly basis
Answer: Option A
Q178
A field is
  • A can store any type of data at any time
  • B capable of storing many facts
  • C the smallest amount of data DBMS can store
  • D either true or false
Answer: Option C
Q179
Which of the following is a valid key field.
  • A Initials+family name
  • B Student name
  • C Car registration number
  • D Streetname
Answer: Option C
Q180
Which of the following is a valid database. 1.A telephone directory 2.The northern college record system 3.box of flowers 4.none
  • A 2 only
  • B 1 and 2
  • C 2 and 3
  • D 4
Answer: Option B

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test