Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
Correct Answer :
B. direct access storage
Related Questions
The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol
i, ii only
ii and iv only
ii and iv only
i, iv only
The transaction consists of all statements executed between
the begin transaction and end transaction
the start transaction and end transaction
the begin transaction and finish transaction
none of the above.
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 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
B-Tree is used for
searching data
storing data
both A and B
none of these
Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
QBE
Query By Execution
Query By Example
Query By Extraction
None of the above.
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
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
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
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
Which of the following is logical topology?
Bus
Ring
Star
None of these
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
.................. 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
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to
View
Cursor defination
Referential intergrity
Trigger
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
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
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
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
View never contains derived columns.
True
False
Cant say
none
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii