A relation is said to be in ………. If it doesnt contain partial dependency
1NF
2NF
3NF
BCNF
Correct Answer :
B. 2NF
Related Questions
FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
i and ii only
ii and iii only
i and iii only
iii and iv only
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
The raw facts and figures are:
Data
Data field
DBMS
DBASE
.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.
Baseband transmission
Broadband transmission
Digital transmission
Analog transmission
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
EEPROM
Electrically Extractable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
Electronically Erasable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
The index table has …… Columns.
1
2
3
4
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
In two-phase locking
the data items are locked in growing phase.
the data items are released in shrinking phase.
Both A and B are true
Both A and B are false
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
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
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
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
Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.
i only
ii, only
ii, iii only
none of the above
.................. 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
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
The attribute that can be divided into other attributes is called
Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute
Object based data models are used in describing the abstraction of the following levels?
Conceptual and view
Only physical
Physical and conceptual
Only conceptual
An entity set that does not have sufficient attributes to form a primary key is a
strong entity set.
weak entity set.
simple entity set.
primary entity set.
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.
i ,iii only
ii, iv only
iii, iv only
ii, iii, iv
A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.
only i)
only i) and ii)
only ii) and iii)
i) ii) iii)