In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
Correct Answer :
D. Triangle
Related Questions
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
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
Primary storage
magnetic disk
magnetic tape
juke box
cache
Which of the following is not proper state of transaction ?
Partially aborted
Partially committed
Aborted
Committed
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
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
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
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
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 operation that will increase the length of a list is
insert
modify
lookup
none of the above
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)
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.
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
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
QBE
Query By Execution
Query By Example
Query By Extraction
None of the above.
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
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
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable
i and ii only
ii and iii only
i and iii only
None of these
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.
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these