building indices
pipelining
join ordering
none of the above
B. pipelining
Two - phase locking
Graph-based locking
Time-stamp based locking
None of these .
2NF
5NF
4NF
3NF
None
Multi
Single
Concurrent
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
Procedural DML.
Non-Procedural DML.
Procedural DDL.
Non-Procedural DDL.
inner join
full outer join
right outer join
all of the above
Instance
Program
Schema
Super Key
DISTINCT
UNIQUE
NULL
EXISTS
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.
Sub
Parent
Candidate
Super
DISTINCT
NO DUPLICATE
UNIQUE
None of the above
partially committed
active
committed
none of the above
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
SQL
System
Nested
None of these
Unary Operator
Ternary Operator
Binary Operator
Not an operator
schema
instance of the database
data domain
independence
Union
Intersection
Cartesian Product
Select
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
Sequential
Direct
Index sequential
None of the above
Double lines
Single line
Dashed lines
Triangle
Government Union Internet
Graphical Unit Interface
Graphical User Interface
Graphical University Interface
Union
Intersection
Difference
Join
Fields
Records
Relations
Keys
Constraints
Triggers
Stored procedure
Cursors
TOTAL
ADD
COUNT
SUM
Logm(n)
(m+n)/2
Logm/2(m+n)
None of these
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.
Query languages and utilities
DML and query language
Data dictionary and transaction log
Data dictionary and query language
Primary
Foreign
Candidate
Alternate
Software
Server
Program
Client