Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
Correct Answer :
D. none of the above
Related Questions
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
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
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD
A logical schema
is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both A) and C)
which of the following is a binary operation?
project
select
rename
none of the above
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol
i, ii only
ii and iv only
ii and iv only
i, iv only
A type of query that is placed within a WHERE or HAVING clause of another query is called
Super query
Sub query
Master query
Multi-query
A lock that allows concurrent transactions to access different rows of the same table is known as a
Field-level lock
Row-level lock
Table-level lock
Database-level lock
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
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.
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)
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
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
Data Manipulation Language DML) is not to
Create information table in the Database
Insertion of new information into the Database
Deletion of information in the Database
Modification of information in the Database
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
In this data model each record can hae more than one parent
Hierarchical model
E-R model
Network based model
none of these
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
Which one of the following statements is false?
The data dictionary is normally maintained by the database administrator.
Data elements in the database can be modified by changing the data dictionary.
The data dictionary contains the name and description of each data element.
The data dictionary is a tool used exclusively by the database administrator.
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
Radio frequencies below ............. are more suitable for omnidirectional applications.
300MHz
1GHz
5GHz
10 GHz
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
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