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
Correct Answer :
A. BCNF
Related Questions
What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
View never contains derived columns.
True
False
Cant say
none
UML is stands for
Universal Modeling Language
Unified Modeling Language
United Modeling Language
Uni Modeling Language
Which of the following is true statement ?
SQL permits attribute names to be repeated in the same relation.
a SQL query automatically eliminates duplicates.
a SQL query will not work if there are no indexes on the relations
None of these
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
A DBMS query language is designed to
support end users who use English-like commands.
support in the development of complex applications software.
specify the structure of a database.
all of the above.
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.
Noise
Delay distortion
Attenuation distortion
Dispersion
The ability to modify the conceptual schema without causing any change to the application program is known as
Physical data independence
Logical data independence
External data independence
Static data
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
The attribute that can be divided into other attributes is called
Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
Which of the following is logical topology?
Bus
Ring
Star
None of these
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.
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
.................. is the loss of energy as the signal propagates outward, where the amount of energy depends on the frequency.
Noise
Delay distortion
Attenuation distortion
Dispersion
State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable
i and ii only
ii and iii only
i and iii only
None of these
Event condition action model is related to
Views
Cursors
Triggers
None of these.
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
Query processing is
converting data to insert in a database
translation of query to lower form
range of activities involved in extracting data from a database
none of the above
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
Data integrity refers to
the uniqueness of the data in a database
the correctness and completeness of the data in a database
the un redundancies of the data in a database
Data independence of the database
As a side-effect of database update ,the system automatically executes a statement called
a view
a grant permission
a trigger
all of the above
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
none of the above
Referential integrity
controls relationships between operations of an object
controls relationships between instances of a class
controls relationships between attributes in a table
controls relationships between tables in a database