DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q101
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 database
Answer: Option C
Q102
A row or record in a relational database is called a(n)
  • A field
  • B pointer
  • C file
  • D tuple
Answer: Option D
Q103
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
Q104
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
Q105
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
Q106
The hierarchical DBMS organizes data elements into
  • A segments
  • B data compartments
  • C data units
  • D objects
Answer: Option A
Q107
An abstract model of the database from a business perspective best defines
  • A physical design
  • B object design
  • C organizational view
  • D conceptual design
Answer: Option D
Q108
The process of creating small, stable data structures from complex groups of data when designing a relational database defines
  • A data decomposition
  • B data structuring
  • C data transcribing
  • D normalization
Answer: Option D
Q109
Which of the following best describes a special organizational function for managing the organization
  • A database administration
  • B information management
  • C data analysis
  • D data administration
Answer: Option D
Q110
Data administration
  • A establishes specific policies and procedures through which data can be managed as an organizational resource
  • B establishes access rules and procedures
  • C defines and organizes database structure and content
  • D maintains the database
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