In E-R Diagram weak entity set are represented by
Ellipse
Dashed ellipse
Dashed Rectangle
Doubled Rectangle
Correct Answer :
D. Doubled Rectangle
Related Questions
The index table has …… Columns.
1
2
3
4
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
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.
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
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
Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions
i only
ii only
Both A and B
None of the above
Data stored in cursor is called ……………
record
active data set
object
none of the above
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to
View
Cursor defination
Referential intergrity
Trigger
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
Radio frequencies below ............. are more suitable for omnidirectional applications.
300MHz
1GHz
5GHz
10 GHz
The attribute that can be divided into other attributes is called
Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
none of these
Which of the following will NOT eliminates the ambiguities of a null value?
Define the attribute as required
Define subtypes
Define each attribute as having an initial value that is recognized as blank
Define supertypes
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
A composite attribute is converted to individual attributes in which of the following normal form ?
first
Second
third
fourth
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.
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
The language used in application programs to request data from the DBMS is referred to as the
DML
DDL
VDL
SDL
Triggers are also called
active rules
passive rules
inferences
none of the above
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD