Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
Correct Answer :
A. 4 NF
Related Questions
In this data model each record can hae more than one parent
Hierarchical model
E-R model
Network based model
none of these
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:
mn
m+n
m+n)/2
2 m+n)
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT
The left outer join takes all tuples
in the left relation which didnt match with any tuple in right relation
in the left relation which matched with a tuple in right relation
in the right relation which didnt match with any tuple in left relation
in the right relation which matched with a tuple in left relation
The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity
B-Tree is used for
searching data
storing data
both A and B
none of these
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
Which of the following file organization provides very fast access to any arbitrary record of a file?
Ordered file
Unordered file
Hashed file
B-tree
Noisy channel has ……… .. types of protocols
two
three
four
none
A composite attribute is converted to individual attributes in which of the following normal form ?
first
Second
third
fourth
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
A logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?
BCNF
Second
Third
Fourth
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
Volatile storage
loses its contents when power is switched off.
doesnt loses its contents when power is switched off.
creates backup when power is switched off.
none
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :
B-Tree File
Hashed File
Indexed File
Sequential file.
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
entity integrity rule
referential integrity constraint
composite attribute
action assertion
In two-phase locking protocol the two phases are
growing phase and shrinking phase
execution phase and blocking phase.
running phase and sleeping phase.
none of the above
Which of the following is not an Aggregate function?
Min
Max
Select
Avg