DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q281
Duplication of data in files may cause
  • A data integrity problems.
  • B data items with the same names used for different purposes.
  • C data items with different names in different files.
  • D A and C
Answer: Option D
Q282
Which of the following is NOT an advantage of database systems?
  • A better data quality
  • B program-data independence
  • C redundant data
  • D standards enforcement
Answer: Option C
Q283
Which of the following is NOT a function of a DBMS?
  • A data storage, retrieval, and update.
  • B logical data dependence.
  • C recovery services.
  • D integrity services
Answer: Option B
Q284
Which of the following is used to store the structure and format of user forms, reports, queries, and other application components?
  • A Application MetaData
  • B Report Table
  • C Query By Example
  • D None
Answer: Option A
Q285
Data in the database that represent a description of the database structure are called:
  • A Indexes
  • B User Data
  • C Application metadata
  • D Metadata
Answer: Option D
Q286
The intermediary between the design tools and run-time subsystems and data is called:
  • A DBMS engine
  • B Database schema
  • C Operating system
  • D User interface
Answer: Option A
Q287
Restrictions on the business activities that need to be reflected in the database and database application are known as:
  • A Database schema
  • B Relationships
  • C Business rules
  • D None
Answer: Option C
Q288
Which of the following is not a way in which a query can be expressed?
  • A By surrogate keys
  • B Query by form
  • C Use the data access language SQL
  • D Query by example
Answer: Option A
Q289
What is Database?
  • A Collection of Information
  • B Collection of meaningful real world data
  • C Which stores Data
  • D All the above
Answer: Option B
Q290
Advantages of DBMS. Which statement is true? (i) security (ii) Redundancy is controlled (iii) Providing backup and recovery (iv) Providing multiple user interfaces.
  • A (i) and (ii)
  • B (iii) and (vi)
  • C (i),(ii),(iii) and not (iv)
  • D (i),(ii),(iii) and (iv)
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