Quiz Discussion

Schema Definition is written by ___________.

• 1]

  Application Programmer

• 2]

  Naive User

• 3]

  Database Administrator

• 4]

  Sophisticated user

Database Manager Performs following query related operation

• 1]

  Drop Table

• 2]

  Creating Schema

• 3]

  Retrieving Record

• 4]

  Creating View

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

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

Which of the user write programs in the host language and embed the DML statements into it?

• 1]

  Specialized User

• 2]

  Sophisticated User

• 3]

  Application Programmer

• 4]

  Naive User

Database Manager is also known as _________

• 1]

  Sophisticated User

• 2]

  System Manager

• 3]

  Application Programmer

• 4]

  Storage Manager

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

• 1]

  Personal

• 2]

  Workgroup

• 3]

  Department

• 4]

  Enterprise

Overall design of the database is called as _________.

• 1]

  Database Instance

• 2]

  Database Abstraction

• 3]

  Database Schema

• 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

Data administrators are responsible for

• 1]

  physical database design

• 2]

  managing technical issues in the database environment

• 3]

  overall management of data resources in an organization

• 4]

  writing application programs