The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
Correct Answer :
B. CSMA/CD
Related Questions
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
Which of the following is logical topology?
Bus
Ring
Star
None of these
Volatile storage
loses its contents when power is switched off.
doesnt loses its contents when power is switched off.
creates backup when power is switched off.
none
The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
Authorization command in SQL
Allow
Access
Grant
none of the above
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
none of the above
A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.
only i)
only i) and ii)
only ii) and iii)
i) ii) iii)
B-Tree is used for
searching data
storing data
both A and B
none of these
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :
B-Tree File
Hashed File
Indexed File
Sequential file.
Data Manipulation Language DML) is not to
Create information table in the Database
Insertion of new information into the Database
Deletion of information in the Database
Modification of information in the Database
In two-phase locking
the data items are locked in growing phase.
the data items are released in shrinking phase.
Both A and B are true
Both A and B are false
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
Select the incorrect statement
View is derived from other tables.
Once a transaction has executed commit work its effect cant be undone by rollback work .
The input to the aggregate function avg can be non numeric data types
A primary key can never be null.
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.
The attribute that can be divided into other attributes is called
Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
Symbol to represent weak entity set in ER Model
Dotted rectangle
Square
Doubly outlined rectangle
Diamond
Relational Algebra is
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
none of the above
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity