DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q181
Assume you are extending the design of The Northern College Student Records System to include details on each classroom. The college is never likely to have more than ten classrooms and definitely not ever going to have more than 25 classrooms. What data type would you select
  • A Numeric- Integer
  • B Numeric
  • C Numeric
  • D Numeric
Answer: Option C
Q182
A Database Management System can 1.Delete data 2. Retrieve data 3.Add new data 4.Edit Data
  • A 1 and 2
  • B 1,2 and 4
  • C 1,2 and 3
  • D 1,2,3 and 4
Answer: Option D
Q183
A unique key field is
  • A Is a special field that has to be a unique number
  • B Is a special field that identifies a particular record in a data table
  • C Is a special field that each database has to have.
  • D none
Answer: Option B
Q184
Input Masks are
  • A only used with a RDBMS
  • B Used to force user input into a particular form.
  • C Used to prevent any data at all being entered into a particular field
  • D Use to ensure that numbers are kept within expected bounds
Answer: Option B
Q185
A flat file Database management system is
  • A A DBMS that can only have one table in it
  • B A DBMS that contains records that have a large number of fields in them
  • C A DBMS that can only have simple data tables in it
  • D none of these
Answer: Option A
Q186
A table
  • A Cannot be empty
  • B consists of rows and columns
  • C Consists of Alphanumeric data
  • D can only store data of one type
Answer: Option D
Q187
Which of the following statements are true 1.A character data type can contain 0,1,2,3,4,5,6,7,8,9 2.Some DBMS
  • A 1 and 2
  • B 1,2 and 3
  • C 1,2 and 4
  • D 1,2,3 and 4
Answer: Option C
Q188
Which of the following statements are true
  • A All records in a data table need not necessarily have the same fields in them
  • B A data table is made up of records
  • C Fields must contain specified types of data
  • D A record is made up of fields
Answer: Option B
Q189
The person who is having central control over data and programs accessing that data
  • A DBA
  • B Database Designer
  • C Developer
  • D none
Answer: Option A
Q190
The users who use the database by writing special database application programs are called
  • A Sophisticated end user
  • B Specialized end user
  • C Na
  • D Native end user
Answer: Option A

📚 More from Database

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