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.
Correct Answer :
B. weak entity set.
Related Questions
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
none of these
File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file
The privilege lists include
i) select
ii) insert
iii) update
iv) delete
only i)
only i) ii)
only i) ii) iii)
i) ii) iii) iv)
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
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
Transaction processing is associated with everything below except
producing detail, summary, or exception reports.
recording a business activity.
confirming an action or triggering a response.
maintaining data.
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.
Count function in SQL returns the number of
values.
distinct values.
groups.
columns.
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
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
A composite attribute is converted to individual attributes in which of the following normal form ?
first
Second
third
fourth
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
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.
Authorization command in SQL
Allow
Access
Grant
none of the above
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
The index table has …… Columns.
1
2
3
4
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
Data rate
Bit rate
Signal to Noise Ratio
Baud rate
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
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
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
Noiseless channel has ……… types of protocols.
2
3
4
5
Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.