When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?
first
second
third
fourth
Correct Answer :
C. third
Related Questions
In E-R Diagram weak entity set are represented by
Ellipse
Dashed ellipse
Dashed Rectangle
Doubled Rectangle
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.
Noise
Delay
Dispersion
Attenuation
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
Object based data models are used in describing the abstraction of the following levels?
Conceptual and view
Only physical
Physical and conceptual
Only conceptual
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
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
Authorization command in SQL
Allow
Access
Grant
none of the above
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
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
What is the result of the following SQL statement ?
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID
A list of employees phone number
A list of all employees that have spouses, with phone number included in the list
A list of all employees names, including the phone number if they have one
Two lists : One list of employees, the other of phone numbers
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
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.
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
UML is stands for
Universal Modeling Language
Unified Modeling Language
United Modeling Language
Uni Modeling Language
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L