Related Questions
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
The cost of reading and writing temporary files while evaluating a query can be reduced by
What is the correct answer?
4
What is data integrity?
A. It is the data contained in database that is non redundant.
B. It is the data contained in database that is accurate and consistent.
C. It is the data contained in database that is secured.
D. It is the data contained in database that is shared.
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
In a relational schema, each tuple is divided into fields called
What is the correct answer?
4
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.
What is the correct answer?
4
An outstanding functionality of SQL is its support for automatic_____ to the target data.
What is the correct answer?
4
An advantage of the database management approach is
A. data redundancy increases
B. data is dependent on programs
C. data is integrated and can be accessed by multiple programs
What is the correct answer?
4
Which of the following addressing modes permits relocation without any change over in the code?
C. PC relative addressing
D. Base register addressing
What is the correct answer?
4
According to the levels of abstraction, the schema at the intermediate level is called
What is the correct answer?
4
Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.
What is the correct answer?
4
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :
A. Operationally, if Y is deleted, so is X
B. existence is dependent on Y.
C. Operationally, if X is deleted, so is Y.
D. Operationally, if X is deleted, & remains the same.
What is the correct answer?
4
Which of the following is not a recovery technique?
What is the correct answer?
4
If the closure of an attribute set is the entire relation then the attribute set is a
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
E-R Modeling is achieved by using ____ diagrams
What is the correct answer?
4
DROP is a statement in SQL.
What is the correct answer?
4
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
C. SQL server service manager
What is the correct answer?
4
The set of all values that can be taken by the attribute is called as _______ of the attribute.
What is the correct answer?
4
Shadow paging has
What is the correct answer?
4
Which of the following is not a characteristic of a relational database model?
C. Complex logical relationship
What is the correct answer?
4
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces a result of degree
What is the correct answer?
4
Which is the best file organization when data is frequently added or deleted from a file?
What is the correct answer?
4
Immediate database modification technique uses
D. Neither undo nor redo.
What is the correct answer?
4
If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
What is the correct answer?
4
The statement that is executed automatically by the system as a side effect of the modification of the database is
What is the correct answer?
4
Drop Table cannot be used to drop a table referenced by a ______ constraint.
What is the correct answer?
4
If a transaction T has obtained an exclusive lock on item Q, then T can
D. write Q but not read Q
What is the correct answer?
4
Tree structures are used to store data in
What is the correct answer?
4
A logical schema
A. is the entire database
B. Describes how data is actually stored on disk.
C. is a standard way of organizing information into accessible parts.