1 / 4

Final Exam Coverage

Final Exam Coverage. SQL. Joins and outerjoins Subqueries Aggregations Views Inserts, updates, deletes Ordering results Constraints FK CHECK Constraints enforced by views Security and Authorization Granting and Revoking Privileges. Enforcing Security through Views.

liv
Download Presentation

Final Exam Coverage

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Final Exam Coverage

  2. SQL. • Joins and outerjoins • Subqueries • Aggregations • Views • Inserts, updates, deletes • Ordering results • Constraints • FK • CHECK • Constraints enforced by views • Security and Authorization • Granting and Revoking Privileges. • Enforcing Security through Views. • Security in Statistical Databases.

  3. Concurrency • Anomalies related to Concurrent Execution of Transactions. • 2-Phase Locking. • SQL support for transactions. • Recovering from Failures. • UNDO, REDO and UNDO/REDO • Storage • Disks mechanics. • Computation Model. • 2 Phase Multiway Merge Sort (2PMMS). • Impact of block size. • Sorting very large relations. • Indexes • B-Trees. Lookup, Insertion and Deletion in B-Trees. • Query Evaluation. • Functional Dependencies. • Closure algorithm. • BCNF and 4NF • OLAP and Data Mining

  4. Help page • One help page is allowed in the exam.

More Related