Relational Algebra is
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
Correct Answer :
C. Procedural query Language
Related Questions
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
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.
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:
mn
m+n
m+n)/2
2 m+n)
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above
Triggers are also called
active rules
passive rules
inferences
none of the above
The transaction consists of all statements executed between
the begin transaction and end transaction
the start transaction and end transaction
the begin transaction and finish transaction
none of the above.
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
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.
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
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
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
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
Query processing is
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
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
Data rate
Bit rate
Signal to Noise Ratio
Baud rate
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
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
.................. is the loss of energy as the signal propagates outward, where the amount of energy depends on the frequency.
Noise
Delay distortion
Attenuation distortion
Dispersion
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
entity integrity rule
referential integrity constraint
composite attribute
action assertion
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
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 logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
Data integrity refers to
the uniqueness of the data in a database
the correctness and completeness of the data in a database
the un redundancies of the data in a database
Data independence of the database
Object based data models are used in describing the abstraction of the following levels?
Conceptual and view
Only physical
Physical and conceptual
Only conceptual
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these