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
Quick Quiz
Sub-Queries cannot
a) Use group by
b) Relative Data
c) Join Tables
d) Appear in DML Statements
Option c – Join Tables
Insert statement is ………. command
a) Query
b) Relational
c) DML
d) DDL
Option b – Relational
Aggregate functions are those which take ………. as input and retrieve a single Value
a) Collection of values
b) Single value
c) Aggregate value
d) Both a & b
Option a – Collection of values
Which of the following are network services
a) File service
b) Print Service
c) Database Service
d) All
Option d – All
Which one of the following is used to define the structure of relation?
a) DML
b) DDL
c) Query
d) Relational Schema
Option b – DDL
Which of the following provides the ability to query information from the Database
a) DML
b) DDL
c) Query
d) Relational Schema
Option a – DML
Select * from employee; what type of statement is it
a) DML
b) DDL
c) View
d) Integrity Constraint
Option a – DML
To remove a relation from an SQL database we use ……. command.
a) Delete
b) Purge
c) Remove
d) Drop table
Option d – Drop table
Update that violate ……. are disallowed.
a) Transaction Control
b) Authorization
c) DDL Commands
d) Integrity Constraints
Option d – Integrity Constraints
Which of the following is not aggregate function?
a) avg
b) sum
c) with
d) min
Option c – with
Which is the advantage of database
a) Prevents Data redundancy
b) Restricts unauthorized access
c) Backup and recovery
d) All
Option d – All
Which is the database language
a) C
b) C++
c) SQL
d) None of these
Option c – SQL
Which person is responsible for overall activities for database
a) Database designer
b) Database analyst
c) Database Administrator (DBA)
d) Database manager
Option c – Database Administrator (DBA)
Which level of database is viewed by user
a) Internal level
b) External Level
c) Conceptual Level
d) All of these
Option b – External Level
Which is the false statement
a) A database is ordered collection of data.
b) DBMS manages the database
c) A database is systematic compilation of records.
d) Data helps in making decisions.
Option d – Data helps in making decisions.
Which is the data model
a) Relational
b) Object-Relational
c) Network
d) All of these
Option d – All of these
Which is not he feature of database
a) Data redundancy
b) Independence
c) Flexibility
d) Data Integrity
Option a – Data redundancy
Which is the type of data independence
a) Physical data independence
b) Logical data independence
c) Both
d) None
Option c – Both
Which is the feature of database
a) Query Language
b) Multi user access
c) Data Dictionary
d) All of these
Option b – Multi user access
Which is the component of database management system
a) Query Language
b) Database Manager
c) File manager
d) All of these
Option d – All of these
In ER model rectangle represents
a) Attributes
b) Entity set
c) Relationships
d) None of these
Option b – Entity set
In ER model rectangle represents
a) Attributes
b) Entity set
c) Relationships
d) None of these
Option b – Entity set
Which of the following is a fundamental operation in relational algebra?
a) Set intersection
b) Natural join
c) Assignment
d) None
Option d – None
The view of total database content is
a) Conceptual view
b) Internal view
c) External view
d) Physical view
Option a – Conceptual view
Internal level has
a) Individual Users View of the database
b) Community view of the database
c) Physical Representation of the database
d) All of these
Option c – Physical Representation of the database
Materialized views make sure that
a) View is verified for errors
b) View is updated
c) View is kept Stable
d) View is deleted after specifying the error
Option b – View is updated
The ……….. condition allows a general predicated over the relations being joined
a) On
b) Using
c) Set
d) Where
Option a – On
Which of the join operations do not preserve non-matched tuple
a) Left outer Join
b) Right outer Join
c) Inner Join
d) None
Option c – Inner Join
A …….. Consists of a sequences of query or update statements.
a) Transaction
b) Commit
c) Rollback
d) Flash back
Option a – Transaction
Which of the following makes the transaction permanent in the database
a) View
b) Commit
c) Rollback
d) Flash back
Option b – Commit
What does rollback do
a) Un-does the Transaction before commit
b) Clear all Transactions
c) Redo all the transaction before commit
d) No Action
Option d – No Action
A …….. is a special kind of stored procedure that execute in response to certain action on table
a) View
b) Trigger
c) Function
d) None
Option b – Trigger
Triggers are supported in ………
a) Delete
b) Update
c) View
d) ALL
Option c – View
The variables in the trigger are declared using ……… symbol
a) –
b) @
c) /
d) /@
Option b – @
which of the following creates a virtual relationship and stores the query
a) View
b) Procedure
c) Function
d) None
Option a – View
A …….. is used to define overall design of the database
a) Schema
b) application program
c) data definition language
d) code
Option a – Schema
A table on the many side of a one to many or many to many relationship must :
a) Be in Second Normal Form (2NF)
b) Be in Third Normal Form (3NF)
c) Have a single attribute key
d) Have a composite key
Option d – Have a composite key
Functional Dependencies are the types of constraints that are based on ………
a) Key
b) Key revisited
c) Superset key
d) None of these
Option a – Key
According to enhanced-entity relationships, association between super class and subclass is
a) Super class is subset of subclass
b) subclass is subset of super class
c) Subclass is partial joint of super class
d) super class is partial joint of subclass
Option b – subclass is subset of super class
DBMS is a collection of …….. that enables user to create and maintain a database.
a) Keys
b) Translators
c) Program
d) Language Activity
Option c – Program
In an ER model, ……… is described in the database by storing its data.
a) Entity
b) Attribute
c) Relationship
d) Notation
Option a – Entity
A top-to-bottom relationship among the items in a database is established by a
a) Hierarchical schema
b) Network schema
c) Relational Schema
d) All of the above
Option a – Hierarchical schema
……… defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
a) Instance
b) Schema
c) Program
d) Super Key
Option b – Schema
…….. is a full form of SQL.
a) Standard query language
b) Sequential query language
c) Structured query language
d) Server side query language
Option c – Structured query language
The collection of information stored in a database at a particular moment is called as……
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.
