schema
instance of the database
data domain
independence
B. instance of the database
Like
COMPARE
BETWEEN
IN
Domain Integrity Constraints
Referential Integrity Constraints
Domain Constraints
Entity Integrity Constraints
Relations
Queries
Domains
All of the above
record
string
title
list
Query
Embedded SQL
DDL
DCL
programming
navigation
functioning
notification
schema
instance of the database
data domain
independence
Entity
Attribute
Relationship
Notation
Network model.
Relational model.
Hierarchical model.
File based system.
building indices
pipelining
join ordering
none of the above
the pin code
the last name
the compound key first name and last name
Tr from next page
Data Definition Language .
Meta Language
Procedural query Language
None of the above
Serializable schedule.
Recoverable schedule.
Deadlock free schedule.
Cascadeless schedule.
Entity set
File
Entity instance
Organization
B-Tree
graph
Query Tree
directed graph
Predicate calculus
Relational calculus
Relational algebra
SQL
Hierarchical schema
Network schema
Relational Schema
All of the above
jamming
password
documentation
record lock
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.
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 .
Union
Intersection
Cartesian Product
Select
OR
AND
NOT
ALL
GROUP BY Clause
HAVING Clause
FROM Clause
WHERE Clause
(i) and (ii)
(iv) only
(i) and (iv)
(ii) and (iii)
Primary storage
Secondary Storage
All
Tertiary Storage
alter
update
set
create
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.
SQL
System
Nested
None of these
theta join
outer join
natural join
composed join
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