m - 1
m + 1
m * m
m
D. m
GROUP BY Clause
HAVING Clause
FROM Clause
WHERE Clause
Total participation.
Multiple participation.
Cardinality N.
None of the above.
DISTINCT
UNIQUE
NULL
EXISTS
data redundancy increases
data is dependent on programs
data is integrated and can be accessed by multiple programs
none of the above
add an attribute
delete an attribute
alter the default values of an attribute
all of the above
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
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
Oval; An oval with an underlined attribute
Circle; A circle with bolded attribute inside it
Diamond; A bolded attribute
Square; An attribute within the square
Data Flow Document
Data File Diagram
Data Flow Diagram
Non of the above
<>
<
=<
>=
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
distinct values
cannot have NULL
both (A) & (B)
same as primary key
Domain Integrity Constraints
Referential Integrity Constraints
Domain Constraints
Entity Integrity Constraints
It will result in a deadlock situation.
It will immediately be rejected.
It will immediately be granted.
It will be granted as soon as it is released by A .
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
Data security
Derived columns
Hiding of complex queries
All of the above
Secondary key
Alternate key
Unique key
Primary key
Integrity
Availability
Confidentiality
Discretionary Security
Entity
Attribute
Relationship
Notation
COUNT .
COUNT (*)
MAX
MIN
Standard query language
Sequential query language
Structured query language
Server side query language
Lost update problem.
Update anomaly.
Unrepeatable read.
Dirty read.
Understand each user's perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above
Volatile
Non - Volatile
Logical
Physical
Similarity
Granularity
Dimensionality
Arity
Sub
Parent
Candidate
Super
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
Snapshot
Dynaset
Stateless
Stateful
DFD
Flowcharts
Gantt Charts
E-R
Create table Employee(EMPNO int, EMPNAME char(10));
Create table Employee(EMPNO integer, EMPNAME String(10));
Create table Emplo(EMPNO number, EMPNAME string);
Create table Emp(EMPNO int, EMPNAME char(10));