_____clause is an additional filter that is applied to the result.
Select
Order by
Group-by
Having
Correct Answer :
D. Having
Related Questions
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
SQL server Profile
SQL server wizard.
SQL server service manager
SQL server setup
Relational Algebra is
Data Definition Language .
Meta Language
Procedural query Language
None of the above
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______
Volatile
Non - Volatile
Logical
Physical
The clause alter table in SQL can be used to
add an attribute
delete an attribute
alter the default values of an attribute
all of the above
In an E-R diagram double lines indicate
Total participation.
Multiple participation.
Cardinality N.
None of the above.
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;
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
2NF
3NF
BCNF
1NF
A transaction is in state after the final statement has been executed.
partially committed
active
committed
none of the above
In 2NF
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
Functional dependency
Multi-valued dependency
Transitive dependency
Partial dependency
A data type or format is specified for each _________
Relation
Tuple
Database
Domain
Which of the following is not comparison operator?
<>
<
=<
>=
Tree structures are used to store data in
Network model.
Relational model.
Hierarchical model.
File based system.
The graphical representation of a query is .
B-Tree
graph
Query Tree
directed graph
Checkpoints are a part of
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
DROP is a statement in SQL.
Query
Embedded SQL
DDL
DCL
SQL server stores index information in the _____system table
system indexes
syst indexes
sys indexes
sysind
The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is
Procedural DML.
Non-Procedural DML.
Procedural DDL.
Non-Procedural DDL.
The _______ is a set of programs to use and / or modify this data.
DBMS
System
Program
Software
____specifies a search condition for a group or an aggregate.
GROUP BY Clause
HAVING Clause
FROM Clause
WHERE Clause
It is an abstraction through which relationships are treated as higher level entities
Generalization.
Specialization.
Aggregation.
Inheritance.
_____ database is used to provide statistical information or summaries of values based on various criteria.
Statistical
Mathematical
Normalized
Un normalized
_____ command can be used to modify a column in a table
alter
update
set
create
The cost of reading and writing temporary files while evaluating a query can be reduced by
building indices
pipelining
join ordering
none of the above
The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.
Schema
Tuple
Domain
Relational
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.
For using a specific database …………… command is used.
use database
database name use
Both A & B
None of them
Shadow paging has
no redo
no undo
redo but no undo
neither redo nor undo
If a transaction T has obtained an exclusive lock on item Q, then T can
read Q
write Q
both read and write Q
write Q but not read Q
According to the levels of abstraction, the schema at the intermediate level is called
Logical schema.
Physical schema.
Subschema.
None of the above.