Database Management System MCQ (Multiple Choice

Questions)
Here are 1000 MCQs on Database Management System (Chapterwise).

1. What is the full form of DBMS?

a) Data of Binary Management System
b) Database Management System
c) Database Management Service
d) Data Backup Management System
View Answer

2. What is a database?
a) Organized collection of information that cannot be accessed, updated, and managed
b) Collection of data or information without organizing
c) Organized collection of data or information that can be accessed, updated, and managed
d) Organized collection of data that cannot be updated
View Answer

3. What is DBMS?
a) DBMS is a collection of queries
b) DBMS is a high-level language
c) DBMS is a programming language
d) DBMS stores, modifies and retrieves data
View Answer

4. Who created the first DBMS?

a) Edgar Frank Codd
b) Charles Bachman
c) Charles Babbage
d) Sharon B. Codd
View Answer

5. Which type of data can be stored in the database?

a) Image oriented data
b) Text, files containing data
c) Data in the form of audio or video
d) All of the above
View Answer
advertisement

6. In which of the following formats data is stored in the database management system?
a) Image
b) Text
c) Table
d) Graph
View Answer

7. Which of the following is not a type of database?

a) Hierarchical
b) Network
c) Distributed
d) Decentralized
View Answer

8. Which of the following is not an example of DBMS?

a) MySQL
b) Microsoft Acess
c) IBM DB2
d) Google
View Answer

9. Which of the following is not a feature of DBMS?

a) Minimum Duplication and Redundancy of Data
b) High Level of Security
c) Single-user Access only
d) Support ACID Property
View Answer

10. Which of the following is a feature of the database?

a) No-backup for the data stored
b) User interface provided
c) Lack of Authentication
d) Store data in multiple locations
View Answer

11. Which of the following is not a function of the database?

a) Managing stored data
b) Manipulating data
c) Security for stored data
d) Analysing code

View Answer

12. Which of the following is a function of the DBMS?

a) Storing data
b) Providing multi-users access control
c) Data Integrity
d) All of the above
View Answer

13. Which of the following is a component of the DBMS?

a) Data
b) Data Languages
c) Data Manager
d) All of the above
View Answer

advertisement

14. Which of the following is known as a set of entities of the same type that share same properties, or attributes?
a) Relation set
b) Tuples
c) Entity set
d) Entity Relation model
View Answer

15. What is information about data called?

a) Hyper data
b) Tera data
c) Meta data
d) Relations
View Answer

16. What does an RDBMS consist of?

a) Collection of Records
b) Collection of Keys
c) Collection of Tables
d) Collection of Fields
View Answer

17. The values appearing in given attributes of any tuple in the referencing relation must likewise occur in specified
attributes of at least one tuple in the referenced relation, according to _____________________ integrity constraint.
a) Referential
b) Primary
c) Referencing
d) Specific
View Answer

18. _____________ is a hardware component that is most important for the operation of a database management
system.
a) Microphone
b) High speed, large capacity disk to store data
c) High-resolution video display
d) Printer
View Answer

advertisement
19. The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.
a) Data and the DBMS
b) Application and SQL
c) Database application and the database
d) The user and the software
View Answer

20. The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________
a) TCL (Transaction Control Language)
b) DCL (Data Control Language)
c) DDL (Data Definition Langauge)
d) DML (Data Manipulation Langauge)
View Answer

21. ______________ is a set of one or more attributes taken collectively to uniquely identify a record.
a) Primary Key
b) Foreign key
c) Super key
d) Candidate key
View Answer

22. Which command is used to remove a relation from an SQL?

a) Drop table
b) Delete
c) Purge
d) Remove
View Answer

23. Which of the following set should be associated with weak entity set for weak entity to be meaningful?
a) Neighbour set
b) Strong entity set
c) Owner set
d) Identifying set
View Answer

24. Which of the following command is correct to delete the values in the relation teaches?
a) Delete from teaches;
b) Delete from teaches where Id =’Null’;
c) Remove table teaches;
d) Drop table teaches;
View Answer

25. Procedural language among the following is __________

a) Domain relational calculus
b) Tuple relational calculus
c) Relational algebra
d) Query language
View Answer

26. _________________ operations do not preserve non-matched tuples.

a) Left outer join
b) Inner join
c) Natural join
d) Right outer join
View Answer

27. Which forms have a relation that contains information about a single entity?
a) 4NF
b) 2NF
c) 5NF
d) 3NF
View Answer

28. The top level of the hierarchy consists of ______ each of which can contain _____.
a) Schemas, Catalogs
b) Schemas, Environment
c) Environment, Schemas
d) Catalogs, Schemas
View Answer

29. _______ indicates the maximum number of entities that can be involved in a relationship.
a) Greater Entity Count
b) Minimum cardinality
c) Maximum cardinality
d) ERD
View Answer

30. The user IDs can be added or removed using which of the following fixed roles?
a) db_sysadmin
b) db_accessadmin
c) db_securityadmin
d) db_setupadmin
View Answer

31. Why the following statement is erroneous?

SELECT dept_name, ID, avg (salary)

FROM instructor
GROUP BY dept_name;

a) Dept_id should not be used in group by clause

b) Group by clause is not valid in this query
c) Avg(salary) should not be selected
d) None
View Answer

32. The traditional storage of data organized by the customer, stored in separate folders in filing cabinets is an
example of ______________ type of ‘database’ management system.
a) Object-oriented database management system
b) Relational database management system
c) Network database management system
d) Hierarchical database management system

View Answer

33. After groups have been established, SQL applies predicates in the ___________ clause, allowing aggregate functions
to be used.
a) Where
b) Having
c) Group by
d) With
View Answer

34. Which of the following is not the utility of DBMS?

i) Backup ii) Loading iii) Process Organization iv) File organization
a) i, ii, and iv only
b) i, ii and iii only
c) i, iii and iv only
d) All i, ii, iii, and iv
View Answer

35. What does a foreign key combined with a primary key create?
a) Network model between the tables that connect them
b) Parent-Child relationship between the tables that connects them
c) One to many relationship between the tables that connects them
d) All of the mentioned

View Answer

36. Which of the following is correct according to the technology deployed by DBMS?
a) Pointers are used to maintain transactional integrity and consistency
b) Cursors are used to maintain transactional integrity and consistency
c) Locks are used to maintain transactional integrity and consistency
d) Triggers are used to maintain transactional integrity and consistency
View Answer

37. Which of the following is correct regarding the file produced by a spreadsheet?
a) can be used as it is by the DBMS
b) stored on disk in an ASCII text format
c) all of the mentioned
d) none of the mentioned
View Answer
38. What is the function of the following command?

Delete from r where P;

a) Clears entries from relation

b) Deletes relation
c) Deletes particular tuple from relation
d) All of the mentioned
View Answer

39. ______ resembles Create view.

a) Create table . . . as
b) Create view as
c) Create table . . .like
d) With data
View Answer

40. The query specifying the SQL view is said to be updatable if it meets which of the following conditions?
a) select clause contains relation attribute names but not have expressions, aggregates, or distinct specification
b) from clause has 1 relation
c) query does not have group by or having clause
d) All of the mentioned
View Answer

41. When the “ROLLUP” operator for expression or columns within a “GROUP BY” clause is used?
a) Find the groups that make up the subtotal in a row
b) Create group-wise grand totals for the groups indicated in a GROUP BY clause
c) Group expressions or columns specified in a GROUP BY clause in one direction, from right to left, for computing
the subtotals
d) To produce a cross-tabular report for computing subtotals by grouping phrases or columns given within a GROUP
BY clause in all available directions
View Answer

42. Which of the following is the best way to represent the attributes in a large db?
a) Dot representation
b) Concatenation
c) Relational-and
d) All of the mentioned
View Answer

43. Which of the following is the subset of SQL commands used to manipulate Oracle Structures, including tables?
a) Data Described Language
b) Data Retrieval Language
c) Data Manipulation Language
d) Data Definition Language
View Answer
44. Which of the following functions construct histograms and use buckets for ranking?
a) Ntil()
b) Newtil()
c) Rank()
d) All of the mentioned
View Answer

45. __________ command is used in SQL to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a
single transaction.
a) CREATE CLUSTER
b) CREATE PACKAGE
c) CREATE SCHEMA
d) All of the mentioned
View Answer

46. Which of the following key is required in to handle the data when the encryption is applied to the data so that the
unauthorised user cannot access the data?
a) Primary key
b) Authorised key
c) Encryption key
d) Decryption key
View Answer

47. Which of the following is known as the process of viewing cross-tab with a fixed value of one attribute?
a) Dicing
b) Pivoting
c) Slicing
d) Both Pivoting and Dicing
View Answer

48. For designing a normal RDBMS which of the following normal form is considered adequate?
a) 4NF
b) 3NF
c) 2NF
d) 5NF
View Answer

49. Which of the following is popular for applications such as storage of log files in a database management system
since it offers the best write performance?
a) RAID level 0
b) RAID level 1
c) RAID level 2
d) RAID level 3
View Answer

50. Which of the following represents a query in the tuple relational calculus?
a) { }{P(t) | t }
b) {t | P(t)}
c) t | P() | t
d) All of the mentioned
View Answer

51. The oldest DB model is _______________

a) Network
b) Physical
c) Hierarchical
d) Relational
View Answer

52. Evaluate the statements issued by the DBA in the given sequence if OE and SCOTT are the users and the ORDERS
table is owned by OE.

CREATE ROLE r1;

GRANT SELECT, INSERT ON oe. orders TO r1;
GRANT r1 TO scott;
GRANT SELECT ON oe. orders TO scott;
REVOKE SELECT ON oe.orders FROM scott;

What would be the outcome after executing the statements?

a) The REVOKE statement would give an error because the SELECT privilege has been granted to the role R1
b) The REVOKE statement would remove the SELECT privilege from SCOTT as well as from the role R1
c) SCOTT would be able to query the OE.ORDERS table
d) SCOTT would not be able to query the OE.ORDERS table
View Answer

53. Which of the following establishes a top-to-bottom relationship among the items?
a) Relational schema
b) Network schema
c) Hierarchical schema
d) All of the mentioned
View Answer

54. A major goal of the db system is to minimize the number of block transfers between the disk and memory. Which
of the following helps in achieving this goal?
a) Secondary storage
b) Storage
c) Catalog
d) Buffer
View Answer

55. What happens if a piece of data is stored in two places in the db?
a) Storage space is wasted & Changing the data in one spot will cause data inconsistency
b) In can be more easily accessed
c) Changing the data in one spot will cause data inconsistency
d) Storage space is wasted
View Answer
56. The logical design, and the snapshot of the data at a given instant in time is known as?
a) Instance & Relation
b) Relation & Schema
c) Domain & Schema
d) Schema & Instance
View Answer

Chapterwise Multiple Choice Questions on DBMS

Our 1000+ MCQs focus on all topics of the DBMS subject, covering 100+ topics. This will
help you to prepare for exams, contests, online tests, quizzes, viva-voce, interviews, and
certifications. You can practice these MCQs chapter by chapter starting from the 1st
chapter or you can jump to any chapter of your choice. You can also download the PDF
of Database Management System MCQs by applying below.

1. The Relational Model

2. SQL : Queries, Constraints and Triggers
3. Relational Algebra
4. Database Systems Design and Implementation
5. Normalization
6. Database Programming Techniques
7. Storage and File Structures
8. Indexing and Hashing
9. Query Processing Techniques
10. Transactions
11. Concurrency Control
12. Recovery System

1. The Relational Model

The section contains multiple choice questions and answers on dealing with the concept of Relational Model. These
include relational and schema, keys and relational query operators.

Relational Database and Schema Relational Query Operations and Relational

Operators
Keys

2. SQL : Queries, Constraints and Triggers

The section contains questions and answers on different set of SQL basics, set and null value operations,
modifications, views and transactions, different types of integrity constraints, joins, nested subqueries and aggregate
functions, schemas and data types, triggers, functions and procedures and different queries and aggregation
features.

SQL Basics and SQL Data Definition Transactions

SQL Queries Integrity Constraints
Basic SQL Operations SQL Data Types and Schemas
Set Operations Authorizations
Null Values Operations Access SQL From a Programming Language
Aggregate Functions and Nested Subqueries 1 Functions and Procedures
Aggregate Functions and Nested Subqueries 2 Triggers
Modification of Database Recursive Queries and Aggregation Features
Join Expressions OLAP
Views

3. Relational Algebra
The section contains MCQs on different concepts of relational algebra. These include domain and tuple relational
calculus.

Relational Algebra Tuple Relational Calculus and Domain Relational

Calculus

4. Database Systems Design and Implementation

The section contains multiple choice questions and answers on E-R model, E-R design, constraints, atomic domains
and DDL and DML.

The Entity-Relationship Model Extended E-R Features

Constraints Querying part-1 DDL
Entity-Relationship Diagrams Querying part-2 DML
Reduction to Relational Schemas Atomic Domains
Entity-Relationship Design Issues

5. Normalization in Database Manangement System

The section contains questions and answers on different normal forms, multivalued dependencies and
decomposition algorithms, user interfaces and different application programs.
Normal Forms Multivalued Dependencies
Functional-Dependency Theory Database Design Process
Algorithms for Decomposition Application Programs and User Interfaces

6. Database Programming Techniques

The section contains MCQs on many fundamentals of web programming, JSP and servlets, application performance
and security, application encryption and architecture.

Web Fundamentals Application Performance

Servlets and JSP Application Security
Application Architectures Encryption and Its Applications
Rapid Application Development

7. Storage and File Structures in Database Management System

The section contains multiple choice questions and answers on different storage structures like physical, flash,
tertiary, data-dictionary and file structures like RAID, file record organisation and buffers.

Physical Storage Media File Organisations

Magnetic Disk and Flash Storage Organization of Records in Files
RAID Data-Dictionary Storage
Tertiary Storage Buffer

8. Indexing and Hashing

The section contains questions and answers on index definition, bitmap and ordered indices and various hashing
techniques.

Ordered Indices Bitmap Indices

Hashing Techniques Index Definition in SQL
Ordered Indexing and Hashing

9. Query Processing Techniques

The section contains MCQs on query processing and optimization techniques, selection, sort and join operations,
relational expressions and materialized views.
Query Processing Transformation of Relational Expressions
Selection Operation Estimating Statistics of Expression Results
Sorting Materialized Views
Join Operations Advanced Query Optimization
Evaluation of Expressions

10. Transactions
The section contains multiple choice questions and answers on concepts of transaction, storage structures,
properties of transaction like atomicity, durability, isolation and their implementations.

Transaction Concept Querying part 4

A Simple Transaction Model Querying part 5
Storage Structure Implementation of Isolation Levels
Transaction Atomicity and Durability Transactions as SQL Statements
Querying part 3

11. Concurrency Control

The section contains questions and answers on deadlocks, lock based protocols, granularity, types of reads like
insertion, deletion and predicate and the concept of concurrency in index structures.

Lock-Based Protocols Snapshot Isolation

Deadlocks Insertion Deletion Predicate Reads
Multiple Granularity Concurrency in Index Structures
Multiversion Schemes

12. Recovery System

The section contains MCQs on classification of failures, backup systems, buffer management and recovery and
different lock releases.

Failure Classification ARIES

Recovery Lock Release and Undo Operations
Buffer Management Remote Backup Systems
Failure with Nonvolatile Storage
If you would like to learn "Database Management System" thoroughly, you should attempt to work on the complete
set of 1000+ MCQs - multiple choice questions and answers mentioned above. It will immensely help anyone trying to
crack an exam or an interview.

Note: We are working on pdf download for Database Management System MCQs and will publish the download link
here. Fill this Database Management System mcq pdf download request form for download notification.

Wish you the best in your endeavor to learn and master Database Management System!

advertisement

Additional Resources:
Oracle Database MCQ PDF Download
MongoDB MCQ PDF Download
Energy and Environment Management MCQ PDF Download
Hazardous Waste Management MCQ PDF Download
Information Technology MCQ PDF Download

Popular Pages:
Computer Network MCQ Questions
Computer Fundamental MCQ Questions
Cloud Computing MCQ Questions
SQL Server MCQ Questions
Total Quality Management MCQ Questions
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and
CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel,
SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at
LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram

SanfoundryClasses.

About | Certifications | Internships | Jobs | Privacy Policy | Terms | Copyright | Contact

     

© 2011-2023 Sanfoundry. All Rights Reserved.