The one guideline to be followed while designing the database is
A database design may be ambiguous.
It should avoid/reduce the redundancy.
Unrelated data should be in the same table so that updating the data will be easy.
An entity should not have attributes.
Correct Answer :
B. It should avoid/reduce the redundancy.
Related Questions
DFD stands for
Data Flow Document
Data File Diagram
Data Flow Diagram
Non of the above
Shadow paging has
no redo
no undo
redo but no undo
neither redo nor undo
In a relational schema, each tuple is divided into fields called
Relations
Queries
Domains
All of the above
HSAM stands for ……….
Hierarchic Standard Access Method
Hierarchic Sequential Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method
In E-R Diagram total participation is represented by
Double lines
Single line
Dashed lines
Triangle
Which of the following aggregate functions does not ignore nulls in its results?.
COUNT .
COUNT (*)
MAX
MIN
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.
None
Multi
Single
Concurrent
The _______ is a set of programs to use and / or modify this data.
DBMS
System
Program
Software
A transaction is in state after the final statement has been executed.
partially committed
active
committed
none of the above
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
In an ER model,_____ is described in the database by storing its data.
Entity
Attribute
Relationship
Notation
The keyword to eliminate duplicate rows from the query result in SQL is
DISTINCT
NO DUPLICATE
UNIQUE
None of the above
Dependency preservation is not guaranteed in
BCNF
3NF
PJNF
DKNF
Which of the following is not a consequence of non-normalized database?
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
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
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
2NF
3NF
BCNF
1NF
_____clause is an additional filter that is applied to the result.
Select
Order by
Group-by
Having
The transactions like adding an employee, enrolling a student in a course are examples of _______
Logical
Physical
None
Theoretical
Which of the following is not a characteristic of a relational database model?
Table
Tree like structure
Complex logical relationship
Records
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.
Database
Data
Transaction
Record
Which of the following is not comparison operator?
<>
<
=<
>=
Wait-for graph is used for
detecting view serializability.
detecting conflict serializability.
deadlock prevention
deadlock detection
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.
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
Functional dependency
Multi-valued dependency
Transitive dependency
Partial dependency
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are
m+n and 0
m+n and |m-n|
mn and 0
mn and m+n
The rule that a value of a foreign key must appear as a value of some specific table is called a
Referential constraint.
Index.
Integrity constraint.
Functional dependency.
Which of the following constitutes a basic set of operations for manipulating relational data?
Predicate calculus
Relational calculus
Relational algebra
SQL
In 2NF
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.