In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
Correct Answer :
C. ellipse.
Related Questions
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
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)
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.
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
The index table has …… Columns.
1
2
3
4
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
B-Tree is used for
searching data
storing data
both A and B
none of these
Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
Noiseless channel has ……… types of protocols.
2
3
4
5
View never contains derived columns.
True
False
Cant say
none
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data.
programs are not dependent on the logical attributes of data.
both B) and C).
UML is stands for
Universal Modeling Language
Unified Modeling Language
United Modeling Language
Uni Modeling Language
Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
Which of the following file organization provides very fast access to any arbitrary record of a file?
Ordered file
Unordered file
Hashed file
B-tree
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file
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
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
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
Data stored in cursor is called ……………
record
active data set
object
none of the above
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
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
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