1) The advantage(s) of creating indexes in the database is/are A) Indexes reduce

Question

1) The advantage(s) of creating indexes in the database is/are A) Indexes reduce time to insert data into the database B) Indexes enhance the presentation of data to the end user C) Indexes can reduce data access times significantly D) Indexes reduce the amount of storage space that the database requires E) All of the above 2) Which of the following statements is true? A) MongoDB is Docu oriented Database. HBase is a Column ed database. ment B) MongoDB is Document Oriented base. HBase is a relational database. C) Both MongoDB and HBase are key-Value type of databases D) Both MongoDB and HBase are Column oriented databases E) Both MongoDB and HBase are Document oriented databases 3) Which of the following statements is true? A) You cannot search for a value of an attribute in the "Document" of a Document oriented database. You can search for a value of an attribute stored in the "Value" of a Key-Value data store. B) You can search for a value of an attribute in the "Document of a Document oriented database. You can also search for a value of an attribute stored in the "Value" of a Key-Value data store. C You can search for a value of an attribute in the "Document" of a Document oriented database. You cannot search for a value of an attribute stored in the "Value" of a Key-Value data store. D) You cannot search for a value of an attribute in the "Document" of a Document oriented database. You cannot search for a value of an attribute stored in the "V of a Key-Value data store. alue"

Explanation / Answer

Hi, I have answered first 4 questions.

Please let me know in case of any issue in first 4.

Q1
   Ans: C

   The advantages of indexes are as follows:
       Their use in queries usually results in much better performance.
       They make it possible to quickly retrieve (fetch) data.
       They can be used for sorting. A post-fetch-sort operation can be eliminated.
       Unique indexes guarantee uniquely identifiable records in the database.

Q2
   Ans: B

Q3
   Ans: C

Q4
   Ans: E

   In key-value database, you can search based on key only

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.