Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
Correct Answer :
C. DBMS ,different site
Related Questions
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
Which of the following is logical topology?
Bus
Ring
Star
None of these
What does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
none of the above
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
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
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
The language used in application programs to request data from the DBMS is referred to as the
DML
DDL
VDL
SDL
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
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)
Which of the following statements is not true about two tier client server database architecture?
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
Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
i and ii only
ii and iii only
ii only
i only
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
UML is stands for
Universal Modeling Language
Unified Modeling Language
United Modeling Language
Uni Modeling Language
In mesh topology, if the number of devices is n , then the number of ports present in each device is
n
n+1
n-1
n/2
Referential integrity
controls relationships between operations of an object
controls relationships between instances of a class
controls relationships between attributes in a table
controls relationships between tables in a database
If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.
Noise
Delay
Dispersion
Attenuation
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
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above