Database MCQ & Objective Questions
Understanding databases is crucial for students preparing for school and competitive exams. Mastering this topic not only enhances your conceptual clarity but also boosts your confidence in tackling exam questions. Practicing MCQs and objective questions on databases helps you identify important questions and improves your exam preparation strategy.
What You Will Practise Here
Fundamentals of Database Management Systems (DBMS)
Types of Databases: Relational, NoSQL, and more
Key Concepts: Tables, Records, and Fields
Database Normalization and its forms
SQL Queries: Basics and advanced operations
Data Models: Hierarchical, Network, and Relational
Common Database Functions and their applications
Exam Relevance
Databases are a significant part of the curriculum in CBSE, State Boards, and competitive exams like NEET and JEE. Questions often focus on definitions, concepts, and practical applications of databases. Expect to see multiple-choice questions that test your understanding of database structures, SQL commands, and normalization processes. Familiarizing yourself with these patterns will greatly enhance your performance in exams.
Common Mistakes Students Make
Confusing different types of databases and their uses
Misunderstanding normalization forms and their significance
Overlooking SQL syntax and common errors in queries
Neglecting the importance of primary and foreign keys
Failing to relate theoretical concepts to practical scenarios
FAQs
Question: What are the main types of databases I should know for exams?Answer: You should focus on relational databases, NoSQL databases, and their respective uses in different scenarios.
Question: How can I improve my SQL query skills?Answer: Regular practice of SQL queries through objective questions and hands-on exercises will enhance your skills significantly.
Now is the time to take charge of your learning! Dive into our practice MCQs on databases and test your understanding. Consistent practice will not only prepare you for exams but also solidify your grasp of essential concepts. Start solving today!
Q. In an ER model, what does a solid line connecting two entities represent?
A.
A weak relationship
B.
A strong relationship
C.
An attribute
D.
A foreign key constraint
Show solution
Solution
A solid line connecting two entities in an ER model represents a strong relationship.
Correct Answer:
B
— A strong relationship
Learn More →
Q. In an ER model, what does a solid line represent?
A.
A weak relationship
B.
A strong relationship
C.
An attribute
D.
A derived attribute
Show solution
Solution
A solid line in an ER model represents a strong relationship between entities.
Correct Answer:
B
— A strong relationship
Learn More →
Q. In an ER model, what does an entity represent?
A.
A relationship
B.
A table
C.
A column
D.
A constraint
Show solution
Solution
In an Entity-Relationship (ER) model, an entity represents a table in the database.
Correct Answer:
B
— A table
Learn More →
Q. In an ER model, what is an attribute?
A.
A relationship between entities
B.
A property or characteristic of an entity
C.
A unique identifier for an entity
D.
A type of database operation
Show solution
Solution
An attribute is a property or characteristic that describes an entity in an ER model.
Correct Answer:
B
— A property or characteristic of an entity
Learn More →
Q. In database architecture, what is the purpose of a data dictionary?
A.
To store user data
B.
To define the structure of the database
C.
To manage transactions
D.
To optimize queries
Show solution
Solution
A data dictionary defines the structure of the database, including tables, fields, and relationships.
Correct Answer:
B
— To define the structure of the database
Learn More →
Q. In database transactions, what does ACID stand for?
A.
Atomicity, Consistency, Isolation, Durability
B.
Atomicity, Concurrency, Integrity, Durability
C.
Atomicity, Consistency, Isolation, Data
D.
Atomicity, Consistency, Isolation, Dependency
Show solution
Solution
ACID stands for Atomicity, Consistency, Isolation, and Durability, which are the properties that guarantee reliable transactions.
Correct Answer:
A
— Atomicity, Consistency, Isolation, Durability
Learn More →
Q. In DBMS architecture, what does the term 'data independence' refer to?
A.
The ability to change the data structure without affecting the application
B.
The separation of data and application logic
C.
The ability to access data from multiple sources
D.
The use of multiple databases
Show solution
Solution
Data independence refers to the ability to change the data structure without affecting the application that uses the data.
Correct Answer:
A
— The ability to change the data structure without affecting the application
Learn More →
Q. In DBMS architecture, what does the term 'physical data independence' refer to?
A.
The ability to change the logical schema without changing the physical schema
B.
The ability to change the physical storage without affecting the logical schema
C.
The ability to access data from multiple sources
D.
The ability to enforce security measures
Show solution
Solution
Physical data independence refers to the ability to change the physical storage of data without affecting the logical schema.
Correct Answer:
B
— The ability to change the physical storage without affecting the logical schema
Learn More →
Q. In DBMS architecture, what is the purpose of the data abstraction layer?
A.
To manage user access
B.
To provide a user interface
C.
To separate physical storage from logical data structures
D.
To optimize query performance
Show solution
Solution
The data abstraction layer separates physical storage from logical data structures, allowing users to interact with data without needing to know how it is stored.
Correct Answer:
C
— To separate physical storage from logical data structures
Learn More →
Q. In ER modeling, what does a diamond shape represent?
A.
Entity
B.
Attribute
C.
Relationship
D.
Weak entity
Show solution
Solution
In ER modeling, a diamond shape represents a relationship between entities.
Correct Answer:
C
— Relationship
Learn More →
Q. In JDBC, which method is used to execute a SQL statement?
A.
executeQuery()
B.
runQuery()
C.
executeSQL()
D.
executeStatement()
Show solution
Solution
In JDBC, the method used to execute a SQL statement is 'executeQuery()'.
Correct Answer:
A
— executeQuery()
Learn More →
Q. In object-oriented data modeling, what is an 'object'?
A.
A collection of data and methods
B.
A single data entry in a database
C.
A type of database schema
D.
A relationship between entities
Show solution
Solution
In object-oriented data modeling, an object is a collection of data and methods that operate on that data.
Correct Answer:
A
— A collection of data and methods
Learn More →
Q. In Object-Oriented Databases, what does 'inheritance' allow?
A.
Creating new classes based on existing ones
B.
Storing data in a flat structure
C.
Using only primitive data types
D.
Eliminating the need for relationships
Show solution
Solution
Inheritance allows for creating new classes based on existing ones, promoting code reuse and organization.
Correct Answer:
A
— Creating new classes based on existing ones
Learn More →
Q. In SQL Server 2000, which command is used to create a new database?
A.
CREATE DATABASE
B.
NEW DATABASE
C.
ADD DATABASE
D.
MAKE DATABASE
Show solution
Solution
The command to create a new database in SQL Server 2000 is 'CREATE DATABASE'.
Correct Answer:
A
— CREATE DATABASE
Learn More →
Q. In SQL, which clause is used to filter records after grouping?
A.
WHERE
B.
HAVING
C.
GROUP BY
D.
ORDER BY
Show solution
Solution
The HAVING clause is used to filter records after grouping in SQL.
Correct Answer:
B
— HAVING
Learn More →
Q. In SQL, which command is used to create a new table?
A.
INSERT
B.
UPDATE
C.
CREATE
D.
ALTER
Show solution
Solution
The SQL command 'CREATE' is used to create a new table in the database.
Correct Answer:
C
— CREATE
Learn More →
Q. In SQL, which command is used to modify existing records in a table?
A.
UPDATE
B.
MODIFY
C.
CHANGE
D.
ALTER
Show solution
Solution
The SQL command used to modify existing records in a table is 'UPDATE'.
Correct Answer:
A
— UPDATE
Learn More →
Q. In the context of ASP, what does the term 'server-side scripting' refer to?
A.
Code executed on the client machine
B.
Code executed on the server before sending to the client
C.
Code that runs in the database
D.
Code that is compiled into an executable
Show solution
Solution
Server-side scripting refers to code that is executed on the server before the results are sent to the client, which is a key feature of ASP.
Correct Answer:
B
— Code executed on the server before sending to the client
Learn More →
Q. In the context of concurrency control, what does 'locking' refer to?
A.
Preventing data from being accessed by multiple users simultaneously
B.
Encrypting data for security
C.
Creating backups of the database
D.
Indexing data for faster retrieval
Show solution
Solution
Locking refers to preventing data from being accessed by multiple users simultaneously to maintain data integrity during transactions.
Correct Answer:
A
— Preventing data from being accessed by multiple users simultaneously
Learn More →
Q. In the context of data warehousing, what does ETL stand for?
A.
Extract, Transform, Load
B.
Evaluate, Test, Launch
C.
Execute, Transfer, Log
D.
Extract, Transfer, Load
Show solution
Solution
ETL stands for Extract, Transform, Load, which is the process of moving data from source systems into a data warehouse.
Correct Answer:
A
— Extract, Transform, Load
Learn More →
Q. In the context of database design, what does 'denormalization' refer to?
A.
The process of reducing redundancy
B.
The process of increasing redundancy for performance
C.
The process of normalizing data
D.
The process of creating indexes
Show solution
Solution
Denormalization refers to the process of increasing redundancy in a database to improve performance, often at the cost of data integrity.
Correct Answer:
B
— The process of increasing redundancy for performance
Learn More →
Q. In the context of DBMS architecture, what does 'three-tier architecture' refer to?
A.
Data, Application, Presentation
B.
Client, Server, Database
C.
User, Application, Database
D.
Data, Logic, User Interface
Show solution
Solution
Three-tier architecture in DBMS refers to the separation of data, application logic, and presentation layers into three distinct tiers.
Correct Answer:
A
— Data, Application, Presentation
Learn More →
Q. In the context of DBMS architecture, what does the term 'data independence' mean?
A.
Data can be accessed without a database
B.
Changes to the data structure do not affect application programs
C.
Data is stored in a single location
D.
Data can be easily replicated
Show solution
Solution
Data independence means that changes to the data structure do not require changes to application programs that access the data.
Correct Answer:
B
— Changes to the data structure do not affect application programs
Learn More →
Q. In the context of DBMS architecture, what does the term 'physical data independence' mean?
A.
Changes to the physical storage do not affect the logical schema
B.
Changes to the logical schema do not affect the physical storage
C.
Data can be accessed without knowing its physical location
D.
Data can be stored in multiple formats
Show solution
Solution
Physical data independence means that changes to the physical storage of data do not affect the logical schema of the database.
Correct Answer:
A
— Changes to the physical storage do not affect the logical schema
Learn More →
Q. In the context of DBMS architecture, what is a 'client-server' model?
A.
A model where all data is stored on the client
B.
A model where the server handles all data processing
C.
A model where clients and servers share processing tasks
D.
A model that does not use a network
Show solution
Solution
In a client-server model, clients and servers share processing tasks, with clients requesting services and servers providing them.
Correct Answer:
C
— A model where clients and servers share processing tasks
Learn More →
Q. In the context of DBMS architecture, what is a 'data model'?
A.
A way to visualize data
B.
A structure for organizing data
C.
A method for querying data
D.
A technique for data encryption
Show solution
Solution
A data model is a structure for organizing data, defining how data is connected and how it can be accessed.
Correct Answer:
B
— A structure for organizing data
Learn More →
Q. In the context of distributed databases, what does the term 'partitioning' refer to?
A.
Dividing data into smaller, manageable pieces
B.
Combining multiple databases into one
C.
Creating backups of the database
D.
Encrypting sensitive data
Show solution
Solution
Partitioning refers to dividing data into smaller, manageable pieces to improve performance and manageability in distributed databases.
Correct Answer:
A
— Dividing data into smaller, manageable pieces
Learn More →
Q. In the context of distributed databases, what is 'eventual consistency'?
A.
All nodes are always consistent
B.
Data will become consistent over time
C.
Data is never consistent
D.
Data is only consistent during transactions
Show solution
Solution
Eventual consistency means that while data may not be immediately consistent across all nodes, it will become consistent over time.
Correct Answer:
B
— Data will become consistent over time
Learn More →
Q. In the context of ER modeling, what does a 'weak entity' depend on?
A.
A primary key
B.
A strong entity
C.
A foreign key
D.
A composite key
Show solution
Solution
A weak entity depends on a strong entity for its existence and does not have a primary key of its own.
Correct Answer:
B
— A strong entity
Learn More →
Q. In the context of ER modeling, what does a 'weak entity' represent?
A.
An entity that cannot exist without a strong entity
B.
An entity with no attributes
C.
An entity that has a composite key
D.
An entity that is not related to any other entity
Show solution
Solution
A weak entity represents an entity that cannot exist without a strong entity, relying on it for its identification.
Correct Answer:
A
— An entity that cannot exist without a strong entity
Learn More →
Showing 31 to 60 of 340 (12 Pages)
