Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
Correct Answer :
C. Online Analytical Processing
Related Questions
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
The language used in application programs to request data from the DBMS is referred to as the
DML
DDL
VDL
SDL
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
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
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
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
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.
i only
ii, only
ii, iii only
none of the above
EEPROM
Electrically Extractable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
Electronically Erasable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
Which of the following is true statement ?
SQL permits attribute names to be repeated in the same relation.
a SQL query automatically eliminates duplicates.
a SQL query will not work if there are no indexes on the relations
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
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
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
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
Which of the following statements is not true about two tier client server database architecture?
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
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above