Flashcards
Semester Test 1
Cards in this deck (24)
- 1Four Categories of NoSQL Databases:- Document Databases
- Key-Value Stores
- Graph Databases
- Wide-column Stores - 2Weaknesses of Relational Databases?- Semantic Overloading
- Poor Representation of real-world objects
- Data Structure Homogeneity
- Column-Row Intersections must be atomic - 3Big Data Is?- Big Velocity
- Big Variety
- Big Volume - 4What is Impedance in the context of programming?Impedance is the resistance or cognitive load that a programmer experiences when they must context-switch from one language to another.
- 5What are the two methods to query db4objects? What is the underlying engine?- Native Queries
- Query By Example
- SODA - 6How do Object Relational databases solve Relational Database Problems?- Offer an object-oriented perspective
- 7True or False, one approach to achieving persistence in an object-oriented database is using an unstructured database as the underlying storage engine?FALSE!
- 8True or False, an object-oriented data model is a persistent and shareable collection of objects?FALSE!
- 9True or False, object-relational databases preserve a significant body that has gone into developing relational databases and applications?TRUE!
- 10True or False, semi-structured data is well-formed XML that conforms to an XML Schema?FALSE!
- 11Two features of new SQL standards:- User-defined types
- Inheritance of attributes. - 12True or False, one of the major differences between key-value stores and document stores is that for key-value stores, searching can only be conducted on the key field, while or the document stores searching can be conducted on the key and value fields?FALSE!
- 13True or False, in object-oriented databases, each object stores its own copy of the class methods?FALSE!
- 14List three types of aggregation queries in MongoDB:- MapReduce
- Aggregation Pipeline
- Built-in Aggregation Methods - 15True or False, Semi-Structured data may be irregular or incomplete?TRUE!
- 16True or False, OODBMSs develop new database programming languages which support OOP and object persistence?FALSE!
- 17True or False, the data in a graph database is stored using an adjacency matrix where each cell in the matrix stores a key-value pair for the relationship between the graph nodes?FALSE!
- 18True or False, for document databases, documents are encoded in a standard data exchange format, such as XML or JSON:TRUE!
- 19True or False, the RDBMS has a fixed set of operations (on sets of tuples) which cannot be extended?TRUE!
- 20True or False, the SQL 93 and SQL 98 stanards specify how XML data should be stored in a relational/object relational database:TRUE!
- 21True or False, in OODMBSs obejcts may be organisaed into groups, and one special object is responsible for storing the class methods on behalf of the other objects in the group?FALSE!
- 22For the MongoDB document database, a collection is a group of documents, and documents within a collection can have different fields:TRUE!
- 23Complete the trigger: CREATE TRIGGER booking_delete AFTER DELETE ON Booking ...FOR EACH ROW
EXECUTE PROCEDURE delete_audit() - 24Write the PostgreSQL statement to show the staff number and name of all staff who work at branch number B005SELECT unnest(xpath(, "staffData")) AS name
unnest(xpath(, "staffData)) AS staffNo
FROM XMLStaff
WHERE unnest(xpath("//STAFF/@branchNo", "staffData") = "B005"
Information
- Description
- COS 326 Flashcards on Semester Test 1, created by Regan Koopmans on 20/09/2017.
- Created by
- Regan Koopmans
- Views
- 6
- Tags
- Rating