Related Questions
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 fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.
What is the correct answer?
4
Which of the following ensures the atomicity of the transaction?
A. Transaction management component of DBMS
B. Application Programmer
C. Concurrency control component of DBMS
D. Recovery management component of DBMS
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
The drawback of shadow paging technique are
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
Manager salary details are hidden from the employee .This is
A. Conceptual level data hiding.
B. External level data hiding.
C. Physical level data hiding.
What is the correct answer?
4
Immediate database modification technique uses
D. Neither undo nor redo.
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
Which normal form is considered adequate for normal relational database design?
What is the correct answer?
4
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
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
Wait-for graph is used for
A. detecting view serializability.
B. detecting conflict serializability.
What is the correct answer?
4
A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.
What is the correct answer?
4
What is a disjoint less constraint?
A. It requires that an entity belongs to no more than one level entity set.
B. The same entity may belong to more than one level.
C. The database must contain an unmatched foreign key value.
D. An entity can be joined with another entity in the same level entity set.
What is the correct answer?
4
A top-to-bottom relationship among the items in a database is established by a
What is the correct answer?
4
Which of the following is not a logical database structure?
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
Maximum height of a B+ tree of order m with n key values is
What is the correct answer?
4
_____ command can be used to modify a column in a table
What is the correct answer?
4
For correct behaviour during recovery, undo and redo operation must be
What is the correct answer?
4
The _______ is a set of programs to use and / or modify this data.
What is the correct answer?
4
Shadow paging has
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
E-R Modeling is achieved by using ____ diagrams
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
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.
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
Data items grouped together for storage purposes are called a
What is the correct answer?
4
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.