Quiz No. 2 - Business Analytics

A type of database in which when one server fails, it will not affect the entire data set.

• centralized database

• distributed database

• cloud database

• relational database

It provides an interface to perform various operations like database creation, storing data in it, updating data, creating a table in the database and a lot more

A collection and a document in MongoDB is equivalent to which of the SQL concepts respectively?

• table and row

• table and column

• column and row

• database and table

A collection in MongoDB is a group of ______________

• databases

• related documents

• schema

• rows

There is a CREATE DATABASE statement in MongoDB like there is in SQL.

• TRUE

• FALSE

A function of a DBMS that maintains the segregation between the program and the data.

Utility Services refers to mechanisms for recovery of data that is apparently lost due to system crashes

• True

• False

Data sharing allows the user to perform different types of operations such as string manipulation, date operations and so on.

• True

• False

Manipulation of data tells us that we can CRUD (create, retrieve, update, and delete) our data within the DBMS

• True

• False

Properties of the relational model that follows the "all or nothing" strategy

• consistency

• isolation

• atomicity

• durability