In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
Correct Answer :
A. as
Related Questions
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
Authorization command in SQL
Allow
Access
Grant
none of the above
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
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
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
A relation which is in 3NF is
in 1NF also
in 2NF also
free from transitive dependencies
All of these
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
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.
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
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.
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.
Noise
Delay distortion
Attenuation distortion
Dispersion
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
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
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 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)
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
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
Triggers are also called
active rules
passive rules
inferences
none of the above
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
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these