Quiz Discussion

Overall design of the database is called as _________.

• 1]

  Database Instance

• 2]

  Database Abstraction

• 3]

  Database Schema

• 4]

  None of these

If DBA modify the structure of the data record then this modification do not affect other application is called as _____________.

• 1]

  Data Independence

• 2]

  Data Integrity

• 3]

  Data Isolation

• 4]

  Data Security

Structured data may include which of the following?

• 1]

  Photo image

• 2]

  Video clip

• 3]

  Dates

• 4]

  None of the above

Farmer goes to ATM Center to withdraw an amount of Rs.300/-. Which type of user farmer is?

• 1]

  Unsophisticated User

• 2]

  Sophisticated User

• 3]

  Application Programmer

• 4]

  Specialized User

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

Person A is Java Developer interacts with Person D to understand the complete database schema
written by him.
Person B knows the database Schema and he is able to hit complex queries.
Unlike Person B, Person C does not use traditional database processing frameworks.
Who among the 4 users will be called as Sophisticated User.

• 1]

  Person B

• 2]

  Person A

• 3]

  Person C

• 4]

  Person D

Granting and Authorization for data access is provided by _____________

• 1]

  DBA

• 2]

  Application Developer

• 3]

  Storage Manager

• 4]

  Database Manager

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

• 1]

  Interaction

• 2]

  Operation

• 3]

  Transaction

• 4]

  None of these

Database Manager is also known as _________

• 1]

  Sophisticated User

• 2]

  System Manager

• 3]

  Application Programmer

• 4]

  Storage Manager