Generalization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
Correct Answer :
B. bottom-up approach.
Related Questions
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?
BCNF
Second
Third
Fourth
A functional dependency between two or more non-key attributes is called
Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
A logical schema
is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both A) and C)
Radio frequencies below ............. are more suitable for omnidirectional applications.
300MHz
1GHz
5GHz
10 GHz
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
Generalization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
Data stored in cursor is called ……………
record
active data set
object
none of the above
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
The index table has …… Columns.
1
2
3
4
A transaction is said to have terminated if it has
either committed or aborted
either partially committed or aborted
either committed or failed
none of these
Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .
i and ii only
ii and iii only
i and iii only
i only
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
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
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
The attribute that can be divided into other attributes is called
Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute
A type of query that is placed within a WHERE or HAVING clause of another query is called
Super query
Sub query
Master query
Multi-query
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
A relation which is in 3NF is
in 1NF also
in 2NF also
free from transitive dependencies
All 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
Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.
i and ii only
ii and iii only
i and iii only
i only
The race condition occurs when
Two concurrent processes attempt to interact with each other.
Two concurrent processes interact with different data files.
Two concurrent processes attempt to hold a data item .
none of the above.
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.