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 is the best file organization when data is frequently added or deleted from a file?
The part of a database management system which ensures that the data remains in a consistent state is
Relations produced from an E-R model will always be
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
The rule that a value of a foreign key must appear as a value of some specific table is called a
Data items grouped together for storage purposes are called a
If a transaction T has obtained an exclusive lock on item Q, then T can
Which one is correct statement?Logical data independence provides following without changing application…
____specifies a search condition for a group or an aggregate.
Which of the following addressing modes permits relocation without any change over in the code?
operator is used to compare a value to a list of literals values that have been specified.
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
The keyword to eliminate duplicate rows from the query result in SQL is
In multiple granularity of locks SIX lock is compatible with
An advantage of the database management approach is
Which of the following is not a property of transactions?
An outstanding functionality of SQL is its support for automatic_____ to the target data.
DBMS is a collection of _____ that enables user to create and maintain a database.
The one guideline to be followed while designing the database is
Relational Algebra does not have
Maximum height of a B+ tree of order m with n key values is
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
A relational database developer refers to a record as
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
______is a preferred method for enforcing data integrity
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
_____ database is used to provide statistical information or summaries of values based on various criteria.
Isolation of the transactions is ensured by
Which normal form is considered adequate for normal relational database design?
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter