A logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
Correct Answer :
B. User View
Related Questions
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
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
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
Which of the following concurrency control schemes is not based on serializability property?
Two-phase locking
Timestamped based locking
Graph-based locking
none of the above
Noiseless channel has ……… types of protocols.
2
3
4
5
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
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
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.
Baseband transmission
Broadband transmission
Digital transmission
Analog transmission
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
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
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
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
FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
i and ii only
ii and iii only
i and iii only
iii and iv only
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
.................. is the loss of energy as the signal propagates outward, where the amount of energy depends on the frequency.
Noise
Delay distortion
Attenuation distortion
Dispersion
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
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
Data integrity refers to
the uniqueness of the data in a database
the correctness and completeness of the data in a database
the un redundancies of the data in a database
Data independence of the database
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
A …………… is a memory area where data are processed.
view
trigger
cursor
none 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
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
The raw facts and figures are:
Data
Data field
DBMS
DBASE