Related Questions
What is the correct answer?
4
Union operator is a :
What is the correct answer?
4
Dependency preservation is not guaranteed in
What is the correct answer?
4
When an E-R diagram is mapped to tables, the representation is redundant for
B. weak relationship sets
D. strong relationship sets
What is the correct answer?
4
A ______ module is typically designed so that it will run on a user workstation or personal computer.
What is the correct answer?
4
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows
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
Key to represent relationship between tables is called
What is the correct answer?
4
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
A. Oval; An oval with an underlined attribute
B. Circle; A circle with bolded attribute inside it
C. Diamond; A bolded attribute
D. Square; An attribute within the square
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 drawback of shadow paging technique are
What is the correct answer?
4
If an entity can belong to only one lower level entity then the constraint is
What is the correct answer?
4
In SQL the word natural can be used with
What is the correct answer?
4
Protection of data from unauthorized Disclosure results in loss of _______
D. Discretionary Security
What is the correct answer?
4
What are the desirable properties of a decomposition
B. Dependency preservation.
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
Which of the following constitutes a basic set of operations for manipulating relational data?
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
DBMS is a collection of _____ that enables user to create and maintain a database.
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
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
______ keyword is used to find the number of values in a column.
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
______is a preferred method for enforcing data integrity
What is the correct answer?
4
The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
What is the correct answer?
4
In b-tree the number of keys in each node is than the number of its children.
What is the correct answer?
4
operator is used to compare a value to a list of literals values that have been specified.
What is the correct answer?
4
In 2NF
A. No functional dependencies (FDs) exist.
B. No multivalued dependencies (MVDs) exist.
D. No partial MVDs exist.
What is the correct answer?
4
The data in the database at a particular moment of time is called the _______
What is the correct answer?
4
Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values
What is the correct answer?
4
The collection of information stored in a database at a particular moment is called as ......
B. instance of the database