QN1. The DBMS acts as an interface between what two components of an enterprise-class database system?
A. Database application and the database
B. Data and the database
C. The user and the database application
D. Database application and SQL
Answer
Answer: A. Database application and the database
QN2. Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
[A]. IDMS
[B]. DB2
[C]. dBase-II
[D]. R:base
Answer
Answer: [B]. DB2
QN3: The following are functions of a DBMS except ________ .
A. creating and processing forms
B. creating databases
C. processing data
D. administrating databases
Answer
Answer: A. creating and processing forms
QN4: SQL stands for ________ .
A. Structured Query Language
B. Sequential Query Language
C. Structured Question Language
D. Sequential Question Language
Answer
Answer: A. Structured Query Language
QN5: The different classes of relations created by the technique for preventing modification anomalies are called:
[A]. normal forms.
[B]. referential integrity constraints.
[C]. functional dependencies.
[D]. None of the above is correct.
Answer
Answer: [A]. normal forms.
QN6: A relation is in this form if it is in BCNF and has no multivalued dependencies:
[A]. second normal form.
[B]. third normal form.
[C]. fourth normal form.
[D]. domain/key normal form.
Answer
Answer: [C]. fourth normal form.
QN7. Row is synonymous with the term:
A. record.
B. relation.
C. column.
D. field.
Answer
Answer: A. record.
QN8. The primary key is selected from the:
[A]. composite keys.
[B]. determinants.
[C]. candidate keys.
[D]. foreign keys.
Answer
Answer: [C]. candidate keys.
QN9. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
A. transitive dependency.
B. insertion anomaly.
C. referential integrity constraint.
D. normal form.
Answer
Answer: C. referential integrity constraint.
QN10. Which of the following is a group of one or more attributes that uniquely identifies a row?
A. Key
B. Determinant
C. Tuple
D. Relation
Answer
Answer: A. Key
QN11. In the relational model, relationships between relations or tables are created by using:
[A]. composite keys.
[B]. determinants.
[C]. candidate keys.
[D]. foreign keys.
Answer
Answer: [D]. foreign keys.
QN12. A relation is considered a:
A. Column.
B. one-dimensional table.
C. two-dimensional table.
D. three-dimensional table.
Answer
Answer: C. two-dimensional table.
QN13. The SQL command to create a table is
The SQL command to create a table is:
A. MAKE TABLE
B. ALTER TABLE
C. DEFINE TABLE
D. CREATE TABLE
Answer
Answer: D. CREATE TABLE
QN14. A functional dependency is a relationship between or among:
A. tables.
B. rows.
C. relations.
D. attributes.
Answer
Answer: D. attributes.
QN15. SQL views can be used to hide:
A. columns and rows only.
B. complicated SQL syntax only.
C. both of the above can be hidden by an SQL view.
D. None of the above is correct.
Answer
Answer: C. both of the above can be hidden by an SQL view.
QN16. The SQL statement to create a view is:
A. CREATE VIEW.
B. MAKE VIEW.
C. SELECT VIEW.
D. INSERT VIEW.
Answer
Answer: A. CREATE VIEW.
QN17. To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
A. a particular column in a particular underlying table.
B. a particular column in a particular row.
C. a particular row in a particular underlying table.
D. None of the above is correct.
Answer
Answer: C. a particular row in a particular underlying table.
QN18. Which of the following is NOT a type of SQL constraint?
A. PRIMARY KEY
B. FOREIGN KEY
C. ALTERNATE KEY
D. UNIQUE
Answer
Answer: C. ALTERNATE KEY
QN20. A ________ is a program that performs some common action on database data and that is stored in the database.
A. trigger
B. stored procedure
C. pseudofile
D. None of the above is correct.
Answer
Answer: B. stored procedure
QN22. For what purposes are views used?
[A]. To hide columns only
[B]. To hide rows only
[C]. To hide complicated SQL statements only
[D]. All of the above are uses for SQL views
Answer
Answer: [D]. All of the above are uses for SQL views
QN22. What is an SQL virtual table that is constructed from other tables?
A. Just another table
B. A view
C. A relation
D. Query results
Answer
Answer: B. A view
QN23. What is not an advantage of stored procedures?
A. Greater security
B. SQL can be optimized
C. Code sharing
D. Increased network traffic
Answer
Answer: D. Increased network traffic
QN23. What SQL structure is used to limit column values of a table?
A. The LIMIT constraint
B. The CHECK constraint
C. The VALUE constraint
D. None of the above is correct.
Answer
Answer: B. The CHECK constraint
QN24. The SQL ALTER statement can be used to:
A. change the table structure.
B. change the table data.
C. add rows to the table.
D. delete rows from the table.
Answer
Answer: A. change the table structure.
QN25. ODL supports which of the following types of association relationships?
A. Unary
B. Unary and Binary
C. Unary and Binary and Ternary
D. Unary and Binary and Ternary and higher
Answer
Answer: B. Unary and Binary
QN26. Using ODL, you can define which of the following?
A. Attribute
B. Structure
C. Operation
D. All of the above
Answer
Answer: D. All of the above
QN27. The object definition language (ODL) is which of the following?
A. Used to develop logical schemas
B. A data definition language for OODB
C. A method to implement a logical schema
D. All of the above.
Answer
Answer: D. All of the above.
QN28. Which of the following is true concerning an ODBMS?
A. They have the ability to store complex data types on the Web.
B. They are overtaking RDBMS for all applications.
C. They are most useful for traditional, two-dimensional database table applications.
D. All of the above.
Answer
Answer: A. They have the ability to store complex data types on the Web.
QN29. A relationship should be specified how in the ODL?
A. One direction starting with the first class
B. One direction starting with the second class
C. Neither direction.
D. Both directions.
Answer
Answer: D. Both directions.
QN30. Multiplicity is the same as what concept for an ERD?
A. Relationship
B. Attribute
C. Entity
D. Cardinality
Answer
Answer: D. Cardinality
QN31. Composition is a stronger form of which of the following?
A. Aggregation
B. Encapsulation
C. Inheritance
D. All of the above
Answer
Answer: A. Aggregation
QN32. The term Complete for a UML has the same meaning as which of the following for an EER diagram?
A. Overlapping rule
B. Disjoint rule
C. Total specialization rule
D. Partial specialization rule
Answer
Answer: C. Total specialization rule
QN33. A UML diagram includes which of the following?
A. Class name
B. List of attributes
C. List of operations
D. All of the above
Answer
Answer: D. All of the above
QN34. An object can have which of the following multiplicities?
A. Zero
B. One
C. More than one
D. All of the above.
Answer
Answer: D. All of the above.
QN35. Which of the following applies to a class rather than an object?
A. Query
B. Update
C. Scope
D. Constructor
Answer
Answer: C. Scope
QN36. The benefits of object-oriented modeling are which of the following?
A. The ability to tackle more challenging problems
B. Reusability of analysis, design, and programming results
C. Improved communication between users, analysts, etc.
D. All of the above
Answer
Answer: D. All of the above
QN37. Which of the following is a technique for hiding the internal implementation details of an object?
A. Encapsulation
B. Polymorphism
C. Inheritance
D. All of the above
Answer
Answer: A. Encapsulation
QN38. Aggregation is which of the following?
A. Expresses a part-of relationship and is a stronger form of an association relationship.
B. Expresses a part-of relationship and is a weaker form of an association relationship.
C. Expresses an is-a relationship and is a stronger form of an association relationship.
D. Expresses an is-a relationship and is a weaker form of an association relationship.
Answer
Answer: A. Expresses a part-of relationship and is a stronger form of an association relationship.
QN39. A constructor operation does which of the following?
A. Creates a new instance of a class
B. Updates an existing instance of a class
C. Deletes and existing instance of a class
D. All of the above
Answer
Answer: A. Creates a new instance of a class
