Database Management Systems.
ESL, ITL.
Database Management Systems. - 0 - 1 online resource (336 pages)
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.
Database Management Systems is designed as quick reference guide for important undergraduate computer courses. The organized and accessible format of this book allows students to learn the important concepts in an easy-to-understand, question-and-answer format. These portable learning tools have been designed as one-stop references for students to understand and master the subjects by themselves.
9788131797600
Electronic books.
005.74
Database Management Systems. - 0 - 1 online resource (336 pages)
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.
Database Management Systems is designed as quick reference guide for important undergraduate computer courses. The organized and accessible format of this book allows students to learn the important concepts in an easy-to-understand, question-and-answer format. These portable learning tools have been designed as one-stop references for students to understand and master the subjects by themselves.
9788131797600
Electronic books.
005.74