Important 29 MCQ's For NoSql

No Sql Aquires 20 marks in paper

MCQ No - 1

Following represent column in NoSQL __________.

(A) Database

(B) Field

(C) Document

(D) Collection

MCQ No - 2

What is the aim of NoSQL?

(A) NoSQL provides an alternative to SQL databases to store textual data.

(B) NoSQL databases allow storing non-structured data.

(C) NoSQL is not suitable for storing structured data.

(D) NoSQL is a new data format to store large datasets.

MCQ No - 3

__________ is a online NoSQL developed by Cloudera.

(A) HCatalog

(B) Hbase

(C) Imphala

(D) Oozie

MCQ No - 4

Which of the following is not a NoSQL database?

(A) SQL Server

(B) MongoDB

(C) Cassandra

(D) None of the mentioned

MCQ No - 5

Which of the following is a NoSQL Database Type?

(A) SQL

(B) Document databases

(C) JSON

(D) All of the mentioned

MCQ No - 6

Which of the following is a wide-column store?

(A) Cassandra

(B) Riak

(C) MongoDB

(D) Redis

MCQ No - 7

“Sharding” a database across many server instances can be achieved with _______________

(A) LAN

(B) SAN

(C) MAN

(D) All of the mentioned

MCQ No - 8

Most NoSQL databases support automatic __________ meaning that you get high availability and disaster recovery.

(A) processing

(B) scalability

(C) replication

(D) all of the mentioned

MCQ No - 9

Which of the following are the simplest NoSQL databases?

(A) Key-value

(B) Wide-column

(C) Document

(D) All of the mentioned

MCQ No - 10

________ stores are used to store information about networks, such as social connections.

(A) Key-value

(B) Wide-column

(C) Document

(D) Graph

MCQ No - 11

NoSQL databases is used mainly for handling large volumes of ______________ data.

(A) unstructured

(B) structured

(C) semi-structured

(D) all of the mentioned

MCQ No - 12

Which of the following language is MongoDB written in?

(A) Javascript

(B) C

(C) C++

(D) All of the mentioned

MCQ No - 13

Point out the correct statement.

(A) MongoDB is classified as a NoSQL database

(B) MongoDB favors XML format more than JSON

(C) MongoDB is column-oriented database store

(D) All of the mentioned

MCQ No - 14

Which of the following format is supported by MongoDB?

(A) SQL

(B) XML

(C) BSON

(D) All of the mentioned

MCQ No - 15

NoSQL was designed with security in mind, so developers or security teams don't need to worry about implementing a security layer. Is it true or false?

(A) True

(B) False

MCQ No - 16

Which of the following is not a reason NoSQL has become a popular solution for some organizations?

(A) Better scalability

(B) Improved ability to keep data consistent

(C) Faster access to data than relational database management systems (RDBMS)

(D) More easily allows for data to be held across multiple servers

MCQ No - 17

NoSQL prohibits structured query language (SQL). Is it True or False?

(A) True

(B) False

MCQ No - 18

When is it best to use a NoSQL database?

(A) When providing confidentiality, integrity, and availability is crucial

(B) When the data is predictable

(C) When the retrieval of large quantities of data is needed

(D) When the retrieval speed of data is not critical

MCQ No - 19

Which of the following companies developed NoSQL database Apache Cassandra?

(A) LinkedIn

(B) Twitter

(C) MySpace

(D) Facebook

MCQ No - 20

NoSQL databases are most often referred to as:

(A) Relational

(B) Distributed

(C) Object-oriented

(D) Network

MCQ No - 21

SQL databases are:

(A) Horizontally scalable

(B) Vertically scalable

(C) Either horizontally or vertically scalable

(D) They don't scale

MCQ No - 22

Which of the following is not an example of a NoSQL database?

(A) CouchDB

(B) MongoDB

(C) HBase

(D) PostgreSQL

MCQ No - 23

Which of the following is a reason to use an SQL database?

(A) It can easily store unstructured data.

(B) It's ACID-compliant.

(C) It can enable development in the cloud.

(D) All of the above

MCQ No - 24

Which of the following is a characteristic of a NoSQL database?

(A) Uses tables for storage

(B) Needs a schema

(C) Requires JOINs

(D) Uses JSON

MCQ No - 25

Which of the following is a primary classification for NoSQL architectures?

(A) Document databases

(B) Graph databases

(C) Key-value databases

(D) All of the above

MCQ No - 26

SQL command types include data manipulation language (DML) and data definition language (DDL).

(A) True

(B) False

MCQ No - 27

________ systems are scale-out file-based (HDD) systems moving to more uses of memory in the nodes.

(A) NoSQL

(B) NewSQL

(C) SQL

(D) All of the mentioned

MCQ No - 28

Point out the correct statement.

(A) Hadoop is ideal for the analytical, post-operational, data-warehouse-ish type of workload

(B) HDFS runs on a small cluster of commodity-class nodes

(C) NEWSQL is frequently the collection point for big data

(D) None of the mentioned

MCQ No - 29

Which is an advantage of NewSQL ?

(A) Less complex applications, greater consistency.

(B) Convenient standard tooling.

(C) SQL influenced extensions.

(D) All of the mentioned