Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
A. Redundant Arrays of Independent Disks
procedural query language
nonprocedural query language
scan(), write()
none of the above
12 bits
16 bits
24 bits
28 bits
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
i and ii only
ii and iii only
i and iii only
iii and iv only
2
3
4
5
mn
m+n
m+n)/2
2 m+n)
physical level.
logical level.
conceptual level
view level.
300MHz
1GHz
5GHz
10 GHz
parallel
serial
analog
digital
Min
Max
Select
Avg
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
Baseband transmission
Broadband transmission
Digital transmission
Analog transmission
Data rate
Bit rate
Signal to Noise Ratio
Baud rate
entity integrity rule
referential integrity constraint
composite attribute
action assertion
first
second
third
fourth
Gray
White
Blue
Black
executable statement.
declarative statement.
Ordered file
none of the above
Cardinality
Degree
Tuple
Order
in the left relation which didnt match with any tuple in right relation
in the left relation which matched with a tuple in right relation
in the right relation which didnt match with any tuple in left relation
in the right relation which matched with a tuple in left relation
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
insert
modify
lookup
none of the above
Data
Data field
DBMS
DBASE
1 Gbps
56 Mbps
100 Mbps
256 Mbps
i and ii only
ii and iii only
i and iii only
All i, ii iii
BCNF
Second
Third
Fourth
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
view
trigger
cursor
none of the above
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only