MSE Practice Intro to IS

What does DBMS stand for?

• Database Management Service

• Data Management Base System

• Database Management System

• Data Bulk Managing Software

Which of the following is a disadvantage of DBMS?

• Improved data integrity

• Complexity

• Increased productivity

• Control of data redundancy

What is a primary key in a relational database?

• A key that can be duplicated

• A key used for encryption

• A key that stores multiple values

• A key that uniquely identifies each record

Which operation creates a subset of all records meeting criteria stated?

• Join

• Select

• Project

• Update

What type of database is designed to handle large data sets that are not easily organized into tables?

• NoSQL Database

• Distributed Database

• Relational Database

• Cloud Database

Which of the following is an example of a non-relational database?

• MySQL

• MongoDB

• Oracle

• Microsoft Access

What is a characteristic of cloud databases?

• They require physical servers

• They cannot handle relational data

• They are priced based on usage

• They are only for large enterprises

Which of the following is a feature of distributed databases?

• Centralized control

• Stored in multiple physical locations

• Limited access

• Single point of failure

__________ is a type of network spans broad geographical distances.

• Campus Area Network (CAN)

• Local Area Network (LAN)

• Metropolitan Area Network (MAN)

• Wide Area Network (WAN)

What does the acronym LAN stand for?

• Local Area Network

• Large Area Network

• Long Area Network

• Limited Area Network