INF202 Faculty: Ramana Allena Readiness Assurance Test – 5 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. 4) Identify the correct statement(s) about Columns and Column Families of a Column Oriented database A) A Column Family can contain one or more Columns B) You can create a new Column of an existing Column Family. But creation of a new Column Family requires a schema change. C) A Column Family cannot contain more than one Column D) A Column can contain more than one Column Family E) Both A and B are correct 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? A) A Column Oriented Database B) A Key-Value type of Database C) A Document Database D) A Graph Database E) Both A and D