DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q91
A characteristic or quality describing a particular entity is called
  • A record
  • B file
  • C attribute
  • D pointer
Answer: Option C
Q92
Which of the following is an attribute?
  • A a student
  • B a student database
  • C a student personal history file
  • D a student
Answer: Option D
Q93
The field in a record that uniquely identifies instances of that record so that it can be retrieved, updated, or sorted best describes
  • A master key
  • B master field
  • C attribute
  • D key field
Answer: Option D
Q94
The smallest data element in the data hierarchy is a
  • A byte
  • B field
  • C bit
  • D file
Answer: Option C
Q95
Problems with the traditional file environment include
  • A data redundancy
  • B poor data security
  • C inability to share data among applications
  • D all of the above
Answer: Option D
Q96
The situation that occurs when different divisions, functional areas, and groups in an organization independently collect the same piece of information best describes
  • A program-data independence
  • B data redundancy
  • C lack of flexibility
  • D poor security
Answer: Option B
Q97
Which of the following is a group of files?
  • A attribute
  • B database
  • C field
  • D segment
Answer: Option B
Q98
A logical view is
  • A the process of creating small stable data structures from complex groups of data when designing a relational database.
  • B a methodology for documenting databases illustrating the relationship between various entities in the database.
  • C an approach to data management that stores both data and the procedures acting on the data as objects that can be automatically retrieved and shared.
  • D a representation of data as they would appear to an application programmer or user.
Answer: Option D
Q99
The language associated with a database management system that is employed by end users and programmers to manipulate data in the database is the
  • A data definition language
  • B data presentation language
  • C data manipulation language
  • D data translation language
Answer: Option C
Q100
The most prominent data manipulation language today is
  • A COBOL.
  • B DL/1
  • C IMS
  • D SQL
Answer: Option D

📚 More from Database

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