GIS Unit II

DBMS is used to create, read, update, and delete data in databases

• True

• False

DBMS provides mechanisms to ensure data security and integrity

• False

• True

What is a Data Dictionary?

• A tool for data visualization

• A centralized repository of data descriptions

• A programming language

• A type of database management system

What is the purpose of metadata in a Data Dictionary?

• To secure data access

• To analyze data trends

• To provide information about data characteristics

• To store primary data

In ER model, Students have courses indicating ____________

• One to On Relationship

• one to many relationship

• many to many relationship

• many to one relationship

What is normalization in DBMS?

• Technique to increase redundancy

• Method to improve data integrity

• Process of organizing data in a database

• Approach to optimize database performance

What is a super key in DBMS?

• A key that is always a primary key

• A key used for data validation

• A key that allows duplicate values

• A set of attributes that uniquely identifies a record

What is a primary key in DBMS?

• A field that allows null values

• A unique identifier for each record in a table

• A key that can be duplicated

• A key used for sorting data

Which normal form requires the removal of partial dependencies?

• 3NF

  
  

• 2NF

• 1NF

• BCNF

What is the purpose of a GIS data model?

• To create 3D visualizations

• To analyze weather patterns

• To standardize how geographic information is organized and managed

• To design user interfaces