DBMS is a software used to store, manage, retrieve and define data in a database. It acts as an interface between the user and the database. There are many commands in this, by which the user can easily work in the database.
In this post, we have listed some important Database management system (DBMS) question answers in one line format. These DBMS questions collected from previous competative exams and very much helpful for those, who is doing prepration for exams like HTET, CTET, KVS, NVS, DSSSB, REET, UPTET and other state staff selection exams.
|
Q 1.
Which DBMS supports full-fledged client server application development ?
Ans.
Oracle 7.1
|
|
Q 2.
In an object-oriented model, one object can access data of another object by passing ?
Ans.
Message
|
|
Q 3.
What is the example of network database ?
Ans.
IDMS
|
|
Q 4.
Data about data is normally termed as ?
Ans.
Meta data
|
|
Q 5.
______ data type can store unstructured data ?
Ans.
Raw
|
|
Q 6.
In E-R diagram generalisation is represented by ?
Ans.
Triangle
|
|
Q 7.
_______ function devides one numeric expression by another and returns the remainder ?
Ans.
MOD
|
|
Q 8.
The _____ operator is used to compare a value to list of literals values that have been specified ?
Ans.
IN
|
|
Q 9.
To delete a particular column in a relation the command used is ?
Ans.
Alter
|
|
Q 10.
In E-R diagram relationship type is represented by ?
Ans.
Diamond
|
|
Q 11.
The natural join is called ?
Ans.
Combination of projection and cartesian product
|
|
Q 12.
An instance of relational schema R (A, B, C) has distinct value of A, including NULL values, then what is A ?
Ans.
A is not a candidate key
|
|
Q 13.
in E-R diagram derived attribute is represented by ?
Ans.
Dashed ellipse
|
|
Q 14.
A primary key is combined with a foreign key creates ?
Ans.
Parent child relationship between the tables that connect them.
|
|
Q 15.
The physical location of a record is determined by a mathematical formula that transform a file key into a record location is called ?
Ans.
Hashed file
|
|
Q 16.
Which is record based logical model ?
Ans.
Network Model
|
|
Q 17.
What is the another name of Weak Entity ?
Ans.
Child
|
|
Q 18.
Which operation constitute a basic set of operations for manipulating relational data ?
Ans.
Relational algebra
|
|
Q 19.
A set of possible data values is called ?
Ans.
Domain
|
|
Q 20.
Which comparison operator are used in SQL ?
Ans.
=, Like and Between
|
|
Q 21.
Which are two ways in which entities can participate in a relationship ?
Ans.
Total and partial
|
|
Q 22.
Which database is closest to the users ?
Ans.
External database
|
|
Q 23.
The users who use the easy to use menu are called ?
Ans.
Naive users
|
|
Q 24.
Which operations need the participating relations to be a union compatible ?
Ans.
Union, Intersection and Difference
|
|
Q 25.
The RDBMS terminology for a row is called ?
Ans.
Tuple
|
|
Q 26.
Which operation is used if we are interested in only certain columns of a table ?
Ans.
Projection
|
|
Q 27.
What relationship called when it is maintained between entities ?
Ans.
Binary
|
|
Q 28.
It is better to use files then a DBMS when there are ?
Ans.
Multiple users which to access the data ?
|
|
Q 29.
Properties of entities are called ?
Ans.
Attributes
|
|
Q 30.
The file organisation that provides very fast access to any arbitary record of a file is called ?
Ans.
Hashed file
|