Data items grouped together for storage purposes are called a
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
A _____ is used to define overall design of the database
Which of the following is not a recovery technique?
In b-tree the number of keys in each node is than the number of its children.
Which of the following ensures the atomicity of the transaction?
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
A transaction is in state after the final statement has been executed.
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
The fact that all employees of a particular organization should not have salaries more than $10000 is…
A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
In an ER model,_____ is described in the database by storing its data.
What is a disjoint less constraint?
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
______contains information that defines valid values that are stored in a column or data type.
As per equivalence rules for query transformation, selection operation distributes over
The graphical representation of a query is .
operator is used to compare a value to a list of literals values that have been specified.
According to the levels of abstraction, the schema at the intermediate level is called
A top-to-bottom relationship among the items in a database is established by a
Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
What are the desirable properties of a decomposition
DBMS is a collection of _____ that enables user to create and maintain a database.
Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
If a transaction T has obtained an exclusive lock on item Q, then T can
The part of a database management system which ensures that the data remains in a consistent state is
_____ database is used to provide statistical information or summaries of values based on various criteria.
The data in the database at a particular moment of time is called the _______
Drop Table cannot be used to drop a table referenced by a ______ constraint.
Union operator is a :
Relationships among relationships can be represented in an-E-R model using
A table can have only one
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter