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.
Which of the following statement on the view concept in SQL is invalid?
Relations produced from an E-R model will always be
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
The values of the attribute describes a particular
Grant and revoke are _____ statements.
Key to represent relationship between tables is called
______is a preferred method for enforcing data integrity
Which of the following is not a consequence of concurrent operations?
In E-R Diagram total participation is represented by
_____ command can be used to modify a column in a table
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
DBMS helps achieve
Which of the following constitutes a basic set of operations for manipulating relational data?
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
The drawback of shadow paging technique are
Which of the following is not a recovery technique?
The collection of information stored in a database at a particular moment is called as ......
The cost of reading and writing temporary files while evaluating a query can be reduced by
Dependency preservation is not guaranteed in
_____ First proposed the process of normalization.
The rule that a value of a foreign key must appear as a value of some specific table is called a
operator is used to compare a value to a list of literals values that have been specified.
As per equivalence rules for query transformation, selection operation distributes over
HSAM stands for .
A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
Which one is correct statement?Logical data independence provides following without changing application…
Checkpoints are a part of
In a relational schema, each tuple is divided into fields called
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter