1. The advantage(s) of creating indexes in the database is/are a.Indexes reduce
ID: 3834152 • Letter: 1
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 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
Explanation / Answer
Ans 1. C Indexing reduces data access time. At the same time, indexing decrease performance on update, insert and delete and as well as takes up more space,
Ans 2. A HBase is column oriented like SAP HANA is and MongoDB is document oriented where most of documents are stored into JSON format.
Ans 3. B Above said is true for Document oriented and Column oriented storage database.
Ans 4. E
Ans 5. B
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.