Database Management Systems : Xpress Learning

Description

Cover Contents Preface Chapter 1: Database System Multiple-choice Questions Answers Chapter 2: Conceptual Modeling Mapping cardinalities Participation constraint Entity types versus attributes Binary versus ternary relationship Structural diagrams Behavioural diagrams Multiple-choice Questions Answers Chapter 3: Relational Model Domain integrity Entity integrity Referential integrity Semantic integrity Insert operation Delete operation Update operation Representation of weak entity types Representation of composite and multivalued attributes Representation of generalization Representation of aggregation Multiple-choice Questions Answers Chapter 4: Relational Algebra and Calculus Queries in relational algebra Queries in tuple calculus Queries in domain relational calculus Expression in relational algebra Expression in tuple calculus Expression in domain calculus Queries in relational algebra Queries in tuple calculus Queries in domain calculus Multiple-choice Questions Answers Chapter 5: Structured Query Language Adding an attribute Modifying an attribute Dropping an attribute Adding a constraint Dropping a constraint Renaming an attribute Renaming a relation Multiple-choice Questions Answers Chapter 6: Relational Database Design Multiple-choice Questions Answers Chapter 7: Data Storage and Indexing Primary storage Secondary storage Tertiary storage Fixed-length records Variable-length Records Advantages Disadvantages Extendible hashing Linear hashing Types of single-level indexes Partitioned hashing Grid files Multiple-choice Questions Answers Chapter 8: Query Processing and Optimization Cost analysis Cost analysis Variation of the hash join technique Multiple-choice Questions Answers Chapter 9: Introduction to Transaction Processing Multiple-choice Questions Answers Chapter 10: Concurrency Control Techniques Multiversion timestamp ordering Multiversion two-phase locking Multiple-choice Questions Answers Chapter 11: Database Recovery System Recovery techniques based on deferred update Recovery techniques based on immediate update Multiple-choice Questions Answers Chapter 12: Database Security Accidental threats Malicious or intentional threats Managing user accounts Database audit Multiple-choice Questions Answers Chapter 13: Database System Architecture Single lock manager Distributed lock manager Primary copy Majority locking Wait-for graph Time-out based technique Two-phase commit (2PC) Multiple-choice Questions Answers Chapter 14: Data Warehousing, OLAP, and Data Mining Multiple-choice Questions Answers Chapter 15: Information Retrieval Limitations of the vector space model Multiple-choice Questions Answers Chapter 16: Miscellaneous Questions Features of PostgreSQL Features of Oracle Features of Microsoft SQL server Features of IBM DB2 Object definition language Object query language Multiple-choice Questions Answers Index