An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
Correct Answer :
C. data is integrated and can be accessed by multiple programs.
Related Questions
Which of the following layer uses trailer of the frame for error detection?
Transport layer
Network layer
Datalink layer
None of these
As a side-effect of database update ,the system automatically executes a statement called
a view
a grant permission
a trigger
all of the above
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.
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
Which of the following is not a constraint on a single relation?
check
unique
not null
is duplicate
The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :
B-Tree File
Hashed File
Indexed File
Sequential file.
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD
Query processing is
converting data to insert in a database
translation of query to lower form
range of activities involved in extracting data from a database
none of the above
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
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
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
Event condition action model is related to
Views
Cursors
Triggers
None of these.
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
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
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 which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
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
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key
Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
An entity set that does not have sufficient attributes to form a primary key is a
strong entity set.
weak entity set.
simple entity set.
primary entity set.
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 is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file
A composite attribute is converted to individual attributes in which of the following normal form ?
first
Second
third
fourth