Relations
Queries
Domains
All of the above
A. Relations
inner join
full outer join
right outer join
all of the above
partially committed
active
committed
none of the above
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 .
BCNF
3NF
PJNF
DKNF
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
<>
<
=<
>=
Aggregation
Association
Weak entity sets
Weak relationship sets
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
Union
Intersection
Difference
Join
Serializable schedule.
Recoverable schedule.
Deadlock free schedule.
Cascadeless schedule.
Direct
Indirect
Existence
No
Standard query language
Sequential query language
Structured query language
Server side query language
Partition constraint.
Dependency preservation.
Redundancy.
Security.
Deferred update
Immediate update
Two-phase commit
Shadow paging
Hierarchical schema
Network schema
Relational Schema
All of the above
Select * from R natural join S.
Select * from R cross join S.
Select * from R union join S.
Select * from R inner join S.
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.
Clustered
Hashed
Un-clustered
Collision
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
Single global database
Multiple databases
Top-down approach
None of the above
Query languages and utilities
DML and query language
Data dictionary and transaction log
Data dictionary and query language
the pin code
the last name
the compound key first name and last name
Tr from next page
Like
COMPARE
BETWEEN
IN
Domain Integrity Constraints
Referential Integrity Constraints
Domain Constraints
Entity Integrity Constraints
record
string
title
list
Union
Intersection
Cartesian Product
Select
Entity set
File
Entity instance
Organization
Database
Data
Transaction
Record
Conceptual, physical and internal
Conceptual, view and external
Logical, physical and internal
Logical, physical and view
First normal form.
Second normal form.
Third normal form.
Fourth normal form.