i only
ii only
Both A and B
None of the above
C. Both A and B
the logical view.
the physical view.
the external view.
all of the above.
UPDATE
DROP
ALTER
SELECT
SQL permits attribute names to be repeated in the same relation.
a SQL query automatically eliminates duplicates.
a SQL query will not work if there are no indexes on the relations
None of these
serial functions
non-serial functions
row functions
column functions
Hashed file
B-tree
Ordered file
Unordered file
top-down approach.
bottom-up approach.
left-right approach.
none of the above
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
ALOHA
ETHERNET
CSMA/CA
CSMA/CD
12 bits
16 bits
24 bits
28 bits
i and ii only
ii and iii only
i and iii only
None of these
True
False
Cant say
none
Groups
Table
Attributes
Switchboards
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).
converting data to insert in a database
translation of query to lower form
range of activities involved in extracting data from a database
none of the above
Ring
Bus
Mesh
none of these
Conceptual and view
Only physical
Physical and conceptual
Only conceptual
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
in 1NF also
in 2NF also
free from transitive dependencies
All of these
Thermal
Medium
Protocol
Impulse
500
7
3500
none of these
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
temporarily
permanently
none of these
all of the above
SQL statements are processed on tier server
SQL statements may be processed on some of the clients
Business logic is mostly processed on clients
Business logic may be processed on the server
executable statement.
declarative statement.
Ordered file
none of the above
i and ii only
ii and iii only
i and iii only
iii and iv only
primarykey
superkey
candidatekey
foreignkey
Partner
Mutual
Exclusive
Atomic
project
select
rename
none of the above
Attributes
Multi-valued attributes
Weak entity set
Relationship sets