[Solved] MSDS7330 Assignment 1

• The DBMS acts as an interface between what two components of an enterprise-class database system?
  1. Database application and the database
  2. Data and the database
  3. The user and the database application
  4. Database application and SQL
• The following are components of a database except which of the following?
  1. user data
  2. metadata
  3. reports
  4. indexes
• Table is synonymous with the term
  1. record
  2. relation
  3. column
  4. row
• Row is synonymous with the term
  1. column
  2. relation
  3. field
  4. record
• Attribute is synonymous with the term
  1. record
  2. relation
  3. column
  4. row
• For some relations, changing the data can have undesirable consequences called:
  1. referential integrity constraints.
  2. modification anomalies.
  3. normal forms.
  4. transitive dependencies.
• The different classes of relations created by the technique for preventing modification anomalies are called:
  1. normal forms.
  2. referential integrity constraints.
  3. functional dependencies.
  4. relation instance.
• A database schema is
  1. A plan created by the database.
  2. The logical design of the database.
  3. A particular instance of a database.
  4. The snapshot of the data in the database at a giventime.
• The primary key is selected from the
  1. composite keys.
  3. candidate keys.
  4. foreign keys.
• Which of the following is a group of one or more attributes that uniquely identifies a row?
  1. Key
  2. Determinant

1. Tuple

• A relation is considered a
  2. one-dimensional table.
  3. two-dimensional table.
  4. three-dimensional table.
• In the relational model, relationships between relations or tables are created by using:
  1. composite keys.
  3. candidate keys.
  4. foreign keys.
• You have run an SQL statement that asked the DBMS to display data in a table named UserTables. The results include columns of data labeled TableName, NumberOfColumns and PrimaryKey. What are these labels?

2

1. user data
2. metadata
3. a report
4. indexes

• An Enterprise Resource Planning application is an example of a(n) ?
  1. single-user database application
  2. multiuser database application
  3. e-commerce database application
  4. data mining database application
• The following are functions of a DBMS except ?
  1. creating and processing forms
  2. creating databases
  3. processing data
  4. administrating databases