Quiz Discussion

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

Granting and Authorization for data access is provided by _____________

• 1]

  DBA

• 2]

  Application Developer

• 3]

  Storage Manager

• 4]

  Database Manager

Schema Definition is written by ___________.

• 1]

  Application Programmer

• 2]

  Naive User

• 3]

  Database Administrator

• 4]

  Sophisticated user

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

Database Manager is also known as _________

• 1]

  Sophisticated User

• 2]

  System Manager

• 3]

  Application Programmer

• 4]

  Storage Manager

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

Database Manager Performs following query related operation

• 1]

  Drop Table

• 2]

  Creating Schema

• 3]

  Retrieving Record

• 4]

  Creating View

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

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