DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q261
Most database software includes: a. special purpose database management software called the DBMS. b. application software that uses DBMS facilities to manipulate the database to achieve a specific business function. c. application software that is always written using a fourth-generation language supplied with the DBMS. d. application software that utilises the command language of the DBMS.
  • A a,c and d
  • B c and b
  • C b and d
  • D a and b
Answer: Option C
Q262
Which of the following closely describes a workgroup database application?
  • A A sales person keeping track of his customer information with contact details.
  • B A software development team maintaining a list of software objects.
  • C A personnel database that is designed to track data concerning employees, job skills and job assignments for a large organisation.
  • D A large healthcare organisation that operates a group of medical centres including hospitals, clinics and nursing homes.
Answer: Option B
Q263
The following are the three language components of a database management system (DBMS). Data Definition Language (DDL) (ii) Sub-schema DDL (iii) Data Manipulation Language Two different types of people (users and practioners) are concerned with them. Which of them do users of a DBMS usually deal with?
  • A (i) only
  • B (iii) only
  • C (i) and (ii) only
  • D (ii) and (iii) only
Answer: Option B
Q264
Data Independence refers to:
  • A Handling of data by the DBMS software entirely independent of the operating system.
  • B Insulating the application program from external changes such as inclusion of a new data item into an existing record structure.
  • C Separation of data descriptions from the application programs that uses the data.
  • D Allowing application programs to be executed at a node different to the database server.
Answer: Option B
Q265
Which of the following is (are) true with respect to data models? a. The network data model was introduced to overcome the main deficiencies in the use of files. b. The hierarchical data model uses a tree data structure. c. The object-oriented data model was introduced to deal with non-traditional commercial applications such as Geographical Information Systems (GIS). d. The relational data model was widely accepted by most users from its inception in early 1970s.
  • A a,c and d
  • B c and d
  • C b and c
  • D d and b
Answer: Option C
Q266
A _________ is a logically coherent collection of data with some inherent meaning, representing some aspect of real world
  • A Database
  • B data
  • C Data dictionary
  • D none
Answer: Option A
Q267
. A __________ is a collection of programs that enables user to create and maintain a database.
  • A DBMS
  • B Data
  • C Data dictionary
  • D none
Answer: Option A
Q268
The database and DBMS software together is called as_________
  • A Database collection
  • B Database method
  • C Database system.
  • D Database repository.
Answer: Option C
Q269
The following is /are the Advantage(s) of DBMS?
  • A Redundancy is controlled
  • B Unauthorised access is restricted
  • C Providing multiple user interfaces
  • D All the above
Answer: Option D
Q270
The level of abstraction that describes only part of entire database
  • A Physical
  • B External
  • C Internal
  • D Conceptual
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