Which of the following aggregate functions does not ignore nulls in its results?.
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
Manager salary details are hidden from the employee .This is
For correct behaviour during recovery, undo and redo operation must be
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
The graphical representation of a query is .
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
The keyword to eliminate duplicate rows from the query result in SQL is
_____ First proposed the process of normalization.
Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
Processed data is called _____
In b-tree the number of keys in each node is than the number of its children.
Which of the following relational algebraic operations is not from set theory?
An outstanding functionality of SQL is its support for automatic_____ to the target data.
Which of the following ensures the atomicity of the transaction?
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
The values of the attribute describes a particular
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
Wait-for graph is used for
The language that requires a user to specify the data to be retrieved without specifying exactly how…
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
The _____ category includes storage media that can be operated on directly by the computers central…
approach reduces time and effort required for design and lesser risk in database management.
______is a special type of integrity constraint that relates two relations & maintains consistency across…
Shadow paging has
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
Which of the following addressing modes permits relocation without any change over in the code?
The set of all values that can be taken by the attribute is called as _______ of the attribute.
Which of the following is not a consequence of concurrent operations?
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter