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
Correct Answer :
B. Relational algebra is a non-procedural language
Related Questions
.................. 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
A fragmentation is categorized in
1 part
2 part
3 part
4 part
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
The language used in application programs to request data from the DBMS is referred to as the
DML
DDL
VDL
SDL
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?
first
second
third
fourth
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD
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.
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
The index table has …… Columns.
1
2
3
4
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
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
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
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
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
Which of the following is logical topology?
Bus
Ring
Star
None of these
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
none of the above
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT
What does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
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
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
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
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
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
Relational Algebra is
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
Noisy channel has ……… .. types of protocols
two
three
four
none