In an E-R diagram double lines indicate
Total participation.
Multiple participation.
Cardinality N.
None of the above.
Correct Answer :
A. Total participation.
Related Questions
If an entity can belong to only one lower level entity then the constraint is
disjoint
partial
overlapping
single
Relational Algebra does not have
Selection operator.
Projection operator.
Aggregation operators.
Division operator.
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.
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
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 .
Union operator is a :
Unary Operator
Ternary Operator
Binary Operator
Not an operator
The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E.
Regular
Irregular
None
Weak
E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R
Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C
(i) and (ii)
(iv) only
(i) and (iv)
(ii) and (iii)
_____ First proposed the process of normalization.
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are
m+n and 0
m+n and |m-n|
mn and 0
mn and m+n
The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
Similarity
Granularity
Dimensionality
Arity
Which of the following is not a consequence of concurrent operations?
Lost update problem.
Update anomaly.
Unrepeatable read.
Dirty read.
An outstanding functionality of SQL is its support for automatic_____ to the target data.
programming
navigation
functioning
notification
The normal form that is not necessarily dependency preserving is
2NF
3NF
BCNF
4NF
Cascading rollback is avoided in all protocol except
strict two-phase locking protocol.
tree locking protocol
two-phase locking protocol
validation based protocol.
The graphical representation of a query is .
B-Tree
graph
Query Tree
directed graph
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 set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces a result of degree
m - 1
m + 1
m * m
m
The default level of consistency in SQL is
repeatable read
read committed
read uncommitted
serializable
Which of the following addressing modes permits relocation without any change over in the code?
Indirect addressing
Indexed addressing
PC relative addressing
Base register addressing
Tree structures are used to store data in
Network model.
Relational model.
Hierarchical model.
File based system.
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
Star
llustar
SQL
Cygnus
____ table store information about database or about the system.
SQL
System
Nested
None of these
Maximum height of a B+ tree of order m with n key values is
Logm(n)
(m+n)/2
Logm/2(m+n)
None of these
In 2NF
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
Create table Employee(EMPNO int, EMPNAME char(10));
Create table Employee(EMPNO integer, EMPNAME String(10));
Create table Emplo(EMPNO number, EMPNAME string);
Create table Emp(EMPNO int, EMPNAME char(10));
Which of the following is not comparison operator?
<>
<
=<
>=
_____ database is used to provide statistical information or summaries of values based on various criteria.
Statistical
Mathematical
Normalized
Un normalized