Quiz Discussion

Schema Definition is written by ___________.

• 1]

  Application Programmer

• 2]

  Naive User

• 3]

  Database Administrator

• 4]

  Sophisticated user

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

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

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

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

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

Granting and Authorization for data access is provided by _____________

• 1]

  DBA

• 2]

  Application Developer

• 3]

  Storage Manager

• 4]

  Database Manager

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

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