………………… approach reduces time and effort required for design and lesser risk in database management.
Single global database
Multiple databases
Top-down approach
None of the above
Correct Answer :
B. Multiple databases
Related Questions
What is a disjoint less constraint?
It requires that an entity belongs to no more than one level entity set.
The same entity may belong to more than one level.
The database must contain an unmatched foreign key value.
An entity can be joined with another entity in the same level entity set.
It is an abstraction through which relationships are treated as higher level entities
Generalization.
Specialization.
Aggregation.
Inheritance.
The part of a database management system which ensures that the data remains in a consistent state is
authorization and integrity manager
buffer manager
transaction manager
file manager
Which one is true statement :
With finer degree of granularity of locking a high degree of concurrency is possible.
Locking prevents non-serializable schedules.
Locking cannot take place at field level.
An exclusive lock on data item X is granted even if a shared lock is already held on X.
DROP is a statement in SQL.
Query
Embedded SQL
DDL
DCL
_____is a full form of SQL.
Standard query language
Sequential query language
Structured query language
Server side query language
Union operator is a :
Unary Operator
Ternary Operator
Binary Operator
Not an operator
The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is
Procedural DML.
Non-Procedural DML.
Procedural DDL.
Non-Procedural DDL.
Which of the following is a reason to model data?
Understand each user's perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
Union
Intersection
Difference
Join
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
Star
llustar
SQL
Cygnus
A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.
Direct
Indirect
Existence
No
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ______
Fields
Records
Relations
Keys
_____ First proposed the process of normalization.
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
The drawback of shadow paging technique are
Commit overhead
Data fragmentation
Garbage collection
All of these
Which of the following is not comparison operator?
<>
<
=<
>=
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
OR
AND
NOT
ALL
Key to represent relationship between tables is called
primary key
secondary key
foreign key
none of the above
Cascading rollback is avoided in all protocol except
strict two-phase locking protocol.
tree locking protocol
two-phase locking protocol
validation based protocol.
The default level of consistency in SQL is
repeatable read
read committed
read uncommitted
serializable
In an E-R diagram double lines indicate
Total participation.
Multiple participation.
Cardinality N.
None of the above.
The normalization was first proposed by .
Code
Codd
Boyce Codd
Boyce
A table can have only one
Secondary key
Alternate key
Unique key
Primary key
What are the desirable properties of a decomposition
Partition constraint.
Dependency preservation.
Redundancy.
Security.
Data items grouped together for storage purposes are called a
record
string
title
list
The one guideline to be followed while designing the database is
A database design may be ambiguous.
It should avoid/reduce the redundancy.
Unrelated data should be in the same table so that updating the data will be easy.
An entity should not have attributes.
The collection of information stored in a database at a particular moment is called as ......
schema
instance of the database
data domain
independence
DBMS helps achieve
Centralized control of data
Data independence
Both A and B
Neither A nor B
Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C
(i) and (ii)
(iv) only
(i) and (iv)
(ii) and (iii)
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX