Relational Algebra is
Data Definition Language .
Procedural query Language
None of the above
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
The data models defined by ANSI/SPARC architecture are
The full form of GUI is _________
Isolation of the transactions is ensured by
Which of the following is true for network structure?
______is a special type of integrity constraint that relates two relations & maintains consistency across…
_____is a full form of SQL.
Union operator is a :
A _____ is used to define overall design of the database
The drawback of shadow paging technique are
Key to represent relationship between tables is called
The collection of information stored in a database at a particular moment is called as ......
What is a disjoint less constraint?
The default level of consistency in SQL is
The rule that a value of a foreign key must appear as a value of some specific table is called a
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
Which normal form is considered adequate for normal relational database design?
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
If a transaction T has obtained an exclusive lock on item Q, then T can
Which of the following statement on the view concept in SQL is invalid?
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Immediate database modification technique uses
The data in the database at a particular moment of time is called the _______
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
In E-R Diagram total participation is represented by
_____ database is used to provide statistical information or summaries of values based on various criteria.
The fact that all employees of a particular organization should not have salaries more than $10000 is…
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter