Quiz Discussion

Which of the following types of databases are the most common?

• 1]

  Personal

• 2]

  Workgroup

• 3]

  Department

• 4]

  Enterprise

Some advantages of the database approach include all, but

• 1]

  minimal data redundancy

• 2]

  improved data consistency

• 3]

  improved data sharing

• 4]

  program-data dependency

Duplicate data often results in loss of data integrity because

• 1]

  the data formats may be inconsistent

• 2]

  data values may not agree

• 3]

  Both A & B

• 4]

  Neither A & B

Duty of Database manager is to enforce integrity and _________ checks.

• 1]

  Complexity

• 2]

  Security

• 3]

  Multiplicity

• 4]

  None of these

Structured data may include which of the following?

• 1]

  Photo image

• 2]

  Video clip

• 3]

  Dates

• 4]

  None of the above

__________ is collection of operations that performs a single logical function in database application.

• 1]

  Interaction

• 2]

  Operation

• 3]

  Transaction

• 4]

  None of these

Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly?

• 1]

  Embedded SQL

• 2]

  Dynamic SQL

• 3]

  SQL declarations

• 4]

  SQL data analysis

Metadata enables database designers and users to do all of the following except

• 1]

  sample data

• 2]

  understand what data exist

• 3]

  what the fine distinctions are between similar data items

• 4]

  what the data mean

An extranet is which of the following?

• 1]

  The use of Internet protocols with limited access to company data by the company's customers and suppliers.

• 2]

  The use of Internet protocols with unlimited access to company data by the company's customers and suppliers.

• 3]

  The use of Internet protocols with limited access to company data by people within an organization.

• 4]

  The use of Internet protocols with unlimited access to company data by people within an organization.

Overall design of the database is called as _________.

• 1]

  Database Instance

• 2]

  Database Abstraction

• 3]

  Database Schema

• 4]

  None of these