____specifies a search condition for a group or an aggregate.
GROUP BY Clause
HAVING Clause
FROM Clause
WHERE Clause
Correct Answer :
B. HAVING Clause
Related Questions
Which of the following is true for network structure?
It is a physical representation of the data.
It allows many to many relationship.
It is conceptually simple.
It will be the dominant database of the future.
Which of the following is not a consequence of concurrent operations?
Lost update problem.
Update anomaly.
Unrepeatable read.
Dirty read.
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
Functional dependency
Multi-valued dependency
Transitive dependency
Partial dependency
Which of the following is a reason to model data?
Understand each user's perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above
Relationships among relationships can be represented in an-E-R model using
Aggregation
Association
Weak entity sets
Weak relationship sets
Manager salary details are hidden from the employee .This is
Conceptual level data hiding.
External level data hiding.
Physical level data hiding.
None of these.
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
It will result in a deadlock situation.
It will immediately be rejected.
It will immediately be granted.
It will be granted as soon as it is released by A .
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX
What are the desirable properties of a decomposition
Partition constraint.
Dependency preservation.
Redundancy.
Security.
Relations produced from an E-R model will always be
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
____specifies a search condition for a group or an aggregate.
GROUP BY Clause
HAVING Clause
FROM Clause
WHERE Clause
In SQL the statement select * from R, S is equivalent to
Select * from R natural join S.
Select * from R cross join S.
Select * from R union join S.
Select * from R inner join S.
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :
Operationally, if Y is deleted, so is X
existence is dependent on Y.
Operationally, if X is deleted, so is Y.
Operationally, if X is deleted, & remains the same.
………………… approach reduces time and effort required for design and lesser risk in database management.
Single global database
Multiple databases
Top-down approach
None of the above
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
Star
llustar
SQL
Cygnus
Immediate database modification technique uses
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
Change Staff table by removing default of Assistant for position column
ALTER TABLE Staff ALTER position DROP DEFAULT;
ALTER TABLE Staff ALTER position DEFAULT;
ALTER TABLE Staff ALTER DROP DEFAULT;
MODIFY Staff ALTER position DROP DEFAULT;
Tree structures are used to store data in
Network model.
Relational model.
Hierarchical model.
File based system.
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows
4,0
0,0
4,5
8,5
The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is
View
Order by
Group by
Having
The part of a database management system which ensures that the data remains in a consistent state is
authorization and integrity manager
buffer manager
transaction manager
file manager
It is an abstraction through which relationships are treated as higher level entities
Generalization.
Specialization.
Aggregation.
Inheritance.
A top-to-bottom relationship among the items in a database is established by a
Hierarchical schema
Network schema
Relational Schema
All of the above
A _____ is used to define overall design of the database
code
data definition language
application program
schema
Dependency preservation is not guaranteed in
BCNF
3NF
PJNF
DKNF
In SQL the word natural can be used with
inner join
full outer join
right outer join
all of the above
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
Oval; An oval with an underlined attribute
Circle; A circle with bolded attribute inside it
Diamond; A bolded attribute
Square; An attribute within the square
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data
programs are not dependent on the logical attributes of data
both B and C
In E-R Diagram total participation is represented by
Double lines
Single line
Dashed lines
Triangle