Primary storage
magnetic disk
magnetic tape
juke box
cache
Correct Answer :
D. cache
Related Questions
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
View never contains derived columns.
True
False
Cant say
none
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
Symbol to represent weak entity set in ER Model
Dotted rectangle
Square
Doubly outlined rectangle
Diamond
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
Which of the following is not a constraint on a single relation?
check
unique
not null
is duplicate
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
i and ii only
ii and iii only
ii only
i only
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
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
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
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.
Noise
Delay
Dispersion
Attenuation
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.
i ,iii only
ii, iv only
iii, iv only
ii, iii, iv
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
Transaction processing is associated with everything below except
producing detail, summary, or exception reports.
recording a business activity.
confirming an action or triggering a response.
maintaining data.
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these