DBMS-22-7-25

The primary goal of an information system is to:

• Control organizational policies

• Store hardware resources

• Support decision-making

• Increase software complexity

An example of a Transaction Processing System (TPS) is:

• Payroll System

• Executive Support System

• Expert System

• Artificial Intelligence System

Which type of system is used for long-term planning in an organization?

• Management Information System

• Decision Support System

• . Executive Information System

• Transaction Processing System

Which of the following is NOT a characteristic of Big Data?

• Volume

• Variety

• Velocity

• Volatility

The framework developed by Apache for distributed storage and processing of Big Data is:

• Android

• Hadoop

• Tableau

• MongoDB

Which of the following is a document-based NoSQL database?

• MySQL
• Cassandra
• Redis
• MongoDB

Which type of NoSQL database uses a key-value format for storing data?

• Graph database

• Document store

• Columnar store

• Key-Value store

In an ER diagram, a rectangle is used to represent:

• Entities
• Attributes
• Relationships
• Weak entities

Which of the following is not a type of attribute in the ER model?

• Composite

• Derived

• weak

• multivalued

What is a primary key in the ER model?

• A primary key is a unique identifier for records in a database table.
• A primary key is used to store images in a database.
• A primary key can have duplicate values.
• A primary key is a type of foreign key.