Quick Quiz
Questions ▼
DBMS MCQ for Competitive Exams. We covered all the DBMS MCQ for Competitive Exams in this post for free so that you can practice well for the exam.
Install our MCQTUBE Android app from the Google Play Store and prepare for any competitive government exams for free.
We also covered some other topics of MCQ like general knowledge on our website for free.
You will get their respective links in the related posts section provided below.
Related Posts:
- DBMS mcq in Hindi normalization competitive exams pdf interview questions
- General Knowledge MCQ for Competitive Exams with Answers
- 50 GK Question in English with Answers
DBMS MCQ for Competitive Exams
Sub-Queries are not allowed to
a) Use group by
b) Handle related data
c) Perform table joins
d) Be part of DML commands
Option c – Perform table joins
The Insert statement is classified as a
a) Query
b) Relational command
c) DML command
d) DDL command
Option b – Relational command
Aggregate functions work by taking
a) A collection of values
b) A single value
c) An aggregate value
d) Both a and b
Option a – A collection of values
Which of the following are considered network services?
a) File service
b) Print service
c) Database service
d) All of these
Option d – All of these
Which command type is used to set the structure of a table?
a) DML
b) DDL
c) Query
d) Relational Schema
Option b – DDL
Which option allows information retrieval from a database?
a) DML
b) DDL
c) Query
d) Relational Schema
Option a – DML
The command “Select * from employee;” is an example of
a) DML
b) DDL
c) View
d) Integrity Constraint
Option a – DML
Which command is used to delete a table from the database?
a) Delete
b) Purge
c) Remove
d) Drop table
Option d – Drop table
Updates that go against ……. are not permitted.
a) Transaction controls
b) Authorization rules
c) DDL commands
d) Integrity constraints
Option d – Integrity constraints
Which one is not an aggregate function?
a) avg
b) sum
c) with
d) min
Option c – with
What is a key benefit of using databases?
a) Minimizes data duplication
b) Controls unauthorized access
c) Supports backup and recovery
d) All of these
Option d – All of these
Which of these is a database language?
a) C
b) C++
c) SQL
d) None of these
Option c – SQL
Who manages the overall operation of a database system?
a) Database designer
b) Database analyst
c) Database Administrator (DBA)
d) Database manager
Option c – Database Administrator (DBA)
Which database level is visible to the user?
a) Internal level
b) External level
c) Conceptual level
d) All of these
Option b – External level
Identify the incorrect statement.
a) A database is an organized data collection.
b) DBMS handles database management.
c) A database is a structured record system.
d) Data itself helps in decision-making.
Option d – Data itself helps in decision-making.
Which of the following is a type of data model?
a) Relational
b) Object-Relational
c) Network
d) All of these
Option d – All of these
Which is not a feature of a database system?
a) Data redundancy
b) Data independence
c) Flexibility
d) Data integrity
Option a – Data redundancy
What types of data independence exist?
a) Physical data independence
b) Logical data independence
c) Both types
d) None
Option c – Both types
Which of the following is a feature of databases?
a) Query language support
b) Multiple user access
c) Data dictionary
d) All of these
Option b – Multiple user access
Which of these is part of a database management system?
a) Query language
b) Database manager
c) File manager
d) All of these
Option d – All of these
In an ER diagram, a rectangle symbolizes
a) Attributes
b) Entity set
c) Relationships
d) None of these
Option b – Entity set
In an ER diagram, what does a rectangle signify?
a) Attributes
b) Entity set
c) Relationships
d) None of these
Option b – Entity set
Which of the following is considered a basic operation in relational algebra?
a) Set intersection
b) Natural join
c) Assignment
d) None
Option d – None
The complete view of all data within a database is known as
a) Conceptual view
b) Internal view
c) External view
d) Physical view
Option a – Conceptual view
The internal level of a database describes
a) Individual user’s view
b) Community’s overall view
c) Physical storage structure
d) All of these
Option c – Physical storage structure
Materialized views ensure that
a) The view is checked for mistakes
b) The view stays up-to-date
c) The view remains unchanged
d) The view is deleted if errors are found
Option b – The view stays up-to-date
The ……. condition enables a general expression across the joined tables.
a) On
b) Using
c) Set
d) Where
Option a – On
Which join type does not retain unmatched rows?
a) Left outer join
b) Right outer join
c) Inner join
d) None
Option c – Inner join
A ……. is a sequence of queries or updates executed as a unit.
a) Transaction
b) Commit
c) Rollback
d) Flash back
Option a – Transaction
Which operation makes a transaction permanent in the database?
a) View
b) Commit
c) Rollback
d) Flash back
Option b – Commit
What is the function of rollback?
a) Cancels changes made by the transaction before commit
b) Deletes all transactions
c) Reapplies transactions done before commit
d) No action
Option d – No action
A ……. is a special stored procedure that runs automatically when a specific table event occurs.
a) View
b) Trigger
c) Function
d) None
Option b – Trigger
Triggers can be applied to
a) Delete
b) Update
c) View
d) All
Option c – View
In a trigger, variables are defined using the ……. symbol.
a) –
b) @
c) /
d) /@
Option b – @
Which option builds a virtual table and keeps the query?
a) View
b) Procedure
c) Function
d) None
Option a – View
A ……. represents the overall structure of the database.
a) Schema
b) Application program
c) Data definition language
d) Code
Option a – Schema
In a one-to-many or many-to-many relationship, the table on the ‘many’ side must
a) Meet Second Normal Form (2NF)
b) Meet Third Normal Form (3NF)
c) Use a single attribute key
d) Have a composite key
Option d – Have a composite key
Functional dependencies are constraints that rely on a
a) Key
b) Key revisited
c) Superset key
d) None of these
Option a – Key
In an extended ER model, the link between a superclass and subclass is such that
a) Superclass is part of subclass
b) Subclass is part of superclass
c) Subclass is partially joined with superclass
d) Superclass is partially joined with subclass
Option b – Subclass is part of superclass
DBMS is a set of ……. that allows users to build and manage databases.
a) Keys
b) Translators
c) Programs
d) Language activities
Option c – Programs
In an ER model, ……. is recorded in the database by storing relevant data.
a) Entity
b) Attribute
c) Relationship
d) Notation
Option a – Entity
A top-down relationship among database elements is created by a
a) Hierarchical schema
b) Network schema
c) Relational schema
d) All of the above
Option a – Hierarchical schema
……. describes the structure of a relation with a specific set of attribute-domain combinations.
a) Instance
b) Schema
c) Program
d) Super key
Option b – Schema
The full form of SQL is
a) Standard query language
b) Sequential query language
c) Structured query language
d) Server-side query language
Option c – Structured query language
The specific data held in a database at a given time is called
a) Schema
b) Instance of the database
c) Data domain
d) Independence
Option b – Instance of the database
We covered all the DBMS MCQ for competitive exams above in this post for free so that you can practice well for the exam.
Check out the latest MCQ content by visiting our mcqtube website homepage.
Also, check out:
