Select * from R natural join S.
Select * from R cross join S.
Select * from R union join S.
Select * from R inner join S.
B. Select * from R cross join S.
distinct values
cannot have NULL
both (A) & (B)
same as primary key
Data Definition Language .
Meta Language
Procedural query Language
None of the above
2NF
5NF
4NF
3NF
Entity
Attribute
Relationship
Notation
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
DISTINCT
UNIQUE
NULL
EXISTS
Unary Operator
Ternary Operator
Binary Operator
Not an operator
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.
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
Secondary key
Alternate key
Unique key
Primary key
theta join
outer join
natural join
composed join
Data security
Derived columns
Hiding of complex queries
All of the above
disjoint
partial
overlapping
single
It requires that an entity belongs to no more than one level entity set.
The same entity may belong to more than one level.
The database must contain an unmatched foreign key value.
An entity can be joined with another entity in the same level entity set.
Conceptual level data hiding.
External level data hiding.
Physical level data hiding.
None of these.
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
OR
AND
NOT
ALL
no redo
no undo
redo but no undo
neither redo nor undo
system indexes
syst indexes
sys indexes
sysind
repeatable read
read committed
read uncommitted
serializable
Default
Index
Rule
View
Two - phase locking
Graph-based locking
Time-stamp based locking
None of these .
the pin code
the last name
the compound key first name and last name
Tr from next page
View
Order by
Group by
Having
Select * from R natural join S.
Select * from R cross join S.
Select * from R union join S.
Select * from R inner join S.
Star
llustar
SQL
Cygnus
Direct
Indirect
Existence
No
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));
All views are not updateable
The views may be referenced in an SQL statement whenever tables are referenced.
The views are instantiated at the time they are referenced and not when they are defined.
The definition of a view should not have GROUP BY clause in it.
Double lines
Single line
Dashed lines
Triangle