Related Questions
What is the correct answer?
4
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
What is the correct answer?
4
Which of the following is not a consequence of non-normalized database?
What is the correct answer?
4
In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by
What is the correct answer?
4
Which of the following aggregate functions does not ignore nulls in its results?.
What is the correct answer?
4
Key to represent relationship between tables is called
What is the correct answer?
4
The full form of GUI is _________
A. Government Union Internet
B. Graphical Unit Interface
C. Graphical User Interface
D. Graphical University Interface
What is the correct answer?
4
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple.
What is the correct answer?
4
Which of the following relational algebraic operations is not from set theory?
What is the correct answer?
4
The data models defined by ANSI/SPARC architecture are
A. Conceptual, physical and internal
B. Conceptual, view and external
C. Logical, physical and internal
D. Logical, physical and view
What is the correct answer?
4
_____clause is an additional filter that is applied to the result.
What is the correct answer?
4
Isolation of the transactions is ensured by
A. Transaction management
B. Application programmer
What is the correct answer?
4
What are the desirable properties of a decomposition
B. Dependency preservation.
What is the correct answer?
4
HSAM stands for ……….
A. Hierarchic Standard Access Method
B. Hierarchic Sequential Access Method
C. Hierarchic Sequential and Method
D. Hierarchic Standard and Method
What is the correct answer?
4
The rule that a value of a foreign key must appear as a value of some specific table is called a
A. Referential constraint.
D. Functional dependency.
What is the correct answer?
4
The one guideline to be followed while designing the database is
A. A database design may be ambiguous.
B. It should avoid/reduce the redundancy.
C. Unrelated data should be in the same table so that updating the data will be easy.
D. An entity should not have attributes.
What is the correct answer?
4
In SQL the statement select * from R, S is equivalent to
A. Select * from R natural join S.
B. Select * from R cross join S.
C. Select * from R union join S.
D. Select * from R inner join S.
What is the correct answer?
4
DBMS is a collection of _____ that enables user to create and maintain a database.
What is the correct answer?
4
The cost of reading and writing temporary files while evaluating a query can be reduced by
What is the correct answer?
4
______ keyword is used to find the number of values in a column.
What is the correct answer?
4
A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.
What is the correct answer?
4
The default level of consistency in SQL is
What is the correct answer?
4
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.
What is the correct answer?
4
Cascading rollback is avoided in all protocol except
A. strict two-phase locking protocol.
C. two-phase locking protocol
D. validation based protocol.
What is the correct answer?
4
For correct behaviour during recovery, undo and redo operation must be
What is the correct answer?
4
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
What is the correct answer?
4
Immediate database modification technique uses
D. Neither undo nor redo.
What is the correct answer?
4
A relational database developer refers to a record as
What is the correct answer?
4
In a relational schema, each tuple is divided into fields called
What is the correct answer?
4
For using a specific database …………… command is used.
What is the correct answer?
4
The middleware databases in which the business rules act are applicable to _______ tier architectures