Q.1
A supertype/subtype hierarchy has which of the following features?
  • Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
  • Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
  • Attributes are assigned at the highest logical level.
  • Attributes are assigned at the lowest logical level.
Q.2
What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
  • ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
  • ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
  • ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
  • None of the above is correct.
Q.3
When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
  • Disjoint with total specialization
  • Disjoint with partial specialization
  • Overlap with total specialization
  • Overlap with partial specialization
Q.4
The process of reading a database schema and producing a data model from that schema is known as:
  • data modeling.
  • database design.
  • reverse engineering.
  • None of the above is correct.
Q.5
The first step in database development is which of the following?
  • Enterprise data modeling
  • Logical database design
  • Physical database design and definition
  • Database Implementation
Q.6
Which of the following are goals of OLE DB?
  • Create object interfaces for DBMS functionality pieces only.
  • Increase flexibility only.
  • Object interface over any type of data only.
  • All of the above as goals of OLE DB.
Q.7
The object definition language (ODL) is which of the following?
  • Used to develop logical schemas
  • A data definition language for OODB
  • A method to implement a logical schema
  • All of the above.
Q.8
An Oracle System Change Number (SCN):
  • is a value that is incremented whenever a dirty read occurs.
  • is incremented whenever a deadlock occurs.
  • is a value that keeps track of explicit locks.
  • is a value that is incremented whenever database changes are made.
Q.9
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
  • ASP
  • XML
  • ODBC
  • ADO
Q.10
Using OQL, you may do which of the following?
  • Return an entire collection of elements including duplicates.
  • Return a collection of elements without duplicates.
  • Return a specific subset of elements using a given criteria.
  • All of the above.
0 h : 0 m : 1 s