Relations produced from an E-R model will always be
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
Correct Answer :
A. First normal form.
Related Questions
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
Union
Intersection
Difference
Join
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
jamming
password
documentation
record lock
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client
Manager salary details are hidden from the employee .This is
Conceptual level data hiding.
External level data hiding.
Physical level data hiding.
None of these.
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data
programs are not dependent on the logical attributes of data
both B and C
What is data integrity?
It is the data contained in database that is non redundant.
It is the data contained in database that is accurate and consistent.
It is the data contained in database that is secured.
It is the data contained in database that is shared.
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :
Operationally, if Y is deleted, so is X
existence is dependent on Y.
Operationally, if X is deleted, so is Y.
Operationally, if X is deleted, & remains the same.
______is a preferred method for enforcing data integrity
Constraints
Triggers
Stored procedure
Cursors
Relationships among relationships can be represented in an-E-R model using
Aggregation
Association
Weak entity sets
Weak relationship sets
A _____ is used to define overall design of the database
code
data definition language
application program
schema
Which of the following constitutes a basic set of operations for manipulating relational data?
Predicate calculus
Relational calculus
Relational algebra
SQL
If a transaction T has obtained an exclusive lock on item Q, then T can
read Q
write Q
both read and write Q
write Q but not read Q
A logical schema
is the entire database
Describes how data is actually stored on disk.
is a standard way of organizing information into accessible parts.
All of the above
Which of the following concurrency control schemes is not based on the serializability property?
Two - phase locking
Graph-based locking
Time-stamp based locking
None of these .
Change Staff table by removing default of Assistant for position column
ALTER TABLE Staff ALTER position DROP DEFAULT;
ALTER TABLE Staff ALTER position DEFAULT;
ALTER TABLE Staff ALTER DROP DEFAULT;
MODIFY Staff ALTER position DROP DEFAULT;
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
m - 1
m + 1
m * m
m
E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R
Immediate database modification technique uses
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security
Which of the following is not a characteristic of a relational database model?
Table
Tree like structure
Complex logical relationship
Records
Cascading rollback is avoided in all protocol except
strict two-phase locking protocol.
tree locking protocol
two-phase locking protocol
validation based protocol.
The normalization was first proposed by .
Code
Codd
Boyce Codd
Boyce
Which is the best file organization when data is frequently added or deleted from a file?
Sequential
Direct
Index sequential
None of the above
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
M:N
M:1
1:M
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
distinct values
cannot have NULL
both (A) & (B)
same as primary key
The values of the attribute describes a particular
Entity set
File
Entity instance
Organization
Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for the supplier S1.
UPDATE S CITY = KANPUR WHERE SNO=S1
UPDATE S SET CITY = KANPUR FOR SNO=S1
UPDATE S SET CITY = KANPUR WHERE SNO=S1
UPDATE S RENAME CITY = KANPUR WHERE SNO=S1
Which of the following ensures the atomicity of the transaction?
Transaction management component of DBMS
Application Programmer
Concurrency control component of DBMS
Recovery management component of DBMS
Checkpoints are a part of
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF