Quiz Discussion

Schema Definition is written by ___________.

• 1]

  Application Programmer

• 2]

  Naive User

• 3]

  Database Administrator

• 4]

  Sophisticated user

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

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

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

Collection of information stored in database at particular instance of time is called as __________.

• 1]

  Data Structure

• 2]

  Database Schema

• 3]

  Instance of Database

• 4]

  Objects in Database

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

• 1]

  Complexity

• 2]

  Security

• 3]

  Multiplicity

• 4]

  None of these

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.

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

User which interact with the system using database query language is called as ___________

• 1]

  Application Programmer

• 2]

  Sophisticated User

• 3]

  Naive User

• 4]

  Specialized User