Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1) The advantage(s) of creating indexes in the database is/are 2) Which of the f

ID: 3804307 • Letter: 1

Question

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

2) Which of the following statements is true?

3) Which of the following statements is true?

4) Identify the correct statement(s) about Columns and Column Families of a Column Oriented database

5) You are designing a web application. You have a requirement to provide a facility to the user to store his/her preferences on the look-and-feel of the web pages of your application. According to Fowler and Sadalage, which of the following database types is best suited for this requirement?

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 Document oriented Database. HBase is a Column Oriented database. B) MongoDB is Document oriented Database. 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 "Value" of a Key-Value data store.

Explanation / Answer

1) Index is basically used to point to data and are physical structure. The advantages include it reduce time to insert data into database, also reduce data access time significantly.

2) MongoDB is document oriented database (where it is designed for storing, accessing and managing document oriented information and is referred to as semi structured data as well). and HBase is a Colum oriented database

3) The document oriented database allows search based on key value and also value to an attribute. Hence you can search for a value of an attribute and also you can search for a value of an attribute stored in value of key value data store.