DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q151
Which of the following is a group of files?
  • A attribute
  • B database
  • C field
  • D segment
Answer: Option B
Q152
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
Q153
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
Q154
The most prominent data manipulation language today is:
  • A COBOL
  • B DL/1
  • C IMS
  • D SQL
Answer: Option D
Q155
Which of the following is an automated or manual tool for storing and organizing information about the data maintained in a database?
  • A JAD
  • B . electronic journal
  • C data dictionary
  • D hypermedia
Answer: Option C
Q156
A row or record in a relational database is called a(n):
  • A field
  • B pointer
  • C file
  • D tuple
Answer: Option D
Q157
In a relational database, the operation that creates a subset of data consisting of columns in a table, permitting the user to create new tables that contain only the information required is the:
  • A join operation
  • B project operation
  • C section operation
  • D select operation
Answer: Option B
Q158
In the relational database, the operation that combines relational tables to provide the user with more information than is available in individual tables is the:
  • A join operation
  • B merge operation
  • C select operation
  • D grow operation
Answer: Option A
Q159
The logical database model that presents data to users in a treelike structure is the:
  • A object-oriented DBMS
  • B network DBMS
  • C relational DBMS
  • D hierarchical DBMS
Answer: Option D
Q160
The hierarchical DBMS organizes data elements into:
  • A segments
  • B data compartments.
  • C data units.
  • D objects.
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